ExcelFlux

DSTDEV function

Estimates the standard deviation based on a sample of selected database entries.

Database · Guided Excel example

Where can you use it?

Teams working with structured records. When summarising matching records in a headed Excel list, match the criteria header to the source header.

Scenario in the workbook

Find the sample standard deviation for each sales group. The criteria header must match Group in the source table.

A worked example from the workbook

RowABC
6GroupAmountCriteria blocks
7A12Group
8A24A
9A36Group
10B8B
11B16Group
12B24C
13C5—
14C10—
15C15—
Record 1
=DSTDEV($A$6:$B$15,"Amount",$C$7:$C$8)

Illustrative output12

See the inputs and instructions for all 3 examples

Worked examples

Find the sample standard deviation for each sales group. The criteria header must match Group in the source table.

Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.

Row A B C
6 Group Amount Criteria blocks
7 A 12 Group
8 A 24 A
9 A 36 Group
10 B 8 B
11 B 16 Group
12 B 24 C
13 C 5 —
14 C 10 —
15 C 15 —
Trial Expression Sample output
Record 1 =DSTDEV($A$6:$B$15,"Amount",$C$7:$C$8) 12
Record 2 =DSTDEV($A$6:$B$15,"Amount",$C$9:$C$10) 8
Record 3 =DSTDEV($A$6:$B$15,"Amount",$C$11:$C$12) 5
Microsoft Excel reference