Please help me create and interpret the confidence intervals- 90%, 95%, and 99%..
1)Compute the confidence interval(s) for the attached data (data and graphs)Distance only.
2)Provide graph and table in excel
3)Based on the confidence interval(s), determine if you would change the conclusion that distance does affect a home's selling price.
4)Briefly discuss the confidence interval(s) and how they impact a home's selling price.
Construction of confidence interval for population parameter is discussed in the answer. Excel template for each problem is also included. This template can be used to obtain the answers of similar problems.