Posted: December 13th, 2016

Question

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.

>>

>

Place an order in 3 easy steps. Takes less than 5 mins.