Explore BrainMass
Share

Explore BrainMass

    Using Excel to Find Correlations

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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

    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?

    © BrainMass Inc. brainmass.com October 10, 2019, 5:51 am ad1c9bdddf
    https://brainmass.com/statistics/correlation/using-excel-find-correlations-520232

    Attachments

    Solution Preview

    Please see the attached files; the first is written explanation and the next actual Excel workings. Good luck!

    Question 1: 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
    Solution: Using Excel, we get the following (see sheet 4)
    Column 1 Column 2
    Column 1 1
    Column 2 0.962911 1
    So, we can see that the correlation coefficient is R=0.962911. It appears that there is a strong positive relationship between X and Y.

    Question 2: A drug company is ...

    Solution Summary

    The expert uses Excel to find the correlation between variables.

    $2.19