TUGAS MID EKONOMETIKA

TUGAS MID EKONOMETIKA Nama : RIKWAN No. Stambuk : 2010.12.029 Kls/semester : Masamba / VI Prongram Studi : Agribisnis Fakultas : pertanian No. Resp X1 X2 Y Y² X1Y X2Y X1X2 X12 X22 1 26 159 205 42,025 5,330 32,595 4,134 676 25,281 2 28 164 206 42,436 5,768 33,784 4,592 784 26,896 3 35 198 254 64,516 8,890 50,292 6,930 1,225 39,204 4 31 184 246 60,516 7,626 45,264 5,704 961 33,856 5 21 150 201 40,401 4,221 30,150 3,150 441 22,500 6 49 208 291 84,681 14,259 60,528 10,192 2,401 43,264 7 30 184 234 54,756 7,020 43,056 5,520 900 33,856 8 30 154 209 43,681 6,270 32,186 4,620 900 23,716 9 24 149 204 41,616 4,896 30,396 3,576 576 22,201 10 31 175 216 46,656 6,696 37,800 5,425 961 30,625 11 32 192 245 60,025 7,840 47,040 6,144 1,024 36,864 12 47 201 286 81,796 13,442 57,486 9,447 2,209 40,401 13 54 248 312 97,344 16,848 77,376 13,392 2,916 61,504 14 40 166 265 70,225 10,600 43,990 6,640 1,600 27,556 15 42 287 322 103,684 13,524 92,414 12,054 1,764 82,369 JUMLAH 520 2,819 3,696 934,358 133,230 714,357 101,520 19,338 550,093 ∑Y =an+b1∑x1+b2∑x2 ∑x1Y = a∑x1+b1∑x1²+b2∑x1x2 ∑x2Y = a∑x2+b1∑x1x2+b2∑x2² 3,696 = 15 A + 520 b1 + 2,819 b2 ………..(1) 133,230 = 520 A + 19,338 b1 + 101,520 b2 ………..(2) 714,357 = 2,819 A + 101,520 b1 + 550,093 b2 ………..(3) Persamaan (1) dan (2) 3,696 = 15 a + 520 b1 + 2,819 b2 x 520 133,230 = 520 a + 19,338 b1 + 101,520 b2 x 15 1,921,920 = 7,800 a + 270,400 b1 + 1,465,880 b2 1,998,450 = 7,800 a + 290,070 b1 + 1,522,800 b2 _ -76,530 = 0 a -19,670 b1 -56,920 -76,530 = -19,670 b1 -56,920 b2 x (-) 76,530 19,670 b1 + 56,920 b2 ………..(4) Persamaan (1) dan (3) 3,696 = 15 a + 520 b1 + 2,819 b2 x 2,819 714,357 = 2,819 a + 101,520 b1 + 550,093 b2 x 15 10,419,024 = 42,285 a + 1,465,880 b1 + 7,946,761 b2 10,715,355 = 42,285 a + 1,522,800 b1 + 8,251,395 b2 _ -296,331 = 0 a -56,920 b1 -304,634 b2 -296,331 = -56,920 b1 -304,634 b2 x (-) 296,331 = 56,920 b1 + 304,634 b2 ………..(5) Persamaan (4) dan (5) 76,530 = 19,670 b1 + 56,920 b2 56,920 296,331 = 56,920 b1 + 304,634 b2 19,670 4,356,087,600 = 1,119,616,400 b1 3,239,886,400 b2 5,828,830,770 = 1,119,616,400 b1 5,992,150,780 b2 _ -1,472,743,170 = 0 b1 + -2,752,264,380 b2 b2 = -1,472,743,170 : -2,752,264,380 b2 = 0.535 Untuk b2 (0,535) didistribusikan ke persamaan ……(4) 76,530 = 19,670 b1 + 56,920 b2 76,530 = 19,670 b1 + 56,920 x 0.535 76,530 = 19,670 b1 + 30,458.026 b1 = 76,530 - 30,458.026 19,670 b1 = 46,071.974 19,670 b1 = 2.342 Untuk b1=2,342 dan b2 =0,535 di distribusikan ke persamaan …….(1) 3,696 = 15 a + 520 b1 + 2,819 b2 3,696 = 15 a + 520 2.342 + 2819 0.535 3,696 = 15 a + 1,217.968 + 1,508.454 3,696 = 15 a + 2,726.421 a = 3,696 - 2,726.421 15 a = 969.579 15 a = 64.639 a = 64.639 b1 = 2.342 b2 = 0.535 Keterangan : a = konstanta b1 = koefisien regresi X1 b2 = koefisien regresi X2 Persamaan reggresi Y = a+b1x1+b2x2+e Y = 64.639 + 2.342 520 + 0.535 2,819 + 2 Y = 1,285 PENGUJIAN HOPOTESIS Koefisien korelasi berganda ( R ) R = b1∑X1Y+b2∑X2Y ∑Y² R = 2.342 133,230 + 0.535 714,357 934,358 R = 312,057.399 + 382,254.118 934,358 R = 694,311.517 934,358 R = 0.743 Koefisien korelasi berganda ( R ) R² = ( 0.743 )2 0.552 F Hitung F Hitung = R² ( N - k - 1 ) k ( 1 - R² ) F Hitung = 0.552 ( 15 - 2 - 1 ) 2 ( 1 - 0.552 ) F Hitung = 7,398 F Tabel DK pembilang = k = 2 DK penyebut = n-k- 1 = 15 -2 -1 = 12 F table = 3,890 Hipotesis H0 : β1 = β2 = 0 Variabel sales dan promosi tidak berpengaruh signifikan terhadap luas outlet yang berasal dari 15 daera yang berada di Indonesia H0 : β1 ≠ β2 ≠ 0 variable sales dan Promosi berpengaru signifikan terhadap luas outlet yang berasal dari 15 daera yang berada di Indonesia Kriteria : F hitung ≤ F table = H0 diterima F hitung > F table = H0 ditolak, Ha diterima F hitung (7,398) > F table ( 3,890) berarti Ho ditolak, dan Ha diterima Jadi dapat disimpulkan bahwa sales dan promosi tidak berpegaruh signifikan terhadap luas outlet yang berasal dari 15 daera di Indonesia.