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 represents the year of birth after 1990, and y represents the life expectancy. Use Excel to find the best fit linear regression equation. Round the slope and intercept to three decimal places.

x   y
0   77.296
1   77.607
2   77.926
3   78.253
4   78.588
5   78.925
6   79.256
7   79.573
8   79.872
9   80.150
10   80.407
11   80.645
12   80.870
13   81.089
14   81.304
15   81.523
16   81.748
17   81.981
18   82.220
19   82.462
20   82.704
21   82.937
22   83.155
23   83.355
24   83.536
25   83.700

Provide your answer below:

y = _x + _

Answer 1

The statistical software output for this problem is :

y = 0.254 x + 77.636