FILE (U se Excel) A realtor in M ission Viejo, California, b eliev es that th e standard deviation o f h o u se prices is m ore than 100 units, w here each unit equals $1,000. A ssum e hou se prices are normally distributed.

a. Sta te t h e null a n d t h e a lternative h y p o t h e s e s for t h e test.

b. O p e n th e Mission Viejo (raw) data from th e text w ebsite into an Excel sp r ea d sh e e t (data are in $1,000s). Calculate t h e v a lu e o f t h e t e s t statistic.

c. U se Excel's fu n ctio n (either CHISQ.DIST.RT or CHISQ.DIST)

to calculate th e p -value.

d. At α = 0 .0 5 w h a t is t h e c o n c lu s io n ? Is t h e realtor's claim supported by th e data? P-399