Stdevpa() Function

The Excel STDEVPA function calculates the standard deviation for an entire population. Unlike the STDEVP function, STDEVPA evaluates text and logicals that appear in references.

Syntax

The syntax for the STDEVPA function in Microsoft Excel is:

=STDEVPA( value1, value2, ... value_n )

Parameters or Arguments

value1

A population value that can be a number, text, or a logical value. A value that is TRUE is evaluated as 1. A value that is FALSE or a text value is evaluated as 0.

value2, ... value_n

Optional. They are the population values that can be numbers, text, and logical values. There can be up to 30 values entered.

Stdevpa Function Example

The following spreadsheet shows the Excel Stdevpa function used to calculate the standard deviation of the set of values in cells A1-A4 and in cells A1-A6.

Formulas:

	A	B
1	1	=STDEVPA( A1:A4 )
2	3	=STDEVPA( A1:A6 )
3	5	=STDEVPA( A1:A4, 1, 0 )
4	2
5	TRUE
6	text

Results:

	A	B
1	1	1.479019946
2	3	1.632993162
3	5	1.632993162
4	2
5	TRUE
6	text

Note that, in the spreadsheet above, the function in cell B2 includes the values in cells A5 and A6. In this case:

►   The logical value TRUE in cell A5 is treated as the value 1;

►   The text in cell A6 is treated as the value 0.

This is shown by the example in cell B3, in which cells A1 - A4 and the values 1 and 0 give the same result as the standard deviation calculation for cells A1 - A6.

Reference:

https://www.techonthenet.com/excel/formulas/stdevpa.php

http://www.excelfunctions.net/Excel-Stdevpa-Function.html

https://exceljet.net/excel-functions/excel-stdevpa-function

follow us on http://arivilm.blogspot.in

like us on https://www.facebook.com/Arivilm2501/