Test: Midterm Exam Keyboard Navigation Help Questions Previous Question $7$ of $16$ Next Problem $03-17($Charts$)1.$Only Visited, Not Judged $2.$Only Visited, Not Judged $3.$Only Visited, Not Judged $4.$Only Visited, Not Judged $5.$Only Visited, Not Judged $6.$Only Visited, Not Judged $7.$Only Visited, Not Judged $8.$Only Visited, Not Judged $9.$Not Answered $10.$Not Answered $11.$Not Answered $12.$Not Answered $13.$Not Answered $14.$Not Answered $15.$Not Answered $16.$Not Answered Question Workspace The Northwest regional manager of Logan Outdoor Equipment Company has conducted a study to determine how her store managers are allocating their time. A study was undertaken over three weeks that collected the data below related to the percentage of time each store manager spent on the tasks of attending required meetings, preparing business reports, customer interaction, and being idle. The results of the data collection appear in the table below. Click on the datafile logo to reference the data. Attending Required Meetings Tasks Preparing Business Reports Customer Interaction Idle Locations Seattle $32\%17\%37\%14\%$ Portland $52\%11\%24\%13\%$ Bend $18\%11\%52\%19\%$ Missoula $21\%6\%43\%30\%$ Boise $12\%14\%64\%10\%$ Olympia $17\%12\%54\%17\%($a$)$ Create a stacked$-$bar chart in Excel with locations along the vertical axis. Reformat the bar chart to best display these data by adding axis labels, a chart title etc. Choose the correct chart below. $($i$)($ii$)($iii$)($iv$)$ Chart $($i$)($b$)$ Create a clustered$-$bar chart in Excel with locations along the vertical axis and clusters of tasks. Reformat the bar chart to best display these data by adding axis labels, a chart title, etc. Choose the correct graph below. $($i$)($ii$)($iii$)($iv$)$ Chart $($iii$)($c$)$ Create multiple bar charts in Excel in which each location becomes a single bar chart showing the percentage of time spent on tasks. Reformat the bar charts to best display these data by adding axis labels, a chart title, etc. Choose the correct graph below. $($i$)($ii$)($iii$)($iv$)$ Chart $($ii$)($d$)$ Which form of bar chart $($stacked$,$ clustered or multiple$)$ is preferred for these data? Why? For comparing different managers against one another, the stacked and clustered bar charts are better. For breaking down how individual managers are spending their time, the multiple bar charts are better. $($e$)$ What can we infer about the differences among how store managers are allocating their time at the different locations? Most of the managers tend to spend the majority of their time in customer interactions $,$ although the Portland manager in particular appears to spend an excessive amount of time attending required meetings $.$