Problems need to include all required steps and answer(s) for full credit. All answers need to be reduced to lowest terms where possible. If the answer is in %, show two decimal places.

Answer the following problems showing your work and explaining (or analyzing) your results. Submit your work in a typed Microsoft Word document.

Below are excel functions, which you can use to solve for measures of central tendency and variability. You can use the formulas too; but, they will be time consuming.

EXCEL FUNCTIONS

Measures of Central Tendency

Suppose data are in cells A1 to A10

Mean                                           =AVERAGE(A1:A10)

Median                                         =MEDIAN(A1:A10)

Mode                                            =MODE(A1:A10)

Measures of Variability

Suppose data are in cells A1 to A10

Range                                            =MAX(A1:A10)-MIN(A1:A10)

IQR                                                =QUARTILE.EXC(Array,3)-QUARTILE.EXC(Array,1)

Population Variance σ2                  =VAR.P(A1:A10)

Sample Variance s2                       =VAR(A1:A10) or VAR.S(A1:A10)

Population Standard Deviation σ   =STDEV.P(A1:A10)

Sample Standard Deviation s        =STDEV(A1:A10) or STDEV.S(A1:A10)