Question

1. copy column o of the sheet named \iqr\ to column a of a new sheet named \standard deviation\
2. make row 1 bold and centered
3. in cell c1, type

\

1. in cell c2, enter the formula =count(a:a)
2. in cell d1, type \population mean\
3. in cell d2, enter the formula =average(a:a)
4. in cell e1, type \deviation\
5. in cell e2, enter the formula =a2 - $d$2
6. in cell f1, type \deviation^2\
7. in cell f2, enter the formula =e2^2
8. highlight the cell range e2:f782, then select home > editing > fill > down
9. in cell g1, type \sum\
10. in cell g2, enter the formula =sum(f:f)
11. in cell h1, type \population variance\
12. in cell h2, enter the formula =g2/c2
13. in cell h3, enter the formula =average(f:f)
14. in cell h4, enter the formula =var.p(a:a)
15. in cell i1, type \population sd\
16. in cell i2, enter the formula =sqrt(h2)
17. in cell i3, enter the formula =stdev.p(a:a)

8 numeric 1 point
what is the standard deviation in inches? (round to one decimal place.)
answer

Explanation:

Step1: Identify population SD value

From the spreadsheet, the population standard deviation (cell I2/I3) is 4.832448.

Step2: Round to 1 decimal place

Round 4.832448 to one decimal place: $\text{Round}(4.832448, 1) = 4.8$

Answer:

4.8