{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

MATH_221_SAMPLE_MODULE_2_UPDATED_SU_10

# MATH_221_SAMPLE_MODULE_2_UPDATED_SU_10 - r = 1 appears not...

This preview shows pages 1–8. Sign up to view the full content.

MATH_221_SAMPLE_MODULE_2_SU_10 Exercise 1 A. Interpret the Correlation Coefficient Step 1 Retrieve or Copy the Given Data

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Step 2 Formula the Worksheet Click an empty cell such as A8 . With the above cell selected, enter the following formula: =CORREL(A2:A7,B2:B7) Use Ctrl + Shift + Enter to have the formula return a value. Observe the result. If the result is between 80 and 100 % , then there is a strong positive correlation.  We also conclude that as the weight increases, systolic blood pressure as increases. Exercise 2 A. Interpret the Correlation Coefficient
Notice that the above data appears to have a linear trend with a positive slope ( upward from left  to right ) .  Hence the answer cannot be a negative value.  The data set does not appear to be in a perfect linear form hence

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: r = 1 appears not to be the answer. The best answer appears to be r = 0.84 . Exercise 3 A. Interpret the Correlation Coefficient The data set appears to be in a perfect linear form with a decreasing slope, hence r = - 1 . Exercise 1 B. Find the Regression Equation Step 1 Retrieve or Copy the Given Data Step 2 Formula the Worksheet Highlight the cell range A32 : B32 . With the above region highlighted, enter the following formula: =LINEST(B2:B31,A2:A31) Use Ctrl + Shift + Enter to have the formula return the values. 0.555528219 25.02880809 This represents a line of best fit equal to: y = mx + b or y = 0.56x + 25.03...
View Full Document

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern