Statistical Tests I need WORD and EXCEL sheets

profileMicheal05435
excel-ct13.docx

Using the Gapminder datasets provided (Check attached files), perform the following problems using Excel.

1. Perform a Cox proportional hazard test to determine the risk factors comparing survival curves between the groups breast cancer deaths per 100,000 women, cervical cancer deaths per 100,000 women, and colon/rectum cancer deaths per 100,000 women data set here: 

1. indicator breast female mortality.xlsx

2. indicator cervix female mortality.xlsx

3. indicator colon and rectum female mortality.xlsx     Please use years 2000, 2001, and 2002.

4. Provide introduction and conclusion

Cox proportional hazards model in Excel tutorial

https://help.xlstat.com/customer/en/portal/articles/2062273-cox-proportional-hazards-model-in-excel-tutorial

2. Perform a Kaplan-Meier Log-rank test to determine the survival curve of the dataset here:

1. indicator_estimated incidence infectious tb per 100000.xlsx Please use the date range of 1998-2007 to calculate the survival curve.

2. Provide introduction and conclusion

Kaplan-Meier survival analysis in Excel tutorial

https://help.xlstat.com/customer/en/portal/articles/2062246-kaplan-meier-survival-analysis-in-excel-tutorial?b_id=9283

3. Perform a Chi-Square analysis to determine the observed and expected distributions between infectious TB estimated number of new cases per 100,000 and total number of new cases reported here:

1. indicator_reported incidence infectious tb.xlsx 

2. indicator_estimated incidence infectious tb per 100000.xlsx  Please use the years 2005-2007 in each of the studies.

3. Provide introduction and conclusion

Run Chi-square and Fisher’s exact tests in Excel tutorial

https://help.xlstat.com/customer/portal/articles/2062459?b_id=9283

Important Notes:

· Provide the Excel sheets with the results.

· Provide screenshots of your submission and present your findings in a Word document. Provide minimum 4 pages.

· 25% plagiarism as possible.

· APA format.

· References 7 not later than 2013 and provide in-text citation.