Sheet3 contains percentage data of footwear purchases organized by age groups and gender. The data also includes a breakout of the age and gender of the US population by percentage. Create a clustered column chart, a stacked column chart, a 100% stacked column chart to compare the purchases by different age groups each year with the US population. Place the three charts on the same worksheet as the source data. Include appropriate titles and a legend in each chart. In a cell below each chart, explain what you think the chart illustrates.

Question

Sheet3 contains percentage data of footwear purchases organized by age groups and gender. The data also includes a breakout of the age and gender of the US population by percentage. Create a clustered column chart, a stacked column chart, a 100% stacked column chart to compare the purchases by different age groups each year with the US population. Place the three charts on the same worksheet as the source data. Include appropriate titles and a legend in each chart. In a cell below each chart, explain what you think the chart illustrates.   

Expand

Expert Answer

Want to see the step-by-step answer?

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times may vary by subject and question complexity. Median response time is 34 minutes for paid subscribers and may be longer for promotional offers.
Tagged in
Math
Statistics

Graphical Methods

Related Statistics Q&A

Find answers to questions asked by students like you.