1. Sue also decides to see if weight loss might be related to hours spent watchi

Question

1. Sue also decides to see if weight loss might be related to hours spent watching TV. She surveys other women and gathers the following data

What can she say about TV watching and weight loss? Is there a srong methematical relationship?

how would you graph the relationship?

2. Sue know a woman who watches 12 hours a week of TV. (she has Comcast) how much

weight does Sue think she'll lose?

3. Sue decides to go on the Dr.Phil show and talk about her study. Can she tell Dr. P that watching TV

causes weight gain?

Please help me figure out the Excel formulas as well as the answers. Thank you so much in advance.

Weight loss per week: Hours watching TV per week: 3 2 2 5 1 8 4 2 2 4 2 6 1 8 1 7 3 1

Explanation / Answer

to check strong mathematical relationship and how much weight loss use regression and correlation coefficient, use excel to solve these, the excel path is,

enter the data of hour ( x ) and weight loss (y ) in excel---->data------>data analysis ------>regression-----.ok------.input Y range ( select y data )------->input X range ( select x data ) ------>output range ( click on one blank box from excel )---------->ok . the excel give the output

here the correlation coefficient denoted by r and it is 0.91, if r > 0.8 then it is strong relationship between the two variable.

from excel output the intercept = b0 = 3.83 and slope = b1 = -0.36 then the regression line is

y = 3.83 - 0.36 ( x ) here to put the value x= hours = 12 then

y = 3.83 - 0.36( 12 ) then y = -0.49 weight loss

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.