Question: Consider the demand for trading cards as listed below. table [ [ Month , Demand ] , [ January , 4 6 , 0

Consider the demand for trading cards as listed below.
\table[[Month,Demand],[January,46,000],[February,40,000],[March,55,000],[April,65,000],[May,79,000],[June,73,000],[July,80,000],[August,93,000],[September,94,000]]
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. \table[[Month,Demand],[January,46,000],[February,40,000],[March,55,000],[April,65,000],[May,79,000],[June,73,000],[July,80,000],[August,93,000],[September,94,000]] Use

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!