Help me in my assignment , please quickly

Suppose you are interested in predicting the abortion rate in the USA based on various factors in the excel file Abortion.xls

The definition of the variables of interest is presented in the table below:

Variable	Definition / Unit
abortion	Abortion rate
price	The average price charged in non-hospital facilities for an abortion
income	Disposable income per capita
law	Enforced law that restricts a minors access to abortion,
educ	The percent of a states population that is 25 years or older with a high school degree

1. Formulate a multiple linear regression model that includes all potential explanatory variables and estimate it with the given sample data. Hint: Note the presence of a qualitative variable that needs to be re-coded as a dummy variable.

2. Interpret the parameters estimated in the regression equation

3. Are the coefficients statistically significant? *Hint: Conduct proper hypothesis testing

4. How well does the estimated regression equation fit the data? Hint: Explain the R-squared

5. Write down the null and the alternative hypothesis to test the homoscedastic assumption of the classical linear regression model.

6. Write the auxiliary regression equation for the White test to find out if the error variance is homoscedastic

7. Conduct White test to test the hypothesis stated in part e.

8. If heteroscedasticity is established, what might you do to correct for this violation of OLS assumptions?

Consider the following model: abortioni = Be + Biprice; + Bzincome; + B2 lawi + B4educi + Ui A B D E price 256 332 298 251 248 228 292 329 281 272 320 303 370 400 249 300 291 328 280 288 1 abortion law 2 12.4 no 3 17.7 no 4 9.3 yes 5 7.7 no 6 13.5 yes 7 13.4 yes 8 14.2 yes 9 18.2 no 10 12.5 no 11 18.2 yes 12 11.4 no 13 7.2 no 14 10.7 yes 15 6.8 no 16 24.1 no 17 16.2 no 18 22.4 no 19 14.7 no 20 11.4 no 21 12 yes 22 23.1 no 23 24 yes 24 23.9 no 25 4.3 yes 26 21.2 no 27 11.6 yes 28 15.7 yes 29 13.6 yes 30 19.5 yes 31 22.4 yes 32 25.2 yes 33 30 no 34 30 yes 35 15.6 yes 36 18.6 no 37 23.6 no 38 35.2 no 39 22.7 no 40 27.7 no 41 42.1 no 42 44.2 no 43 25.4 no 44 14.6 no 45 16.5 no 46 46 no 47 26.4 no 48 28.4 yes 49 46.2 no 50 31 no 51 26.2 no 52 educ 64.3 75.1 85.1 66 66.3 68.3 68.3 81 74.6 66.9 64.6 79.7 76.7 66.3 78.7 67.1 70 78.8 80.1 75.6 72.1 70.9 81.5 83 80.8 66.9 81.8 78.6 75.7 81.3 76.8 74.4 72 82.4 74.7 84.4 77.5 75.2 83.8 76.2 78.8 76.2 82.2 86.6 80.1 78.4 80 74.8 76.7 79.2 income 14082 15458 15573 15598 15635 15931 16212 16227 16420 16522 16528 16649 17048 17198 17401 17674 17863 18163 18275 18366 18437 18549 18605 18631 18792 18970 18974 19038 19040 19387 19586 19711 20276 20503 20642 20666 20724 20883 21289 21348 21648 21774 21933 22067 22200 23268 23676 24095 26091 27150 257 319 248 378 276 348 279 276 298 340 352 271 322 270 296 309 247 267 270 293 275 272 372 461 422 264 330 338 316 374 Consider the following model: abortioni = Be + Biprice; + Bzincome; + B2 lawi + B4educi + Ui A B D E price 256 332 298 251 248 228 292 329 281 272 320 303 370 400 249 300 291 328 280 288 1 abortion law 2 12.4 no 3 17.7 no 4 9.3 yes 5 7.7 no 6 13.5 yes 7 13.4 yes 8 14.2 yes 9 18.2 no 10 12.5 no 11 18.2 yes 12 11.4 no 13 7.2 no 14 10.7 yes 15 6.8 no 16 24.1 no 17 16.2 no 18 22.4 no 19 14.7 no 20 11.4 no 21 12 yes 22 23.1 no 23 24 yes 24 23.9 no 25 4.3 yes 26 21.2 no 27 11.6 yes 28 15.7 yes 29 13.6 yes 30 19.5 yes 31 22.4 yes 32 25.2 yes 33 30 no 34 30 yes 35 15.6 yes 36 18.6 no 37 23.6 no 38 35.2 no 39 22.7 no 40 27.7 no 41 42.1 no 42 44.2 no 43 25.4 no 44 14.6 no 45 16.5 no 46 46 no 47 26.4 no 48 28.4 yes 49 46.2 no 50 31 no 51 26.2 no 52 educ 64.3 75.1 85.1 66 66.3 68.3 68.3 81 74.6 66.9 64.6 79.7 76.7 66.3 78.7 67.1 70 78.8 80.1 75.6 72.1 70.9 81.5 83 80.8 66.9 81.8 78.6 75.7 81.3 76.8 74.4 72 82.4 74.7 84.4 77.5 75.2 83.8 76.2 78.8 76.2 82.2 86.6 80.1 78.4 80 74.8 76.7 79.2 income 14082 15458 15573 15598 15635 15931 16212 16227 16420 16522 16528 16649 17048 17198 17401 17674 17863 18163 18275 18366 18437 18549 18605 18631 18792 18970 18974 19038 19040 19387 19586 19711 20276 20503 20642 20666 20724 20883 21289 21348 21648 21774 21933 22067 22200 23268 23676 24095 26091 27150 257 319 248 378 276 348 279 276 298 340 352 271 322 270 296 309 247 267 270 293 275 272 372 461 422 264 330 338 316 374