Quote:
Originally Posted by Rickertsen2
Does anybody know of a program that can take a spreadsheet with numerical data in each column, and find correlations between columns? This is for something scouting related.
|
Going back to statistics, just calculate the r
2-value of the lists of data to find the correlation coefficient.
http://en.wikipedia.org/wiki/Pearson...on_coefficient
You can do this in Excel, and you can also compute it on TI-83+/84 graphing calculators, by entering one set of values into one list (such as L1) and the other set of values into another list (such as L2), and then using the LinReg(ax+b) L1,L2 function (which can be found in the [STAT] then "Calc" menu) to find the r-values, as well as the a and b values of the line of best fit for the data.
Since the r
2-value explains the amount of the variance in the data, a perfect correlation of the two lists of data would have a r
2-value of 1.0, and a r
2-value of 0.228 would indicate the 22.8% of the variance of the latter set of data can be explained by the first set of data. The range of the r
2-value is from 0 to 1.
If you want to find whether or not the data is positively or negatively correlated, use the plain r-value. These values will range from -1 to 1, depending on the correlation. (-1 = perfect negative correlation; 0 = no correlation; 1 = perfect positive correlation)