1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
A B C D E F G H I J K L M N O P Q R
Template for Moving-Average Forecasting Method with Seasonality
Seasonally Seasonally Range Name Cells
True Adjusted Adjusted Actual Forecasting Number of previous ActualForecast G6:G35
Year Month Value Value Forecast Forecast Error periods to consider ForecastingError H6:H35
1 Jan 68 76 n = 3 MAD K26
1 Feb 71 81 #N/A MSE K29
1 Mar 66 73 #N/A
Type of Seasonality NumberOfPeriods K6
1 Apr 72 77 76 71 1 Monthly SeasonalFactor K12:K23
1 May 77 80 77 74 3 SeasonallyAdjustedForecast F6:F35
1 June 85 78 77 84 1
Month Seasonal Factor SeasonallyAdjustedValue E6:E35
1 July 94 80 79 92 2 Jan 0.90 TrueValue D6:D35
1 Aug 96 83 80 91 5 Feb 0.88 TypeOfSeasonality K9
1 Sep 80 82 81 78 2 Mar 0.91
1 Oct 73 80 82 75 2 Apr 0.93
1 Nov 84 80 82 86 2 May 0.96
1 Dec 89 82 81 87 2 June 1.09
2 Jan 75 83 81 73 2 July 1.17
2 Feb 76 86 82 72 4 Aug 1.15
2 Mar 81 89 84 76 5 Sep 0.97
2 Apr 84 90 86 80 4 Oct 0.91
2 May 85 89 89 85 0 Nov 1.05
2 June 99 91 89 97 2 Dec 1.08
2 July 107 91 90 105 2
2 Aug 108 94 90 104 4Mean Absolute Deviation
2 Sep 94 97 92 89 5 MAD = 2.79
2 Oct 90 99 94 86 4
2 Nov 106 101 97 101 5Mean Square Error
2 Dec 110 102 99 107 3 MSE = 9.68
3 Jan #N/A 101 91
3 Feb #N/A #N/A
3 Mar #N/A #N/A
3 Apr #N/A #N/A
3 May #N/A #N/A
3 June #N/A #N/A
0
20
40
60
80
100
120
1 3 5 7 9 11 13 15 17 19 21 23 25 27 29
Seasonally-Adjusted Value
Time Period
Seasonally Adjusted
Value
Seasonally Adjusted
Forecast
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
A B C D E F G H I J K L M N O P Q R
Template for Exponential Smoothing Forecasting Method with Seasonality
Seasonally Seasonally Range Name Cells
True Adjusted Adjusted Actual Forecasting Smoothing Constant ActualForecast G6:G35
Year Month Value Value Forecast Forecast Error a = 0.2 Alpha K5
1 Jan 68 76 80 72 4 ForecastingError H6:H35
1 Feb 71 81 79 70 1
Initial Estimate InitialEstimate K8
1 Mar 66 73 79 72 6 Average = 80 MAD K28
1 Apr 72 77 78 73 1 MSE K31
1 May 77 80 78 75 2
Type of Seasonality SeasonalFactor K14:K25
1 June 85 78 78 85 0 Monthly SeasonallyAdjustedForecast F6:F35
1 July 94 80 78 92 2 SeasonallyAdjustedValue E6:E35
1 Aug 96 83 79 91 5
Month Seasonal Factor TrueValue D6:D35
1 Sep 80 82 80 77 3 Jan 0.90 TypeOfSeasonality K11
1 Oct 73 80 80 73 0 Feb 0.88
1 Nov 84 80 80 84 0 Mar 0.91
1 Dec 89 82 80 87 2 Apr 0.93
2 Jan 75 83 81 73 2 May 0.96
2 Feb 76 86 81 71 5 June 1.09
2 Mar 81 89 82 75 6 July 1.17
2 Apr 84 90 84 78 6 Aug 1.15
2 May 85 89 85 82 3 Sep 0.97
2 June 99 91 86 93 6 Oct 0.91
2 July 107 91 87 101 6 Nov 1.05
2 Aug 108 94 88 101 7 Dec 1.08
2 Sep 94 97 89 86 8
2 Oct 90 99 90 82 8Mean Absolute Deviation
2 Nov 106 101 92 97 9 MAD = 4.28
2 Dec 110 102 94 101 9
3 Jan #N/A 96 86 Mean Square Error
3 Feb #N/A #N/A MSE = 25.87
3 Mar #N/A #N/A
3 Apr #N/A #N/A
3 May #N/A #N/A
3 June #N/A #N/A
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
A B C D E F G H I J K L M N O P Q R S T U
Template for Exponential-Smoothing with Trend Forecasting Method with Seasonality
Seasonally Seasonally Range Name Cells
True Adjusted Latest Estimated Adjusted Actual Forecasting Smoothing Constant ActualForecast I6:I35
Year Month Value Value Trend Trend Forecast Forecast Error a = 0.2 Alpha M5
1 Jan 75 83 282 74 1b = 0.2 Beta M6
1 Feb 76 86 2 2 84 74 2 ForecastingError J6:J35
1 Mar 81 89 2 2 87 79 2Initial Estimate InitialEstimateAverage M9
1 Apr 84 90 3 2 90 83 1 Average = 80 InitialEstimateTrend M10
1 May 85 89 2 2 92 88 3 Trend = 2 MAD M30
1 June 99 91 2 2 93 102 3 MSE M33
1 July 107 91 2 2 95 111 4Type of Seasonality SeasonalFactor M16:M27
1 Aug 108 94 1 2 96 110 2 Monthly SeasonallyAdjustedForecast H6:H35
1 Sep 94 97 1 2 97 95 1 SeasonallyAdjustedValue E6:E35
1 Oct 90 99 2 2 99 90 0Month Seasonal Factor TrueValue D6:D35
1 Nov 106 101 2 2 101 106 0 Jan 0.90 TypeOfSeasonality M13
1 Dec 110 102 2 2 103 111 1 Feb 0.88
2 Jan #N/A 2 2 104 94 Mar 0.91
2 Feb #N/A #N/A Apr 0.93
2 Mar #N/A #N/A May 0.96
2 Apr #N/A #N/A June 1.09
2 May #N/A #N/A July 1.17
2 June #N/A #N/A Aug 1.15
2 July #N/A #N/A Sep 0.97
2 Aug #N/A #N/A Oct 0.91
2 Sep #N/A #N/A Nov 1.05
2 Oct #N/A #N/A Dec 1.08
2 Nov #N/A #N/A
2 Dec #N/A #N/A Mean Absolute Deviation
3 Jan #N/A #N/A MAD = 1.66
3 Feb #N/A #N/A
3 Mar #N/A #N/A Mean Square Error
3 Apr #N/A #N/A MSE = 4.21
3 May #N/A #N/A
3 June #N/A #N/A
0
20
40
60
80
100
120
1 3 5 7 9 11 13 15 17 19 21 23 25 27 29
Seasonally-Adjusted Value
Time Period
Seasonally Adjusted Value
Seasonally Adjusted
Forecast
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
A B C D E F G H I J K L M N O P Q R S T U
Template for Exponential-Smoothing with Trend Forecasting Method with Seasonality
Seasonally Seasonally Range Name Cells
True Adjusted Latest Estimated Adjusted Actual Forecasting Smoothing Constant ActualForecast I6:I35
Year Month Value Value Trend Trend Forecast Forecast Error a = 0.2 Alpha M5
1 Jan 68 76 080 72 4b = 0.2 Beta M6
1 Feb 71 81 -1 079 69 2 ForecastingError J6:J35
1 Mar 66 73 0 0 79 72 6Initial Estimate InitialEstimateAverage M9
1 Apr 72 77 -1 077 72 0 Average = 80 InitialEstimateTrend M10
1 May 77 80 0 0 77 74 3 Trend = 0 MAD M30
1 June 85 78 0 0 77 84 1 MSE M33
1 July 94 80 0 0 77 90 4Type of Seasonality SeasonalFactor M16:M27
1 Aug 96 83 0 0 78 89 7 Monthly SeasonallyAdjustedForecast H6:H35
1 Sep 80 82 1 0 79 77 3 SeasonallyAdjustedValue E6:E35
1 Oct 73 80 1 0 80 73 0Month Seasonal Factor TrueValue D6:D35
1 Nov 84 80 0 0 80 84 0 Jan 0.90 TypeOfSeasonality M13
1 Dec 89 82 0 0 80 87 2 Feb 0.88
2 Jan 75 83 1 0 81 73 2 Mar 0.91
2 Feb 76 86 1 0 82 72 4 Apr 0.93
2 Mar 81 89 1 1 83 76 5 May 0.96
2 Apr 84 90 2 1 85 79 5 June 1.09
2 May 85 89 2 1 87 84 1 July 1.17
2 June 99 91 1 1 89 97 2 Aug 1.15
2 July 107 91 1 1 90 106 1 Sep 0.97
2 Aug 108 94 1 1 92 105 3 Oct 0.91
2 Sep 94 97 2 1 93 91 3 Nov 1.05
2 Oct 90 99 2 1 96 87 3 Dec 1.08
2 Nov 106 101 2 2 98 103 3
2 Dec 110 102 2 2 100 108 2Mean Absolute Deviation
3 Jan #N/A 2 2 102 92 MAD = 2.74
3 Feb #N/A #N/A
3 Mar #N/A #N/A Mean Square Error
3 Apr #N/A #N/A MSE = 10.44
3 May #N/A #N/A
3 June #N/A #N/A
0
20
40
60
80
100
120
1 3 5 7 9 11 13 15 17 19 21 23 25 27 29
Seasonally-Adjusted Value
Time Period
Seasonally Adjusted Value
Seasonally Adjusted
Forecast
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
A B C D E F G H I J
Template for Seasonal Factors
True Range Name Cells
Year Month Value Type of Seasonality SeasonalFactor G10:G21
1 Jan 352 Monthly TrueValue D5:D41
1 Feb 329 TypeOfSeasonality F5
1 Mar 365
1 Apr 358
Estimate for
1 May 412 Month Seasonal Factor
1 June 446 Jan 0.81
1 July 420 Feb 0.81
1 Aug 471 Mar 0.88
1 Sep 355 Apr 0.92
1 Oct 312 May 1.02
1Nov 567 June 1.11
1Dec 533 July 1.02
2 Jan 317 Aug 1.19
2 Feb 331 Sep 0.81
2 Mar 344 Oct 0.76
2 Apr 386 Nov 1.44
2 May 423 Dec 1.26
2 June 472
2 July 415
2 Aug 492
2 Sep 340
2 Oct 301
2Nov 629
2Dec 505
3 Jan 338
3 Feb 346
3 Mar 383
3 Apr 404
3 May 431
3 June 459
3 July 433
3 Aug 518
3 Sep 309
3 Oct 335
3Nov 594
3Dec 527
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
A B C D E F G H I J K L M N O P Q R
Template for Moving-Average Forecasting Method with Seasonality
Seasonally Seasonally Range Name Cells
True Adjusted Adjusted Actual Forecasting Number of previous ActualForecast G6:G35
Year Month Value Value Forecast Forecast Error periods to consider ForecastingError H6:H35
1 Jan #N/A n = 3 MAD K26
1 Feb #N/A #N/A MSE K29
1 Mar #N/A #N/A
Type of Seasonality NumberOfPeriods K6
1 Apr #N/A #N/A Monthly SeasonalFactor K12:K23
1 May #N/A #N/A SeasonallyAdjustedForecast F6:F35
1 June #N/A #N/A
Month Seasonal Factor SeasonallyAdjustedValue E6:E35
1 July #N/A #N/A Jan 0.81 TrueValue D6:D35
1 Aug #N/A #N/A Feb 0.81 TypeOfSeasonality K9
1 Sep #N/A #N/A Mar 0.88
1 Oct 335 440 #N/A Apr 0.92
1 Nov 594 413 #N/A May 1.02
1 Dec 527 420 #N/A June 1.11
2 Jan 364 450 424 343 21 July 1.02
2 Feb 343 425 428 345 2 Aug 1.19
2 Mar 391 446 432 378 13 Sep 0.81
2 Apr 437 474 440 406 31 Oct 0.76
2 May 458 451 448 456 2 Nov 1.44
2 June 494 447 457 505 11 Dec 1.26
2 July 468 460 457 465 3
2 Aug 555 467 453 538 17 Mean Absolute Deviation
2 Sep 387 480 458 369 18 MAD = 13.30
2 Oct 364 478 469 357 7
2 Nov 662 461 475 683 21 Mean Square Error
2 Dec 581 463 473 594 13 MSE = 249.09
3 Jan #N/A 467 378
3 Feb #N/A #N/A
3 Mar #N/A #N/A
3 Apr #N/A #N/A
3 May #N/A #N/A
3 June #N/A #N/A
380
400
420
440
460
480
500
1 3 5 7 9 11 13 15 17 19 21 23 25 27 29
Seasonally-Adjusted Value
Time Period
Seasonally Adjusted
Value
Seasonally Adjusted
Forecast
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
A B C D E F G H I J K L M N O P Q R
Template for Exponential Smoothing Forecasting Method with Seasonality
Seasonally Seasonally Range Name Cells
True Adjusted Adjusted Actual Forecasting Smoothing Constant ActualForecast G6:G35
Year Month Value Value Forecast Forecast Error a = 0.2 Alpha K5
1 Jan 364 450 420 339 25 ForecastingError H6:H35
1 Feb 343 425 426 344 1
Initial Estimate InitialEstimate K8
1 Mar 391 446 426 373 18 Average = 420 MAD K28
1 Apr 437 474 430 396 41 MSE K31
1 May 458 451 439 446 12
Type of Seasonality SeasonalFactor K14:K25
1 June 494 447 441 488 6 Monthly SeasonallyAdjustedForecast F6:F35
1 July 468 460 442 450 18 SeasonallyAdjustedValue E6:E35
1 Aug 555 467 446 530 25
Month Seasonal Factor TrueValue D6:D35
1 Sep 387 480 450 363 24 Jan 0.81 TypeOfSeasonality K11
1 Oct 364 478 456 347 17 Feb 0.81
1 Nov 662 461 461 662 0 Mar 0.88
1 Dec 581 463 461 579 2 Apr 0.92
2 Jan #N/A 461 373 May 1.02
2 Feb #N/A #N/A June 1.11
2 Mar #N/A #N/A July 1.02
2 Apr #N/A #N/A Aug 1.19
2 May #N/A #N/A Sep 0.81
2 June #N/A #N/A Oct 0.76
2 July #N/A #N/A Nov 1.44
2 Aug #N/A #N/A Dec 1.26
2 Sep #N/A #N/A
2 Oct #N/A #N/A Mean Absolute Deviation
2 Nov #N/A #N/A MAD = 15.83
2 Dec #N/A #N/A
3 Jan #N/A #N/A Mean Square Error
3 Feb #N/A #N/A MSE = 384.99
3 Mar #N/A #N/A
3 Apr #N/A #N/A
3 May #N/A #N/A
3 June #N/A #N/A
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
A B C D E F G H I J K L M N O P Q R S T U
Template for Exponential-Smoothing with Trend Forecasting Method with Seasonality
Seasonally Seasonally Range Name Cells
True Adjusted Latest Estimated Adjusted Actual Forecasting Smoothing Constant ActualForecast I6:I35
Year Month Value Value Trend Trend Forecast Forecast Error a = 0.2 Alpha M5
1 Jan 364 450 0420 339 25 b = 0.2 Beta M6
1 Feb 343 425 6 1 427 345 2 ForecastingError J6:J35
1 Mar 391 446 1 1 428 375 16 Initial Estimate InitialEstimateAverage M9
1 Apr 437 474 5 2 433 399 38 Average = 420 InitialEstimateTrend M10
1 May 458 451 10 3445 452 6 Trend = 0 MAD M30
1 June 494 447 5 4 450 497 3 MSE M33
1 July 468 460 3 4 453 461 7Type of Seasonality SeasonalFactor M16:M27
1 Aug 555 467 5 4 458 545 10 Monthly SeasonallyAdjustedForecast H6:H35
1 Sep 387 480 6 4 464 374 13 SeasonallyAdjustedValue E6:E35
1 Oct 364 478 7 5 472 359 5Month Seasonal Factor TrueValue D6:D35
1 Nov 662 461 6 5 479 688 26 Jan 0.81 TypeOfSeasonality M13
1 Dec 581 463 2 4 479 602 21 Feb 0.81
2 Jan #N/A 1 4 480 388 Mar 0.88
2 Feb #N/A #N/A Apr 0.92
2 Mar #N/A #N/A May 1.02
2 Apr #N/A #N/A June 1.11
2 May #N/A #N/A July 1.02
2 June #N/A #N/A Aug 1.19
2 July #N/A #N/A Sep 0.81
2 Aug #N/A #N/A Oct 0.76
2 Sep #N/A #N/A Nov 1.44
2 Oct #N/A #N/A Dec 1.26
2 Nov #N/A #N/A
2 Dec #N/A #N/A Mean Absolute Deviation
3 Jan #N/A #N/A MAD = 14.26
3 Feb #N/A #N/A
3 Mar #N/A #N/A Mean Square Error
3 Apr #N/A #N/A MSE = 314.71
3 May #N/A #N/A
3 June #N/A #N/A
380
390
400
410
420
430
440
450
460
470
480
490
1 3 5 7 9 11 13 15 17 19 21 23 25 27 29
Seasonally-Adjusted Value
Time Period
Seasonally Adjusted Value
Seasonally Adjusted
Forecast
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
A B C D E F G H I J K L M N O P
Template for Linear Regression
Time Independent Dependent Estimation Square Linear Regression Line Range Name Cells
Period Variable Variable Estimate Error of Error y = a + bx aJ5
1 1 430 428 2.04 4a = 410.33 bJ6
2 2 446 446 0.41 0b = 17.63 DependentVariable D5:D34
3 3 464 463 0.78 1 Estimate E5:E34
4 4 480 481 0.85 1 EstimationError F5:F34
5 5 498 498 0.48 0Estimator IndependentVariable C5:C34
6 6 514 516 2.12 4 If x = 20 SquareOfError G5:G34
7 7 532 534 1.75 3 x J10
8 8 548 551 3.38 11 then y= 762.94 y J12
9 9 570 569 0.99 1
10 10 591 587 4.36 19
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
y = 17.63x + 410.33
0
100
200
300
400
500
600
700
0 2 4 6 8 10 12
Dependent Variable
Independent Variable
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
A B C D E F G H I J K L M N O P
Template for Linear Regression
Time Independent Dependent Estimation Square Linear Regression Line Range Name Cells
Period Variable Variable Estimate Error of Error y = a + bx aJ5
1 1 4,600 4,600 0.00 0a = 3,900.00 bJ6
2 2 5,300 5,300 0.00 0b = 700.00 DependentVariable D5:D34
3 3 6,000 6,000 0.00 0 Estimate E5:E34
4 EstimationError F5:F34
5Estimator IndependentVariable C5:C34
6 If x = 20 SquareOfError G5:G34
7 x J10
8 then y= 17,900.00 y J12
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
y = 700x + 3900
0
1,000
2,000
3,000
4,000
5,000
6,000
7,000
0 1 1 2 2 3 3 4
Dependent Variable
Independent Variable
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
A B C D E F G H I J K L M N O P
Template for Linear Regression
Time Independent Dependent Estimation Square Linear Regression Line Range Name Cells
Period Variable Variable Estimate Error of Error y = a + bx aJ5
1 1 4,600 5,321 721.43 520,459 a = 5,229 bJ6
2 2 5,300 5,414 114.29 13,061 b = 92.9 DependentVariable D5:D34
3 3 6,000 5,507 492.86 242,908 Estimate E5:E34
4 4 6,300 5,600 700.00 490,000 EstimationError F5:F34
5 5 6,200 5,693 507.14 257,194 Estimator IndependentVariable C5:C34
6 6 5,600 5,786 185.71 34,490 If x = 8 SquareOfError G5:G34
7 7 5,200 5,879 678.57 460,459 x J10
8 then y= 5,971 y J12
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
y = 92.857x + 5228.6
0
1,000
2,000
3,000
4,000
5,000
6,000
7,000
0 1 2 3 4 5 6 7 8
Dependent Variable
Independent Variable
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
A B C D E F G H I J K L M N O P
Template for Exponential Smoothing Forecasting Method with Trend
Exponential Range Name Cells
Time True Latest Estimated Smoothing Forecasting Alpha J6
Period Value Trend Trend Forecast Error Smoothing Constants Beta J7
1 4,600 700.00 4,600 0 a = 0.5 EstimatedTrend E6:E35
2 5,300 700.00 700.00 5,300 0 b = 0.5 Forecast F6:F35
3 6,000 700.00 700.00 6,000 0 ForecastingError G6:G35
4 6,300 700.00 700.00 6,700 400 Initial Estimates InitialEstimateAverage J10
5 6,200 500.00 600.00 7,100 900 Average = 3,900 InitialEstimateTrend J11
6 5,600 150.00 375.00 7,025 1,425 Trend = 700 LatestTrend D6:D35
7 5,200 -337.50 18.75 6,331 1,131 MAD J14
8 -546.88 -264.06 5,502 Mean Absolute Deviation MSE J17
9#N/A MAD = 550.89 TrueValue C6:C35
10 #N/A
11 #N/A Mean Square Error
12 #N/A MSE = 611,478.79
13 #N/A
14 #N/A
15 #N/A
16 #N/A
17 #N/A
18 #N/A
19 #N/A
20 #N/A
21 #N/A
22 #N/A
23 #N/A
24 #N/A
25 #N/A
26 #N/A
27 #N/A
28 #N/A
29 #N/A
30 #N/A
0
1,000
2,000
3,000
4,000
5,000
6,000
7,000
8,000
1 3 5 7 9 11 13 15 17 19 21 23 25 27 29
Value
Time Period
True Value
Forecast
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
A B C D E F G H I J K L M N O P
Template for Linear Regression
Time Independent Dependent Estimation Square Linear Regression Line Range Name Cells
Period Variable Variable Estimate Error of Error y = a + bx aJ5
1 1 382 388 6.42 41 a = 380 bJ6
2 2 405 397 8.43 71 b = 8.15 DependentVariable D5:D34
3 3 398 405 6.72 45 Estimate E5:E34
4 4 421 413 8.13 66 EstimationError F5:F34
5 5 426 421 4.98 25 Estimator IndependentVariable C5:C34
6 6 415 429 14.18 201 If x = 11 SquareOfError G5:G34
7 7 443 437 5.67 32 x J10
8 8 451 445 5.52 30 then y= 470 y J12
9 9 446 454 7.63 58
10 10 464 462 2.22 5
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
y = 8.1515x + 380.27
0
50
100
150
200
250
300
350
400
450
500
0 2 4 6 8 10 12
Dependent Variable
Independent Variable
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
A B C D E F G H I J K L M N O P
Template for Linear Regression
Time Independent Dependent Estimation Square Linear Regression Line Range Name Cells
Period Variable Variable Estimate Error of Error y = a + bx aJ5
1225 16 16 0.21 0a = 8.71 bJ6
2400 21 21 0.29 0b = 0.031 DependentVariable D5:D34
3350 20 20 0.29 0 Estimate E5:E34
4275 17 17 0.36 0 EstimationError F5:F34
5450 23 23 0.14 0Estimator IndependentVariable C5:C34
6 If x = 300 SquareOfError G5:G34
7 x J10
8 then y= 18 y J12
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
y = 0.0314x + 8.7143
0
5
10
15
20
25
050 100 150 200 250 300 350 400 450 500
Dependent Variable
Independent Variable
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
A B C D E F G H I J K L M N O P
Template for Linear Regression
Time Independent Dependent Estimation Square Linear Regression Line Range Name Cells
Period Variable Variable Estimate Error of Error y = a + bx aJ5
1162 12 12 0.30 0a = -3.38 b J6
2149 910 1.49 2b = 0.093 DependentVariable D5:D34
3185 13 14 0.84 1 Estimate E5:E34
4171 14 13 1.46 2 EstimationError F5:F34
5138 10 90.53 0Estimator IndependentVariable C5:C34
6154 11 11 0.04 0 If x = 150 SquareOfError G5:G34
7 x J10
8 then y= 11 y J12
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
y = 0.0931x – 3.382
0
2
4
6
8
10
12
14
16
020 40 60 80 100 120 140 160 180 200
Dependent Variable
Independent Variable
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
A B C D E F G H I J K L M N O P
Template for Linear Regression
Time Independent Dependent Estimation Square Linear Regression Line Range Name Cells
Period Variable Variable Estimate Error of Error y = a + bx aJ5
1323 24 22 2.48 6a = -9.95 b J6
2359 23 25 2.02 4b = 0.10 DependentVariable D5:D34
3396 28 29 0.63 0 Estimate E5:E34
4421 32 31 0.93 1 EstimationError F5:F34
5457 34 35 0.57 0Estimator IndependentVariable C5:C34
6472 37 36 0.97 1 If x = 150 SquareOfError G5:G34
7446 33 34 0.50 0 x J10
8407 30 30 0.30 0 then y= 5 y J12
9374 27 26 0.51 0
10 343 22 23 1.47 2
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
y = 0.0974x – 9.9542
0
5
10
15
20
25
30
35
40
050 100 150 200 250 300 350 400 450 500
Dependent Variable
Independent Variable