Colour by Numbers: Solving Algebraic Equations Without Algebra
A series of Excel models is described. They allow solution of f(x) = 0 by examining change of sign of function values. The function is graphed and change of sign easily detected by a change of colour. Prominent Excel features used are Names, Chart Wizard and Conditional Formatting. Several sample Ex...
| Main Author: | |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
McMaster University
|
| Series: | Spreadsheets in Education |
| Online Access: | http://sie.scholasticahq.com/article/4532-colour-by-numbers-solving-algebraic-equations-without-algebra.pdf |