TABLE 1 TABLE 2 TABLE 3 7,196575941 7,040971168 4,287668 4,153444814 7,192353644 6,006722 4,715830609 6,042236996 11,0551 5,248674135 5,761523046 18,41364 4,278970429 6,987554356 15,9353 1,654762041 7,316752204 10,82002 4,571997811 8,03930326 10,44006 6,111054461 8,333333333 11,16363 1,695448177 7,744131129 11,61179 2,249904054 9,610826993 15,06611 0,094037534 10,39637481 24,87883 3,014548966 12,10352119 10,13395 3,790503812 13,55669714 13,98494 6,620585081 13,6186653 16,52224 5,360737419 14,68703664 11,47756 0,383390769 15,54637452 16,81518 1,846544477 15,29961436 17,15232 5,09911491 14,72998703 14,479 1,211483719 15,37640427 15,14927 0,017834778 16,77213717 17,22452 2,100735221 19,92096464 15,47712 4,200132549 20,58374198 15,6519 2,394784159 20,14852753 14,56777 0,317785676 21,56618973 12,98156 1,018219873 20,63338758 9,561052 2,137056889 21,66471942 10,21348 1,233519913 21,38916875 7,905679 3,200001049 19,78277267 7,987288 3,099995418 19,09884615 7,78699 4,299998961 16,96836846 7,028155 2,600002116 15,13095929 8,796302 0,500000905 13,67122396 7,64186 2,399996245 12,26352885 12,20528 4,200003476 10,78916014 5,793571 2,699994567 9,44879617 6,527026 3,700382352 8,282659951 5,449103 2,949079137 7,758217946 6,255249 4,554552745 8,309623189 8,849399 5,277056312 8,675759374 8,831509 5,603797657 9,178134139 7,504521 5,360475891 9,745803493 6,351038 The first column is your dependent variable (Y) and the other two variables are your independent variables (1 and 2) Using multiple OLS, estimate the sample regression equations of the dependent variable and the two independent variables (remember to use the correct dependent variable) Include an output table and comment on any interesting aspects of the results Interpret your estimate of and (the slope coefficients) and comment on the goodness of fit of the estimated equations Clearly stating the hypothesis, test statistic, critical value and conclusion, test the joint hypothesis that there is a statistically significant relationship between the dependent variable and the two independent variables Discuss whether the results of the regression equation are in accordance with what you might have expected How might you improve this research

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 23, 2024

TABLE 1 TABLE 2 TABLE 3 7,196575941 7,040971168 4,287668 4,153444814 7,192353644 6,006722 4,715830609 6,042236996 11,0551 5,248674135 5,761523046 18,41364 4,278970429 6,987554356 15,9353 1,654762041 7,316752204 10,82002 4,571997811

TABLE 1	TABLE 2	TABLE 3
7,196575941	7,040971168	4,287668
4,153444814	7,192353644	6,006722
4,715830609	6,042236996	11,0551
5,248674135	5,761523046	18,41364
4,278970429	6,987554356	15,9353
1,654762041	7,316752204	10,82002
4,571997811	8,03930326	10,44006
6,111054461	8,333333333	11,16363
1,695448177	7,744131129	11,61179
2,249904054	9,610826993	15,06611
-0,094037534	10,39637481	24,87883
3,014548966	12,10352119	10,13395
3,790503812	13,55669714	13,98494
6,620585081	13,6186653	16,52224
5,360737419	14,68703664	11,47756
-0,383390769	15,54637452	16,81518
-1,846544477	15,29961436	17,15232
5,09911491	14,72998703	14,479
-1,211483719	15,37640427	15,14927
0,017834778	16,77213717	17,22452
2,100735221	19,92096464	15,47712
4,200132549	20,58374198	15,6519
2,394784159	20,14852753	14,56777
-0,317785676	21,56618973	12,98156
-1,018219873	20,63338758	9,561052
-2,137056889	21,66471942	10,21348
1,233519913	21,38916875	7,905679
3,200001049	19,78277267	7,987288
3,099995418	19,09884615	7,78699
4,299998961	16,96836846	7,028155
2,600002116	15,13095929	8,796302
0,500000905	13,67122396	7,64186
2,399996245	12,26352885	12,20528
4,200003476	10,78916014	5,793571
2,699994567	9,44879617	6,527026
3,700382352	8,282659951	5,449103
2,949079137	7,758217946	6,255249
4,554552745	8,309623189	8,849399
5,277056312	8,675759374	8,831509
5,603797657	9,178134139	7,504521
5,360475891	9,745803493	6,351038

The first column is your dependent variable (Y) and the other two variables are your independent variables (1 and 2). Using multiple OLS, estimate the sample regression equations of the dependent variable and the two independent variables (remember to use the correct dependent variable). Include an output table and comment on any interesting aspects of the results. Interpret your estimate of and (the slope coefficients) and comment on the goodness-of-fit of the estimated equations. Clearly stating the hypothesis, test statistic, critical value and conclusion, test the joint hypothesis that there is a statistically significant relationship between the dependent variable and the two independent variables. Discuss whether the results of the regression equation are in accordance with what you might have expected. How might you improve this research?