plot equation in Excel

[Guest]

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

thanks alot.

 

[Guest]

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

Thanks.

Chad

 

[Jon Peltier]

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

 

[Guest]

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]

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