I - Project - Kelompok 4

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

SUMMARY OUTPUT

Regression Statistics
Multiple R 0.263183
R Square 0.069265
Adjusted R-0.030456
Standard E 77.23045
Observatio 32

ANOVA
df SS MS F Significance F
Regression 3 12428.66 4142.888 0.694586 0.563116
Residual 28 167007.2 5964.542
Total 31 179435.8

Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
Intercept 4489.078 1624.03 2.76416 0.009979 1162.404 7815.752 1162.404 7815.752
X Variable 6.266E-07 5.456E-06 0.114862 0.909374 -1.05E-05 1.18E-05 -1.05E-05 1.18E-05
X Variable 2.592303 3.196492 0.810984 0.424215 -3.955414 9.140019 -3.955414 9.140019
X Variable 1.043126 0.770666 1.353539 0.18671 -0.535512 2.621764 -0.535512 2.621764
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.091468
R Square 0.008366
Adjusted R-0.060022
Standard E 78.33056
Observatio 32

ANOVA
df SS MS F Significance F
Regression 2 1501.225 750.6125 0.122336 0.885305
Residual 29 177934.6 6135.676
Total 31 179435.8

Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
Intercept 6663.713 240.474 27.71074 2.037E-22 6171.888 7155.537 6171.888 7155.537
X1 1.01E-06 5.526E-06 0.182819 0.856212 -1.03E-05 1.231E-05 -1.03E-05 1.231E-05
X2 1.528784 3.142552 0.486478 0.630284 -4.898457 7.956025 -4.898457 7.956025
Waktu Data Variable
Y X1 X2 X3 Y XI
3-Apr-23 6,827.17 14.99 80.42 1,983.90 6.83 6,827.17
4-Apr-23 6,833.18 14.92 80.71 2,022.20 6.83 6,833.18 Mean
5-Apr-23 6,819.67 14.96 80.61 2,020.90 6.82 6,819.67 Standard E
6-Apr-23 6,792.77 14.96 80.7 2,011.90 6.79 6,792.77 Median
10-Apr-23 6,771.23 14.91 79.74 1,989.10 6.77 6,771.23 Mode
11-Apr-23 6,811.31 14.96 81.53 2,004.80 6.81 6,811.31 Standard D
12-Apr-23 6,798.96 14.91 83.26 2,010.90 6.80 6,798.96 Sample Var
13-Apr-23 6,785.60 14.82 82.16 2,041.30 6.79 6,785.60 Kurtosis
14-Apr-23 6,818.57 14.72 82.52 2,002.20 6.82 6,818.57 Skewness
17-Apr-23 6,787.58 14.69 80.83 1,994.20 6.79 6,787.58 Range
18-Apr-23 6,821.81 14.86 80.86 2,007.40 6.82 6,821.81 Minimum
19-Apr-23 6,699.72 14.89 79.16 1,995.20 6.70 6,699.72 Maximum
20-Apr-23 6,617.01 15.01 77.29 2,007.60 6.62 6,617.01 Sum
21-Apr-23 6,677.57 14.95 77.87 1,979.50 6.68 6,677.57 Count
24-Apr-23 6,703.82 14.84 78.76 1,989.10 6.70 6,703.82 Largest(1)
25-Apr-23 6,744.64 14.95 77.07 1,994.00 6.74 6,744.64 Smallest(1)
26-Apr-23 6,910.15 14.94 74.3 1,985.70 6.91 6,910.15 Confidence
27-Apr-23 6,945.48 14.84 74.76 1,989.90 6.95 6,945.48
28-Apr-23 6,915.72 14.68 76.78 1,999.10 6.92 6,915.72 ANALISIS KORELASI
01-Mei-2023 6,699.01 14.66 75.66 1,983.40 6.70 6,699.01
02-Mei- 2023 6,863.30 14.67 71.66 2,014.30 6.86 6,863.30 X1
03-Mei-2023 6,812.72 14.75 68.6 2,028.60 6.81 6,812.72 X2
04-Mei-2023 6,844.03 14.680. 68.56 2,048.00 6.84 6,844.03 X3
05-Mei-2023 6,787.63 15 71.34 2,017.40 6.79 6,787.63 Y
08-Mei-2023 6,787.63 14.67 73.16 2,026.30 6.79 6,787.63
09-Mei-2023 6,779.98 14.75 73.71 2,036.20 6.78 6,779.98 SUMMARY OUTPUT
10-Mei-2023 6,811.90 14.77 72.56 2,030.50 6.81 6,811.90
11-Mei-2023 6,755.94 14.69 70.87 2,014.70 6.76 6,755.94 Regression Statistics
12-Mei-2023 6,707.76 14.770.5 70.04 2,014.00 6.71 6,707.76 Multiple R
13-Mei-2023 6,711.74 14.74 70.11 2,018.00 6.71 6,711.74 R Square
14-Mei-2023 6,676.56 14.80 70.86 1,988.00 6.68 6,676.56 Adjusted R
15-Mei-2023 6,663.11 14.89 72.83 198.00 6.66 6,663.11 Standard E
Observatio

