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...

Full description

Bibliographic Details
Main Author: Stephen J. Sugden
Format: Article
Language:English
Published: Bond University
Series:Spreadsheets in Education
Online Access:http://sie.scholasticahq.com/article/4532-colour-by-numbers-solving-algebraic-equations-without-algebra.pdf