Question: Correlation First, please review the Calculating Correlations Using Excel YouTube video. Once you have viewed this correlation example using Excel, use the data from the
Correlation
First, please review the Calculating Correlations Using Excel YouTube video. Once you have viewed this correlation example using Excel, use the data from the data sheet and answer the following questions and utilize the seven-step process where appropriate.
1.Perform a Pearson Product Moment Correlation on the following comparisons: (15 points)
a.height vs. weight
b.weight vs. age
c.height vs. shoe size
Problem 1a
Step 1:Ho:______
Ha:______
Step 2: Alpha level = _____
Step 3: Sampling distribution is df = _____
Step 4: Decision Rule: I will reject the Ho if the |_robs_| value falls at or beyond
the |_rcrit_| of ____, otherwise I will fail to reject
Step 5: Calculation: \_robs_/ = _____
Step 6: Summary: Since the |_robs_| of _________________ the |_rcrit_| of
_____, I thereforereject/fail to reject (choose one) the Ho.
Step 7: Conclusion: Since _______ occurred, I conclude ___________________________________________________________________.
Problem 1b
Step 1:Ho:______
Ha:______
Step 2: Alpha level = _____
Step 3: Sampling distribution is df = _____
Step 4: Decision Rule: I will reject the Ho if the |_robs_| value falls at or beyond
the |_rcrit_| of ____, otherwise I will fail to reject
Step 5: Calculation: \_robs_/ = _____
Step 6: Summary: Since the |_robs_| of _________________ the |_rcrit_| of
_____, I thereforereject/fail to reject (choose one) the Ho.
Step 7: Conclusion: Since _______ occurred, I conclude ___________________________________________________________________.
Problem 1c
Step 1:Ho:______
Ha:______
Step 2: Alpha level = _____
Step 3: Sampling distribution is df = _____
Step 4: Decision Rule: I will reject the Ho if the |_robs_| value falls at or beyond
the |_rcrit_| of ____, otherwise I will fail to reject
Step 5: Calculation: \_robs_/ = _____
Step 6: Summary: Since the |_robs_| of _________________ the |_rcrit_| of
_____, I thereforereject/fail to reject (choose one) the Ho.
Step 7: Conclusion: Since _______ occurred, I conclude ___________________________________________________________________.
2.Explain the correlation coefficient of determination. (15 points)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help