The standard deviation is calculated using the 'n' method.Īrguments can be the following: numbers names, arrays, or references that contain numbers text representations of numbers or logical values, such as TRUE and FALSE, in a reference. If your data represents a sample of the population, you must compute the standard deviation by using STDEVA.įor large sample sizes, STDEVA and STDEVPA return approximately equal values.
STDEVPA assumes that its arguments are the entire population. You can also use a single array or a reference to an array instead of arguments separated by commas. 1 to 255 values corresponding to a population. Value1 is required, subsequent values are optional. The STDEVPA function syntax has the following arguments: The standard deviation is a measure of how widely values are dispersed from the average value (the mean). DescriptionĬalculates standard deviation based on the entire population given as arguments, including text and logical values. This article describes the formula syntax and usage of the STDEVPA function in Microsoft Excel. Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel 2010 Excel 2007 Excel for Mac 2011 Excel Starter 2010 More.
