steps 2-5

3 Level 2 Determining Effective Doto Display with Charts Chapter 3 Steps To Success: Level 2 In these steps, you will work with the same consumer equipment purchasing data used to complete the Pie of Pie chart that Michelle worked on earlier. This data and the Pic of Pie create a Bar of Pie chart. This same workbook contains detailed purchasing data broken out by age and gender for the following: footwear, camping, fitness, and golf. You'll use this data to create charts that illustrate the relationship between age and gender. The goal is to apply Tufte's principles to effectively present this quantitative information. Complete the following: 1. Open the workbook named Purchases.xlsx in the Chapter 3 folder, and then save the file as Consumer Purchases.xlsx. Review the data sets on the six worksheets. You need to determine which chart subtypes covered in Level 2 will best illustrate the most important information in each worksheet. 2. The l'ie of Pie worksheet contains the consumer purchase data organized by sport that Michelle used to create the Pie of Pie chart earlier. Use this data to create a Pie of Pie chart for the 2015 data. Place this chart on the same worksheet as the source data. Format the chart to look like the chart shown in Figure 3.24. Include the chart title 2015 Consumer Purchases by Sport on your chart. 3. Use the data found on the Purchases by Sport worksheet to create a Bar of Pie chart that illustrates the percentage contribution by each sport to the total purchase amount. Create one Bar of Pie chart for each year. Place the three charts on the same worksheet as the source data. Include a chart title and data labels for each chart that are similar to the ones you included in the Pic of Pie chart in Step 2. 4. The Footwear Purchases worksheet contains percentage data for footwear purchases organized by age groups and gender. The data also includes a breakout of the age and gender of the U.S. population by percentage. Create a clustered column chart, a stacked column chart, and a 100% stacked column chart to compare the purchases by different age groups cach year with the U.S. population. Place the three charts on the same worksheet as the source data. Include appropriate titles and a legend in cach chart. In a cell below each chart, explain what you think the chart illustrates. 5. The Camping Purchases worksheet contains percentage data for camping purchases organized by age groups and gender. The data also includes a breakout of the age and gender of the U.S. population by percentage. Create an area chart, a stacked area chart, and a 100% stacked area chart to compare the purchases by different age groups each year with the U.S. population. Place the three charts on the same work sheet 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, 6. The Fitness Purchases worksheet contains percentage data for fitness purchases orga- nized by age groups and gender. The data also includes a breakout of the age and gender of the U.S. population by percentage. Create a line chart, a stacked line chart, and a 100% stacked line chart to compare the purchases by different age groups cach 195 3 Level 2 Determining Effective Doto Display with Charts Chapter 3 Steps To Success: Level 2 In these steps, you will work with the same consumer equipment purchasing data used to complete the Pie of Pie chart that Michelle worked on earlier. This data and the Pic of Pie create a Bar of Pie chart. This same workbook contains detailed purchasing data broken out by age and gender for the following: footwear, camping, fitness, and golf. You'll use this data to create charts that illustrate the relationship between age and gender. The goal is to apply Tufte's principles to effectively present this quantitative information. Complete the following: 1. Open the workbook named Purchases.xlsx in the Chapter 3 folder, and then save the file as Consumer Purchases.xlsx. Review the data sets on the six worksheets. You need to determine which chart subtypes covered in Level 2 will best illustrate the most important information in each worksheet. 2. The l'ie of Pie worksheet contains the consumer purchase data organized by sport that Michelle used to create the Pie of Pie chart earlier. Use this data to create a Pie of Pie chart for the 2015 data. Place this chart on the same worksheet as the source data. Format the chart to look like the chart shown in Figure 3.24. Include the chart title 2015 Consumer Purchases by Sport on your chart. 3. Use the data found on the Purchases by Sport worksheet to create a Bar of Pie chart that illustrates the percentage contribution by each sport to the total purchase amount. Create one Bar of Pie chart for each year. Place the three charts on the same worksheet as the source data. Include a chart title and data labels for each chart that are similar to the ones you included in the Pic of Pie chart in Step 2. 4. The Footwear Purchases worksheet contains percentage data for footwear purchases organized by age groups and gender. The data also includes a breakout of the age and gender of the U.S. population by percentage. Create a clustered column chart, a stacked column chart, and a 100% stacked column chart to compare the purchases by different age groups cach year with the U.S. population. Place the three charts on the same worksheet as the source data. Include appropriate titles and a legend in cach chart. In a cell below each chart, explain what you think the chart illustrates. 5. The Camping Purchases worksheet contains percentage data for camping purchases organized by age groups and gender. The data also includes a breakout of the age and gender of the U.S. population by percentage. Create an area chart, a stacked area chart, and a 100% stacked area chart to compare the purchases by different age groups each year with the U.S. population. Place the three charts on the same work sheet 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, 6. The Fitness Purchases worksheet contains percentage data for fitness purchases orga- nized by age groups and gender. The data also includes a breakout of the age and gender of the U.S. population by percentage. Create a line chart, a stacked line chart, and a 100% stacked line chart to compare the purchases by different age groups cach 195