In Excel 2007 go to Office button Excel options Formulas Iteration area. Create a recursive formula by stating the first term and then stating the formula to be the common ratio times the. A n 3 2 n 1 a ngreenE 3maroonC 2 n-1 an 3 2n 1.
Fx 2 4 which has a seed value of f3 9.
Determine if the sequence is geometric Do you multiply or divide the same amount from one term to the next 2. Enabling iterative calculations will bring up two additional inputs in the same menu. Through recursive formulas we can solve many mathematical problems related to geometric sequences. In Excel 2007 go to Office button Excel options Formulas Iteration area.