Correlating data to a given curve
Correlating data to a given curve
(OP)
Has Excel a built in function to calculate the level of correlation between a set of data points and a given equation or other set of points?
Since the trendline function for the graphs will already give the correlation coefficient between a given set of data points and a best fit trend line generated by the program for these points.
Is there a way of using a different line to the trendline for the same calculation?
Since the trendline function for the graphs will already give the correlation coefficient between a given set of data points and a best fit trend line generated by the program for these points.
Is there a way of using a different line to the trendline for the same calculation?
RE: Correlating data to a given curve
Good luck...
RE: Correlating data to a given curve
The basic premise is equal weighting of all errors. This may lead to large errors if the data is highly non-linear or if there is a large dynamic range in the data. Linearization prior to fitting may prove to be more useful.
TTFN
RE: Correlating data to a given curve
RE: Correlating data to a given curve
It works in StarOffice anyway, that's all I have access to at the moment.