SUMMARY OUTPUT

Regression Statistics
Multiple R 0.1996089856
R Square 0.0398437471
Adjusted R Square -0.440234379
Standard Error 31325.65631
Observations 7

ANOVA
df SS MS F Significance F
Regression 2 162884068.7717 81442034 0.082994 0.9219
Residual 4 3925186972.943 9.81E+08
Total 6 4088071041.714

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

Lower 95.0%
Intercept 161431.90502 950347.9734547 0.169866 0.873361 -2477157 2800021 -2477157
X Variable 1 -1.709035E-09 4.77875081E-08 -0.03576 0.973185 -1.34E-07 1.31E-07 -1.34E-07
X Variable 2 -0.344789896 6.8387843054 -0.05042 0.962207 -19.3323 18.64272 -19.3323

RESIDUAL OUTPUT PROBABILITY OUTPUT

Observation Predicted Y Residuals Percentile Y

1 88331.286631 -34189.2866313 7.142857 46237
2 86328.803635 20725.19636534 21.42857 54142
3 84369.701837 10072.29816309 35.71429 74221
4 82434.233634 -3828.23363427 50 78606
5 78693.963463 37653.03653666 64.28571 94442
6 76596.08625 -2375.08624989 78.57143 107054
7 74294.92455 -28057.9245496 92.85714 116347
8 71971.248659
9
10
11
12 90000

85000

80000

75000

70000
80000

75000

70000

65000
1 2 3 4
 Normal P
150000
100000
50000
0
29 86

Y
7 14 142 571
5 7 8
Upper 95.0% 4 2 8 285 142
1 4 7
7 . 21 . 35 .
2800021
Sample
1.31E-07
18.64272

X Variable 1 Residual Plot

60000
40000
Residuals

20000
0
6000000 7000000 8000000 9000000 10000000
-20000
-40000
100000 X Variable 1
90000
80000
100000
70000
90000
60000 f(x) = - 2401.79497815
80000
50000 Column B
70000
Column A
40000
60000
30000
50000
20000
40000
10000
30000
0
20000
1 2 3 4 5 6 7 8 Column
9 10B 11 12
10000
0
1 2 3 4
 30000
20000
Column B
10000
0
1 2 3 4

1 2 3 4 5 6 7
 Normal Probability Plot
150000
100000
50000
0
Column F
2 9 8 6 4 3 50 8 5 7 7 1 4 5 7 1
Y

7 14 142 571 2 5 8
8 5 57 28 7 14 42 8 1 42
2 8 4 8 5 71 5 7
14 4 2 7 1 .2 8.5 2.8
7 . 21 . 35 . 6 4 7 9
Sample Percentile

100000
90000
f(x) = - 2401.7949781553x + 91185.6084840495
80000
70000
60000 Column A
50000 Column B
Linear (Column B)
40000
Linear (Column B)
30000
20000
10000
0
1 2 3 4 5 6 7
30000
20000
10000
0
1 2 3 4 5 6 7
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.1996089856
R Square 0.0398437471
Adjusted R -0.4402343793
Standard E 31325.65630974
Observatio 7

ANOVA
df SS MS F Significance F
Regression 2 162884068.7717 81442034 0.082994 0.9219
Residual 4 3925186972.943 9.81E+08
Total 6 4088071041.714

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

Lower 95.0%
Upper 95.0%
Intercept 161431.9050227 950347.9734547 0.169866 0.873361 -2477157 2800021 -2477157 2800021
X Variable -0.0017090347 0.0477875081 -0.03576 0.973185 -0.13439 0.13097 -0.13439 0.13097
X Variable -0.3447898961 6.8387843054 -0.05042 0.962207 -19.3323 18.64272 -19.3323 18.64272

RESIDUAL OUTPUT PROBABILITY OUTPUT

Observation Predicted Y Residuals Percentile Y

1 88331.28663134 -34189.2866313 7.142857 46237
2 86328.80363466 20725.19636534 21.42857 54142
3 84369.70183691 10072.29816309 35.71429 74221
4 82434.23363427 -3828.23363427 50 78606
5 78693.96346334 37653.03653666 64.28571 94442
6 76596.08624989 -2375.08624989 78.57143 107054
7 74294.92454959 -28057.9245496 92.85714 116347

y=
 Normal Probability Plot
150000
100000
50000
0
Column F
2 9 8 6 43 50 8 57 71 4 57 1
Y

7 14 142 571 42 85 28
2 8 5 8 5 7 42 8 5 7 1 14 2 714
14 4 2 7 1 .2
8 57 8 5
7. 21 . 3 5 . 6 4 78 92
. .
Sample Percentile

Upper 95.0%

X Variable 1 Residual Plot

60000
40000
Residuals

20000
0
6000000
-20000 7000000 8000000 9000000 10000000
-40000
X Variable 1
Tahun PDRB Penduduk Bongkar
2011 6434663 180,120 54,142
2012 6777597 184,228 107,054
2013 7108261 188,271 94,442
2014 7408755 192,395 78,606
2015 8749347 196,598 116,347
2016 9152537 200,684 74,221
2017 9673060 204,778 46,237

-0.187035168 139.79632501 -18986424.07

5.2298204644 15.35747701 3071328.3647
0.9557562985 327707.49683 #N/A
43.204174418 4 #N/A
6.43466E+12 6434663
6.7776E+12 6777597
7.10826E+12 7108261
7.40876E+12 7408755
8.74935E+12 8749347
9.15254E+12 9152537
9.67306E+12 9673060