Reference material for COVAR_SAMP
NULL
- that input row is ignored.
Use this when analyzing a sample rather than an entire population. For covariance of population see COVAR_POP.
Parameter | Description | Supported input types |
---|---|---|
<expr1> | First numeric expression to use for covariance computation. | DOUBLE PRECISION |
<expr2> | Second numeric expression to use for covariance computation. | DOUBLE PRECISION |
COVAR_SAMP
returns a result of type DOUBLE PRECISION
.
PlayStats
table from the sample UltraFast
database.
Example
The CurrentLevel
and CurrentScore
variables are highly correlated
473291.6614849927
Example
But CurrentLevel
and CurrentScore
variables are not correlated at all
0.040317002824098884