Statistical Tests I need WORD and EXCEL sheets
Using the Gapminder datasets provided (Check attached files), perform the following problems using Excel.
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
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.