Overview
Project: Part 2 – Descriptive Statistics Assignment
For this part of the project, you will calculate descriptive statistics for the first question, age, using the Excel spreadsheet your instructor will send with all the class data.
This sheet will also provide space for you to do the following descriptive statistics under the “Module 3” tab:
You will submit the Excel sheet with the following information:
Make a Frequency Distribution with 5 classes, also list the midpoints, relative frequency, and cumulative relative frequency
Make a cumulative relative frequency ogive
oDon’t forget descriptive title and labels on x and y axis (ogive is not descriptive, what does the graph represent?)
Make a frequency polygon
oDon’t forget a descriptive title and labels on x and y axis (polygon is not descriptive, what does the graph represent?)
Calculate the mean
Calculate the median
Calculate the sample standard deviation (our data is sample from our class, not a population!)
Calculate the Q1 and Q3 values
Note: Your assignment will be checked for originality via the Turnitin plagiarism tool.