 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / October 2007plot equation in Excel
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 > 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/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 _______ > The question is how to add trend lineor curve based on an equation in a > scatter-points plot. [quoted text clipped - 8 lines] >> >> 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 > If you have an equation you wish to plot: > [quoted text clipped - 23 lines] > >> > >> 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 _______ > Thank you firstly. > [quoted text clipped - 34 lines] >> >> >> >> thanks alot. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.