|
|
|
|
|
|
|
|
|
|
|
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 |
|
|
|
|
|
|
|
|
|
|
|
|