First National Bank employs three real estate appraisers whose job is to establish a property's market value
Question:
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.
Step by Step Answer:
Business Statistics Communicating With Numbers
ISBN: 9780078020551
2nd Edition
Authors: Sanjiv Jaggia, Alison Kelly