Off-topic Talk Where overpaid, underworked S2000 owners waste the worst part of their days before the drive home. This forum is for general chit chat and discussions not covered by the other off-topic forums.

How do you graph a function in Excel?!

Thread Tools
 
Old Feb 15, 2002 | 08:02 AM
  #11  
magician's Avatar
Registered User
 
Joined: Jul 2001
Posts: 6,592
Likes: 0
From: Yorba Linda, CA
Default

Originally posted by mingster


thanks, but what you're saying is that i have to manually insert values for X and Y? can't excel solve that itself?
No. You insert X values and use the formula (solved for Y) for the corresponding Y values.

"Can't Excel solve them itself?" you ask. In a manner of speaking, it can. Put in a column of X values and a column of "guesses" for the Ys. Put in a third column from your function which should equal zero in all cases; e.g., Y + 2X - 3 in your first equation. Put in a fourth column which is the square of the values in the third column. Sum the values in the fourth column. Use Excel's solver (Tools, Solver) to minimize this last value by varying the Ys; this explains why you use the squares because the minimum will occur when they're all zero.

Once the solver has done its thing, the first two columns will have Xs and Ys to plot.

This seems like a lot of work when the algebra to solve a linear equation for Y is so simple, but if algebra should terrify you . . . .

PS I just tried this with your firse equation. I used X values from -10 to 10 in steps of 0.1 (201 values). I put all the Y's as zero. When I tried to run the solver telling it to vary all of the Ys it said I had too many variables. So I only used the first 101 (-10.0 to 0.0), then used the last 100 (0.1 to 10.0). It worked like a charm.
Reply
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
stockae92
Off-topic Talk
7
Dec 15, 2005 08:27 AM
babygrass
Off-topic Talk
9
Jun 24, 2002 07:06 PM
mingster
Off-topic Talk
12
May 24, 2002 09:54 PM
mingster
Off-topic Talk
21
Oct 9, 2001 12:43 PM




All times are GMT -8. The time now is 07:27 PM.