Y X
107 152.92
110 149.99 Chart Title
112 173.52
177.5 250
115
122 203.46
125 215.47
f(x) = 3.6714652262x - 244.0204118839
200 R = 0.9555063441
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.9775000481 150
R Square 0.9555063441
Adjusted R Square 0.9443829301
Axis Title
Standard Error 1.6569940704
Observations 6 100
ANOVA
df SS MS F
50
Regression 1 235.8508159354 235.8508159354 85.9004570229
Residual 4 10.9825173979 2.7456293495
Total 5 246.8333333333
0
Coefficients Standard Error 106 t Stat 110
108 112P-value
114 116 118 120
Intercept 68.6309979725 5.0663412567 13.5464617354 0.0001718829
Axis Title
X 0.260252048 0.0280799557 9.2682499439 0.0007536765
RESIDUAL OUTPUT
Observation Predicted Y Residuals Standard Residuals
1 108.4287411452 -1.4287411452 -0.9640234627
2 107.6662026447 2.3337973553 1.5746977087
3 113.789933333 -1.789933333 -1.2077329301
4 114.8257364839 0.1742635161 0.1175819139
5 121.5818796487 0.4181203513 0.2821209638
6 124.7075067446 0.2924932554 0.1973558065
X Residual Plot X Line Fit Plot
3 130
2 120
Residuals
1 110
Y
0 100
-1140 150 160 170 180 190 200 210 220 90
-2 140 150 160 170 180 190 200 210 220
X Residual Plot X Line Fit Plot
3 130
2 120
Residuals
1 110
Y
0 100
-1140 150 160 170 180 190 200 210 220 90
-2 140 150 160 170 180 190 200 210 220
X X
Chart Title
244.0204118839
Column B
Linear (Column B)
Significance F
0.0007536765
114 Lower 118
116 95% 120 Upper 95%
122 124 Lower
12695,0% Upper 95,0%
54.564579589 82.6974163559 54.564579589 82.6974163559
Axis Title
0.1822895924 0.3382145035 0.1822895924 0.3382145035
PROBABILITY OUTPUT
Percentile Y
8.3333333333 107
25 110
41.6666666667 112
58.3333333333 115
75 122
91.6666666667 125
X Line Fit Plot Normal Probability Plot
130
120
Y 110
Predicted Y
Y
100
90
50 160 170 180 190 200 210 220 0 10 20 30 40 50 60 70 80 90 100
X Line Fit Plot Normal Probability Plot
130
120
Y 110
Predicted Y
Y
100
90
50 160 170 180 190 200 210 220 0 10 20 30 40 50 60 70 80 90 100
X Sample Percentile
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.977500048
R Square 0.955506344
Adjusted R Square 0.94438293
Standard Error 1.65699407
Observations 6
ANOVA
df SS MS F Significance F
Regression 1 235.8508159354 235.85081594 85.900457023 0.0007536765
Residual 4 10.9825173979 2.7456293495
Total 5 246.8333333333
Coefficients Standard Error t Stat P-value Lower 95%
Intercept 68.63099797 5.0663412567 13.546461735 0.0001718829 54.564579589
X 0.260252048 0.0280799557 9.2682499439 0.0007536765 0.1822895924
Upper 95% Lower 95,0% Upper 95,0%
82.6974163559 54.564579589 82.6974163559
0.3382145035 0.1822895924 0.3382145035
INDEX (X) ILD (Y)
107 152.92 PERBANDINGAN ANTARA INDEX vs ILD
110 149.99
250
112 173.52
115 177.5 200 f(x) = 3.6714652262x - 244.0204118839
122 203.46 R = 0.9555063441
125 215.47 150
Column B
ILD (N)
100 Linear (Column B)
50
0
106 108 110 112 114 116 118 120 122 124 126
INDEX
#VALUE! ILD
INDEX #VALUE!
Y