Details:question 1Details: Complete “Practice Exercise 1” (page 157) and “Practice Exercise 11” (page 180) in the textbook. For the data set listed, use Excel to extract the mean and standard deviation for the sample of lengths of stay for cardiac patients. Use the following Excel steps:1) Enter the data set into Excel.2) Click on the Data tab at the top.3) Highlight your data set with your mouse.4) Click on the Data Analysis tab at the top right.5) Click on Descriptive Statistics in the analysis tool list.6) Find the mean and standard deviation of the data sets.7) Send the results to instructor via e-mail, along with your analysis of the description of the data set.APA format is not required, but solid academic writing is expected. question 2 Use Excel to do a correlation between the following variables:1) X – 2,5,5,6,6,7,8,92) Y – 1,2,2,3,4,4,5,5This 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. question 3 Details: t-test for two samplesA drug company is measuring levels of oxygenation in patients after receiving a test medication. As the researcher, you are interested in whether Group I, which received the medication, has the same oxygenation levels as Group II, which did not.1) Group 1: 2,3,3,4,4,7,8,92) Group 2: 1,2,2,3,4,4,5,5,6,8Use Excel to run a t-test for two samples, assuming equal variances, with an alpha value of 0.05. Run the t-test and note:1) Are you doing a one-tailed test or a two-tailed test (Excel will give you both)?2) What is the probability that Group I is different from Group 2, using the p value? Is it significant against the benchmark of p < .05?APA format is not required, but solid academic writing is expected.
