Posted: December 13th, 2016

Click on the Data Analysis tab at the top right.

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

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
Live Chat+1-631-333-0101EmailWhatsApp