08-10-2011, 03:00 PM
Ok, I have another question now. I'm on exam 2 and I'm having a little trouble understanding what I should be putting here.
The question is as follows:
3. Consider the following sales data for 1999
Month J F M A M J J Aug Sept Oct
Demand 12 14 16 17 19 23 24 18 21
e. A linear trend has been considered. If a = 12 and b = 2.1, forecast all periods from January to October.
When I enter in the data into Excel OM under the I get an intercept of 12.38888 (which I believe intercerpt = a) and a slope of 1.166666 (which I believe slope = b). Gives me a forecast of 24.0555 for October.
Am I supposed to enter in his values for intercept and slope then? If I do, it changes the forecast to 33. Or am I misinterpreting what a and b mean in the problem?
Thanks for any help.
The question is as follows:
3. Consider the following sales data for 1999
Month J F M A M J J Aug Sept Oct
Demand 12 14 16 17 19 23 24 18 21
e. A linear trend has been considered. If a = 12 and b = 2.1, forecast all periods from January to October.
When I enter in the data into Excel OM under the I get an intercept of 12.38888 (which I believe intercerpt = a) and a slope of 1.166666 (which I believe slope = b). Gives me a forecast of 24.0555 for October.
Am I supposed to enter in his values for intercept and slope then? If I do, it changes the forecast to 33. Or am I misinterpreting what a and b mean in the problem?
Thanks for any help.
~Banta
Graduated 2/17/11: BS in Business, Concentration: General Business from Excelsior College
EXAMS/COURSES TAKEN: UB - Principles of Comm - C | UB - US History II - C | AS - Freshman Comp - C | CLEP Humanities - 70 | CLEP College Math - 66 | CLEP Bio - 70 | CLEP Psych - 74 | CLEP American Gov - 68 | CLEP Social Sciences - 73 | CLEP Microeconomics - 72 | CLEP Macroeconomics - 74 | CLEP Management - 72 | DSST Supervision - 457 | DSST HRM - 70 | DSST OB - 75 | ALEKS College Algebra - 78% | ALEKS Intro to Statistics - 71% | CSU Pueblo 311 MGMT - A | SL Accounting I - A | SL Accounting II - A | DSST Finance - 458 | DSST M&B - 63 | CLEP Intro Business Law - 71 | DSST Business Law II - 79 | CLEP Info Systems - 73 | DSST MIS - 481 | DSST Business Ethics - 458 | DSST Intro to Business - 461 | DSST Environment - 70 | CLEP Marketing - 71 | CLEP A&I - 73 | SL Sociology - 98% | SL Intro to Criminal Justice - 96% | SL Western Civ I - 92% | Excelsior BUS 495 - A
Degree plan.
Graduated 2/17/11: BS in Business, Concentration: General Business from Excelsior College
EXAMS/COURSES TAKEN: UB - Principles of Comm - C | UB - US History II - C | AS - Freshman Comp - C | CLEP Humanities - 70 | CLEP College Math - 66 | CLEP Bio - 70 | CLEP Psych - 74 | CLEP American Gov - 68 | CLEP Social Sciences - 73 | CLEP Microeconomics - 72 | CLEP Macroeconomics - 74 | CLEP Management - 72 | DSST Supervision - 457 | DSST HRM - 70 | DSST OB - 75 | ALEKS College Algebra - 78% | ALEKS Intro to Statistics - 71% | CSU Pueblo 311 MGMT - A | SL Accounting I - A | SL Accounting II - A | DSST Finance - 458 | DSST M&B - 63 | CLEP Intro Business Law - 71 | DSST Business Law II - 79 | CLEP Info Systems - 73 | DSST MIS - 481 | DSST Business Ethics - 458 | DSST Intro to Business - 461 | DSST Environment - 70 | CLEP Marketing - 71 | CLEP A&I - 73 | SL Sociology - 98% | SL Intro to Criminal Justice - 96% | SL Western Civ I - 92% | Excelsior BUS 495 - A
Degree plan.
![[-]](https://www.degreeforum.net/mybb/images/collapse.png)