Hello, Thanks for your response!
Here's a random sampling of the data: 169 140 10 164 197 19 50 339 31 73 326 19 204 238 34 143 201 18 59 74 3 296 216 20 31 121 9 108 148 7 139 317 24 41 263 14 233 286 35 221 121 17 111 304 25 39 325 13 201 211 37 474 102 72 28 158 7 268 230 34 246 202 19 199 208 50 144 447 48 358 138 61 300 8 27 301 255 37 197 169 24 236 205 54 28 329 14 150 159 23 244 298 52 74 108 6 202 159 37 259 127 23 19 350 16 189 131 29 40 183 17 369 255 62 122 236 3 310 201 51 95 162 10 335 162 37 91 447 55 171 179 21 110 215 9 87 242 17 328 219 49 225 182 21 245 243 42 The data in the first two columns (A and B for purposes explained below) are the independent variables, with the third column being the dependent (C) Currently, the equation I'm using is: -10.5348929531027+0.113896884380505*A+0.0893951738657916*B = C As mentioned, this does not fit the data particularly well. It predicts too low a result when A and B are small, and too high a result when A and B are large. For this reason, I believe a logarithmic curve will best represent the data ... but other suggestions are also certainly welcome. Hope you, or someone, can help! Thank you. On Nov 23, 9:13 am, Dilip Pandey <dilipan...@gmail.com> wrote: > Hi Bob, > > This seems to be interesting to me. Would you mind providing some > sample data with the the indicative result which you want to obtain > through Excel. > > Best Regards, > DILIPandey > > On 11/23/10, Bob <bobwo...@gmail.com> wrote: > > > > > > > > > > > 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 athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://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&;... > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY > MBA-HR,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India -- ---------------------------------------------------------------------------------- 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
