WorksheetFunction.Var_S Method (Excel)

Estimates variance based on a sample.


expression. Var_S( _Arg1_ , _Arg2_ , _Arg3_ , _Arg4_ , _Arg5_ , _Arg6_ , _Arg7_ , _Arg8_ , _Arg9_ , _Arg10_ , _Arg11_ , _Arg12_ , _Arg13_ , _Arg14_ , _Arg15_ , _Arg16_ , _Arg17_ , _Arg18_ , _Arg19_ , _Arg20_ , _Arg21_ , _Arg22_ , _Arg23_ , _Arg24_ , _Arg25_ , _Arg26_ , _Arg27_ , _Arg28_ , _Arg29_ , _Arg30_ )

expression A variable that represents a 'WorksheetFunction' object.


Name Required/Optional Data Type Description
Arg1 - Arg30 Required Variant Number1, number2, ... - 1 to 30 number arguments corresponding to a sample of a population.

Return Value



  • 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.

  • VAR_S uses the following formula: Formulawhere x is the sample mean AVERAGE(number1,number2,?) and n is the sample size.

See also

WorksheetFunction Object