Applied statistics to nursing

1.Refer to the “Visual Learner: Statistics” for examples to help complete the problems in the “Topic 5: Correlation/Regression and Chi Square Excel Worksheet.” Also, to aide in the Excel calculations, view the appropriate section of the Excel tutorials. Answer each question completely in the Excel worksheet provided.

2.Complete Exercise 23 and 24 in Statistics for Health Care Research: A Practical Workbook.

In order to receive full credit on calculated answers, please show your work. (Use Word’s equation editor, etc., and/or provides a short written description as to how you obtained the final result.) Exercise 24 includes 10 questions and a bonus question. Answer all questions including the bonus question.