Bagas Aji P. (C1H018030) Econometrics Multiple Regression.xlsx - 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.xlsx

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

Name : Bagas Aji P NIM : C1H018030 Econometrics Assignment Multiple Regression No 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 0.430352 Det [A3]= 200033 X 1 X 2 X 1 2 X 2 2 Y 2 X 1 X 2 X 1 Y X 2 Y
Name : Bagas Aji P NIM : C1H018030 Econometrics Assignment Multiple Regression a. Y = a + b1X1 + b2X2 + e Y = (Det A1/DetA) + (Det A2/DetA)X1 + (Det A3/Det A)X2 + e b. Y = 8,85657 + 0,799865(95) + 0,430352(5) Y = 86,99551 c. d. f. Y = (4116640/46812) + (371787/45812)X 1 + (200033/464812)X 2 + e Y = 8,85657 + 0,799865X 1 + 0,430352X 2 82,8% Y variable can be explained by X 1 and X 2 variables t x1 > t tabel 5,832 > 1,833 there are positive effect of income (X 1 ) toward expenditure (Y) t x2

#### You've reached the end of your free preview.

Want to read all 5 pages?

• Summer '14

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern