Excel Class Example - Data 2 5 8 8 9 11 14 15 1 Mean 1.03...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Data 2 5 1 Mean Quartile Calculations 8 1.03 10 0.95 Initial first quartile rank 2 8 1 10 0.7 Rule 1 applies 9 1 Median use rank: 2 11 1 9 0.95 value of rank: 8 14 1 9 0.7 first quartile: 8 15 1 1st Quartile Initial third quartile rank 6 0.98 8 0.95 Rule 1 applies 0.98 8 0.7 use rank: 6 0.98 3rd Quartile value of rank: 14 0.98 14 0.95 third quartile: 14 0.98 14 0.7 0.98 Std. Deviation 0.98 3.56 7.12 10.68 0.98 1 Std. Dev 0.98 6.44 0.9 0.98 13.56 0.9 2 Std Dev. 2.88 0.8 17.12 0.8 3 Std Dev -0.68 0.7 20.68 0.7 Summary Mean 10 Median 9 1st Quartile 8 3rd Quartile 14 Std. Deviation 3.56 -5 0 5 10 15 20 Data 2 C C C C C C C C
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
0 25 Column B Column D Column D Column D Column D Column D Column D Column D
Background image of page 2
Data 1 5 1 Mean Quartile Calculations 8 1 10 0.95 Initial first quartile rank 2 10 1.05 10 0.7 Rule 1 applies 10 1.03 Median use rank: 2 10 1 10 0.95 value of rank: 8 12 1 10 0.7 first quartile: 8 15 1 1st Quartile Initial third quartile rank 6 0.98 8 0.95 Rule 1 applies 0.98 8 0.7 use rank: 6 0.98 3rd Quartile
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 6

Excel Class Example - Data 2 5 8 8 9 11 14 15 1 Mean 1.03...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online