Business Question

Overview

Project: Part 2 – Descriptive Statistics Assignment

You will work on "Project: Part 2 – Descriptive Statistics Assignment" in the provided Excel document. Do not do it on paper. Do it right in the very Excel document.

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

o 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

o 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

Note: Your assignment will be checked for originality via the Turnitin plagiarism tool.