http://www.perlmonks.org?node_id=134635


in reply to Re: Seeking abnormalities in data sets.
in thread Seeking abnormalities in data sets.

I would caution against using Excel and a correlation coefficent. The correlation coeffecient (often referred to as r^2) is relatively insensitive to variations in the data. A better measure of goodness of fit is chi squared, which you can calculate when you do a least squares fit. Check out Numerical Recipes chapter 15 for details on doing the calculations.

Scott