stats

Documentation

Overview

Package stats provides aggregate functions for statistics.

Provided functions:

• stddev_pop: population standard deviation
• stddev_samp: sample standard deviation
• var_pop: population variance
• var_samp: sample variance
• covar_pop: population covariance
• covar_samp: sample covariance
• corr: correlation coefficient
• regr_r2: correlation coefficient squared
• regr_avgx: average of the independent variable
• regr_avgy: average of the dependent variable
• regr_sxx: sum of the squares of the independent variable
• regr_syy: sum of the squares of the dependent variable
• regr_sxy: sum of the products of each pair of variables
• regr_count: count non-null pairs of variables
• regr_slope: slope of the least-squares-fit linear equation
• regr_intercept: y-intercept of the least-squares-fit linear equation
• regr_json: all regr stats in a JSON object

These join the Built-in Aggregate Functions:

• count: count rows/values
• sum: sum values
• avg: average value
• min: minimum value
• max: maximum value

See: ANSI SQL Aggregate Functions

Index

• func Register(db *sqlite3.Conn)

Functions

func Register

func Register(db *sqlite3.Conn)

Register registers statistics functions.