The Regional Manager of a Company Wishes to Determine the Time

question 20

Essay

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?

---

Definitions:

Astrocytes

Star-shaped glial cells in the brain and spinal cord involved in physical support, maintenance of the blood-brain barrier, and nutrient and ion regulation.

Microglia

Specialized type of glial cells in the brain and spinal cord that act as the main form of active immune defense in the central nervous system.

Ependymal Cells

Specialized glial cells that line the ventricles of the brain and the central canal of the spinal cord, involved in the production of cerebrospinal fluid.

Oligodendrocytes

Glial cells in the central nervous system that produce myelin, a substance that forms a sheath around nerve fibers to facilitate electrical impulse conduction.