**THIS DISCUSSION IS DIVIDE IN TWO PARTS –
0. MAIN DISCUSSION POST BY WEDNESDAY 6/14/2023 BEFORE 8:00 PM EST
0. TWO REPLIES BY FRIDAY 06/16/2023 BEFORE 8:00 PM EST
CORRELATION IN YOUR LIFE
Graphical Relationship
· After you create a scatterplot (see below) for the data in the BMI and HDL cholesterol columns (from the data set ST3001Data_L_Rivera)
Instructions:
**Use the data from ST3001Data_L_Rivera – see excel document attached**
1. Using Excel, calculate the linear correlation coefficient between the data in the BMI and HDL cholesterol columns.
2. 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.
1. 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.
2.
