BIS 155 Course Great Wisdom / tutorialrank.com BIS 155 Course Great Wisdom / tutorialrank.com | Page 47

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