MATH 1342 -- Statistics
Project 1
Instructions:
- Download numbers.xls or numbers.txt (right-click the hyperlink and click "Save Target As..."). These files contain the same list of numbers. The first is in Microsoft Excel's worksheet format and the second is in plain text format.
- If you are using Microsoft Excel to complete this project (which is highly reccomended), then download the following instructions for using Microsoft Excel to make histograms, etc.
- Make a frequency table and histogram for this data set with a class width of 18.
- Make another frequency table and histogram for this data set with a class width of 14.
- Make another frequency table and histogram for this data set with a class width of 10.
- Make another frequency table and histogram for this data set with a class width of 6.
- Use the less-than-method for making each frequency table.
- For each table/histogram, use 303 as the lower boundary of the first class.
Completing the Assignment:
- Write a summary in Microsoft Word of the data that you have seen. Copy/paste your frequency tables and histograms into this document. If you choose to draw these by hand (not reccomended!), be sure to leave enough room to draw them.
- Include the mean and standard deviation for the sample of numbers in your summary. This can be done in Microsoft Excel using the "=mean(a1:a200)" and "=stdev(a1:a200)" commands. For future reference, the parentheses contain the range of cells to calculate the mean/standard deviation over.
- Do you think that this data comes from a population that is normal, skewed left, or skewed right? Why?
- Sketch what you think the frequency distribution curve might look like and explain why you think this is accurate.