How does the VAR.S function (DAX) work?
The VAR.S function (DAX) returns the variance of a sample population.
VAR.S Formula Syntax
How do you use the VAR.S function?
The VAR.S function calculates the variance of a sample of data. Variance provides a general idea of the spread of data. The VAR.S function can accept up to 254 arguments.
Note while VAR.S ignores text and logicals passed into as cell references, it will evaluate logical values, and text representations of numbers hardcoded directly as arguments. In other words, VAR.S will ignore FALSE when it appears in a range like A1:A10, but will evaluate FALSE when it is provided as an argument.
Related Blog Posts
Related Support Forum Posts
Considerations when using the VAR.S function
- VAR.S assumes that its arguments are a sample of the population. If your data represents the entire population, then compute the variance by using VAR.P.
- Arguments can either be numbers or names, arrays, or references that contain numbers.
- Logical values, and text representations of numbers that you type directly into the list of arguments are counted.
- If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical values, text, or error values in the array or reference are ignored.
- Arguments that are error values or text that cannot be translated into numbers cause errors.
- If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the VAR.A function.
Related Video Tutorials
Formula examples using the VAR.S function
=VAR.S( B3:B1002, D3:D1002, F3:F1002 )
Related Course Modules
To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.