2. Question2_Dataset.xlsx contains the following data for several underdeveloped countries:

• Infant mortality rate
• Adult literacy rate
• Percentage of students finishing primary school
• Per capita GNP
  1. Use this data to develop an equation that can be used to predict infant mortality.
  2. Are there any outliers in this set of data?
  3. Interpret the coefficients in your equation. (What does each coefficient number mean?)
  4. Within what value should 95% of your predictions be infant mortality be accurate?

Please show a STEP by STEP solution.

	Infant Mortality(deaths per thousand births)	%age adult literacy	%age finishing primary school	GNP per capita	Predictions	Residuals	Residuals^2
Cuba	18	98	98	2000	0	18	324
Sri Lanka	20	85	92	3300	0	20	400
Costa Rica	19	94	84	5800	0	19	361
Vietnam	44	85	58	600	0	44	1936
China	54	80	86	2400	0	54	2916
South Africa	56	76	68	4000	0	56	3136
Saudi Arabia	38	59	68	11000	0	38	1444
Brazil	60	78	56	5600	0	60	3600
Zimbawe	68	82	76	1800	0	68	4624
Morocco	68	42	76	3400	0	68	4624
Pakistan	98	36	38	2100	0	98	9604
Nigeria	86	44	56	1600	0	86	7396