Use the data set you created in Week 1 to determine the mathematical relationship between BMI and HDL cholesterol.
Resources
Be sure to review the Learning Resources before completing this activity.
Readings
Be sure to review the Learning Resources before completing this activity.
Readings
MyLab Statistics Pearson eText
Note: The eText link will always open in a new browser window to page 1. Use the expandable table of contents on the top left side of the book to navigate to other chapters and sections.
Triola, M. F. (2022). Elementary statistics using Excel (7th ed.). Pearson.
Chapter 2, “Exploring Data With Tables and Graphs”
Section 2.4, “Scatterplots, Correlation, and Regression” (pp. 86–94)
Chapter 10, “Correlation and Regression”
Section 10.1, “Correlation” (pp. 541–543)
Section 10.2, “Regression” (pp. 562–567)
Media
Vertex42. (2017, August 14). Creating an XY scatterplot in ExcelLinks to an external site. [Video]. YouTube. https://youtu.be/gBbGBrHTMrM
Quantitative Specialists. (2018, February 26). How to calculate a correlation in Excel: Pearson’s rLinks to an external site.; linear relationshipLinks to an external site. [Video]. YouTube. https://youtu.be/rowszOgJ7IE
Miss Sharpe. (2019, October 31). Calculating correlation coefficient ExcelLinks to an external site. [Video]. YouTube. https://youtu.be/Nc0cTp4UdBk
DecisionSkills. (2015, July 13). How ice cream kills! Correlation vs. causationLinks to an external site. [Video]. YouTube. https://www.youtube.com/watch?v=VMUQSMFGBDo
Hijazi, S. (2018, February 11). Creating scatter diagram in Microsoft Excel 2016 (Office 365)Links to an external site. [Video]. YouTube. https://youtu.be/kc8CCKjwrTM
Emmanuel, J. (2016, September 23) Regression output using data analysis in ExcelLinks to an external site. [Video]. You Tube. https://www.youtube.com/watch?v=B-tFvua7qV4
Economistician. (2015, May 15). How to evaluate the coefficient of determination (rLinks to an external site.-squared) of a regression outputLinks to an external site. (Excel 2013) [Video]. YouTube. https://youtu.be/Ulq-r9-9KgY
To prepare:
This Discussion will make use of the data set created in Week 1 and will examine the correlation between BMI and HDL cholesterol.
By Day 4
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.
By Day 6
Respond to at least two of your fellow peers using the following guidelines.
Response 1:
State your peers R-squared (R2) value, as well as the R2 value you computed between BMI and HDL cholesterol level.
Explain which of the relationships is stronger, your peers or yours? Use the R2 value to justify your reasoning.
Calculate the coefficient of determination (R2 value) for your peer’s data. Explain what this indicates about the relationship between BMI and HDL cholesterol.
Explain one reason we cannot assume that changes in HDL cholesterol are caused by changes in BMI.
Response 2:
Use the regression equation that your peer created to model the relationship between BMI and HDL cholesterol.
What would you predict the HDL would be for a patient with a BMI of 25? Show your calculations.
What would you predict the HDL would be for a patient with a BMI of 40? Show your calculations.
What did you predict would happen to HDL cholesterol as the BMI increased in your main post? Did these predictions support your prediction? Why, or why not?
*Please, I need the same writer throughout this course.