Question: Consider the demand for trading cards as listed below. Use Excel to prepare a forecast for October, November, and December using linear regression. Please show
Consider the demand for trading cards as listed below. Use Excel to prepare a forecast for October, November, and December using linear regression. Please show the slope and the intercept of the linear regression model. a) The slope is (round your response to two decimal places). b) The intercept is (round your response to two decimal places). c) The forecast demand for October is (round your response to the nearest integer). d) The forecast demand for November is (round your response to the nearest integer). e) The forecast demand for December is (round your response to the nearest integer). Consider the demand for trading cards as listed below. Use Excel to prepare a forecast for October, November, and December using linear regression. Please show the slope and the intercept of the linear regression model. a) The slope is (round your response to two decimal places). b) The intercept is (round your response to two decimal places). c) The forecast demand for October is (round your response to the nearest integer). d) The forecast demand for November is (round your response to the nearest integer). e) The forecast demand for December is (round your response to the nearest integer)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
