USA: +1 (725) 712-1730
USA: +1 (725) 712-1730

Question & Answer: Air travel on Mountain Airlines for the past 18 weeks was: b. Use an appropriate technique to develop a fo…..

Air travel on Mountain Airlines for the past 18 weeks was: Week Passengers Week Passengers 405 410 428 415 412 428 424 433 438 1e 448 446 451 455 464 466 474 476 482 4 13 16 17 b. Use an appropriate technique to develop a forecast for the expected number of passengers for the next three weeks. (Round your intermediate calculations to 4 decimal places and final answers to 2 decimal places.) Week 19 28 21 Forecasted Demand

Air travel on Mountain Airlines for the past 18 weeks was: b. Use an appropriate technique to develop a forecast for the expected number of passengers for the next three weeks. (Round your intermediate calculations to 4 decimal places and final answers to 2 decimal places.)

Expert Answer

 

b)

X Y XY X2
1 405 405 1
2 410 820 4
3 420 1260 9
4 415 1660 16
5 412 2060 25
6 420 2520 36
7 424 2968 49
8 433 3464 64
9 438 3942 81
10 440 4400 100
11 446 4906 121
12 451 5412 144
13 455 5915 169
14 464 6496 196
15 466 6990 225
16 474 7584 256
17 476 8092 289
18 482 8676 324
sumX = 171 sumY=7931 sumXY=77570 sumX2=2109

b = (nΣXY – ΣXΣY) / [nΣX2 – (ΣX)2]

= (18 (77570) – (171X7931)

18(2019 )- (171)2

= 1396260 – 1356201

36342-29241

= 40059

7101

= 5.64

a =  (ΣY / n) – b (ΣX / n)

7931/18 – 5.64 (171/18)

= 440.62 – 53.68 = 387.04

19 = 387.04 + 5.64(19) = 494.2

20 = 387.04 + 5.64 (20) = 499.84

21. 387.04 + 5.64 (21) = 505.48

Still stressed from student homework?
Get quality assistance from academic writers!
Order now