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 integerConsider the demand for trading cards as listed below.
Month
Demand
January
comma
February
comma
March
comma
April
comma
May
comma
June
comma
July
comma
August
comma
September
comma
Question content area bottom
Part
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
enter your response here round your response to two decimal places
b The intercept is
enter your response here round your response to two decimal places
c The forecast demand for October is
enter your response here round your response to the nearest integer
d The forecast demand for November is
enter your response here round your response to the nearest integer
e The forecast demand for December is
enter your response here round your response to the nearest integer
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
