Econ
darub11
ex_data_set_0.xlsxSheet1
| India statewise data, 2001 | ||||||||||
| State | Infant mortality | Female literacy rate | ||||||||
| (per 1,000 births) | (percent) | |||||||||
| Andhra Pradesh | 66 | 51.17 | ||||||||
| Arunachal Pradesh | 44 | 44.24 | ||||||||
| Assam | 78 | 56.03 | ||||||||
| Bihar | 67 | 33.57 | ||||||||
| Goa | 36 | 75.51 | ||||||||
| Gujarat | 64 | 58.60 | ||||||||
| Haryana | 69 | 56.31 | ||||||||
| Himachal Pradesh | 64 | 68.08 | ||||||||
| Jammu & Kashmir | 45 | 41.82 | ||||||||
| Karnataka | 58 | 57.45 | ||||||||
| Kerala | 16 | 87.86 | ||||||||
| Madhya Pradesh | 97 | 50.28 | ||||||||
| Maharashtra | 49 | 67.51 | ||||||||
| Manipur | 25 | 59.70 | ||||||||
| Meghalaya | 52 | 60.41 | ||||||||
| Mizoram | 23 | 86.13 | ||||||||
| Orissa | 98 | 50.97 | ||||||||
| Pondicherry | 21 | 74.13 | ||||||||
| Punjab | 54 | 63.55 | ||||||||
| Rajasthan | 83 | 44.34 | ||||||||
| Sikkim | 52 | 61.46 | ||||||||
| Tamil Nadu | 53 | 64.55 | ||||||||
| Tripura | 49 | 65.41 | ||||||||
| Uttar Pradesh | 85 | 42.98 | ||||||||
| West Bengal | 53 | 60.22 | ||||||||
| SUMMARY OUTPUT | ||||||||||
| Regression Statistics | ||||||||||
| Multiple R | 0.6664482674 | |||||||||
| R Square | 0.4441532931 | |||||||||
| Adjusted R Square | 0.419986045 | |||||||||
| Standard Error | 16.8246845621 | |||||||||
| Observations | 25 | |||||||||
| ANOVA | ||||||||||
| df | SS | MS | F | Significance F | ||||||
| Regression | 1 | 5202.3497558431 | 5202.3497558431 | 18.3783147658 | 0.0002753619 | |||||
| Residual | 23 | 6510.6102441569 | 283.0700106155 | |||||||
| Total | 24 | 11712.96 | ||||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |||
| Intercept | 122.2056085247 | 15.7965889727 | 7.7362023368 | 0.0000000759 | 89.5278745276 | 154.8833425218 | 89.5278745276 | 154.8833425218 | ||
| X Variable 1 | -1.1159431505 | 0.2603090266 | -4.2869936746 | 0.0002753619 | -1.6544333994 | -0.5774529015 | -1.6544333994 | -0.5774529015 |
