| t | t*t | EOM | LINEST | Regression Fit | ||||||
| 1 | 1 | 360.071 | ||||||||
| 2 | 4 | 361.217 | ||||||||
| 3 | 9 | 358.774 | 0.098857 | -0.67414 | 361.0294 | |||||
| 4 | 16 | 360.271 | 0.521929 | -3.84953 | 366.5164 | 359.4691429 | ||||
| 5 | 25 | 360.139 | 0.0455 | 0.5597 | 356.8228 | 360.7588 | Note | |||
| 6 | 36 | 362.164 | -0.21929 | 3.229029 | 350.4293 | 361.9091714 | 1. Calculate LINEST for the top row | |||
| 7 | 49 | 362.901 | -0.55157 | 7.85 | 334.7809 | 362.7039429 | and then copy into other rows. | |||
| 8 | 64 | 361.878 | -0.0455 | 0.3587 | 361.9678 | 361.9254 | 2. LINEST is an array function. | |||
| 9 | 81 | 360.922 | 0.382357 | -7.06173 | 393.6795 | 361.0948857 | ||||
| 10 | 100 | 361.307 | 0.906714 | -16.8967 | 439.2378 | 360.9423714 | ||||
| 11 | 121 | 362.29 | 0.759786 | -14.086 | 426.0786 | 363.0668286 | ||||
| 12 | 144 | 367.382 | 0.142643 | -0.06393 | 347.0901 | 366.8635143 | ||||
| 13 | 169 | 371.031 | -0.83371 | 24.54637 | 193.0423 | 371.2474286 | ||||
| 14 | 196 | 373.734 | -0.44014 | 14.1944 | 260.6523 | 373.1058857 | ||||
| 15 | 225 | 373.463 | -0.322 | 10.593 | 287.909 | 374.354 | ||||
| 16 | 256 | 375.518 | -0.06579 | 2.583843 | 350.2264 | 374.7267714 | ||||
| 17 | 289 | 374.804 | -0.20079 | 7.212614 | 310.7472 | 375.3345714 | ||||
| 18 | 324 | 375.457 | -0.09821 | 3.367014 | 346.525 | 375.3098286 | ||||
| 19 | 361 | 375.423 | -0.45943 | 16.85109 | 221.0745 | 375.3914571 | ||||
| 20 | 400 | 374.365 | 0.141214 | -6.29787 | 443.4541 | 373.9823714 | ||||
| 21 | 441 | 372.314 | 0.26 | -11.5094 | 500.246 | 373.2086 | ||||
| 22 | 484 | 373.765 | 0.312714 | -13.7594 | 524.1991 | 372.8453714 | ||||
| 23 | 529 | 372.776 | 0.066929 | -2.52861 | 396.1929 | 373.4399429 | ||||
| 24 | 576 | 374.134 | 0.362571 | -16.599 | 563.2684 | 373.7328571 | ||||
| 25 | 625 | 374.88 | -0.38536 | 19.94096 | 117.7682 | 375.4439143 | ||||
| 26 | 676 | 376.735 | -0.26279 | 13.95856 | 190.4886 | 375.7679714 | ||||
| 27 | 729 | 374.841 | -0.09693 | 5.239043 | 304.9084 | 375.7016571 | ||||
| 28 | 784 | 375.622 | 0.522286 | -28.9942 | 777.3916 | 375.0260286 | ||||
| 29 | 841 | 375.461 | 0.405857 | -22.2769 | 680.6403 | 375.9356857 | ||||
| 30 | 900 | 377.694 | 0.346571 | -18.9953 | 635.4879 | 377.5436571 | ||||
| 31 | 961 | 380.119 | -0.197 | 14.2352 | 128.1862 | 380.1604 | ||||
| 32 | 1024 | 382.288 | 0.241357 | -13.075 | 553.036 | 381.7870857 | ||||
| 33 | 1089 | 383.27 | 0.822429 | -50.9269 | 1168.857 | 383.8943429 | ||||
| 34 | 1156 | 387.978 | 1.296786 | -82.8773 | 1706.351 | 387.6064286 | ||||
| 35 | 1225 | 394.041 | 0.893643 | -55.1191 | 1228.957 | 394.5005143 | ||||
| 36 | 1296 | 403.423 | 0.655429 | -38.2345 | 930.0114 | 403.0063429 | ||||
| 37 | 1369 | 412.727 | -0.30829 | 31.99394 | -348.405 | 413.3277714 | ||||
| 38 | 1444 | 423.417 | -0.5015 | 46.7157 | -628.56 | 422.4702 | ||||
| 39 | 1521 | 429.948 | -0.87671 | 75.61931 | -1184.79 | 430.8766286 | ||||
| 40 | 1600 | 437.821 | -0.5095 | 46.5847 | -611.259 | 436.9294 | ||||
| 41 | 1681 | 441.703 | -0.86186 | 75.15969 | -1190.22 | 442.5435143 | ||||
| 42 | 1764 | 446.663 | -0.65107 | 57.5755 | -823.725 | 445.9559429 | ||||
| 43 | 1849 | 447.964 | -0.7025 | 62.1667 | -925.904 | 448.3414 | ||||
| 44 | 1936 | 449.118 | 0.444 | -37.4452 | 1236.545 | 448.5402 | ||||
| 45 | 2025 | 449.234 | 0.540286 | -46.3757 | 1443.182 | 450.3534286 | ||||
| 46 | 2116 | 454.162 | 1.015714 | -89.5001 | 2420.587 | 452.8331714 | ||||
| 47 | 2209 | 456.692 | 0.472929 | -39.125 | 1252.352 | 458.1767429 | ||||
| 48 | 2304 | 465.117 | 0.156429 | -9.35794 | 552.8528 | 464.0829429 | ||||
| 49 | 2401 | 470.408 | -1.17393 | 119.9263 | -2586.7 | 471.0826571 | ||||
| 50 | 2500 | 475.6 | -0.4795 | 51.5233 | -903.008 | 474.4072 | ||||
| 51 | 2601 | 475.857 | 0.007643 | 2.291129 | 340.3693 | 477.0959143 | ||||
| 52 | 2704 | 480.259 | 0.604643 | -59.5382 | 1940.557 | 479.5275143 | ||||
| 53 | 2809 | 483.432 | 0.172786 | -14.0226 | 741.7496 | 483.9076286 | ||||
| 54 | 2916 | 488.536 | -0.33457 | 39.90531 | -690.677 | 488.5993429 | ||||
| 55 | 3025 | 493.182 | -1.09357 | 122.8739 | -2957.25 | 492.7623429 | ||||
| 56 | 3136 | 494.242 | -0.12186 | 15.6082 | 1.854515 | 493.7697143 | ||||
| 57 | 3249 | 493.484 | 0.506857 | -56.0109 | 2040.661 | 494.8178857 | ||||
| 58 | 3364 | 498.186 | 0.852286 | -95.7187 | 3181.425 | 496.8274286 | ||||
| 59 | 3481 | 500.064 | ||||||||
| 60 | 3600 | 506.684 | ||||||||