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
WE HAVE DONE THIS ASSIGNMENT BEFORE, WE CAN ALSO DO IT FOR YOU
GET SOLUTION FOR THIS ASSIGNMENT, Get Impressive Scores in Your Class
CLICK HERE TO MAKE YOUR ORDER on solve for measures of central tendency and variability
