Explore BrainMass

Confidence interval with graphs and excel

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.


Solution Summary

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.