Hello,
These assignments needs to be done on two separate excel. In a way I would need two separate excel attachments. Also, there is question that needs to be answered in excel sheet as well. Thanks in advance.
Details:
1st question ( Correlation between Two Variables)
Use Excel to do a correlation between the following variables:
1) X – 2,5,5,6,6,7,8,9
2) Y – 1,2,2,3,4,4,5,5
This 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.
2nd question (t-Test for two samples)
A 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,9
2) Group 2: 1,2,2,3,4,4,5,5,6,8
Use 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.
This 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.
