Use Correlation Test of MS Excel

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?

1. Prepare two data sets to be tested (eg. income and sales). The data could be either in two rows or two columns.  Place the header label in first row if it in column.
2. Select Data Analysis at Data tab of the Ribbon
3. Excel will provide a correlation wizard.  Put the range of selected cells at the Input rnge.
4. At the Output options, choose where the ouput test will be displayed.
5. Press OK

how to run a correlation in excel, how to run correlation in excel, correlation test excel, how to run correlations in excel, how to run correlation in excel 2007, correlation test in excel, excel correlation test, run correlation in excel, testing correlation in excel