STDEVP Function (Gnumeric)
Learn the STDEVP function in Gnumeric: Calculates the standard deviation based on the entire population.
Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Gnumeric. How formula examples are checked
Quick answer
STDEVP calculates population standard deviation with the n denominator. It differs from sample STDEV for the same finite dataset.
Gnumeric syntax and parameters
=STDEVP(area1,area2,...)
area1 — First cell range representing the complete population.
area2, ... — Further population ranges, if needed.
Version and locale scope: The release-scoped function registry confirms STDEVP within the Gnumeric 1.12.62 standard public function set (September 2026). The Gnumeric manual documents the syntax shown here but is a continuously updated reference, not a frozen 1.12.62 manual. The function’s original introduction version has not been established. The formulas below use comma-separated English-locale syntax; installed regional settings or imported files may display other separators. Availability can depend on installed plugins and builds for Gnumeric functions in general.
Reproduce the example in your own worksheet
Create a worksheet and enter numeric data into the following eight cells. Keep these as real numbers, not quoted text.
| Cell | B: Observation |
|---|---|
| B2 | 2 |
| B3 | 4 |
| B4 | 4 |
| B5 | 4 |
| B6 | 5 |
| B7 | 5 |
| B8 | 7 |
| B9 | 9 |
All eight observations total 40 and average 5. Keep the reference B2:B9 consistent across the example.
- Enter the values in the indicated cells in Gnumeric.
- Select a separate blank result cell outside the input range.
- Enter this formula exactly as written for the sample input:
=STDEVP(B2:B9)
Expected result: 2. The mean is 5, the squared deviations sum to 32, and 32/8 = 4. The square root gives a population standard deviation of 2.
Input interpretation: The difference from STDEV is mathematical, not a proof of identical behavior for every nonnumeric cell type.
Advanced application: add a useful check or calculation
After reproducing the basic result, enter:
=STDEVP(B2:B9)/AVERAGE(B2:B9)
Expected result: 0.4 (40%). The population standard deviation 2 divided by the mean 5 is 0.4; this conveys relative variation when all eight rows form the whole population.
This is a teaching example, not an assertion that the formula has been executed in this software version.
Third worked example: two observations as the entire population
=STDEVP(2,4)
Independently calculated expected result: 1. The mean is 3. Squared deviations are 1 and 1; divide their sum by the population size of 2, then take the square root. Sample standard deviation would instead use a denominator of 1 and produce a different result.
Errors, edge cases and troubleshooting
- Do not use STDEVP for sample estimates merely because the output is smaller; choose the denominator based on the study design.
- A population variation estimate should include all intended rows; omitted rows change both the mean and deviation.
- If the mean is zero, the advanced ratio divides by zero. The STDEVP formula itself does not require a nonzero mean.
If the output differs, first confirm the exact cell contents and range boundaries; use an independent small dataset to isolate a formula issue from imported formats, hidden characters or missing values. Keep result cells outside the input ranges to avoid accidental circular references. Do not hide an error with IFERROR until you know which input is responsible.
Limits and cross-software compatibility
The manual marks STDEVP Excel compatible; modern Excel calls the population function STDEV.P as well. Confirm the receiving application supports whichever function spelling appears in the file.
Gnumeric reference coverage is not a claim that every formula behaves identically in Microsoft Excel, LibreOffice Calc, Apple Numbers or other spreadsheet apps. Review the receiving application’s argument conventions, cell types and version-specific behavior before relying on workbook portability.
More related Gnumeric tutorials
Official sources and verification status
- Official Gnumeric Statistics function reference — STDEVP (checked 2026-10-11).
- Gnumeric official function catalog (checked 2026-10-11; its headline/row totals are not treated as the canonical release count).
- Gnumeric 1.12.62 official release notes (release dated September 2026, checked 2026-10-11).
How this guide was checked
The syntax and behaviour are based on the Gnumeric references cited above. The sample calculations were independently checked; they are expected results, not outputs observed in Gnumeric. Test locale-sensitive text conversion and imported files in your own installation. View the example-check record.