The population after 300 years is 547 people, and the graph is distinctly curved upwards, which means the sequence is diverging.Sometimes you need to extend a sequence on spreadsheet to see the pattern of the sequence.
Does the graph still look the same as it did before? Example – Recursive and Explicit Formulas & Graphs Example – Recursive and Explicit Formulas & GraphsĮxample – Recursive and Explicit Formulas & GraphsĮxpand the spreadsheet from the previous page to determine the expected population in 300 years. The graph appears to be linear (next slide).The explicit formula in cell B3 could be: = 100* 1.12 ^ (A3/20).The recursive formula in B3 could be: = B2 * 1.12.Use the spreadsheet graphing function to draw a graph of the sequence of populations.Write an explicit formula for cell B3.Write a recursive formula for cell B3.The spreadsheet for the first 100 years is shown. NASA scientists have predicted that the population will increase by 12 percent every 20 years. Theory – IntroĪ group of 100 astronauts is sent to Mars to colonize the planet. The amount of medication, caffeine, or alcohol eliminated by our bodies over time follows a predictable pattern.In this lesson, you will solve problems by writing and analyzing sequences on a spreadsheet.The graph shows twosequences that may help Rudydecide whether it's time to thinkabout buying a new car. The depreciation of a car's value over time follows a pattern. For example, if we invest money regularly, the year-end balances may be a geometric sequence. In this lesson, we will study number patterns that occur around us in everyday life. In the previous lesson, a sequence was described as a list of numbers that increase or decrease in size according to a pattern. Solving Sequences SEQ-L2 Objectives:To solve sequence problems using spreadsheets.
0 kommentar(er)
