3 assignments

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.

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Order Now and we will direct you to our Order Page at Litessays. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.