Question

jump to level 1
the following output is from a sample of median home prices in various states.
what is the standard deviation?
ex: 110.342
what does the standard deviation represent? pick
what is the range?
ex: 402
what does the range represent? pick
1
the spread between the maximum and minimum data values
the spread of the middle 50% of the data
the typical difference between a data value and the mean
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 microsoft’s support page for excel rounding.

Explanation:

Answer:

117.43
The typical difference between a data value and the mean
380.00
The spread between the maximum and minimum data values