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

$.$