statistik-tugas analisis regresi ganda
TRANSCRIPT
TUGAS ANALISIS REGRESI GANDA
KELAS : B1- DIKDAS (KONSENTRASI MATEMATIKA)
OLEH : - ERMASNYAH, RIDHA HUTAMI & TRI ASTARI
Keterangan :
Y =
Rata-Rata
X1 =
mata
pelajaran TV
X2 =
mata
pelajaran Koran
X3 =
mata
pelajaran
Majalah
Tabel 1. Pengaruh Televisi, Koran, Majalah, Handphone, Komik, Novel, Buku Cerita, Buku Pelajaran, Internet, Karya Ilmiah Terhadap Hasil Belajar Siswa SMA Bangsa
No. TV Koran Majalah HP Komik Novel Buku Cerita Buku Pelajaran Internet Karya
IlmiahHasil
Belajar1 6 4 3 8 5 5 5 6 6 4 6,52 7 5 4 7 5 4 4 7 7 5 7,23 5 3 5 6 5 5 5 7 6 4 6,84 8 5 6 8 5 5 4 7 7 3 7,65 7 7 4 7 6 4 4 6 5 4 6,86 8 8 5 9 7 6 4 6 7 5 7,27 9 9 5 8 6 5 3 9 8 4 7,88 6 5 5 7 7 6 4 7 8 4 6,69 7 6 7 8 7 4 5 6 8 3 6,8
10 8 4 8 7 6 5 6 7 9 5 7,011 5 7 5 7 6 3 5 8 7 6 6,412 4 7 6 7 7 4 4 8 6 4 6,213 6 7 8 7 6 5 5 7 7 7 6,614 7 6 7 7 8 3 4 6 6 4 6,015 8 5 5 7 7 3 5 8 8 7 6,616 7 7 4 6 6 4 3 5 9 5 7,017 7 6 7 6 7 5 4 7 6 4 6,218 6 7 5 7 6 4 5 8 9 3 6,019 8 8 7 5 7 3 4 6 8 6 6,820 7 8 4 6 6 4 5 7 9 7 6,421 5 8 3 8 7 5 4 7 8 4 6,422 9 7 6 9 6 4 5 9 7 7 6,223 5 6 3 8 6 5 4 7 9 5 6,224 7 7 7 7 6 4 5 7 7 7 6,825 8 6 5 8 6 3 4 7 9 8 6,226 9 7 6 7 6 3 5 8 7 5 6,427 8 6 7 8 5 4 5 7 9 5 6,828 7 7 8 7 6 5 6 6 7 7 6,629 7 8 6 8 7 3 4 5 9 5 6,630 7 6 8 8 6 3 4 6 7 5 6,431 7 8 5 8 7 4 5 7 9 7 6,632 6 9 7 8 6 4 5 8 7 7 6,433 6 6 5 5 7 3 5 6 9 5 6,234 6 6 6 6 6 3 5 5 7 4 6,035 4 5 7 7 4 2 3 7 9 4 5,8
X4 = mata pelajaran Hp
X5 = mata pelajaran Komik
X6 = mata pelajaran Novel
X7 = mata pelajaran Buku Cerita
X8 = mata pelajaran Buku Pelajaran
X9 = mata pelajaran Internet
X10 = mata pelajaran Karya Ilmiah
SOAL :Tentukan persamaan garis regresi linier ganda dari Pengaruh Televisi, Koran, Majalah, Handphone, Komik, Novel, Buku Cerita, Buku
Peajaran, Internet, Karya Ilmiah Terhadap Hasil Belajar Siswa SMA Bangsa.
1. Perhitungan menggunakan Metode DOOLITLE
Perkalian matriks akan menghasilkan nilai X’X dan X’Y yang disajikan pada tabel berikut:
Tabel 2. Metode Doolitle
Aturan Baris X'X X'Y
R' 1 35 237 226 199 252 216 142 157 240 266 179 230,1R' 2 1663 1542 1360 1716 1467 963 1066 1630 1805 1228 1567,8R' 3 1526 1285 1635 1410 914 1008 1556 1725 1177 1487R' 4 1205 1430 1230 798 903 1363 1507 1177 1306,9R' 5 1846 1553 1031 1129 1737 1507 1291 1659,4R' 6 1356 877 969 1477 1641 1107 1418,3R' 7 608 639 977 1072 718 940,5R' 8 723 1079 1192 815 1030,5R' 9 1680 1823 1236 1578,2R'10 2068 1371 1748
R'11 981 1174,8
R'1 R1 35 237 226 199 252 216 142 157 240 266 179 230,1(1/35) r1 r1 1 6,771429 6,457143 5,685714 7,2 6,1714286 4,057143 4,485714 6,857143 7,6 5,11428571 6,574286R'2j - R12 r1j R2 58,17143 11,657 12,49 9,6 4,3714 1,4571 2,886 4,857 3,8 15,9143 9,694286(1/58.17143) R2 r2 1 0,200393 0,214637 0,165029 0,0751473 0,025049 0,049607 0,083497 0,0653242 0,27357564 0,16665R'3j - (R13 r1j + R23 r2j) R3 64,34971 -2,473 5,8762 14,381 -3,206 -6,35 5,312 6,6385 17,9823 -
0,731238
(1/64.349) R3 r3 1 -0,03844 0,091317 0,2234842 -0,049826 -0,09867 0,082555 0,103163 0,27944679 -
0,011363R'4j - (R14r1j + R24r2j + R34r3j) R4 70,76789 -4,635 1,5002 -9,807 9,479 -2,41 -5,96 156,533 -
3,491712
(1/70.76789) . R4 r4 1 -0,065491 0,0211993 -
0,138586 0,133951 -0,034051 -0,084225 2,21191502 -0,04934
R'5j - (R15r5j + R25r2j + R35r3j + R45r4j) R5 29,17559 -4,136 8,01 -0,68 7,556 -409,8 8,18301 0,918257
(1/29.17559) . R5 r5 1 -0,141776 0,274545 -0,02316 0,258967 -14,0468 0,28047455 0,031473R'6j - (R16r1j + R26r2j + R36r3j + R46r4j + R56r5j)
R6 18,810722 2,6077 0,991 -4,573 -60,35 -5,0586 -2,106585
(1/18.810722) R6 r6 1 0,13863 0,052692 -0,243096 -3,208069 -0,2689219 -
0,111989R'7j - (R17r1j + R27r2j + R37r3j + R47r4j + R57r5j + R67r6j)
R7 27,76966 3,002 1,654 113,09 12,4166 6,228192
(1/27.76966) R7 r7 1 0,108092 0,059575 4,0724488 0,44712986 0,22428R'8j - (R18r1j + R28r2j + R38r3j + R48r4j + R58r5j + R68r6j + R78r7j)
R8 16,31104 3,272 -18,47 -8,8117 -2,289156
(1/16.31104) R8 r8 1 0,200581 -1,132312 -0,540227 -
0,140344R'9j - (R19r1j + R29r2j + R39r3j + R49r4j + R59r5j + R69r6j + R79r7j + R89r8j)
R9 29,53648 86,36 8,76714 -1,158333
(1/29.53648) R9 r9 1 2,9238271 0,29682419 -0,039217
R'10j - (R110r1j + R210r2j + R310r3j + R410r4j + R510r5j + R610r6j + R710r7j + R810r8j + R910r9j)
R10 -6639,309 33,4287 -20,04069
(1/-6639.309) R10 r10 1 -0,005035 0,003018R'11j - (R111r1j + R211r2j + R311r3j + R411r4j + R511r5j + R611r6j + R711r7j + R811r8j + R911r9j + R1011r10j)
R11 -306,47437 -1,324163
(1/-306.4744) R11 r11 1 0,004321
Pada baris diatas diperoleh:Pada baris r11 : b10 = 0,004Pada baris r10 : b9 = 0,003Pada baris r9 : b8 = -0,05Pada baris r8 : b7 = -0,12Pada baris r7 : b6 = 0,226Pada baris r6 : b5 = -0,14
Pada baris r5 : b4 = 0,001Pada baris r4 : b3 = -0,01Pada baris r3 : b2 = 0,021Pada baris r2 : b1 = 0,178Pada baris r1 : b0 = 6,066
Dari uraian diatas, dapat disimpulkan persamaan regresinya:
2. Perhitungan menggunakan SPSS (versi 22)
Perhitungan SPSS dilakukan berdasarkan petunjuk berikut:
Buka aplikasi SPSS > copy paste data X dan Y > analyze > regression > linear, seperti gambar:
10987654321 004,0003,005,012,0226,014,0001,001,0021,0178,0066,6 xxxxxxxxxxY
Pindahkan X ke independet dan Y ke dependent > klik OK, seperti gambar:
Maka akan muncul hasilnya sebagai berikut:
REGRESSION /DESCRIPTIVES MEAN STDDEV CORR SIG N /MISSING LISTWISE /STATISTICS COEFF OUTS R ANOVA COLLIN TOL CHANGE ZPP /CRITERIA=PIN(.05) POUT(.10) /NOORIGIN /DEPENDENT VAR00011 /METHOD=ENTER VAR00001 VAR00002 VAR00003 VAR00004 VAR00005 VAR00006 VAR00007 VAR00008 VAR00009 VAR00010.
RegressionDescriptive Statistics
Mean Std. Deviation N
VAR00011 6,5743 ,44148 35
VAR00001 6,7714 1,30802 35
VAR00002 6,4571 1,40048 35
VAR00003 5,6857 1,47072 35
VAR00004 7,2000 ,96406 35
VAR00005 6,1714 ,82197 35
VAR00006 4,0571 ,96841 35
VAR00007 4,4857 ,74247 35
VAR00008 6,8571 1,00419 35
VAR00009 7,6000 1,16821 35
VAR00010 5,1143 1,38843 35
Correlations
VAR00011 VAR00001 VAR00002 VAR00003 VAR00004 VAR00005 VAR00006 VAR00007 VAR00008 VAR00009 VAR00010
Pearson
Correlation
VAR00011 1,000 ,494 ,058 -,063 ,185 -,141 ,478 -,149 ,025 -,043 -,096
VAR00001 ,494 1,000 ,187 ,191 ,224 ,120 ,034 ,087 ,109 ,073 ,258
VAR00002 ,058 ,187 1,000 ,000 ,170 ,390 -,063 -,163 ,131 ,133 ,320
VAR00003 -,063 ,191 ,000 1,000 -,058 ,046 -,194 ,279 -,031 -,092 ,148
VAR00004 ,185 ,224 ,170 -,058 1,000 -,082 ,271 -,058 ,273 -,005 ,048
VAR00005 -,141 ,120 ,390 ,046 -,082 1,000 ,024 ,004 -,148 -,018 ,060
VAR00006 ,478 ,034 -,063 -,194 ,271 ,024 1,000 ,083 ,099 -,187 -,180
VAR00007 -,149 ,087 -,163 ,279 -,058 ,004 ,083 1,000 ,096 -,041 ,344
VAR00008 ,025 ,109 ,131 -,031 ,273 -,148 ,099 ,096 1,000 -,025 ,181
VAR00009 -,043 ,073 ,133 -,092 -,005 -,018 -,187 -,041 -,025 1,000 ,192
VAR00010 -,096 ,258 ,320 ,148 ,048 ,060 -,180 ,344 ,181 ,192 1,000
Sig. (1-
tailed)
VAR00011 . ,001 ,371 ,360 ,143 ,209 ,002 ,196 ,444 ,402 ,292
VAR00001 ,001 . ,141 ,136 ,098 ,247 ,423 ,309 ,267 ,338 ,067
VAR00002 ,371 ,141 . ,499 ,165 ,010 ,359 ,174 ,226 ,223 ,030
VAR00003 ,360 ,136 ,499 . ,370 ,397 ,133 ,053 ,429 ,299 ,199
VAR00004 ,143 ,098 ,165 ,370 . ,320 ,058 ,371 ,056 ,488 ,391
VAR00005 ,209 ,247 ,010 ,397 ,320 . ,445 ,491 ,199 ,458 ,367
VAR00006 ,002 ,423 ,359 ,133 ,058 ,445 . ,318 ,285 ,141 ,150
VAR00007 ,196 ,309 ,174 ,053 ,371 ,491 ,318 . ,292 ,408 ,022
VAR00008 ,444 ,267 ,226 ,429 ,056 ,199 ,285 ,292 . ,443 ,149
VAR00009 ,402 ,338 ,223 ,299 ,488 ,458 ,141 ,408 ,443 . ,134
VAR00010 ,292 ,067 ,030 ,199 ,391 ,367 ,150 ,022 ,149 ,134 .
N VAR00011 35 35 35 35 35 35 35 35 35 35 35
VAR00001 35 35 35 35 35 35 35 35 35 35 35
VAR00002 35 35 35 35 35 35 35 35 35 35 35
VAR00003 35 35 35 35 35 35 35 35 35 35 35
VAR00004 35 35 35 35 35 35 35 35 35 35 35
VAR00005 35 35 35 35 35 35 35 35 35 35 35
VAR00006 35 35 35 35 35 35 35 35 35 35 35
VAR00007 35 35 35 35 35 35 35 35 35 35 35
VAR00008 35 35 35 35 35 35 35 35 35 35 35
VAR00009 35 35 35 35 35 35 35 35 35 35 35
VAR00010 35 35 35 35 35 35 35 35 35 35 35
Variables Entered/Removeda
Model
Variables
Entered
Variables
Removed Method
1 VAR00010,
VAR00004,
VAR00005,
VAR00003,
VAR00009,
VAR00008,
VAR00001,
VAR00006,
VAR00007,
VAR00002b
. Enter
a. Dependent Variable: VAR00011
b. All requested variables entered.
Model Summary
Model R R Square
Adjusted R
Square
Std. Error of the
Estimate
Change Statistics
R Square Change F Change df1 df2 Sig. F Change
1 ,763a ,582 ,408 ,33979 ,582 3,340 10 24 ,007
a. Predictors: (Constant), VAR00010, VAR00004, VAR00005, VAR00003, VAR00009, VAR00008, VAR00001, VAR00006, VAR00007, VAR00002
ANOVAa
Model Sum of Squares df Mean Square F Sig.
1 Regression 3,856 10 ,386 3,340 ,007b
Residual 2,771 24 ,115
Total 6,627 34
a. Dependent Variable: VAR00011
b. Predictors: (Constant), VAR00010, VAR00004, VAR00005, VAR00003, VAR00009, VAR00008,
VAR00001, VAR00006, VAR00007, VAR00002
Coefficientsa
Model
Unstandardized Coefficients
Standardized
Coefficients
t Sig.
Correlations Collinearity Statistics
B Std. Error Beta Zero-order Partial Part Tolerance VIF
1 (Constant) 6,298 ,954 6,602 ,000
VAR00001 ,189 ,049 ,559 3,879 ,001 ,494 ,621 ,512 ,838 1,193
VAR00002 ,038 ,052 ,121 ,731 ,472 ,058 ,148 ,097 ,635 1,576
VAR00003 -,001 ,044 -,002 -,014 ,989 -,063 -,003 -,002 ,822 1,217
VAR00004 -,049 ,068 -,106 -,715 ,482 ,185 -,144 -,094 ,787 1,270
VAR00005 -,152 ,081 -,283 -1,875 ,073 -,141 -,357 -,248 ,765 1,308
VAR00006 ,233 ,068 ,510 3,425 ,002 ,478 ,573 ,452 ,786 1,273
VAR00007 -,112 ,094 -,188 -1,194 ,244 -,149 -,237 -,158 ,701 1,428
VAR00008 -,036 ,063 -,082 -,576 ,570 ,025 -,117 -,076 ,850 1,177
VAR00009 -,002 ,053 -,004 -,032 ,975 -,043 -,006 -,004 ,901 1,110
VAR00010 -,027 ,052 -,084 -,512 ,614 -,096 -,104 -,068 ,645 1,551
a. Dependent Variable: VAR00011
Collinearity Diagnosticsa
Model Dimension Eigenvalue
Condition
Index
Variance Proportions
(Constant) VAR00001 VAR00002 VAR00003 VAR00004 VAR00005 VAR00006 VAR00007 VAR00008 VAR00009 VAR00010
1 1 10,691 1,000 ,00 ,00 ,00 ,00 ,00 ,00 ,00 ,00 ,00 ,00 ,00
2 ,079 11,608 ,00 ,00 ,00 ,11 ,01 ,00 ,25 ,00 ,00 ,00 ,15
3 ,061 13,204 ,00 ,00 ,08 ,46 ,00 ,00 ,01 ,01 ,00 ,01 ,12
4 ,043 15,683 ,00 ,01 ,19 ,05 ,00 ,02 ,08 ,07 ,00 ,00 ,29
5 ,030 18,843 ,00 ,00 ,15 ,06 ,00 ,00 ,23 ,01 ,02 ,32 ,09
6 ,028 19,393 ,00 ,83 ,04 ,02 ,01 ,02 ,01 ,04 ,00 ,01 ,00
7 ,023 21,767 ,00 ,06 ,01 ,03 ,08 ,10 ,03 ,03 ,38 ,06 ,00
8 ,018 24,601 ,00 ,03 ,00 ,21 ,01 ,12 ,26 ,25 ,08 ,28 ,10
9 ,012 30,085 ,00 ,05 ,05 ,01 ,74 ,03 ,12 ,00 ,29 ,07 ,02
10 ,011 31,057 ,01 ,01 ,47 ,01 ,01 ,39 ,00 ,52 ,09 ,01 ,21
11 ,003 59,475 ,99 ,00 ,01 ,04 ,14 ,31 ,02 ,06 ,14 ,25 ,01
a. Dependent Variable: VAR00011
