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.