Using a Microsoft Excel spreadsheet, I want to able able to construct a graph for any function y = f (x). This can be done by generating a table of values with the x values in one colum and the y avlues in another.

The function I want to explore is

First I want to set up the spreadsheet.

x	y = x^2 + 5x + 6
1	12
2	20
3	30
4	42
5	56
6	72
7	90
8	110
9	132
10	156
11	182
12	210
13	240
14	272
15	306
16	342
17	380

It becomes easier to set up the spreadsheet if you know the short cuts to take like autofill and cut and paste.

Then we will go into the graphing mode and select a x-y scatterplot.

Return to my home page