The Search/Analytics feature of Log Service allows you to use mathematical statistic functions to analyze logs. The following table describes the supported mathematical statistic functions.

Statement Description Example
corr(y, x) Returns the correlation coefficient of input values. The result ranges from 0 to 1. latency>100| select corr(latency,request_size)
covar_pop(y, x) Returns the population covariance of input values. latency>100| select covar_pop(request_size,latency)
covar_samp(y, x) Returns the sample covariance of input values. latency>100| select covar_samp(request_size,latency)
regr_intercept(y, x) Returns the linear regression intercept of input values. y is the dependent value. x is the independent value. latency>100| select regr_intercept(request_size,latency)
regr_slope(y,x) Returns the linear regression slope of input values. y is the dependent value. x is the independent value. latency>100| select regr_slope(request_size,latency)
stddev(x) or stddev_samp(x) Returns the sample standard deviation of all input values. latency>100| select stddev(latency)
stddev_pop(x) Returns the population standard deviation of all input values. latency>100| select stddev_pop(latency)
variance(x) or var_samp(x) Returns the sample variance of all input values. latency>100| select variance(latency)
var_pop(x) Returns the population variance of all input values. latency>100| select variance(latency)