This analysis tool and its formulas measure the relationship between two data sets that are scaled to be independent of the unit of measurement. The population correlation calculation returns the covariance of two data sets divided by the product of their standard deviations. You can use the Correlation tool to determine whether two ranges of data move together — that is, whether large values of one set are associated with large values of the other (positive correlation), whether small values of one set are associated with large values of the other (negative correlation), or whether values in both sets are unrelated (correlation near zero).
Syntax
Visual Basic (Usage) |
Copy Code |
Dim instance As Statistics
Dim firstInputSeriesName As String
Dim secondInputSeriesName As String
Dim value As Double
value = instance.Correlation(firstInputSeriesName, secondInputSeriesName)
|
Parameters
- firstInputSeriesName
- First Input Series Name
- secondInputSeriesName
- Second Input Series Name
Return Value
Returns Correlation
Requirements
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
See Also