Question

jump to level 1
the following output is from a sample of median home prices in various states.

what is the standard deviation?
what does the standard deviation represent? pick
what is the range?
what does the range represent?

check
next

challenge
activity
1.6.3: excel: standard deviation.
click this link to download the spreadsheet for use in this activity.
answers must be rounded to two decimal places. if excel displays the wrong number of decimal places, such as a whole number, highlight the cell and click the increase decimal or decrease decimal button as needed. more information about rounding can be found on microsofts support page for excel rounding.

need sample output?
start
the spreadsheet linked above contains various housing and economic
data for all 50 states.
what is the standard deviation of the differences between home values
and mortgage balances for all states in the northeast?
round to two decimal places.

Explanation:

Answer:

113.882
The typical difference between a data value and the mean
360
The spread between the maximum and minimum data values