rie0
Answered

Discover the best answers at Westonci.ca, where experts share their insights and knowledge with you. Discover the answers you need from a community of experts ready to help you with their knowledge and experience in various fields. Discover in-depth answers to your questions from a wide network of professionals on our user-friendly Q&A platform.

Answer the given problem.
Process the data in excel and present the results.
A researcher is interested in knowing how well he can predict blood pressure from sodium intake.
1. Formulate the regression equation for the data.
2. What would be a likely blood pressure reading for a patient with a sodium intake of 6.0? Of 8.5?
PatientsSodiumBP16.515127.317036.616547.517257.618766.716176.716987.819297185107.4190116.2145126.7143​

Sagot :

A regression model is used to show the relationship between variables on a scatter plot

  • The regression equation is: [tex]\^y = 28.2\^x- 27.9[/tex]
  • The likely blood pressure for a patient with sodium intake of 6.0 and 8.5 are 141.3 and 211.8, respectively

How to formulate the regression equation

Using the Microsoft Office Excel, we have the following calculation summary

  • Sum of X = 84
  • Sum of Y = 2030
  • Mean X = 7
  • Mean Y = 169.1667
  • Sum of squares (SSX) = 2.82
  • Sum of products (SP) = 79.4

So, the regression equation is:

[tex]\^y = 28.2\^x- 27.9[/tex]

Blood pressure for a sodium intake of 6.0 and 8.5

This means that x = 6.0 and x = 8.5

When x = 6.0, we have:

[tex]\^y = 28.2 * 6.0- 27.9[/tex]

[tex]\^y = 141.3[/tex]

When x = 8.5, we have:

[tex]\^y = 28.2 * 8.5- 27.9[/tex]

[tex]\^y = 211.8[/tex]

Hence, the likely blood pressure for a patient with sodium intake of 6.0 and 8.5 are 141.3 and 211.8, respectively

Read more about regression at:

https://brainly.com/question/17844286