Overview
Graphical Relationship
- Create a scatterplot for the data in the BMI and HDL cholesterol columns (from the data set you created in Week 1). Insert a screenshot of this graph or attach an .xls or .docx file to your post.
- Using Excel, calculate the linear correlation coefficient between the data in the BMI and HDL cholesterol columns.
- Explain the mathematical relationship between BMI and HDL cholesterol, based on the linear correlation coefficient. Be certain to include comments about the magnitude (strength) and the direction (positive or negative) of the correlation. As BMI increases, what happens to HDL cholesterol?
Linear Regression and Prediction
- Let’s say we wanted to predict the HDL cholesterol level of a patient based on their BMI.
- Using this sample data, perform a linear regression to determine the line of best fit. Use BMI as your x (independent) variable and HDL as your y (response) variable. Use four (4) places after the decimal in your answer. Paste it in your report.
- What is the equation of the line of best fit (linear regression equation)? Present your answer in form.