First National Bank employs three real estate appraisers whose job is to establish a property's market value before the bank offers a mortgage to a prospective buyer. It is imperative that each appraiser values a property with no bias. Suppose First National Bank wishes to check the consistency of the recent values that its appraisers have established. The bank asked the three appraisers to value (in $1,000s) three different types of homes: a cape, a colonial, and a ranch. The results are shown in the accompanying table.

.....................................Appraiser

House Type........1..........2...........3

Cape...............425.......415.......430

Colonial...........530.......550......540

Ranch.............390.......400......380

a. Use Excel to generate the appropriate ANOVA table at the 5% significance level.

b. At the 5% significance level, can you conclude that the average values differ by appraiser? Should the bank be concerned with appraiser inconsistencies?

c. At the 5% significance level, can you conclude that the average values differ by house type?

d. If average values differ by house type, use Tukey's HSD method at the 5% significance level to determine which averages differ.