View Question
Q: Microsoft Excel Trendline Equation is incorrect. Just plain wrong. ( No Answer,   1 Comment )
 Question
 Subject: Microsoft Excel Trendline Equation is incorrect. Just plain wrong. Category: Computers > Software Asked by: mrbluesummers-ga List Price: \$5.00 Posted: 25 Sep 2006 19:10 PDT Expires: 26 Sep 2006 10:52 PDT Question ID: 768410
 Howdy. The fact is I'm running a regression between two sets of data: Size and Decay. From my data points, you can see that the larger the object, the "lower" the decay is. I've punched the numbers into excel and it's given me a nice looking trendline (POWER), but it refuses to give me a decent equation. What I've tried: I tried typing various mutations of the equation (parenthases, different methods of inputting it into a cell, etc) I've tried transforming the function, but I can't do too much of that by hand. You can see the Excel file at http://www.mediamax.com/BlueSummers/Hosted/BlueCherryComputations.xls In case the link goes down; here's the data... EQN: 14.090504x^-1.06355736 DATA: Size Decay Power(WRONG) 6.18014 18 2.030740615 12.3603 5.95 0.971607902 24.7206 3.93 0.464866627 49.4411 2.97 0.222416311 98.8823 2.4 0.106415159 197.765 1.97 0.050914314 395.529 1.73 0.024360062 791.058 1.52 0.011655092 1582.12 1.36 0.005576374 3164.23 1.23 0.00266803 6328.47 1.14 0.001276519 12656.9 1.03 0.000610754 25313.9 0.95 0.000292214 50627.7 0.88 0.000139811 101255 0.82 6.68927E-05 202511 0.785 3.20047E-05 Request for Question Clarification by efn-ga on 25 Sep 2006 23:19 PDT What is your question? Are you looking for an equation, or a way to get an equation out of Excel, or something else? Have you tried the LOGEST function?