I see the equation used on the chart, but is there an actual place where I could find the output, in addition to the line on the graph? Also, can't remember what E is?
Hi Rob, This site shows you how to replicate the same equation in the spreadsheet. http://spreadsheetpage.com/index.php/tip/chart_trendline_formulas/ E is Exponential notation and you can find plenty of info on that with a google search. (also scientific notation) HTH Martin "Rob" wrote in message news:53B331F4-3847-4295-8C2D-D2147240F2D6@microsoft.com... >I see the equation used on the chart, but is there an actual place where I > could find the output, in addition to the line on the graph? > > Also, can't remember what E is?
For both on how to duplicate the analysis in a worksheet and on how to copy the graph equation into the worksheet see Trendline Coefficients and Regression Analysis http://www.tushar-mehta.com/publish_train/data_analysis/16.htm On Wed, 27 Aug 2008 06:34:00 -0700, Rob wrote: I see the equation used on the chart, but is there an actual place where I could find the output, in addition to the line on the graph? Also, can't remember what E is? Regards, Tushar Mehta Microsoft MVP Excel 2000-2008 www.tushar-mehta.com Tutorials and add-ins for Excel, PowerPoint, and other products
