Posted: November 11th, 2016

1Details: >> Complete “Practice Exercise 1” (page 157) and “Practice Exercise 11” >> (page >> 180) in the textbook.

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 >> >> >> >> 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. >> >