Question: ? . Use Excel to solve this problem. [LO1] 2. [Excel) The following data show estimates of the population of Liberia in selected years between
![. Use Excel to solve this problem. [LO1] 2. [Excel) The following](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2021/06/60d09497048b4_26160d09495db3ea.jpg)
?
. 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.
Step by Step Solution
3.43 Rating (162 Votes )
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
