Zoho Sheet DSTDEV Function: Sample Standard Deviation

Zoho’s official DSTDEV entry was retrieved on October 15, 2026. It documents the current rolling web service, not an original introduction release or last functioning version; both historical endpoints remain unknown. Mobile/offline parity is unverified. The additional calculations below are independent mathematical expectations, not native Zoho Sheet output.

DSTDEV(database_table; field; criteria_table)

All three arguments are documented. The first range includes headers and records. The field is a quoted column label or a reference to the header cell. The criteria range contains a header and its condition. Zoho labels the first and third placeholders database_table and criteria_table in this signature, while its descriptions call them database and criteria; these are the same argument positions.

The formulas follow Zoho’s semicolon syntax. Use your workbook’s locale separator where necessary. Keep the field explicit rather than assuming another product’s optional arguments or numeric field-index conventions.

Create Measures and enter A1:C7 exactly as below. Measurement values are numeric. Put Group in E1 and Red in E2; put Group in G1 and Blue in G2.

E1:E2 selects rows 2,4,5,7, while G1:G2 selects rows 3,6. Use these formulas on Measures:

In I1 enter Group and leave I2 physically empty. =DSTDEV(A1:C7;"Measure";I1:I2) gives 4.501851471 under Zoho’s documented blank-below-header rule. The entire population for this calculation is the selected field within the stated database, not every cell in the worksheet.

Red’s mean is 4. Its deviations are −2,0,0,2 and squared deviations 4,0,0,4, totaling 8. For a sample estimate, divide by n−1 = 3, then take the square root: √(8/3). This produces the displayed sample standard deviation.

DSTDEVP instead gives √2 ≈ 1.414213562 for the same records. Sample and population denominators answer different questions; choose the model based on whether these observations are a sample or the entire population of interest.

Duplicate Measures and change only C7 from 6 to 10. Red becomes 2,4,4,10, with mean 5 and squared-deviation total 36. DSTDEV becomes 3.464101615. Blue remains 2.828427125. This shows the effect of one more distant observation without changing group membership.

In another original copy, add 100 to every Red measurement: 102,104,104,106. The result remains 1.632993162, because translating all observations shifts the mean equally and preserves deviations.

In a third original copy multiply those Red measurements by 10: 20,40,40,60. The result becomes 16.329931619. Standard deviation scales by the absolute scale factor, so a unit conversion by ten multiplies this result by ten. Convert the whole dataset consistently rather than mixing units within a field.

For Red’s sample standard deviation, create a separate four-row check using the explicitly selected values 2,4,4,6. Subtract mean 4 and divide by √(8/3). The resulting standardized values are approximately −1.224744871,0,0,1.224744871. They sum to zero; their squares sum to 3, matching n−1.

This is a scale check, not proof the data are normally distributed. It does not create a confidence interval or establish that the four records were randomly sampled. Keep statistical assumptions separate from the mechanics of the spreadsheet function.

A sample denominator n−1 requires at least two participating observations. A singleton does not provide a sample spread estimate. Exact native error tokens for every small or empty selection are not specified by the checked entry, so these mathematical limits are not presented as observed Zoho output.

The page lists general name, type and reference errors, but does not provide a full coercion table for text, booleans, blank cells or embedded errors. The worked table uses only numeric observations and ordinary text group labels. Do not silently turn missing measurements into zero: zero changes both the center and the spread.

If a result differs, check the database boundary, header names, criteria range and actual selected values before changing the formula. Inspect whether the intended statistic is sample or population, variance or standard deviation. A square-root mismatch often indicates the wrong statistic; a difference by n/(n−1) in variance suggests the wrong denominator.

The related official database catalog distinguishes these operations. Common names in other products do not establish matching error handling, coercion or version support. No cross-product import test was performed.