Graphing Data from the investment Chart

When the investment chart is completed, follow these directions to create a graph of the interest and then one of the balance.

TO GRAPH THE INTEREST:

1) Click on C7 and drag down to C23, to highlight the column.

2) Pull down the OPTIONS menu to “Make Chart”.

3) Select “LINE” and click on OK.

4) Answer these questions:
a) The x-axis represents ____________________________________.

b) The y-axis represents ____________________________________.

c) Is the graph a straight line?_________________________________

d) Does the graph represent linear or exponential growth?___________

e) Is the slope of the line constant?_________ Explain why or why not.

________________________________________________________

________________________________________________________


5) Click on the graph so the whole graph is selected. (You will see the small squares on each corner.) Press “DELETE” to eliminate the graph and return to the Investment Chart.

TO GRAPH THE BALANCE:

6) Select the balance column and create a line graph as above. Answer the same questions about the balance graph.

a) _______________________ b) ____________________________

c) _______________________ d) ____________________________

e) ______________________________________________________

________________________________________________________