Use Correlation Test of MS Excel

November 28th, 2008 | Posted by iip in Spreadsheet tips - (0 Comments)

Data Analysis of Excel has a function to determine the relationship between two variables.  Result of this function is coefficient of correlation which shows the strengh or weakness of a relationship. The value of coefficient ranges between -1.0 to +1.0

How to run the correlation test?
(more…)