Question: please help me on this one 1. (20 Points) Given the following regression result: X = Advertising Expenditures next month Y = Units Sold Next
please help me on this one
1. (20 Points) Given the following regression result: X = Advertising Expenditures next month Y = Units Sold Next Month 36 SUMMARY OUTPUT Regression Statistics Adjusted R Square 0.77 Standard Error 400.00 Observations Coefficients Intercept 1000.00 X (Advertising $) 20.00 a. If you are going to spend $600 on advertising (X = $600) next month, forecast units sold. Assuming your forecast is 13,000 units, complete b through e. b. Construct a 95% confidence interval around your forecast c. How many units should be produced to be 96% certain that there will be enough? d. If the company sells 12,600 units or less next month, it will not generate enough cash flow for a debt payment that is due. What is the probability that the company will sell 12,600 units or less? e. What percent of the variation in Units Sold is explained by Advertising Expenditures
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
