By: Carly Cantrell
Can you construct a graph of any function y = f(x) by generating a table of values with the x values in one column and the y values in another? OH YEAH!
The run-down on making excellent graphs:
Creating the domain and range:
1. In the first column-first row, A1, write x. In the second column-first row, B2, type y.
2. The ÒxÓ column becomes the domain of the function. To quickly generate the domain, enter the first number in A2 and the second number in A3. Then highlight the two cells and once you get the black cross you can pull down to fill as many entries as you desire.
3. The ÒyÓ column becomes the outputs.
4. To enter the desired function, click B2. Then Ò= f(x)Ó
5. NOTICE where an ÔxÕ variable would go you must type A2.
6. Then you can drag the B2 cell down to however many entries there are.
Now you have all the data for y = f(x).
To make the actual graph:
1. Highlight all the data
2. Insert ˆ Chart ˆ Scatter ˆ Smooth Lined
Here are some examples of functions and their graphs made in excel:
y = 2x
Excel produced a linear graph with a slope of 2 just as it should have.
y = 3x + 2
Excel produced the appropriate linear graph with a slope of 3 and a y-intercept at 2.
y = x2
Excel produced the correct quadratic function.
y = x2
y = x3
y = sin(x)
Excel is even capable of determining and graphing trigonometry functions.