Data Regresi Berganda 2

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 3

SUMMARY OUTPUT

Regression Statistics
Multiple R 0.9126832406
R Square 0.8329906976
Adjusted R Square 0.7494860464
Standard Error 0.2902075212
Observations 7

ANOVA
df SS MS F Significance F
Regression 2 1.68026123577 0.840131 9.975381 0.0278921071
Residual 4 0.33688162137 0.08422
Total 6 2.01714285714

Coefficients Standard Error t Stat P-value Lower 95% Upper 95%


Intercept -0.213818517 0.75023529585 -0.285002 0.78979 -2.296805632 1.869168598
X Variable 1 0.8984339014 0.25300011817 3.55112 0.023775 0.1959929617 1.600874841
X Variable 2 0.0174527867 0.02115834315 0.824865 0.455797 -0.041292192 0.076197765

PROBABILITY OUTPUT

Percentile Y
7.14285714285714 2.3
21.4285714285714 2.5
35.7142857142857 2.9
50 3
64.2857142857143 3.2
78.5714285714286 3.5
92.8571428571429 4
4.5
4
3.5
3
2.5
2
1.5
1
0.5
0
0 10 20 30 40 50 60 70 80 90 100

Lower 95.0% Upper 95.0%


-2.296805632 1.8691685981
0.1959929617 1.6008748411
-0.041292192 0.076197765
y x1 x2 x1y x2y x1^2 x2^2 x1x2 y^2
3.5 3.1 30 10.85 105 9.61 900 93 12.25
3.2 3.4 25 10.88 80 11.56 625 85 10.24
3 3 20 9 60 9 400 60 9
2.9 3.2 30 9.28 87 10.24 900 96 8.41
4 3.9 40 15.6 160 15.21 1600 156 16
2.5 2.8 25 7 62.5 7.84 625 70 6.25
2.3 2.2 30 5.06 69 4.84 900 66 5.29

Column 1 Column 2 Column 3


Column 1 1
Column 2 0.896985 1
Column 3 0.553602 0.449311 1

You might also like