Q2. a.What are the null and alternative hypotheses? b.At a 95% confidence level, what is the value of alpha (ª), c.What is the critical value (CV comes from the Excel outputbelow) d.What is the value of the test statistic (from the Excel outputbelow) e.What is thep-value associated with the sample statistic? (from the Excel outputbelow)
At the 95% confidencelevel, can we conclude that there is a statistically significant difference in the mean selling price of homes based on their location among the 5 Townships?
Q2.
a.What are the null and alternative hypotheses?
b.At a 95% confidence level, what is the value of alpha (ª),
c.What is the critical value (CV comes from the Excel outputbelow)
d.What is the value of the test statistic (from the Excel outputbelow)
e.What is thep-value associated with the sample statistic? (from the Excel outputbelow)
f.Compare PV to alpha (include values in comparison) and TS to CV (include values from output in your comparison)
g.What is your Decision? (reject/fail to reject Ho)
h.What is your conclusion (in everyday terms)
USE EXCEL TO ANSWER
Step by step
Solved in 2 steps
