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

Related Post

• 5 Reasons to use SmartArt
• How to protect your Excel sheet
• Mengenal Watermark
• Cara Menggunakan "Goal Seek" di Excel
• Islamic finance in the aftermath of global crisis

Related Websites

• Caddie Sense By Michael Carrick and Steve Duno
• Google Ad Auction and Quality Score
• What is the relationship between the cyclical unemployment rate and the natural rate of unemployment?
• Twilight (the movie)
• Using the data form

Tags: Column, Correlation, Data Analysis, Database, microsoft excel, Row, Spreadsheet, 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.