Question I. Use Excel or SPSS to complete Exercise 1 in the Cumulative ReviewExercises on page 485 i

Question I. Use Excel or SPSS to complete Exercise 1 in the Cumulative ReviewExercises on page 485 in the textbook. APA format is not required, but solid academic writing is expected. Due Tuesday NOV 29thQuestion 2. Chapter 11 of the textbook covers “Analysis of Variance”, however the authorsstate that “Testing for Equality of Three or More Population Means” might be a better chaptertitle. 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 amultiple-page scholarly treatise. The goal is that you become familiar with the formal reportformat that you will use whenever you are reporting statistical analysis. The report formatincludes the following sections: Abstract, Purpose, Methods, and Results.Assume that you are asked to perform an exploratory data analysis in which the emphasis is tocompare the difference between the body mass index (BMI) values of men and women. UseExcel and/or SPSS to create reports and run analyses on the data for the Data Set 1 in AppendixB of your textbook.Assume you are a biostatistics analyst and you received a request from the director of thenutrition program to perform the analysis. The director is developing an obesity program for thestate 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 thatwould make your analysis easier to understand would be appreciated.Generate appropriate histograms or box plots. Find appropriate statistics that will help tounderstand the data set. Are there any notable features? Are there any outliers? Describe the keyelements 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 isexpected, and in-text citations and references should be presented using APA documentationguidelines, 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 theassignment; therefore, students should review the rubric prior to beginning the assignment tobecome familiar with the assignment criteria and expectations for successful completion of theassignment.You are required to submit this assignment to Turnitin DUE Dec 8th Question 4 For the following assignment, use the Rank Correlation that wasdemonstrated 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 programswhere health care insurers work with clinical facilities to perform risk analysis of patients todetermine the cost of providing care. The following assignment might be used to assess howmuch a person smokes.When nicotine is absorbed by the body, cotinine is produced. A measurement of cotinine in thebody is therefore a good indicator of how much a person smokes. The reported number ofcigarettes smoked per day and the measured amounts of cotinine (in ng/ml) are provided. (Thevalues are from randomly selected subjects in a National Health Examination Survey.) Is there asignificant linear correlation? How would you measure the cotinine level in the body? Explainthe 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 9thRank Correlation Table x (cigarettes per day) 60 10 4 15 10 1 20 8 7 10 10 20 y(cotinine) 179 283 75.6 174 209 9.51 350 1.85 43.4 25.1 408 344