iip albanjary

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

Incoming search terms :

• correlation test in excel
• how to run correlation in excel
• how to run a correlation in excel
• testing correlation in excel
• blank
• excel test for correlation
• correlation testing in excel
• spreadsheet for testing correlation
• snow boarding
• how to run correlation on excel

Tags: Column, Correlation, Data Analysis, Database, microsoft excel, Row, Spreadsheet office, Statistic

This entry was posted on Friday, November 28th, 2008 at 5:03 am and is filed under Spreadsheet tips. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.