; Descriptive Statistics: Distribution Mean, Median & Standard Deviation
Documents
User Generated
Resources
Learning Center
Your Federal Quarterly Tax Payments are due April 15th

# Descriptive Statistics: Distribution Mean, Median & Standard Deviation

VIEWS: 58 PAGES: 3

Calculation of Mean, Median and Standard Deviation using Excel formulas.

• pg 1
```									              Sub: Statistics                                                                           Topic: Distribution

Question:

Compute and record the mean, the median, and the standard deviation of the
data set. Divide the data into 9 – 15 categories (classes).
ClassOf1 provides expert guidance to College, Graduate, and High school students on homework and assignment problems in
Math, Sciences, Finance, Marketing, Statistics, Economics, Engineering, and many other subjects.

Create both absolute and relative frequency tables for the categories. Produce frequency
tables, showing the total of both frequencies.

Solution:
DETAILED WORKINGS ARE ATTACHED IN SEPARATE EXCEL WORKSHEET

PART I:

The mean, median and standard deviation of the data sets are calculated using Microsoft Excel
(Insert  Formula  Statistical Mean, Median and Standard deviation) and the res
```
To top