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 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 > -- 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
Analysis.xls
Description: MS-Excel spreadsheet
