Question: Use Excel to create a 95 confidence interval of average
Use Excel to create a 95% confidence interval of average Woodbon sales, when mortgage rates are 6%, housing starts are 3,500, and advertising expenditure is $3,500. Interpret the interval.
Answer to relevant QuestionsWould it be appropriate to use the Woodbon model to make a prediction for mortgage rates of 6%, housing starts of 2,500, and advertising expenditure of $4,000? Explain why or why not. Does the Woodbon model that includes mortgage rates and advertising expenditure meet the required conditions for regression? If so, conduct an F-test on the significance of the model. A sales manager is trying to build a sales forecasting model based on number of sales contacts and region. Is region a significant explanatory variable in this model? Examine the residual plots produced by Excel for the Salaries multiple regression model that you built for Develop Your Skills 14.2, Exercise 5, which included years of postsecondary education and years of experience as ...A chain of retail outlets famous for their delicious (if unhealthy) doughnuts is looking for a new location. The company is trying to use data on local median income, population in the local area, and traffic flows by a ...
Post your question