S

Using the Gapminder datasets provided (files located at the bottom of this screen), perform the following problems using excel.

1. Perform a Shapiro-Wilk Normality test to determine if the infant mortality data is normally distributed. Upload the All causes deaths in children 1-59 months per 1,000 births. Upload Excel sheet.

2. Perform a Wilcoxon Signed-Rank test on Maternal deaths. Upload Maternal mortality ratio per 100,000 live births to determine if the data as nonparametric. Upload Excel sheet.

3. Perform an ANOVA test on Mean years in school for mean 25-34 years for men, women, and Mean years in school for women of reproductive age 15-44 to determine the difference in means between the groups.

4. Upload all Excel sheet.

· Focus on: both the mean year datasets please use the years 2008 and 2009.

· Present your findings in excel. 

· Present your findings in a Word document, with a title page included introduction, body explaining the findings and conclusion.

· Your submission should be as many pages as you need (at least 3 pages) to display your findings and explain it.