![]() ![]() Ignore the R^2 that appears in the chart. So you can mimic the Google chart by entering an intercept value (b) that rounds to 2.207. Given the form of the exponentional trendline equation as y = b*EXP(m*x), for m=0.931 (rounded), b must be 2. Obviously, we want to maximize, not minimize R^2.Īnd there appears to be a typo(!) in your image. And I might add a more-explanatory response later. I might add an image and attach an Excel file later. ![]() Re: ``How do I get an exponential regression that minimizes R^2? Doing the same computation in Google sheets gives y = 2.07e^(0.931x)``
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |