(Use Excel)The following are the prices (in $1,000s)of 20 houses sold recently in Vancouver,Washington.A real estate agent believes that the standard deviation of house prices is less than 70 units,where each unit equals $1,000.Assume house prices are normally distributed. 
a.State the null and the alternative hypotheses for the test.
B)Calculate the value of the test statistic.
C)Use Excel's function (either CHISQ.DIST.RT or CHISQ.DIST)to calculate the p-value.
D)At α = 0.10 what is the conclusion? Is the agent's claim supported by the data?
Definitions:
Ordinary Shareholders
Investors who own ordinary shares in a company, granting them rights to dividends and voting in company affairs.
Q2: It is known that the length of
Q12: The term BLUE stands for Best Linear
Q22: Tukey's honestly significant differences (HSD)method uses _
Q26: Exhibit 13.7 A market researcher is studying
Q27: In general,blocks are the levels at which
Q35: Suppose that,on average,electricians earn approximately <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB2339/.jpg"
Q35: A sociologist studies the relationship between a
Q39: Exhibit 13.1 The following is an incomplete
Q95: For any normally distributed random variable with
Q108: Exhibit 14-2.A statistics student is asked to