Question

1. in cell j1, type \deviation sd\
2. in cell j2, enter the formula =stdev.p(b:b)
3. highlight the cell range i2:j2, then select home > number >

number from the drop - down menu
14 numeric 1 point
what is the mean of the deviations in inches? (round to two
decimal places.)
answer
15 numeric 1 point
what is the standard deviation of the deviations in inches?
(round to two decimal places.)
answer

Explanation:

Step1: Identify mean of deviations

From cell I2, the value is 0.00, which is already rounded to two decimal places.

Step2: Identify SD of deviations

From cell J2, the value 4.83 is already rounded to two decimal places.

Answer:

1. 0.00
2. 4.83