Aug 30, 2010 #1 Lan123 Civil/Environmental Aug 27, 2010 155 Is there a way to directly import the trendline equation to an excel cell?
Aug 30, 2010 #2 M MintJulep Mechanical Jun 12, 2003 10,100 Yes. Use the LINEST() or LOGEST() functions. They are array functions. Upvote 0 Downvote
Aug 30, 2010 #3 IDS Civil/Environmental Jun 1, 2001 3,289 Look up the Linest function. Please ask if you need more help. Doug Jenkins Interactive Design Services http://newtonexcelbach.wordpress.com/ Upvote 0 Downvote
Look up the Linest function. Please ask if you need more help. Doug Jenkins Interactive Design Services http://newtonexcelbach.wordpress.com/
Aug 30, 2010 #4 electricpete Electrical May 4, 2001 16,774 Here is an example of using Linest to develop a polynomial trendline. ===================================== (2B)+(2B)' ? http://files.engineering.com/getfile.aspx?folder=71fc900f-c886-461a-bc49-45ed8424f974&file=TrendlineWithLinest.xls Upvote 0 Downvote
Here is an example of using Linest to develop a polynomial trendline. ===================================== (2B)+(2B)' ?
Aug 30, 2010 #5 electricpete Electrical May 4, 2001 16,774 Also push F9 repeatedly to refresh the signal with new random noise. ===================================== (2B)+(2B)' ? Upvote 0 Downvote
Also push F9 repeatedly to refresh the signal with new random noise. ===================================== (2B)+(2B)' ?
Aug 30, 2010 #6 electricpete Electrical May 4, 2001 16,774 Another example 6th order polynomial. ===================================== (2B)+(2B)' ? http://files.engineering.com/getfile.aspx?folder=7e7fd096-49a7-4d3b-a6f7-2331a409a252&file=TrendlineWithLinest2.xls Upvote 0 Downvote
Aug 31, 2010 #7 Clyde38 Electrical Oct 31, 2003 533 See previous threads: http://www.eng-tips.com/viewthread.cfm?qid=214997&page=1 http://www.eng-tips.com/viewthread.cfm?qid=184726 And http://spreadsheetpage.com/index.php/tip/chart_trendline_formulas/ [link http://www.linkedin.com/in/clydehancock] [/url] Upvote 0 Downvote
See previous threads: http://www.eng-tips.com/viewthread.cfm?qid=214997&page=1 http://www.eng-tips.com/viewthread.cfm?qid=184726 And http://spreadsheetpage.com/index.php/tip/chart_trendline_formulas/ [link http://www.linkedin.com/in/clydehancock] [/url]
Aug 31, 2010 Thread starter #8 Lan123 Civil/Environmental Aug 27, 2010 155 Folks Appreciate all you comments. After reading all and viewing the examples now I know exactly what to do. Thanks Upvote 0 Downvote
Folks Appreciate all you comments. After reading all and viewing the examples now I know exactly what to do. Thanks
![btn_liprofile_blue_80x15.gif" width="80" height="15" border="0" alt="View Clyde's profile on LinkedIn](http://www.linkedin.com/img/webpromo/btn_liprofile_blue_80x15.gif" width="80" height="15" border="0" alt="View Clyde's profile on LinkedIn)