Question

1. in cell g1, type \lower limit\
2. in cell h1, type \upper limit\
3. in cell i1, type \frequency\
4. in cell j1, type

elative frequency\

1. in cell h2, enter the formula =$d$2 - 3*$e$2
2. in cell g3, enter the formula =h2
3. in cell h3, enter the formula =g3 + $e$2
4. highlight the cell range g3:h8, then select home > editing > fill > down
5. in the cell range i2:i8, enter the frequencies by referring to the histogram
6. in cell j2, enter the formula =i2/$c$2
7. fill down to the cell range j2:j8
8. highlight the cell range j2:j8, then select home > number > percent style

11 numeric 1 point
what percentage of the heights fall within one standard deviation of the population mean? (round to one decimal place.)
answer
1

Explanation:

Step1: Identify population stats

Population mean $\mu = 8481$, Population SD $\sigma = 4.832448$

Step2: Calculate 1σ range

Lower bound: $\mu - \sigma = 8481 - 4.832448 = 8476.167552$
Upper bound: $\mu + \sigma = 8481 + 4.832448 = 8485.832448$

Step3: Match to frequency ranges

All height ranges (51.39-80.38) fall within 8476.17-8485.83. Sum frequencies: $4+4+4+4+4+4=24$
Total data points: $\sum \text{Frequency} = 24$

Step4: Compute percentage

$\text{Percentage} = \frac{24}{24} \times 100 = 100.0\%$

Answer:

100.0