Problem 8 Week Passenge rs 1 405 2 410 3 420 4 415 5 412 6 420 7 424 8 433 9 438 10 440 11 446 12 451 13 455 14 464 15 466 16 474 17 476 18 482 a: Explain why an averaging tchnique would not be appropriate for forecasting b: what is the appropriate technique to forcast for the next three weeks first scatter plot next: linear trend b: what is the appropriate technique to forcast for the next three weeks first scatter plot next: linear trend Week Passenge 1*Y rs t Y 1 405 1 405 405 1 2 410 2 410 820 4 3 420 3 420 1,260 9 4 415 4 415 1,660 16 5 412 5 412 2,060 25 6 420 6 420 2,520 36 7 424 7 424 2,968 49 8 433 8 433 3,464 64 9 438 9 438 3,942 81 10 440 10 440 4,400 100 11 446 11 446 4,906 121 12 451 12 451 5,412 144 13 455 13 455 5,915 169 14 464 14 464 6,496 196 15 466 15 466 6,990 225 16 474 16 474 7,584 256 17 476 17 476 8,092 289 18 482 18 482 8,676 324 Total all columns bm nty-[Y/n - (20 Slope of the line 1*Y Week Passenge t Y 1 405 1 405 405 1 2 410 2 410 820 4 3 420 3 420 1,260 9 4 415 4 415 1,660 16 5 412 5 412 2,060 25 6 420 6 420 2,520 36 7 424 7 424 2,968 49 8 433 8 433 3,464 64 9 438 9 438 3,942 81 10 440 10 440 4,400 100 11 446 11 446 4,906 121 12 451 12 451 5,412 144 13 455 13 455 5,915 169 14 464 14 464 6,496 196 15 466 15 466 6,990 225 16 474 16 474 7,584 256 17 476 17 476 8,092 289 18 482 18 482 8,676 324 Total all columns bm nty-y/nt - (20 a=>Y-bt Week 19 Y=a+b19 Week 20 Week 21 Explain rationale as well as provide your forcasts Slope of the line Value of y when x=0