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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started