Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

4. [10 Points] Due to advances in medicine and higher standards of living, life expectancy has been increasing in most developed countries since the beginning

image text in transcribed
4. [10 Points] Due to advances in medicine and higher standards of living, life expectancy has been increasing in most developed countries since the beginning of the 20th century. The Amazon marketing strategy department would like to incorporate the life expectancy of American into their business model. The table below shows the average life expectancyes, in years, of Americans from 1900-2020 (see Midterm.xlsx). Year 1900 1910 1920 1930 1940 1950 1960 1970 1980 1990 2000 2010 2020 Life Expectancy (Years) 42 52 56 60 64 67 69.7 70.8 73.7 75.4 76.8 78.7 80 (a) Using Excel, find a logarithmic regression model for this data set, where (use x = 1 for year 1900, x = 2 for year 1910, x = 3 for year 1920, ... etc.) (b) Using the function/model found in (a) to estimate the life expectancy of Americans in year 2030. (c) Using the function/model found in (a) determine in which year the life expectancy Americans will reach 82 (after computing the corresponding year, round your answer to a whole number)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Trigonometry

Authors: Mark Dugopolski

3rd Edition

0321899830, 9780321899835

More Books

Students also viewed these Mathematics questions