? . Use Excel to solve this problem. [LO1] 2. [Excel) The following data show estimates of

?

Transcribed Image Text:

. Use Excel to solve this problem. [LO1] 2. [Excel) The following data show estimates of the population of Liberia in selected years between 1960 and 2010: Year 1960 1.1 1970 200 1980 1990 2010 Population(millions) 1.4 1.9 2.1 2.8 a) Use two-point backward difference formula. (10 POINTS) b) Use the three-point backward difference formula. (10 POINTS) Finite Difference Formulas First Derivative Method Formula Truncation Error f(Xi+1) – f(x) f'(x): O(h) Two-point forward difference Three-point forward h -3f(x) + 4f(Xi+1)- {Xi+2) f'(x) = O(h") difference 2h Two-point backward f(xi) - f(Xi-1) O(h) f'(x) = %3D difference h (G4)0 O(h²) f(Xi-2) – 4f(Xi-1) + 3f(x;) Three-point backward difference Two-point central f'(x) = 2h f(Xi+1) -f(Xi-1) f'(x) = difference 2h (C) Using the slope in 2010 from part (b), apply the two-point central difference formula to extrapolate and predict the population in the year 2020. . Use Excel to solve this problem. [LO1] 2. [Excel) The following data show estimates of the population of Liberia in selected years between 1960 and 2010: Year 1960 1.1 1970 200 1980 1990 2010 Population(millions) 1.4 1.9 2.1 2.8 a) Use two-point backward difference formula. (10 POINTS) b) Use the three-point backward difference formula. (10 POINTS) Finite Difference Formulas First Derivative Method Formula Truncation Error f(Xi+1) – f(x) f'(x): O(h) Two-point forward difference Three-point forward h -3f(x) + 4f(Xi+1)- {Xi+2) f'(x) = O(h") difference 2h Two-point backward f(xi) - f(Xi-1) O(h) f'(x) = %3D difference h (G4)0 O(h²) f(Xi-2) – 4f(Xi-1) + 3f(x;) Three-point backward difference Two-point central f'(x) = 2h f(Xi+1) -f(Xi-1) f'(x) = difference 2h (C) Using the slope in 2010 from part (b), apply the two-point central difference formula to extrapolate and predict the population in the year 2020.