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.