Question

1. The regional manager of a company wishes to determine the time spent at each division in the car production process. A month-long study 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.

Production Plants	Car Body Construction (%)	Paint Shop (%)	Assembly (%)
Michigan	35	45	20
Kentucky	37	41	22
Illinois	33	39	28
Ohio	36	40	24

1. 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.
2. 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
3. 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
4. Which form of bar chart (stacked, clustered, or multiple) is preferable for these data? Why?

Answer 1

a)

b)

c)

d)

Stacked Chart is preferable because we can comapare easily the difference as total is always will be 100%

Thanks in advance!

revert back for doubt

Please upvote