2. At the bottom of the page, you are asked to provide the Count, Average, Median, Mode, Min, and Max for each of the states for each of the data columns. The shaded area at the end of the states is where these descriptive statistics should be entered.
3. To the right of the data, starting at approximately Texas( row 44), use the Data Analysis feature to display the summary descriptive statistics for each temperature and the rank. Be sure to shade and format your descriptive statistics( similar to the shading in Step # 2 above) so as to be able to read everything well.
As you read your results, you might note some interesting results. First and foremost, note how the statistics associated with the rankings are virtually worthless, as they really don ' t provide any insight to the data itself. This is a little of what I meant above when I talked about some statistics are junk, and you have to be careful in how you ask your questions and interrupt the results.
STEP 4: Bar Chart and Summary Statistics
Using the BarChart worksheet, calculate the summary statistics shown at the bottom of the data, for each of Bottles, Cans, and Plastic.
Create a bar chart to the right of the data, with a title of Marketing Campaign Results. You can choose the colors that you want for each city ' s results, but make sure that you show the Y-axis labels to the right and the X-axis labels on the bottom, along with the word City as their label.
STEP 5: Line Chart