-
Analytical Functions for Standard Deviation and Variance 4 min
- Feedback
-
Take Course Survey
Analytical Functions for Standard Deviation and Variance
In this short how-to video we provide you with guidance for using our inbuilt Standard Deviation and Variance database functions.
Introduction:
Actian Data Platform, Vector and Actian X all provide inbuilt database functions for Standard Deviation and Variance calculations. Aggregate functions return a single value, calculated from values in a column. They take a set of values as their argument. Aggregate functions are also called set functions.
Course Style:
The video content is a simple to follow step-by-step format for implementing the Standard Deviation and Variance functionality. The functions covered in this video are stddev_pop(), stddev_samp(), var_pop() and var_samp().
Audience:
This video is aimed at Administrators, Developers and Analysts who have responsibility for analysing the data contained within the production database.
Prerequisites:
- Access to the correct level of Actian Database software as described in the training.
Supplementary Resources:
|
Product Documentation:
|
|
|
Actian Community:
|
|
|
Software Download:
|