Exam 3: Data Visualization

Data are shown below on the quality rating, volume, average wait time from pull-up to completion, average unit purchase, and revenue tier for franchises of a certain fast food restaurant in Area 6. ​​ $\begin{array}{l}\text { Area } 6 \text { Franchise Data }\\\begin{array}{|l|l|c|c|c|c|}\hline \text { Franchise } & \text { Quality Rating } & \begin{array}{c}\text { Volume } \\\text { Cumber }\end{array} & \begin{array}{c}\text { Wait Time } \\\text { Numec.) }\end{array} & \begin{array}{c}\text { Average Unit } \\\text { Purchase (\$) }\end{array} & \begin{array}{c}\text { Revenue } \\\text { Tier }\end{array} \\\hline 124&\text { Above Average }&\text { High }&175&13.25&4\\152&\text { Acceptable }&\text { LOW }&181&10.02&2\\452&\text { Above Average }&\text { LOW }&179&13.56&4\\462&\text { Above Average }&\text { Medium }&175&12.12&3\\485&\text { Superior }&\text { High }&171&15.11&4\\567&\text { Acceptable }&\text { High }&178&9.78&2\\568&\text { Above Average }&\text { Medium }&177&12.54&4\\584&\text { Above Average }&\text { Medium }&175&11.54&3\\625&\text { Superior }&\text { Medium }&175&11.14&3\\875&\text { Superior }&\text { LOW }&180&8.78&1\\\end{array}\end{array}$ ​ Using the table below, complete the crosstabulation chart of quality rating and categorized daily volume. ​ Crosstabulation of Quality Rating and Daily Units for Area 6 Franchises Daily Units Quality Rating Low Medium High Total Acceptable Above Average Superior Total

We create multiple dashboards

To generate a scatter chart matrix, we use

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

The data on the scores obtained by students in five different entrance exams have been collected from 50 colleges and they are provided below. Create a PivotTable in Excel to display the number of students who took each exam and the average score for students in each exam. Exams Scores Exams Scores SAT 520 MCAT 487 ACT 400 GRE 267 MCAT 580 GMAT 455 GRE 280 SAT 528 GMAT 540 GMAT 536 ACT 356 GAT 469 MCAT 520 GRE 455 GRE 355 MCAT 520 GMAT 480 GRE 489 SAT 574 ACT 455 GRE 396 MCAT 589 GMAT 450 GRE 500 ACT 420 GMAT 500 MCAT 560 SAT 528 GRE 297 GMAT 480 GMAT 520 SAT 475 SAT 489 GMAT 570 GMAT 500 ACT 480 SAT 566 MCAT 567 GRE 451 GRE 546 GMAT 460 GMAT 544 ACT 422 GAT 420 MCAT 550 GMAT 453 GRE 310 SAT 510 ACT 384 GRE 473 a. Which exam did most students attempt? b. Which exam has the highest average score? c. Use the PivotTable to determine the exam attempted by the student with the highest score.What is the exam attempted by the student with the lowest score?

Construct a scatter chart for the following set of data. Describe the relationship between the two variables. ​ VARI 2 5 6 7 10 VAR2 3 6 8 13 15 ​

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

Tables should be used instead of charts when

Sadie is constructing a bar chart to describe the average savings account balances for customers at her bank. If the minimum balance is $5.00 and the maximum balance is $18,700, would the following bar chart be a good representation of the data? If not, what would Sadie need to change? ​ ​

The total number of runs scored by the top five players in a cricket match is 198. The following pie chart shows the percentage of runs scored by each player. a. What are the problems with using a pie chart to display these data? b. What type of chart would be preferred for displaying the data in this pie chart? c. Use a different type of chart to display the percentage of runs scored by each player that conveys the data better than the pie chart. Format the chart and add data labels to improve the chart's readability.

A local search service company surveys on the number of service centers available in three major cities for different brands of automobiles with an objective to improve the services to its customers. The data on the 20 automobile brands and the number of service centers are given below: Brands Number of service centers Audi 38 BMW 42 Mercedes-Benz 49 Rolls-Royce 25 Volkswagen 30 Toyota 30 Jaguar 42 Nissan 35 Ford 41 Fiat 35 Land Rover 34 Chevrolet 29 Ferrari 32 Hyundai 15 Porsche 35 Skoda 42 Tata 20 Honda 23 Renault 40 Subaru 10 a. How many automobile brands have centers between 20 and 29 in these three cities? b. How many automobile brands have more than 40 centers in these cities?

An effective display of trend and magnitude is achieved by using a combination of a

The owner of a grocery store is interested in providing better service to his customers with respect to the wait time at the billing counter. The data on 20 waiting customers are given below. $\begin{array}{l}\text { Customer }\\\begin{array} { l l l l l } \text { Number } & \text { Wait Time (min) } & \text { Purchase Amount (\$) }&\text { Customer Age } & \text { Credit Score } \\\hline 1 & 2.3 & 518 & 42 & 694 \\2 & 2.8 & 592 & 33 & 879 \\3 & 3.2 & 598 & 38 & 531 \\4 & 3.4 & 845 & 40 & 509 \\5 & 3.4 & 648 & 29 & 869 \\6 & 4.2 & 695 & 46 & 777 \\7 & 3.2 & 844 & 42 & 470 \\8 & 1.4 & 470 & 40 & 714 \\9 & 6.4 & 488 & 24 & 517 \\10 & 7.8 & 527 & 37 & 794\\11 & 0.5 & 843 & 32 & 351 \\12 & 9.8 & 704 & 43 & 673 \\13 & 5 & 824 & 56 & 846 \\14 & 1.8 & 570 & 35 & 735 \\15 & 6.1 & 503 & 39 & 816\\16 & 3.4 & 483 & 44 & 516 \\17 & 7.8 & 707 & 33 & 729 \\18 & 2.8 & 796 & 42 & 591 \\19 & 1.2 & 485 & 46 & 866 \\20 & 9.5 & 727 & 50 & 879\\\end{array}\end{array}$ a. Use XLMiner to create a scatter chart matrix for these data. Include the variables wait time, purchase amount, customer age, and credit score. b. What can you infer about the relationships between these variables from the scatter chart matrix?

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

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

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

A ______________ is used for examining data with more than two variables, and it includes a different vertical axis for each variable.

A research was conducted on a sample of 1000 males and 1000 females to study the kind of movie most men and women prefer to watch. The results are shown in the table below. Movie Type Male Female Action 294 226 Comedy 264 276 Horror 237 200 Romance 205 298 a. Construct a clustered column chart with the type of movie as the horizontal variable. b. What can we infer from the clustered bar chart in part (a)?

This pie chart describes the age frequencies of students in a Business Analysis class. What is the relative frequency of students who are younger than 23? (Round to a whole number if necessary.) ​ ​

The following table is an example of the profit made by Hydro America, a water servicing company, for five different years. $\begin{array} { | l | l | l | l | } \hline \text { Year } & \text { Total revenue (\$) } & \text { Cost of revenue (\$) } & \text { Gross profit } ( \$ ) \\\hline 2011 & 62723201 & 26256000 & 36467201 \\\hline 2012 & 67177612 & 37026005 & 30151607 \\\hline 2013 & 72648252 & 35054123 & 37594129 \\\hline 2014 & 71225185 & 35187462 & 36037723 \\\hline 2015 & 75847373 & 39298243 & 36549130 \\\hline\end{array}$ Reformat the table to improve readability and to help the manager identify the year with the highest profit.