|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Original Data |
|
|
|
Data Analysed |
|
|
|
|
| |
EOM |
AAA |
3to4 |
DEOM |
AAA |
3to4 |
D3to4 |
LINEST |
|
Interpretation |
|
| 1 |
360.071 |
5.94 |
5.31 |
1.146 |
5.94 |
5.31 |
0.29 |
-1.964760167 |
-2.831554244 |
3.372169376 |
-4.339078664 |
b3 |
b2 |
b1 |
b0 |
| 2 |
361.217 |
6 |
5.6 |
-2.443 |
6 |
5.6 |
-0.11 |
0.86274703 |
0.389518067 |
0.556010077 |
3.259045223 |
sd3 |
sd2 |
sd1 |
sd0 |
| 3 |
358.774 |
6.08 |
5.49 |
1.497 |
6.08 |
5.49 |
0.31 |
0.560778169 |
2.117009877 |
#N/A |
#N/A |
R2 |
Resid SD |
|
|
| 4 |
360.271 |
6.17 |
5.8 |
-0.132 |
6.17 |
5.8 |
-0.19 |
20.85364644 |
49 |
#N/A |
#N/A |
F |
Resid DoF |
|
|
| 5 |
360.139 |
6.14 |
5.61 |
2.025 |
6.14 |
5.61 |
-0.33 |
280.3812899 |
219.6048102 |
#N/A |
#N/A |
Regress SS |
Error SS |
|
|
| 6 |
362.164 |
6.09 |
5.28 |
0.737 |
6.09 |
5.28 |
-0.09 |
|
| 7 |
362.901 |
5.87 |
5.19 |
-1.023 |
5.87 |
5.19 |
-0.01 |
ANOVA Table |
|
| 8 |
361.878 |
5.84 |
5.18 |
-0.956 |
5.84 |
5.18 |
0.12 |
|
SS |
DF |
MSE |
F |
Prob(>F) |
|
| 9 |
360.922 |
5.99 |
5.3 |
0.385 |
5.99 |
5.3 |
-0.07 |
Regression |
280.3812899 |
3 |
93.46042997 |
20.85364644 |
7.59056E-09 |
|
| 10 |
361.307 |
6.12 |
5.23 |
0.983 |
6.12 |
5.23 |
0.41 |
Error |
219.6048102 |
49 |
4.48173082 |
|
|
| 11 |
362.29 |
6.42 |
5.64 |
5.092 |
6.42 |
5.64 |
-0.02 |
Total |
499.9861001 |
52 |
|
|
|
| 12 |
367.382 |
6.48 |
5.62 |
3.649 |
6.48 |
5.62 |
0.05 |
|
Functions
Used: |
| 13 |
371.031 |
6.52 |
5.67 |
2.703 |
6.52 |
5.67 |
0.16 |
Parameter |
Est value |
St dev |
t student |
Prob(>|t|) |
|
TDIST(x,df,tails) |
| 14 |
373.734 |
6.64 |
5.83 |
-0.271 |
6.64 |
5.83 |
-0.3 |
b0 |
-4.339078664 |
3.259045223 |
-1.331395659 |
0.189220015 |
|
FDIST(x,df1,df2) |
| 15 |
373.463 |
6.75 |
5.53 |
2.055 |
6.75 |
5.53 |
0.23 |
b1 |
3.372169376 |
0.556010077 |
6.064942909 |
1.85866E-07 |
|
| 16 |
375.518 |
6.73 |
5.76 |
-0.714 |
6.73 |
5.76 |
0.33 |
b2 |
-2.831554244 |
0.389518067 |
-7.269378447 |
2.54049E-09 |
|
| 17 |
374.804 |
6.89 |
6.09 |
0.653 |
6.89 |
6.09 |
0.43 |
b3 |
-1.964760167 |
0.86274703 |
-2.277330549 |
0.027168029 |
|
| 18 |
375.457 |
6.98 |
6.52 |
-0.034 |
6.98 |
6.52 |
0.16 |
|
| 19 |
375.423 |
6.98 |
6.68 |
-1.058 |
6.98 |
6.68 |
0.39 |
|
| 20 |
374.365 |
7.1 |
7.07 |
-2.051 |
7.1 |
7.07 |
0.05 |
|
| 21 |
372.314 |
7.19 |
7.12 |
1.451 |
7.19 |
7.12 |
0.13 |
|
| 22 |
373.765 |
7.29 |
7.25 |
-0.989 |
7.29 |
7.25 |
0.6 |
|
| 23 |
372.776 |
7.65 |
7.85 |
1.358 |
7.65 |
7.85 |
0.17 |
|
| 24 |
374.134 |
7.75 |
8.02 |
0.746 |
7.75 |
8.02 |
-0.15 |
|
| 25 |
374.88 |
7.72 |
7.87 |
1.855 |
7.72 |
7.87 |
-0.73 |
|
| 26 |
376.735 |
7.67 |
7.14 |
-1.894 |
7.67 |
7.14 |
0.06 |
|
| 27 |
374.841 |
7.66 |
7.2 |
0.781 |
7.66 |
7.2 |
0.39 |
|
| 28 |
375.622 |
7.89 |
7.59 |
-0.161 |
7.89 |
7.59 |
0.15 |
|
| 29 |
375.461 |
8.14 |
7.74 |
2.233 |
8.14 |
7.74 |
-0.23 |
|
| 30 |
377.694 |
8.21 |
7.51 |
2.425 |
8.21 |
7.51 |
-0.05 |
|
| 31 |
380.119 |
8.05 |
7.46 |
2.169 |
8.05 |
7.46 |
-0.37 |
|
| 32 |
382.288 |
7.94 |
7.09 |
0.982 |
7.94 |
7.09 |
-0.27 |
|
| 33 |
383.27 |
7.88 |
6.82 |
4.708 |
7.88 |
6.82 |
-0.6 |
|
| 34 |
387.978 |
7.79 |
6.22 |
6.063 |
7.79 |
6.22 |
-0.61 |
|
| 35 |
394.041 |
7.41 |
5.61 |
9.382 |
7.41 |
5.61 |
-0.13 |
|
| 36 |
403.423 |
7.18 |
5.48 |
9.304 |
7.18 |
5.48 |
-0.7 |
|
| 37 |
412.727 |
7.15 |
4.78 |
10.69 |
7.15 |
4.78 |
-0.64 |
|
| 38 |
423.417 |
7.27 |
4.14 |
6.531 |
7.27 |
4.14 |
0.5 |
|
| 39 |
429.948 |
7.37 |
4.64 |
7.873 |
7.37 |
4.64 |
0.88 |
|
| 40 |
437.821 |
7.54 |
5.52 |
3.882 |
7.54 |
5.52 |
0.43 |
|
| 41 |
441.703 |
7.58 |
5.95 |
4.96 |
7.58 |
5.95 |
0.25 |
|
| 42 |
446.663 |
7.62 |
6.2 |
1.301 |
7.62 |
6.2 |
-0.17 |
|
| 43 |
447.964 |
7.58 |
6.03 |
1.154 |
7.58 |
6.03 |
-0.43 |
|
| 44 |
449.118 |
7.48 |
5.6 |
0.116 |
7.48 |
5.6 |
-0.34 |
|
| 45 |
449.234 |
7.35 |
5.26 |
4.928 |
7.35 |
5.26 |
-0.3 |
|
| 46 |
454.162 |
7.19 |
4.96 |
2.53 |
7.19 |
4.96 |
0.32 |
|
| 47 |
456.692 |
7.19 |
5.28 |
8.425 |
7.19 |
5.28 |
0.09 |
|
| 48 |
465.117 |
7.11 |
5.37 |
5.291 |
7.11 |
5.37 |
0.16 |
|
| 49 |
470.408 |
7.16 |
5.53 |
5.192 |
7.16 |
5.53 |
0.19 |
|
| 50 |
475.6 |
7.22 |
5.72 |
0.257 |
7.22 |
5.72 |
0.32 |
|
| 51 |
475.857 |
7.36 |
6.04 |
4.402 |
7.36 |
6.04 |
-0.38 |
|
| 52 |
480.259 |
7.34 |
5.66 |
3.173 |
7.34 |
5.66 |
0.09 |
|
| 53 |
483.432 |
7.3 |
5.75 |
5.104 |
7.3 |
5.75 |
0.07 |
|
| 54 |
488.536 |
7.3 |
5.82 |
4.646 |
7.3 |
5.82 |
0.08 |
|
| 55 |
493.182 |
7.27 |
5.9 |
1.06 |
7.27 |
5.9 |
0.21 |
|
| 56 |
494.242 |
7.3 |
6.11 |
-0.758 |
7.3 |
6.11 |
-0.06 |
|
| 57 |
493.484 |
7.31 |
6.05 |
4.702 |
7.31 |
6.05 |
-0.07 |
|
| 58 |
498.186 |
7.26 |
5.98 |
1.878 |
7.26 |
5.98 |
0.02 |
|
| 59 |
500.064 |
7.24 |
6 |
6.62 |
7.24 |
6 |
0.24 |
|
| 60 |
506.684 |
7.25 |
6.24 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|