| In this assignment, you will collect data about the shoe store industry and create seven charts that portray industry statistics or trends. For example, one chart may be a line or column chart displaying annual sales of athletic shoes in the US. Another example might be a pie chart showing market share of the major companies in the athletic shoe store industry. All charts must be clearly labeled with a chart title and axis labels. Chart types must be appropriate to the data type. For example, a chart showing trends over time should be either a line, bar or column chart; charts showing how segments contribute to a whole, such as market share data, should be either a pie chart or a tree map. Use either the Revenue Growth or Total Revenue data to create a chart showing JUST the past and project annual industry growth in revenue from 2008 projected to 2022. (You may not need to use all three tables for this assignment.) ? Use the market share data on the [major companies] page to create a pie chart showing the market share percentage of each of the major players in this industry. (Note: You must type the market share numbers and company names into an Excel worksheet to create the dataset to be charted). ? Use any of the data in industry report to create five more charts that are reflective of trends occurring in the industry. Helpful hint: If you want to select two columns of data for a chart and the columns are NOT adjacent (not next to each other), you can select multiple non-adjacent columns using the control key. For example, to select columns A and C, select column A, HOLD DOWN THE CTRL KEY, and select column C. Note: All charts must be clearly labeled with a chart title and axis labels. Chart types must be appropriate to the data type. For example, a chart showing trends over time should be either a line, bar or column chart; charts showing how segments contribute to a whole, such as market share data, should be either a pie chart or a tree map. ALL INFO PROVIDED...PLEASE SCROLL OVER! OD4605 Athletic Shoe Stores | | | | | | | | Key Statistics | | | | | | | | | | | | | | | | | | | | | | | | Revenue ($m) | IVA ($m) | Establishments (Units) | Enterprises (Units) | Employment (Units) | Exports ($m) | Imports ($m) | Wages ($m) | Domestic Demand ($m) | Price of Shoes (Index) | | 2008 | 10,087.7 | 1,453.6 | 8,058 | 2,844 | 71,067 | - | - | 1,090.4 | - | 106 | | 2009 | 10,498.3 | 1,509.6 | 7,741 | 2,756 | 68,088 | - | - | 1,110.7 | - | 108 | | 2010 | 10,942.5 | 1,698.4 | 7,713 | 2,775 | 70,074 | - | - | 1,129.4 | - | 109 | | 2011 | 11,769.2 | 1,786.4 | 7,681 | 2,776 | 75,622 | - | - | 1,174.4 | - | 112 | | 2012 | 12,283.2 | 1,962.0 | 7,805 | 2,832 | 75,629 | - | - | 1,188.2 | - | 118 | | 2013 | 12,182.3 | 1,748.6 | 7,857 | 2,839 | 77,153 | - | - | 1,139.4 | - | 123 | | 2014 | 12,899.7 | 1,557.2 | 8,066 | 2,899 | 84,464 | - | - | 1,170.2 | - | 126 | | 2015 | 13,588.1 | 1,646.7 | 8,106 | 2,918 | 89,218 | - | - | 1,211.9 | - | 128 | | 2016 | 13,948.1 | 1,689.7 | 8,291 | 2,982 | 91,912 | - | - | 1,250.8 | - | 130 | | 2017 | 14,249.7 | 1,728.1 | 8,390 | 3,020 | 93,665 | - | - | 1,278.0 | - | 131 | | 2018 | 14,666.4 | 1,785.4 | 8,593 | 3,090 | 96,642 | - | - | 1,321.7 | - | 134 | | 2019 | 15,093.7 | 1,837.9 | 8,736 | 3,141 | 99,213 | - | - | 1,361.4 | - | 137 | | 2020 | 15,450.8 | 1,884.8 | 8,922 | 3,206 | 101,755 | - | - | 1,398.9 | - | 140 | | 2021 | 15,784.3 | 1,925.8 | 8,997 | 3,230 | 103,782 | - | - | 1,430.3 | - | 143 | | 2022 | 16,130.2 | 1,972.7 | 9,172 | 3,293 | 106,284 | - | - | 1,467.3 | - | 146 | | 2.2 | 2.4 | 1.9 | 2.0 | 2.4 | N/C | N/C | 2.6 | N/C | 2.0 |
