The regional manager of a company wishes to determine the time spent at each division in the car production process. A study was undertaken over a month that resulted in the following data related to the percentage of time spent at three divisions: Car body construction, Paint shop, and Assembly, at four locations of production plants. $$\begin{array} { l | c | c | c }
\text { Production Plants } & \begin{array} { c }
\text { Car Body } \
\text { Constuction (\%) }
\end{array} & \text { Paint Shop (\%) } & \text { Assembly (\%) } \
\hline \text { Michigan } & 35 & 45 & 20 \
\text { Kentucky } & 37 & 41 & 22 \
\text { Illinois } & 33 & 39 & 28 \
\text { Ohio } & 36 & 40 & 24
\end{array}$$
a. Create a stacked-bar chart with production plants along the vertical axis. Reformat the bar chart to best display these data by adding required labels and chart title.
b. Create a clustered-bar chart with production plants along the vertical axis and clusters of divisions. Reformat the bar chart to best display these data by adding required labels and chart title.
c. Create multiple bar charts where each production plant becomes a single bar chart showing the percentage of time spent at the divisions. Reformat the bar charts to best display these data by adding required labels and chart title.
d. Which form of bar chart (stacked, clustered, or multiple) is preferable for these data? Why?

Question

The regional manager of a company wishes to determine the time spent at each division in the car production process. A study was undertaken over a month that resulted in the following data related to the percentage of time spent at three divisions: Car body construction, Paint shop, and Assembly, at four locations of production plants. $$\begin{array} { l | c | c | c } 
\text { Production Plants } & \begin{array} { c } 
\text { Car Body } \
\text { Constuction (\%) }
\end{array} & \text { Paint Shop (\%) } & \text { Assembly (\%) } \
\hline \text { Michigan } & 35 & 45 & 20 \
\text { Kentucky } & 37 & 41 & 22 \
\text { Illinois } & 33 & 39 & 28 \
\text { Ohio } & 36 & 40 & 24
\end{array}$$ 
a. Create a stacked-bar chart with production plants along the vertical axis. Reformat the bar chart to best display these data by adding required labels and chart title.
b. Create a clustered-bar chart with production plants along the vertical axis and clusters of divisions. Reformat the bar chart to best display these data by adding required labels and chart title.
c. Create multiple bar charts where each production plant becomes a single bar chart showing the percentage of time spent at the divisions. Reformat the bar charts to best display these data by adding required labels and chart title.
d. Which form of bar chart (stacked, clustered, or multiple) is preferable for these data? Why?

Quizplus · Accepted Answer

The Answer of The regional manager of a company wishes to determine the time spent at each division in the car production process. A study was undertaken over a month that resulted in the following data related to the percentage of time spent at three divisions: Car body construction, Paint shop, and Assembly, at four locations of production plants. $$\begin{array} { l | c | c | c } 
\text { Production Plants } & \begin{array} { c } 
\text { Car Body } \
\text { Constuction (\%) }
\end{array} & \text { Paint Shop (\%) } & \text { Assembly (\%) } \
\hline \text { Michigan } & 35 & 45 & 20 \
\text { Kentucky } & 37 & 41 & 22 \
\text { Illinois } & 33 & 39 & 28 \
\text { Ohio } & 36 & 40 & 24
\end{array}$$ 
a. Create a stacked-bar chart with production plants along the vertical axis. Reformat the bar chart to best display these data by adding required labels and chart title.
b. Create a clustered-bar chart with production plants along the vertical axis and clusters of divisions. Reformat the bar chart to best display these data by adding required labels and chart title.
c. Create multiple bar charts where each production plant becomes a single bar chart showing the percentage of time spent at the divisions. Reformat the bar charts to best display these data by adding required labels and chart title.
d. Which form of bar chart (stacked, clustered, or multiple) is preferable for these data? Why?

The Regional Manager of a Company Wishes to Determine the Time