Question: The table below gives the average life expectancy (in years) of a person from a certain country based on various years of birth. Here, x
The table below gives the average life expectancy (in years) of a person from a certain country based on various years of birth. Here, x represents the year of birth after 1990, and y represents the life expectancy. Use Excel to find thebest fit linear regression equation.Round the slope and intercept to three decimal places.
x y 0 77.741 1 77.948 2 78.312 3 78.458 4 78.835 5 78.984 6 79.118 7 79.251 8 79.470 9 79.505 10 79.627 11 79.653 12 79.716 13 79.723 14 79.843 15 80.152 16 80.545 17 80.661 18 80.868 19 81.203 20 81.585 21 81.932 22 82.110 23 82.329 24 82.679 25 83.025
Provide your answer below:
y = __ x +__
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
