Question: Project: Part 2 - Descriptive Statistics Assignment For this part of the project, you will calculate descriptive statistics for the first question, age, using the
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
- Don't forget descriptive title and labels on x and y axis (ogive is not descriptive, what does the graph represent?)
- Make a frequency polygon
- Don'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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
