PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • Calculating the coefficient of correlation
  • Number of elements found in the matrix
  • Managing the errors
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
StatCorrelation (Function)
In french: StatCorrelation
Calculates the coefficient of correlation between two series of values.
// Calculate the coefficient of correlation between row 1 and row 2 of a matrix
ResCorrelationCoef = StatCorrelation("MyMatrix", 1, 2, False)
Syntax
<Result> = StatCorrelation(<Matrix Name> [, <1st Row/1st Column> [, <2nd Row/2nd Column> [, <Row/Column>]]])
<Result>: Real
  • Coefficient of correlation that exist between the two series of values,
  • 0 if the coefficient of correlation is null.
<Matrix Name>: Character string (with quotes)
Name of the matrix containing the data, defined by MatCreate.
<1st Row/1st Column>: Optional integer
1st row or 1st column containing the data (1 by default).
<2nd Row/2nd Column>: Optional integer
2nd row or 2nd column containing the data (2 by default).
<Row/Column>: Optional boolean
  • True (by default) if the series of values correspond to matrix columns,
  • False if the series of values correspond to matrix rows.
Remarks

Calculating the coefficient of correlation

StatCorrelation("MyMatrix", 1, 3, False) returns 0,997054.
StatCorrelation("MyMatrix", 1, 3, False) returns 1.
StatCorrelation("MyMatrix", 1, 3, False) returns 0.

Number of elements found in the matrix

The number of elements found in the matrix is taken as reference. This number of elements corresponds to:
  • the number of matrix rows, returned by MatNbLine.
  • the number of matrix columns, returned by MatNbColumn.
If the series contain less elements than the matrix, the missing values are automatically filled with 0. These values are taken into account during the calculations.

Managing the errors

Caution: StatCorrelation returns no error code. To find out whether errors have been generated when calculating the coefficient of correlation, use StatError. To find out the error details, use ErrorInfo associated with the errMessage constant.
Related Examples:
The Stat functions Unit examples (WINDEV): The Stat functions
[ + ] Using the main functions for statistical calculations (using matrices):
- Calculate a sum of values
- Calculate a mean of values
- Find the minimum value in a set of values
- Find the maximum value in a set of values
The Stat functions Unit examples (WINDEV Mobile): The Stat functions
[ + ] Using the main functions for statistical calculations (using matrices):
- Calculate a sum of values
- Calculate a mean of values
- Find the minimum value in a set of values
- Find the maximum value in a set of values
Component : wd240mat.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment