Posted: December 13th, 2016

# For the data set listed, use Excel to extract the >> mean and standard deviation for the sample of lengths of stay for

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

### Expert paper writers are just a few clicks away

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

## Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
\$0.00