; Descriptive Statistics: Distribution Mean, Median & Standard Deviation
Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out
Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

Descriptive Statistics: Distribution Mean, Median & Standard Deviation

VIEWS: 58 PAGES: 3

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

More Info
  • 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