STDEVA

Returns the sample standard deviation of the arguments.

Syntax:

STDEVA(number1, number2, ... number30)

number1 to number30 are up to 30 numbers or ranges containing numbers. Logical values and text may also be included.

STDEVA returns the standard deviation where number1 to number30 are a sample of the entire population.Logical values are regarded as 1 (TRUE) and 0 (FALSE).Text values are always regarded as zero.With N values in the sample, the calculation formula is:

$\sqrt{\frac{1}{N-1}{\sum }_{i=1}^N(x_i-\overline{x}{)}^2}$

Example:

STDEVA(2, 6, 4)

returns 2.

STDEVA(B1:B3)

where cells B1, B2, B3 contain red, TRUE, and 2 returns 1, the standard deviation of 0, 1 and 2.

To find the standard deviation of the sales for salesperson A, you would use the following formula:

STDEVA(2500, 2700, 2400, 2650, 2800)

Alternatively, if the data is in cells B1 to F1, the formula would be:

STDEVA(B1:F1)

Result for Salesperson A:

The STDEVA function would return approximately 159.69. This means that the daily sales for salesperson A typically deviate from their average daily sales by about $159.69.

You would repeat this calculation for each salesperson to analyze the variability of their sales. For example, for salesperson C, the formula would be:

STDEVA(3200, 3100, 3350, 3000, 3400)

The result for salesperson C would be approximately 167.33.

Analysis of Results:

Comparing the results, we can see that:

• Salesperson C has the highest standard deviation (167.33), indicating the most significant variability in their daily sales performance.
• Salesperson B and D have the lowest and identical standard deviations (79.06), suggesting their daily sales are the most consistent and predictable.
• Salesperson A (159.69) and E (96.18) fall in the middle, with E being more consistent than A.