Multiple Regression (Due in 6 hours)
For this task, you’re required to finish Downside 64 (p. 593) in Chapter 12 of your textbook. Use the suitable Excel file templates from www.cengagebrain.com. As soon as full, submit your Excel Doc in Waypoint. Present all work.
23-64) Let Yt be the gross sales throughout month t (in hundreds of dollars) for a pictures studio, and let Pt be the value charged for portraits throughout month t. The information are within the file Week four Project Chapter 12 Downside 64Preview the documentView in a brand new window. Use regression to suit the next mannequin to those information:
Yt = a + b1Yt−1 + b2Pt + et
This equation signifies that final month’s gross sales and the present month’s worth are explanatory variables. The final time period, et, is an error time period.
If the value of a portrait throughout month 21 is $10, what would you are expecting for gross sales in month 21?
Does there seem like an issue with autocorrelation of the residual? Clarify your reply.
Fastidiously assessment the Grading Rubric (Hyperlinks to an exterior web site.)Hyperlinks to an exterior web site. for the factors that will likely be used to guage your task.
