LT Microsoft® Excel® Exercises. Use Microsoft® Excel® and the data file Real-Estate Data to prepare answers to the following assignments:
A. At the 5% significance level is there a difference in the mean selling price of a home in the different townships?
B.. Develop a contingency table that shows whether a home has a pool and the township in which the house is located. Is there an association between the variables "pool" and the "township"? Use .05 level of significance.
C, Develop a contingency table that shows whether a home has an attached garage and the township in which the house is located. Is there an association between the variables "attached garage" and the "township"? Use 0.05 level of significance.