Use the dataset provided and estimate the following regression

question.docx

Home >Mathematics homework help >Numerical analysis homework help >Use the dataset provided and estimate the following regression

Use the dataset provided and estimate the following regression.

Using the regression output provided by Excel, complete the table below (please make your table look professional). Then, test the null hypothesis described in question 1 below. Explicitly state the null and alternative hypothesis in terms of the coefficients given in the regression equation above; report the t-Statistic for the null hypothesis and explain your answer.

In the table below, please report the standard error (in parentheses) underneath the estimated coefficient. (Please make a professional looking table)

Variable	Estimated coefficient (standard error)
Constant
Adult female literacy rate
Gross domestic product per capita
Infant mortality rate

1. The adult female literacy rate has no effect on the sex ratio among the states of India. Explain your answer by reporting the appropriate t-statistic using the information reported in the table provided above.