Hi Richard: Uh, ok. What would be the correct weighting in this instance? (I've actually worked with such power laws before -- e.g., for caches hits/misses.) At 08:24 AM 9/23/2018, Richard Howard wrote:
If the physics of the problem leads one to suspect a power law (or exponential), it is tempting to fit a straight line on a log-log (or log-linear) plot in Excel.
This does not weight all points (and their uncertainties) properly.
Definitely need a warning.
--R
On Sun, Sep 23, 2018 at 10:34 AM Henry Baker <hbaker1@pipeline.com> wrote:
The following xkcd comic (#2048) is funny, but it brings up a good point: are there any good methods for deciding when a particular curve fits a particular set of data points?
Should statistics & spreadsheet programs utilize such a method to warn users that the fit they've chosen isn't very good?
I've thought of somehow using color along the curve to indicate where the fit is good (perhaps "green") and portions along the curve where the fit isn't so good (perhaps "red"). A *spline* curve could also indicate its tension by means of color, for example. (Of course, none of this is going to help those who are color blind!)