rie0
Answered

Explore Westonci.ca, the premier Q&A site that helps you find precise answers to your questions, no matter the topic. Experience the convenience of getting reliable answers to your questions from a vast network of knowledgeable experts. Join our Q&A platform to connect with experts dedicated to providing accurate answers to your questions in various fields.

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