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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock