Graphing a function

A

Abe

I need to know how to graph a polynomial and an exponential function on
excel. Specifically how to enter the equation so graph wizard can compute it.
 
E

Ed Warren

Actually Excel, Access, etc. are built to display discrete data not
continious data as you want to plot. You might find something elsewhere,
but I would have to go to some type of math program 'mathematica',
sigmaplot, 'mathcad' to accomplish this. Otherwise I would have to use one
of the plotting routines from a source like numerical recipes in C to get
there.

If you are going to use excel you will have to decide on a 'step' for x then
build a set of rows with x, x+dx, x+2dx, .... x+ndx and corresponding values
for the y variable, e.g. y= x^2 -2x +1 and then build an xy plot based on
these data. This certainly lies more in the excel world than the access
world.

Best of luck

Ed Warren.
 
Top