IF YOU HAVE EXCEL 2007, PLEASE FOLLOW THE INSTRUCTIONS BELOW:
Click on the button on the top left corner. In the dialogue box, click on Excel options. In the next dialogue box click on Add-Ins. Then click on Analysis tool pack. Click go or okay to get out.
Now click on data and then data analysis on the tool bar. Once a dialogue box opens click on descriptive statistics. Highlight the data range, click on summary statistics and ok.
That will make the summary statistics.
Here is the data for Excel 1:
51.4, 50.4, 45.6, 44.8, 44.6, 42.9, 41.6, 40.6, 40.1, 40.1, 39.8, 39.5, 38.6, 38.5, 38.3
Excel Assignment 3 20 points
Excel Assignment 4 5 points
Excel Assignment 5 10 points
Stem-and-Leaf Click on "Tables" and then "Many descriptive statistics and stem-and leaf displays"
Probability and Quantile Applets
Z-scores and Normal Distribution
This Document is maintained by
ananda@pittstate.edu