Good afternoon, I have a fairly large data set (roughly 7,000 samples) on which I would like to run some nonlinear regression analysis.
I'm fully capable of using the Data Analysis Toolpak and running the linear analysis there, but unless I'm totally missing it, there doesn't seem to be a method for running nonlinear analysis. To be clear, what I want to do is take this data, which is in three columns, and essentially put together an equation to represent Ax + By = C. However, this data does not seem to be all that well represented by a linear equation, and I believe it would be more precise to use an exponential or logarithmic model along the lines of A^x + B^y = C. Can anyone help? Thank you! -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
