Please provide excel functions. Not just answers. 4.4 The Fibonacci numbers are

Question

Please provide excel functions. Not just answers. 4.4 The Fibonacci numbers are an interesting sequence of positive integers where each value is the sum of the previous two values. We begin with (4.3) Each successive value is then obtained from the formula (4.4) 3, 4, 5 F, F i-2 i-1 Create an Excel worksheet containing the first 20 Fibonacci numbers. Test each Fibonacci number to determine if it is odd or even. Place the Fibonacci numbers in column A, and the corresponding odd/even labels in column B.

Explanation / Answer

Formula for fibonacci series A3 = Sum(A1+A2)

Formula to find if the fibonacci series number is even or odd C3 =IF(MOD(A1,2)=0,"Even","Odd")

1 Odd 1 Odd 2 Even 3 Odd 5 Odd 8 Even 13 Odd 21 Odd 34 Even 55 Odd 89 Odd 144 Even 233 Odd 377 Odd 610 Even 987 Odd 1597 Odd 2584 Even 4181 Odd 6765 Odd

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.