Question

Find the regression​ equation, letting the first variable be the predictor​ (x) variable. Using the listed​ actress/actor ages in various​ years, find the best predicted age of the Best Actor winner given that the age of the Best Actress winner that year is 27 years. Is the result within 5 years of the actual Best Actor​ winner, whose age was 44 ​years?

Best Actress	27	32	28	63	34	31	47	28	59	23	42	52
Best Actor	44	35	38	45	52	49	59	52	41	53	45	35

Find the equation of the regression line.

y = ___ + ​(____)x

​(Round the constant to one decimal place as needed. Round the coefficient to three decimal places as​ needed.)

Answer 1

1. Bring data in to excel sheet

2.Select both x and y variable and insert scatter plot chart. Select any data point in the excel and add trend line. In the format trend line option choose "Linear" and also select "Display an equation on chart"

Regression Equation: y = 49.7 -0.105x

Predict 27 years

y = 49.7 -0.105x

y =49.7-0.105*27 = 47