Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

plot equation in Excel

2 views
Skip to first unread message

Yun@discussions.microsoft.com Chad Yun

unread,
Oct 9, 2007, 10:09:01 AM10/9/07
to
Does anybody know how to plot any equation within a excel chat? and also to
calculate the value of R or R2?

thanks alot.

Chad Yun

unread,
Oct 9, 2007, 11:05:00 AM10/9/07
to
The question is how to add trend lineor curve based on an equation in a
scatter-points plot.

Thanks.

Chad

Jon Peltier

unread,
Oct 9, 2007, 2:36:49 PM10/9/07
to
If you have an equation you wish to plot:

http://peltiertech.com/Excel/ChartsHowTo/PlotEquation.html

You can calculate slope, intercept, and correlation coefficient from
worksheet data using SLOPE, INTERCEPT, and CORREL worksheet functions, or
compute more statistics using LINEST.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Chad Yun" <Cha...@discussions.microsoft.com> wrote in message
news:B93F281A-8D6A-41BD...@microsoft.com...

Chad Yun

unread,
Oct 9, 2007, 2:59:02 PM10/9/07
to
Thank you firstly.

My equation likes following format:

aX^2+bXY+cY^2+D=0

Do you have some idea to plot it in an excel chart?

Thanks

Jon Peltier

unread,
Oct 9, 2007, 6:22:53 PM10/9/07
to
You have to be able to derive X and Y pairs from the equation, then plot
these pairs. A mathematician might recognize the general form of your
equation as being a particular shape, which would help you figure out where
to start populating your data range with numbers.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Chad Yun" <Cha...@discussions.microsoft.com> wrote in message

news:1A107E4C-FD2F-40EA...@microsoft.com...

0 new messages