STDEVPA function Instance

Function Name: STDEVPA

function function: Calculates the standard deviation of a sample population.

It differs from the STDEVP function in that literal values and logical values (TRUE or FALSE) participate in the calculation.

function Syntax:

STDEVPA (Value1,value2,.)

Function arguments:

Value1,value2,. 1 to 30 parameters as a sample population. You can use commas to separate arguments, or you can use a single array (that is, a reference to an array cell).

Note: The STDEVPA function assumes that the parameter is a sample population. If the data represents a partial sample of the population, you must use the STDEVA function to estimate the standard deviation.

Examples of functions:

If there are only 9 students attending an examination, the results are as follows:

a1=61, a2=62, a3=63

A4=64, a5=65, a6=66

a7=67, a8=68, a9=69

Then the standard deviation of all grades is "=STDEVPA (a1:a59)", and the return result equals 2.58198889747161.