Mathematical Statistical Function

Recent Pages

Mathematical Statistical Function

最終更新日:2024-03-20 11:47:49

This document introduces the basic syntax and examples of mathematical statistical functions.
Basic syntax
Function
Description
corr(key1, key2) 
Returns the correlation coefficient of two columns. The calculation result range is [0,1].
covar_pop(key1, key2) 
Returns the population covariance of two columns.
covar_samp(key1, key2) 
Returns the sample covariance of two columns.
regr_intercept(key1, key2)
Returns linear regression intercept of input values. key1 is the dependent value. key2 is the independent value.
regr_slope(key1, key2) 
Returns linear regression slope of input values. key1 is the dependent value. key2 is the independent value.
stddev(key)    
Returns the sample standard deviation of the key column. This function is equivalent to the stddev_samp function.
stddev_samp(key)
Returns the sample standard deviation of the key column.
stddev_pop(key) 
Returns the population standard deviation of the key column.
variance(key) 
Returns the sample variance of the key column. This function is equivalent to the var_samp function.
var_samp(key) 
Returns the sample variance of the key column.
var_pop(key)   
Returns the population variance of the key column.
Example
Returns the correlation between data in the timeCost (response time) and SamplingRate (sampling rate) columns:
* | select corr(timeCost,SamplingRate)
﻿

お問い合わせ

カスタマーサービスをご提供できるため、ぜひお気軽にお問い合わせくださいませ。

テクニカルサポート

さらにサポートが必要な場合は、サポートチケットを送信して弊社サポートチームにお問い合わせください。24時間365日のサポートをご提供します。

電話サポート（24 時間365日対応）

tencent cloud

Recent Pages

Mathematical Statistical Function

Basic syntax

Example

この記事はお役に立ちましたか？

この記事はお役に立ちましたか？

Function	Description
corr(key1, key2)	Returns the correlation coefficient of two columns. The calculation result range is [0,1].
covar_pop(key1, key2)	Returns the population covariance of two columns.
covar_samp(key1, key2)	Returns the sample covariance of two columns.
regr_intercept(key1, key2)	Returns linear regression intercept of input values. `key1` is the dependent value. `key2` is the independent value.
regr_slope(key1, key2)	Returns linear regression slope of input values. `key1` is the dependent value. `key2` is the independent value.
stddev(key)	Returns the sample standard deviation of the `key` column. This function is equivalent to the `stddev_samp` function.
stddev_samp(key)	Returns the sample standard deviation of the `key` column.
stddev_pop(key)	Returns the population standard deviation of the `key` column.
variance(key)	Returns the sample variance of the `key` column. This function is equivalent to the `var_samp` function.
var_samp(key)	Returns the sample variance of the `key` column.
var_pop(key)	Returns the population variance of the `key` column.

tencent cloud

サインアップ

ログイン

Recent Pages

Mathematical Statistical Function

Basic syntax

Example

この記事はお役に立ちましたか？

この記事はお役に立ちましたか？