BA 201 Midterm

Natalie needs to compare the number of employees by job title for the last five years. Which of the following charts should Natalie use?

Clustered-column (bar) chart

The charts that are helpful in making comparisons between categorical variables are

bar charts and column charts.

A two-dimensional graph representing the data using different shades of color to indicate magnitude is called a

heat map

Bar charts use

horizontal bars to display the magnitude of the quantitative variable

Consider the clustered bar chart of the dashboard developed to monitor the performance of a call center:

identify the frequency of a particular type of problem by location

Data-ink is the ink used in a table or chart that

is necessary to convey the meaning of the data to the audience.

A disadvantage of stacked-column charts and stacked-bar charts is that

it can be difficult to perceive small differences in areas.

In a business, the values indicating the business's current operating characteristics, such as its financial position, the inventory on hand, and customer service metrics, are typically known as

key performance indicators

The best way to differentiate chart elements is using

labels

A time series plot is also known as a

line chart

The following image is a

line chart

In many cases, white space in a chart can improve

readability.

A _____________ is a graphical presentation of the relationship between two quantitative variables

scatter chart

Which of the following graphs cannot be used to display categorical data?

scatter chart

We create multiple dashboards

so that each dashboard can be viewed on a single screen

A line chart that has no axes but is used to provide information on overall trends for time series data is called a

sparkline

To avoid problems in interpreting the differences in color in a heat map, ____________ can be added.

sparklines

Tables should be used instead of charts when

the values being displayed have different units or very different magnitudes.

Using multiple lines on a line chart or employing multiple charts is an alternative to a

three-dimensional chart

A _____________ is a line that provides an approximation of the relationship between the variables.

trendline

Consider the following frequency distribution. Class Frequency 10-19 10 20-29 16 30-39 19 40-49 3 50-59 2 Construct a cumulative frequency distribution.

10, 26, 45, 48, 50 to find cumulative frequency distribution you will add the current frequency to the frequencies that proceed it example 10+16 = 26 for 20-29

A manager of a fast food restaurant wants the drive-thru employee to ask every fifth customer if he or she is satisfied with the service. Who makes up the population?

All customers who use the drive-thru window of this fast food restaurant

In a survey of patients in a local hospital, 62.42% of the respondents indicated that the health care providers needed to spend more time with each patient. Who makes up the population?

All patients in a local hospital

To generate a scatter chart matrix, we use

Excel Add-In XLMiner

The ratio of the amount of ink used in a table or chart that is necessary to convey information to the total amount of ink used in the table and chart is known as data-ink ratio. Using additional ink that is not necessary to convey information has what effect on the data-ink ratio?

It reduces the data-ink ratio

Which Excel command will return all modes when more than one mode exists?

MODE.MULT

To summarize and analyze data with both a cross-tabulation and charting, Excel typically pairs

PivotCharts with PivotTables.

Which one of the following statements is not true concerning PivotTables in Excel?

PivotTables can be built using data arrayed in rows.

Which of the following relationships would have a negative correlation coefficient?

Supply and demand

__________ merges maps and statistics to present data collected over different geographies.

The geographic information system

A partial relative frequency distribution is given. Class Relative Frequency A 0.22 B 0.18 C 0.25 D ? (a) What is the relative frequency of class D? (b) The total sample size is 800. What is the frequency of class D? (c) Show the frequency distribution. (d) Show the percent frequency distribution

a) 0.35 (figured by adding up all frequencies then subtracting from 1) b) 280 (multiply 0.35 x 800) c) multiply each frequency by the sample size d) list the frequency as a percent so the frequency x 100

Ohio Logistics manages the logistical activities for firms by matching companies that need products shipped with carriers that can provide the best rates and best service for the companies. Ohio Logistics is very concerned that its carriers deliver their customers' material on time, so it carefully monitors the percentage of on-time deliveries. The following table contains a list of the carriers used by Ohio Logistics and the corresponding on-time percentages for the current and previous year. (a) Sort the carriers in descending order by their current year's percentage of on-time deliveries and answer the following questions. Which carrier is providing the best service in the current year? The worst? (b) Calculate the change in percentage of on-time deliveries from the previous to the current year for each carrier. Use Excel's conditional formatting tool to choose the correct list of carrier whose on-time percentage decreased from the previous year to the current year. (c) Use Excel's conditional formatting tool to create data bars for the change in percentage of on-time deliveries from the previous year to the current year for each carrier calculated in part b. Choose the correct list of top 3 carriers whose on-time percentage increased from the previous year to the current year.

a) best - Blue Box Shipping, worst - Rapid Response b) List II, Rapid Response, Minuteman Company, Super Freight c) List IV, Jones Brothers, Honsin Limited, Blue Box Shipping

In a recent report, the top 5 most-visited English-language web sites were google.com (GOOG), facebook.com (FB), youtube.com (YT), yahoo.com (YAH), and wikipedia.com (WIKI). The most-visited web sites for a sample of 50 Internet users follow. (a) Are these data categorical or quantitative? (b) Provide frequency and percent frequency distributions. c) On the basis of the sample, which web site is most frequently the most-often-visited web site for Internet users? Which is second?

a) categorical because no mathematical representation b) to find frequency simply count how many times the reference occurs then to find frequency percentage you take the frequency divided by the sample size and then multiplied by 100 c) reference the frequency

(a) Develop a frequency distribution using classes of 12-14, 15-17, 18-20, 21-23, and 24-26.

a) use COUNTIF in spreadsheet to find the number of occurrences of each word = frequency b) for relative frequency divide frequency by sample size c) for frequency percentage multiply relative frequency by 100

Consumer complaints are frequently reported to the Better Business Bureau. Industries with the most complaints to the Better Business Bureau are often banks, cable and satellite television companies, collection agencies, cellular phone providers, and new car dealerships. The results for a sample of 200 complaints are in the file BBB (a) Show the frequency and percent frequency of complaints by industry. (b) Which industry had the highest number of complaints?

a) use COUNTIF in spreadsheet to find the number of occurrences of each word = frequency then divide frequency by the sample size of data then multiply by 100 b) cellular phone because frequency was highest

A Wall Street Journal subscriber survey asked 46 questions about subscriber characteristics and interests. State whether each of the following questions provides categorical or quantitative data. (a)What is your age? (b)Are you male or female? (c)When did you first start reading the WSJ? High school, college, early career, mid-career, late career, or retirement? (d)How long have you been in your present job or position? (e)What type of vehicle are you considering for your next purchase? Nine response categories include sedan, sports car, SUV, minivan, and so on.

a. quantitative b. categorical c. categorical d. quantitative e. categorical

__________ are visual methods of displaying data.

charts

An alternative for a stacked column chart when comparing more than a couple of quantitative variables in each category is a

clustered column chart

A PivotChart, in few instances, is the same as a

clustered-column chart

A graphical presentation that uses vertical bars to display the magnitude of quantitative data is known as a

column chart

The data dashboard for a marketing manager may have KPIs related to

current sales measures and sales by region

A data visualization tool that updates in real time and gives multiple outputs is called

data dashboard

Fields may be chosen to represent all of the following except ____________ in the body of a PivotTable.

filters