![]() While i do agree that the LOGEST will work perfectly fine to give the trending % increase or decrease, it's not right to say an exponential trend line equation will give the same results as a log function.ĭeciding between an exponential trend line and a logarithmic trend line depends on the coefficient of determination (r^2 value, the closer to 1 the better fit for your data). OR an exponential function to an exponential equation would make sense. Using the LOGEST function to compare to the LOGARITHMIC trend line equation is more accurate. ![]() Click the + button on the right side of the chart, click the arrow next to Trendline and then click More Options. I am continually making adjustments to the trend line by adding more data, and don't want to retype out the formula every time. You do realize you are stating that an Exponential Trend line and that Logarithmic function are the same. Trendline This example teaches you how to add a trendline to a chart in Excel. Is there an easy way to apply the trend line formula from a chart to any given X value in Excel -0.000000000008X3 - 0.00000001X2 + 0.0003X - 0.0029. Without explaining the details (but I will if you want), to see how much sales are changing per period, " If you were instead using an exponential trendline (which would almost always be the right choice), then the formula you'd see is ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |