Data Analysis with Microsoft Excel: Updated for Office 2007

(Tuis.) #1

158 Fundamentals of Statistics


7 Click the OK button to create the table of values (see Figure 4-19).


Figure 4-18
Selecting
summary
statistics for
the Price
variable

Figure 4-19
Summary
statistics for
the Price
variable


As we would expect, the average price of a home in Albuquerque from
our historic sample is higher than the median value. This effect is more no-
ticeable in the northeast sector homes because of the group of high-priced
homes in that location. The mean home price was almost $12,000 greater
than the median due to the positive skewness in the data.
Free download pdf