Does anybody know how to plot any equation within a excel chat? and also to
calculate the value of R or R2?

thanks alot.

The question is how to add trend lineor curve based on an equation in a
scatter-points plot.

Thanks.

Chad



"Chad Yun" wrote:

Does anybody know how to plot any equation within a excel chat? and also to
calculate the value of R or R2?

thanks alot.

If you have an equation you wish to plot:

http://peltiertech.com/Excel/ChartsH...tEquation.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" wrote in message
...
The question is how to add trend lineor curve based on an equation in a
scatter-points plot.

Thanks.

Chad



"Chad Yun" wrote:

Does anybody know how to plot any equation within a excel chat? and also
to
calculate the value of R or R2?

thanks alot.

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" wrote:

If you have an equation you wish to plot:

http://peltiertech.com/Excel/ChartsH...tEquation.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" wrote in message
...
The question is how to add trend lineor curve based on an equation in a
scatter-points plot.

Thanks.

Chad



"Chad Yun" wrote:

Does anybody know how to plot any equation within a excel chat? and also
to
calculate the value of R or R2?

thanks alot.

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" wrote in message
...
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" wrote:

If you have an equation you wish to plot:

http://peltiertech.com/Excel/ChartsH...tEquation.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" wrote in message
...
The question is how to add trend lineor curve based on an equation in a
scatter-points plot.

Thanks.

Chad



"Chad Yun" wrote:

Does anybody know how to plot any equation within a excel chat? and
also
to
calculate the value of R or R2?

thanks alot.