While the Goal Seek feature is interesting and I thank you for bringing it up, I don't think it answers my problem.
I'm attempting to make a predictive model, so I'm looking for a method to determine the best X and Y value to fit the data set. So, while X and Y certainly change from record to record, I want to determine the best singular X and Y values to fit the data set at large. So, the answer to your question of how I'm determining the X and Y is that I don't know! That's why I'm posting here -- to come up with a method of determining a proper X and Y in a non-linear equation. Thanks again for your help! On Nov 24, 10:35 pm, Dilip Pandey <dilipan...@gmail.com> wrote: > Hi Bob, > > I have done something in the attached file. > I believe if the x and y are not fixed at all the time, then we can > use Goal Seek feature of Excel to obtain the desired results. > Question:- How are you determining X and Y when you already have As and Bs. > > Best Regards, > DILIPandey > > On 11/23/10, Bob <bobwo...@gmail.com> wrote: > > > > > > > > > > > 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 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 > > Analysis.xls > 22KViewDownload -- ---------------------------------------------------------------------------------- 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
