Question: 1. Calculate the b parameter for the linear regression of the following data: Period Value 1 507 2 520 3 544 4 539 5 562

1. Calculate the b parameter for the linear regression of the following data:

Period Value
1 507
2 520
3 544
4 539
5 562
6 532
7 537
8 529

(Keep 3 decimals in your answer)

2. Calculate the a parameter for the linear regression of the following data:

Period Value
1 8,997
2 9,111
3 9,114
4 9,007
5 9,023
6 9,021
7 8,890
8 8,963

(Keep 3 decimals in your answer)

3. Calculate the Standard Error of Estimate for the linear regression of the following data:

Period Value
1 9,420
2 9,138
3 9,187
4 8,840
5 8,742
6 9,021
7 8,890
8 9,140

(Keep 2 decimals in your answer)

4. What is the seasonality factor for sales in Month 5?

Month Sales
1 17,601
2 15,303
3 15,970
4 17,156
5 16,144
6 15,865
7 15,101
8 15,917
9 18,476
10 18,339
11 17,253
12 18,654

(Keep 3 decimals in your answer)

5. What is the exponential smoothing forecast for period 5 assuming that alpha = 0.5?

Period Heat
1 418
2 411
3 412
4 413
5 418
6 414
7 421

(Keep 2 decimals in your answer)

6. What is the five period moving average for period 10 for the following data:

Period Gallons
1 288
2 286
3 300
4 290
5 276
6 318
7 331
8 298
9 308

(Keep 2 decimal places in your answer)

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!