ANOVA

Regression
Residual
Total
Intercept
X Variable
X Variable
X Variable

Model akhir regresi yang dipil


y = 4489.07795 + 6.2664E-07
XI X2 X3

473737.75 Mean 76.22781 Mean 2007.184375


458911.6859 Standard E 0.806945 Standard Erro 3.298961559
14839.5 Median 76.925 Median 2007.5
#N/A Mode #N/A Mode 1989.1
2595996.52 Standard D 4.564768 Standard Devi18.66174471
6.7392E+12 Sample Var 20.83711 Sample Varia 348.2607157
31.99999988 Kurtosis -1.371382 Kurtosis -0.725844311
5.656854233 Skewness -0.160966 Skewness 0.343933565
Range 14.7 Range 68.5
14663 Minimum 68.56 Minimum 1979.5
14700000 Maximum 83.26 Maximum 2048
15159608 Sum 2439.29 Sum 64229.9
32 Count 32 Count 32
14700000 Largest(1) 83.26 Largest(1) 2048
14663 Smallest(1) 68.56 Smallest(1) 1979.5
935956.5541 Confidence 1.645774 Confidence L 6.728276458 7,000.00
6,900.00
ANALISIS KORELASI Skala Korelasi
6,800.00
X1 X2 X3 Y 0.00-0.199 Sangat Rendah
6,700.00
1 0.20-0.399 Rendah
-0.195371315 1 0.40-0.599 Sedang 6,600.00
0.099876809 -0.259381 1 0.60-0.799 Kuat 6,500.00
0.016549982 0.084991 0.21766 1 0.80-1.00 Sangat Kuat
6,400.00
14.60 1
SUMMARY OUTPUT

Regression Statistics
0.263182877
0.069265227
-0.030456356
77.23044609
32

df SS MS F Significance F
3 12428.66 4142.888 0.694586 0.563116
28 167007.2 5964.542
31 179435.8
Coefficients Standard Error
t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
4489.077949 1624.03 2.76416 0.009979 1162.4038 7815.75207 1162.403826 7815.75207
6.266396E-07 5.456E-06 0.114862 0.909374 -1.055E-05 1.18019E-05 -1.05486E-05 1.1802E-05
2.592302642 3.196492 0.810984 0.424215 -3.9554141 9.14001935 -3.955414068 9.14001935
1.043126303 0.770666 1.353539 0.18671 -0.5355116 2.62176422 -0.535511617 2.62176422

Model akhir regresi yang dipilih dari variable yang semuanya signifikan
y = 4489.07795 + 6.2664E-07 + 2.59230264 + 1.0431263
Y terhadap X1
7,000.00
6,900.00
6,800.00
f(x) = − 96.5337694022429 x + 8212.50676849912
6,700.00 R² = 0.0198418374320794
6,600.00
6,500.00
6,400.00
14.60 14.65 14.70 14.75 14.80 14.85 14.90 14.95 15.00 15.05

You might also like