i201 AND ORGANIZE YOUR WORK TO ANSWER EACH SECTION OF THIS ASSIGNMENT. ESENTENCES points) ta,t2 points) The function Pen-muri" could be ned as . modett&the number of year, since 1800) for the world population if we believed that right-tail end behavior of the given data were to continue indefinitely. Use this given model to complete the input-output table below (with the help of Excel). Round values so you can interpret to the nearest person Population of world 1804 121927 :591-1959 1974 671987 1999 ! 2011 (b) [5 points] Iif this model were accurate, then what exactly would happen to the population of the world as the years go by in the future? Do you think this moders end-behavior is an accurate predictor for the actual population of the world in the future? Explain (c) [5 points) According to this model what is the population of the world today? Look online to find the estimated actual population today a 2024 and then compare the actual value with the model's predicted value. Would you consider this model to be a good predictor for today's population? Explain. (d) (4 points] According to this model, when will the world population reach 10 billion people? Answer with a complete sentence, and clearly identify where to find your solution in Excel. (e) [6 points] Find the formula for the derivative function, P *(t). Clearly show your formula in your paper. Add a column to your table in Excel that finds the derivative values for each of the given years in the table. Write a complete sentence to interpret the real-world meaning of the derivative value in the year 2011. (f) 13 points] Create a graph of Plt) and also create a graph of P' (t) in Excel. Add clear labels to the axis of both graphs including units. (e) [5 points) According to the model, in what year is the world's population growing at the fastest rate? Explain how you can see this point on the graph of Plt), and also explain how you can see this point on the graph of P '(t). Estimate the rate of growth in that year when it is growing fastest. SAVE AND UPLOAD YOUR EXCEL FILE TO THE DROPBOX IN BLACKBOARD. i201 AND ORGANIZE YOUR WORK TO ANSWER EACH SECTION OF THIS ASSIGNMENT. ESENTENCES points) ta,t2 points) The function Pen-muri" could be ned as . modett&the number of year, since 1800) for the world population if we believed that right-tail end behavior of the given data were to continue indefinitely. Use this given model to complete the input-output table below (with the help of Excel). Round values so you can interpret to the nearest person Population of world 1804 121927 :591-1959 1974 671987 1999 ! 2011 (b) [5 points] Iif this model were accurate, then what exactly would happen to the population of the world as the years go by in the future? Do you think this moders end-behavior is an accurate predictor for the actual population of the world in the future? Explain (c) [5 points) According to this model what is the population of the world today? Look online to find the estimated actual population today a 2024 and then compare the actual value with the model's predicted value. Would you consider this model to be a good predictor for today's population? Explain. (d) (4 points] According to this model, when will the world population reach 10 billion people? Answer with a complete sentence, and clearly identify where to find your solution in Excel. (e) [6 points] Find the formula for the derivative function, P *(t). Clearly show your formula in your paper. Add a column to your table in Excel that finds the derivative values for each of the given years in the table. Write a complete sentence to interpret the real-world meaning of the derivative value in the year 2011. (f) 13 points] Create a graph of Plt) and also create a graph of P' (t) in Excel. Add clear labels to the axis of both graphs including units. (e) [5 points) According to the model, in what year is the world's population growing at the fastest rate? Explain how you can see this point on the graph of Plt), and also explain how you can see this point on the graph of P '(t). Estimate the rate of growth in that year when it is growing fastest. SAVE AND UPLOAD YOUR EXCEL FILE TO THE DROPBOX IN BLACKBOARD
