3 assignments

Question # 00250080 Posted By: lola1 Updated on: 04/13/2016 01:49 AM Due on: 04/27/2016
Subject Health Care Topic Clinical Medicine Tutorials:
Question
Dot Image
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.
Dot Image
Tutorials for this Question
  1. Tutorial # 00245307 Posted By: lola1 Posted on: 04/13/2016 01:50 AM
    Puchased By: 2
    Tutorial Preview
    The solution of 2 assignments...
    Attachments
    Solution-00245307.zip (118 KB)

Great! We have found the solution of this question!

Whatsapp Lisa