Below is the average life expectancy of people born in a given year in the U.S Y
ID: 3332382 • Letter: B
Question
Below is the average life expectancy of people born in a given year in the U.S Year 1920 1930 1940 1950 1960 1970 1980 1990 2000 2010 Life Expectancv 54.1 59.7 62.9 68.2 69.7 70.8 73.7 75.4 77.0 78.3 a. What do you predict the life expectancy will be of a person born in 2020? 2050? Explain b. Using Excel, enter the data and find the line of best fit. Interpret the slope and y-intercepts within the context of the problem. What is the r-value? Interpret it's value within the context of the problem According to your line of best fit, what do you predict your life expectancy will be? Does this mean that you live to that exact age? Explain According to your line of best fit, will there be a time when people live to be 300 years of age? Explain According to your line of best fit, what will the average life expectancy be in the year 2050? 2100? 3000? Explain. Are your results reasonable? Why or why not? c. d. e.Explanation / Answer
y^ = -430.0109 + 0.2539 *year
for year = 2020
y^ = -430.0109 + 0.2539 *2020
= 82.8671
for year = 2050
y^ = -430.0109 + 0.2539 *2050
y^ = 90.4841
b)
y^ = -430.0109 + 0.2539 *year
slope = 0.2539
it means when year increasy by 1 unit, y iincreases by 0.2539 units
b0 = -430.0109 , in theory it means y = -430.0109 , when year = 0 ,
I does not make sense here
r = 0.9716
it means both variables are highly correlated
c)
put the value of year in the line
y^ = -430.0109 + 0.2539 *year
d) 300 = -430.0109 + 0.2539 *year
year = 2875.19
, it is not necessary as 2875 is not in range of given data, the result is not trustworthy
e) In 2050 , expectancy = 90.4841
2100 - expectancy = 103.1791
3000 expectancy = 331.6891
since these years are not in range of given data, the result is not trustworthy
SUMMARY OUTPUT Regression Statistics Multiple R 0.971550537 R Square 0.943910447 Adjusted R Square 0.936899252 Standard Error 1.98786851 Observations 10 ANOVA df SS MS F Significance F Regression 1 532.0030303 532.0030303 134.6290552 2.7693E-06 Residual 8 31.6129697 3.951621212 Total 9 563.616 Coefficients Standard Error t Stat P-value Lower 95% Intercept -430.0109091 43.01001815 -9.99792438 8.50135E-06 -529.1921888 year 0.253939394 0.021885712 11.60297614 2.7693E-06 0.203470852Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.