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

data show estimates of the population of Liberia in selected years between?

. 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Electrical Engineering Questions!