Bagas Aji P. (C1H018030) Econometrics Multiple Regression.pdf - Name Bagas Aji P NIM C1H018030 No 1 2 3 4 5 6 7 8 9 10 11 12 Sum Average X1 60 65 55 75

Bagas Aji P. (C1H018030) Econometrics Multiple Regression.pdf

This preview shows page 1 - 3 out of 5 pages.

Name : Bagas Aji P. NIM : C1H018030 No X 1 X 2 Y X 1 2 X 2 2 Y 2 X 1 X 2 X 1 Y X 2 Y Ypred (Y-Ypred)^2 (Y-Ybar)^2 1 60 4 55 3600 16 3025 240 3300 220 58,461 11,976 142,015 2 65 6 60 4225 36 3600 390 3900 360 63,266 10,667 47,845 3 55 6 45 3025 36 2025 330 2475 270 55,267 105,419 480,355 4 75 5 75 5625 25 5625 375 5625 375 70,862 17,126 65,335 5 70 7 68 4900 49 4624 490 4760 476 67,668 0,110 1,173 6 90 8 85 8100 64 7225 720 7650 680 84,069 0,867 326,995 7 50 4 55 2500 16 3025 200 2750 220 50,462 20,594 142,015 8 85 5 80 7225 25 6400 425 6800 400 78,860 1,299 171,165 9 82 4 75 6724 16 5625 328 6150 300 76,058 1,119 65,335 10 73 5 65 5329 25 4225 365 4745 325 69,262 18,164 3,675 11 50 5 60 2500 25 3600 250 3000 300 50,865 83,448 47,845 12 80 8 80 6400 64 6400 640 6400 640 76,070 15,444 171,165 Sum 835 67 803 60153 397 55399 4753 57555 4566 801,169 286,233 1664,917 Average 69,583 5,583 66,917 Matrix [A] 12 835 67 a 803 835 60153 4753 x b1 = 57555 67 4753 397 b2 4566 Det [A] = 464812 Matrix [A1] Matrix [A2] 803 835 67 12 803 67 57555 60153 4753 835 57555 4753 4566 4753 397 67 4566 397 Det [A1]= 4116640 Det [A2]= 371787 Matrix [A3] 12 835 803 835 60153 57555 67 4753 4566 Det [A3]= 200033
Image of page 1
a. Y = a + b1X1 + b2X2 + e Y = (Det A1/DetA) + (Det A2/DetA)X1 + (Det A3/Det A)X2 + e Y = (4116640/46812) + (371787/45812)X 1 + (200033/464812)X 2 + e Y = 8,85657 + 0,799865X 1 + 0,430352X 2 b. Y = 8,85657 + 0,799865(95) + 0,430352(5) Y = 86,99551 c. 82,8% Y variable can be explained by X 1 and X 2 variables d. t x1 > t tabel 5,832 > 1,833 there are positive effect of income (X 1 ) toward expenditure (Y) t x2 t tabel 0,331 1,833 there are negative effect of family size (X 2 ) toward expenditure (Y) ?
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 5 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes