ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Standard functions / Numeric values functions / Statistical functions
  • 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/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
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> [, <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>: Character string
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 get more details on the error, use ErrorInfo 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
Business / UI classification: Neutral code
Component: wd290mat.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 06/22/2023

Send a report | Local help