Question

standard deviation based on survey data. first, lets randomly select ten observations.
height sample sd

1. in cell k1, type

ow\

1. in cell k2, enter the formula =randbetween(2, $c$2+1)
2. in cell l1, type \sample height\
3. in cell l2, enter the formula =index(a:a, k2)
4. highlight the cell range k2:l11, then select home > editing > fill > down
5. in cell n1, type \sample mean\
6. in cell n2, enter the formula =average(l:l)
7. in cell o1, type \sample sd\
8. in cell o2, enter the formula =stdev.s(l:l)

9 numeric 1 point
what is your estimate of the standard deviation? (round to one decimal place.)

ation deviation^ sum populationpopulation sd row sample height sample mesample sd
3.88 570.5 18238.35 23 35256 4.832448 636 70.5 68.65 2.780365
2 88 523.7 23 35256 4.832448 628 70
4 88 221.6 23 35256 635 70
4 88 221.6 23 35256 609 70
3.88 192.8 445 67
3.88 192.8 737 74
2.88 166 490 67
2.88 166 444 67
1 88 141.2 461 67
1 88 141.2 277 64
1 88 141.2
1 88 141.2
1 88 141.2
sheet1 igr standard deviation
accessibility: investigate

Explanation:

Step1: Identify sample SD value

The sample standard deviation (SD) is given in cell O2 as 2.789365.

Step2: Round to one decimal place

Round 2.789365 to 1 decimal place. Since the second decimal digit is 8 (≥5), we round up the first decimal digit.
$2.789365 \approx 2.8$

Answer:

2.8