Open In App

Var() and VarP() Function in MS Access

Improve
Improve
Like Article
Like
Save
Share
Report

1. Var() Function :
Var() Function in MS Access is used to estimate the variance for a population sample.

Syntax :

Var(expr)

Parameter : This method accept one parameter as mentioned above and described below :

  • expr : It represents a string expression identifying the field that contains the numeric data which we want to evaluate or an expression that performs a calculation using the data in that field. Operands in expr can include the name of a table field, a constant, or a function.

Returns : It calculates variance for a population sample.

Note : If the underlying query contains fewer than two records or no records then it returns a Null value which indicates that a variance cannot be calculated.

Table – ProductDetails

Product_Id Product_Price
100000 90
200001 81
298700 34
345632 84

Example-1 :
The variance of the product price.

SELECT Var(Product_Price) AS Var_Value 
FROM ProcuctDetails;

Output :

Var_Value
664.25

Example-2 :
Variance for only one record.

SELECT Var(100) AS Var_Value ;

Output :

Var_Value

So, we can see it can not be calculated.


2. VarP () Function :
VarP () Function in MS Access is used to estimate the variance for a population. The main difference between The VarP () function and VarP() Function is VarP evaluates a population, and the Var function evaluates a population sample.

Syntax :

VarP(expr)

Parameter : This method accept one parameter as mentioned above and described below :

  • expr : It represents a string expression identifying the field that contains the numeric data which we want to evaluate or an expression that performs a calculation using the data in that field. Operands in expr can include the name of a table field, a constant, or a function.

Returns : It calculates variance for a population.

Note : If the underlying query contains fewer than two records then it returns a Null value which indicates that a standard deviation cannot be calculated.

Table – Products

P_Id P_Price
1001 55
1005 20
1008 66

Example-1 :

SELECT VarP (P_Price) AS VarP_Value 
FROM Procucts;

Output :

VarP_Value
384.666666666667

Example-2 :

SELECT VarP (10) AS VarP_Value;

Output :

VarP_Value

Last Updated : 15 Sep, 2020
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads