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)
