> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Math Aggregate Functions

<AccordionGroup>
  <Accordion title="APPROX_COUNT_DISTINCT(expr)" id="approx_count_distinct-expr" defaultOpen>
    The approximate number of distinct values of `expr`; this is faster to calculate than `COUNT_DISTINCT` but is only an approximation
  </Accordion>

  <Accordion title="APPROX_MEDIAN(expr)" id="approx_median-expr" defaultOpen>
    The approximate median of `expr`; the result should be within about *2%* of the true median value. This is equivalent to issuing
    `APPROX_PERCENTILE(expr, 50)`.
  </Accordion>

  <Accordion title="APPROX_PERCENTILE(expr, p)" id="approx_percentile-expr-p" defaultOpen>
    The approximate *pth* percentile of `expr`; `p` should be a value between *0.0* and *100.0*. `APPROX_PERCENTILE(expr, 50)` will return
    the approximate median of `expr`.
  </Accordion>

  <Accordion title="AVG(expr)" id="avg-expr" defaultOpen>
    Average of the values of `expr`
  </Accordion>

  <Accordion title="CORR(expr1, expr2)" id="corr-expr1-expr2" defaultOpen>
    Correlation coefficient of the values of `expr1` and `expr2`
  </Accordion>

  <Accordion title="CORRELATION(expr1, expr2)" id="correlation-expr1-expr2" defaultOpen>
    Alias for `CORR`
  </Accordion>

  <Accordion title="CORRCOEF(expr1, expr2)" id="corrcoef-expr1-expr2" defaultOpen>
    Alias for `CORR`
  </Accordion>

  <Accordion title="COUNT(expr)" id="count-expr" defaultOpen>
    Count of non-null values of `expr`; use `*` to count all values within an aggregation group or over an entire table
  </Accordion>

  <Accordion title="COUNT_DISTINCT(expr)" id="count_distinct-expr" defaultOpen>
    Count of the distinct values of `expr`
  </Accordion>

  <Accordion title="COV(expr1, expr2)" id="cov-expr1-expr2" defaultOpen>
    Alias for `COVAR_POP`
  </Accordion>

  <Accordion title="COVAR(expr1, expr2)" id="covar-expr1-expr2" defaultOpen>
    Alias for `COVAR_POP`
  </Accordion>

  <Accordion title="COVARIANCE(expr1, expr2)" id="covariance-expr1-expr2" defaultOpen>
    Alias for `COVAR_POP`
  </Accordion>

  <Accordion title="COVAR_POP(expr1, expr2)" id="covar_pop-expr1-expr2" defaultOpen>
    Population covariance of the values of `expr1` and `expr2`
  </Accordion>

  <Accordion title="COVAR_SAMP(expr1, expr2)" id="covar_samp-expr1-expr2" defaultOpen>
    Sample covariance of the values of `expr1` and `expr2`
  </Accordion>

  <Accordion title="KURT(expr)" id="kurt-expr" defaultOpen>
    Alias for `KURTOSIS_POP`
  </Accordion>

  <Accordion title="KURTOSIS(expr)" id="kurtosis-expr" defaultOpen>
    Alias for `KURTOSIS_POP`
  </Accordion>

  <Accordion title="KURTOSIS_POP(expr)" id="kurtosis_pop-expr" defaultOpen>
    Population kurtosis of the values of `expr`
  </Accordion>

  <Accordion title="KURTOSIS_SAMP(expr)" id="kurtosis_samp-expr" defaultOpen>
    Sample kurtosis of the values of `expr`
  </Accordion>

  <Accordion title="KURT_POP(expr)" id="kurt_pop-expr" defaultOpen>
    Alias for `KURTOSIS_POP`
  </Accordion>

  <Accordion title="KURT_SAMP(expr)" id="kurt_samp-expr" defaultOpen>
    Alias for `KURTOSIS_SAMP`
  </Accordion>

  <Accordion title="MAX(expr)" id="max-expr" defaultOpen>
    Maximum of the values of `expr`
  </Accordion>

  <Accordion title="MEAN(expr)" id="mean-expr" defaultOpen>
    Alias for `AVG`
  </Accordion>

  <Accordion title="MIN(expr)" id="min-expr" defaultOpen>
    Minimum of the values of `expr`
  </Accordion>

  <Accordion title="PRODUCT(expr)" id="product-expr" defaultOpen>
    Product of the values of `expr`
  </Accordion>

  <Accordion title="REGR_AVGX(y, x)" id="regr_avgx-y-x" defaultOpen>
    Average of the independent variable (`SUM(x)/N`) of the line determined by computing a least-squares-fit linear regression over the given (X, Y)
    pairs
  </Accordion>

  <Accordion title="REGR_AVGY(y, x)" id="regr_avgy-y-x" defaultOpen>
    Average of the dependent variable (`SUM(y)/N`) of the line determined by computing a least-squares-fit linear regression over the given (X, Y)
    pairs
  </Accordion>

  <Accordion title="REGR_COUNT(y, x)" id="regr_count-y-x" defaultOpen>
    Number of input rows used in computing a linear regression, where both expressions are non-null
  </Accordion>

  <Accordion title="REGR_INTERCEPT(y, x)" id="regr_intercept-y-x" defaultOpen>
    Y-intercept of the line determined by computing a least-squares-fit linear regression over the given (X, Y) pairs
  </Accordion>

  <Accordion title="REGR_R2(y, x)" id="regr_r2-y-x" defaultOpen>
    Square of the correlation coefficient, marking how well the least-squares-fit linear regression fit the data set
  </Accordion>

  <Accordion title="REGR_SLOPE(y, x)" id="regr_slope-y-x" defaultOpen>
    Slope of the line determined by computing a least-squares-fit linear regression over the given (X, Y) pairs
  </Accordion>

  <Accordion title="REGR_SXX(y, x)" id="regr_sxx-y-x" defaultOpen>
    "Sum of squares" of the independent variable (`SUM(x^2) - SUM(x)^2/N`) of the line determined by computing a least-squares-fit linear regression
    over the given (X, Y) pairs
  </Accordion>

  <Accordion title="REGR_SXY(y, x)" id="regr_sxy-y-x" defaultOpen>
    "Sum of Products" of independent variable times dependent variable (`SUM(x * y) - SUM(x) * SUM(y)/N`) of the line determined by computing a
    least-squares-fit linear regression over the given (X, Y) pairs
  </Accordion>

  <Accordion title="REGR_SYY(y, x)" id="regr_syy-y-x" defaultOpen>
    "Sum of squares" of the dependent variable (`SUM(y^2) - SUM(y)^2/N`) of the line determined by computing a least-squares-fit linear regression
    over the given (X, Y) pairs
  </Accordion>

  <Accordion title="SKEW(expr)" id="skew-expr" defaultOpen>
    Alias for `SKEWNESS_POP`
  </Accordion>

  <Accordion title="SKEWNESS(expr)" id="skewness-expr" defaultOpen>
    Alias for `SKEWNESS_POP`
  </Accordion>

  <Accordion title="SKEWNESS_POP(expr)" id="skewness_pop-expr" defaultOpen>
    Population skew of the values of `expr`
  </Accordion>

  <Accordion title="SKEWNESS_SAMP(expr)" id="skewness_samp-expr" defaultOpen>
    Sample skew of the values of `expr`
  </Accordion>

  <Accordion title="SKEW_POP(expr)" id="skew_pop-expr" defaultOpen>
    Alias for `SKEWNESS_POP`
  </Accordion>

  <Accordion title="SKEW_SAMP(expr)" id="skew_samp-expr" defaultOpen>
    Alias for `SKEWNESS_SAMP`
  </Accordion>

  <Accordion title="STDDEV(expr)" id="stddev-expr" defaultOpen>
    Population standard deviation over values of `expr` (i.e. the denominator is *N*)
  </Accordion>

  <Accordion title="STDDEV_POP(expr)" id="stddev_pop-expr" defaultOpen>
    Population standard deviation over values of `expr` (i.e. the denominator is *N*)
  </Accordion>

  <Accordion title="STDDEV_SAMP(expr)" id="stddev_samp-expr" defaultOpen>
    Sample standard deviation over values of `expr` (i.e. the denominator is *N-1*)
  </Accordion>

  <Accordion title="SUM(expr)" id="sum-expr" defaultOpen>
    Sum of the values of `expr`
  </Accordion>

  <Accordion title="VAR(expr)" id="var-expr" defaultOpen>
    Population variance over values of `expr` (i.e. the denominator is *N*)
  </Accordion>

  <Accordion title="VAR_POP(expr)" id="var_pop-expr" defaultOpen>
    Population variance over values of `expr` (i.e. the denominator is *N*)
  </Accordion>

  <Accordion title="VAR_SAMP(expr)" id="var_samp-expr" defaultOpen>
    Sample variance over values of `expr` (i.e. the denominator is *N-1*)
  </Accordion>

  <Accordion title="VARIANCE(expr)" id="variance-expr" defaultOpen>
    Alias for `VAR`
  </Accordion>

  <Accordion title="VARIANCE_POP(expr)" id="variance_pop-expr" defaultOpen>
    Alias for `VAR_POP`
  </Accordion>

  <Accordion title="VARIANCE_SAMP(expr)" id="variance_samp-expr" defaultOpen>
    Alias for `VAR_SAMP`
  </Accordion>
</AccordionGroup>