I. Use Excel or SPSS to complete Exercise 1 in the Cumulative Review Exercises on page 485 in the textbook. APA format is not required, but solid academic writing is expected. Due Tuesday NOV 29th Question 2. Chapter 11 of the textbook covers "Analysis of Variance", however the authors state that "Testing for Equality of Three or More Population Means" might be a better chapter title. Due December 6th Question 3 Use Excel or SPSS to perform the one-way analysis of variance (ANOVA) for the data in "From Data to Decision" on page 565 of the textbook. APA format is not required, but solid academic writing is expected. Write a 750-1000 word statistical laboratory report using the guidelines in the assigned article, "How to Write a Statistical Report." This statistical report is not meant to be an APA report or a multiple-page scholarly treatise. The goal is that you become familiar with the formal report format that you will use whenever you are reporting statistical analysis. The report format includes the following sections: Abstract, Purpose, Methods, and Results. Assume that you are asked to perform an exploratory data analysis in which the emphasis is to compare the difference between the body mass index (BMI) values of men and women. Use Excel and/or SPSS to create reports and run analyses on the data for the Data Set 1 in Appendix B of your textbook. Assume you are a biostatistics analyst and you received a request from the director of the nutrition program to perform the analysis. The director is developing an obesity program for the state and has obtained the data set from the National Center for Health Statistics (NCHS). Because it has been some time since the director has had a statistics course, any points that would make your analysis easier to understand would be appreciated. Generate appropriate histograms or box plots. Find appropriate statistics that will help to understand the data set. Are there any notable features? Are there any outliers? Describe the key elements of center, variation, distribution, and outliers. A minimum of three scholarly references are required. While APA format is not required for the body of this assignment, solid academic writing is expected, and in-text citations and references should be presented using APA documentation guidelines, which can be found in the APA Style Guide, located in the Student Success Center. This assignment uses a grading rubric. Instructors will be using the rubric to grade the assignment; therefore, students should review the rubric prior to beginning the assignment to become familiar with the assignment criteria and expectations for successful completion of the assignment. You are required to submit this assignment to Turnitin DUE Dec 8th Question 4 For the following assignment, use the Rank Correlation that was demonstrated in Chapter 12 of the textbook (page 566). Utilizing Excel or SPSS: 1. Use a rank correlation coefficient to test for a correlation between two variables. 2. Use a significance level of =0.05. The new health care program in the United States makes provisions for capitation programs where health care insurers work with clinical facilities to perform risk analysis of patients to determine the cost of providing care. The following assignment might be used to assess how much a person smokes. When nicotine is absorbed by the body, cotinine is produced. A measurement of cotinine in the body is therefore a good indicator of how much a person smokes. The reported number of cigarettes smoked per day and the measured amounts of cotinine (in ng/ml) are provided. (The values are from randomly selected subjects in a National Health Examination Survey.) Is there a significant linear correlation? How would you measure the cotinine level in the body? Explain the result. Refer to the "Rank Correlation Table." APA format is not required, but solid academic writing is expected. You are not required to submit this assignment to Turnitin Due Dec 9th Rank Correlation Table x (cigarettes per day) 60 10 4 15 10 1 20 8 7 10 10 20 y(cotinine) 17 9 28 3 75. 6 17 4 20 9 9.5 1 35 0 1.8 5 43. 4 25. 1 40 8 344