Assignment 12

Heather J. Robinson

EMAT 6680

Fall Semester 2003

An Excel Spreadsheet is a very easy way to generate a table of values of graphing functions. The spreadsheet is an efficient way to allow students to focus on the behavior of a function rather than generating the values that create that behavior.

Here is a spreadsheet that generates values that graph f(x) = 3x + 1.

x	f(x)= 3x + 1
-12	-35
-9	-26
-6	-17
-3	-8
0	1
3	10
6	19
9	28
12	37

Excel will graph a discrete linear function…

Which could be used to discuss slope, y-intercept, interpolation, and extrapolation.

Here is an example of a discrete parabolic function created by generating values in Excel.