Aug 30, 2010 #1 Lan123 Civil/Environmental Aug 27, 2010 155 0 0 CA Is there a way to directly import the trendline equation to an excel cell?
Aug 30, 2010 #2 MintJulep Mechanical Jun 12, 2003 9,806 1 38 JP 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,201 0 36 AU 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 0 0 US 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 0 0 US 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 0 0 US 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 0 0 US 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 0 0 CA 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