Contact
12 programs
Explore the site

STDEVP Function in Apple Numbers: Population Standard Deviation

Statistical Intermediate Apple Numbers

Calculate true-population standard deviation in Numbers with Apple sample data, numeric examples and minimum-input rules.

Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Apple Numbers. How formula examples are checked

Quick answer: If the four numeric readings 2,4,6,8 are the entire population, =STDEVP(B2:B5) gives the independently calculated expected result √5 ≈ 2.2360679775. The sample version STDEV gives a different answer because it estimates dispersion from only a sample. The function returns population standard deviation, not variance. [A1, A2, C1]

Exact Apple syntax, order and accepted argument types

=STDEVP(value, value…)
Argument Required? Official documented input
value Yes A number, date/time, duration or collection of compatible values. At least two total values are required.
value… No Any additional value(s) or collection(s) of an accepted type.

Apple specifies all values must be of the same type. Unlike VARP’s page, its STDEVP reference explicitly includes duration values; this guide therefore does not claim VARP accepts durations just because the numeric relationship STDEVP² = VARP holds for numeric datasets. The optional ellipsis is not a literal formula argument; no optional boolean/sample-mode argument exists. [A1, A2]

For numeric observations x₁...xₙ, the population mean is μ=Σx/n; population standard deviation is √(Σ(x−μ)²/n). Apple’s page says to use STDEV instead when observations are a sample of a larger population. Using STDEVP on a sample typically understates that sample’s n−1 spread relative to STDEV. [A1, C1]

Numbers-specific setup, release scope, references and localisation

This guide uses Apple’s Formulas and Functions Help, edition 15.4, checked 2026-10-13, and its documented function signature. The help edition is not evidence of a minimum Numbers version on Mac, iPhone, iPad or iCloud.com. Check the specific application’s release notes and test an older installation instead of extrapolating availability. Apple’s Mac Numbers release history is linked below. No native application run was conducted for this review. [R1, R4]

The reproducible examples use one Numbers table, with its first row configured as a header. A range such as B2:B5 identifies four values in that table; put all formulas in otherwise empty cells outside the input ranges to avoid circular references. Numbers can use Table 2::B5 for another table on the same sheet, and Sheet 2::Table 2::B5 for a different sheet and table. Use the formula editor to construct qualified references; Excel’s Sheet1!B5 notation is not Numbers syntax. Header-derived names can be substituted by the editor, so verify the range endpoints. [R2]

English examples use period decimals and comma argument separators, e.g. =AVERAGE(2,4). Apple says that if your decimal separator is a comma, manually typed function arguments require semicolons (for example =AVERAGE(2;4)). The range-colon B2:B5 does not change. Formula-name case is not significant. The optional ellipsis … in Apple’s syntax notation is not typed into the formula. [R1]

Evidence labels: Apple-documented means the exact result appears in official help; independently calculated means reproduced with separate fractional/decimal arithmetic or Python’s standard statistics tools, not a Numbers output. Do not equate either with native Mac/iOS/iPadOS/iCloud execution or screenshots. Error conditions described below are guidance from documented constraints; unless Apple’s reference specifies an exact error code, this guide does not invent one. [R3]

Make a four-reading test table

Set up a Numbers table AllReadings with a header row and four numeric data rows. Enter the observations exactly as below and put the output in a separate cell such as D2.

Row A: Period B: Quantity
2 P-01 2
3 P-02 4
4 P-03 6
5 P-04 8 
=STDEVP(B2:B5)

Independently calculated expected result: 2.23606797749979 (rounded). The mean is 5, squared deviations sum to 20, population variance is 20/4 = 5, and population standard deviation is √5. The unit of the result matches the unit of the values. Apple Numbers was not run. [A1, C1]

Check direct values, a sample formula and a population variance

Formula entered in an empty cell Independent expected result What to compare
=STDEVP(2,4,6,8) 2.23606797749979 Direct numeric arguments.
=STDEVP(B2:B5) 2.23606797749979 The same four values as a documented collection.
=VARP(B2:B5) 5 True population variance.
=STDEV(B2:B5) 2.58198889747161 Sample standard deviation, denominator n−1.
=STDEVP(4,4,4,4) 0 Identical population values have zero spread.
=STDEVP(B2:B5)/AVERAGE(B2:B5) 0.447213595499958 Ratio of spread to mean; format as 44.72% if appropriate.

All results in this table are independent calculations. The ratio can be useful when comparing positive nonzero means measured in the same units, but is not generally suitable when the mean is zero or near zero; it is not a built-in STDEVP option. The comparison is about statistical interpretation, not a guarantee that other applications handle every input type identically. [A1, A2, C1]

Apple’s published five-test classroom example

Apple illustrates STDEVP using five students and five test columns. In a separate table with no header row, place its published numbers into A1:E5 exactly as shown below. If you instead create a header row, shift all input and formula references one row down and check them carefully. [A1]

Student Test A Test B Test C Test D Test E
Student 1 75 82 90 78 84
Student 2 100 90 95 88 90
Student 3 40 80 78 90 85
Student 4 80 35 95 98 92
Student 5 90 98 75 97 88

Apple’s documented formulas apply to the no-header-row table, one vertical test column at a time. These expected outputs were also checked independently from the actual 25 numbers. [A1, C1]

Formula Apple-published approximate result Independent population variance
=STDEVP(A1:A5) 20.3960780543711 416
=STDEVP(B1:B5) 21.9453867589523 481.6
=STDEVP(C1:C5) 8.49941174435031 72.24
=STDEVP(D1:D5) 7.22218803410711 52.16
=STDEVP(E1:E5) 2.99332590941915 8.96

Test B has the highest dispersion. The STDEVP values are the mathematical square roots of the corresponding VARP population variances; neither directionality nor quality of test is inferred from variation alone. [A1, A2, C1]

Advanced interpretation and useful workflows

A product-quality analyst with all lots produced this week can use STDEVP to describe that particular week’s complete population. If the data is only ten sampled lots from thousands of lots, STDEV is the more natural estimator of population spread. The choice depends on the sampling design, not how many rows happen to be in the table. [A1, A2]

Durations: Apple’s STDEVP specification explicitly permits durations when consistent with the other values. For a duration experiment, start with real Duration-formatted cells and test the displayed unit and mixing behaviour in the target Numbers installation; the example above is numeric only, so it does not verify a time-formatting workflow. Do not treat VARP as having identical duration support without its own documentation. Date/time: Apple permits same-type date/time values, but practical interpretation of the displayed output should be checked natively. [A1, A2]

Numerical stability: The arithmetic shortcut mean(x²) − mean(x)² may lose precision for very large, nearly equal numbers in floating-point implementations. The examples here calculate deviations from the mean directly. No Apple-internal algorithm or precision limit is asserted.

Errors and limitations: diagnose without inventing a code

  1. Only one value: Apple requires at least two total values for STDEVP, even if supplied by a collection. Check how many usable observations are actually present. [A1]
  2. Mixed value types: Do not mix durations and numbers or unrelated date/time entries; Apple explicitly requires same-type input values. [A1]
  3. Text or booleans: Apple directs people wanting those included to STDEVPA; ordinary STDEVP is not documented as including them. Avoid untested coercion assumptions. [A1]
  4. Sample vs population: STDEVP divides population variance by n; STDEV uses sample variance. Record the population definition alongside the table. [A1, A2]
  5. Using a range containing result cells: Keep output separate; circular or accidentally enlarged ranges undermine the calculation. [R2, R3]
  6. Wrong table references: The source may be in another Numbers table; Table::B2 references differ from Excel’s Sheet!B2. [R2]
  7. Rounded display: Expected 2.23606797749979 might render as 2.24; increase decimal-place formatting before comparing.
  8. Locale: Decimal-comma users enter multiple arguments with semicolons, e.g. =STDEVP(2;4;6;8); single range syntax is unaffected. [R1]
  9. Unknown release or error wording: Apple’s current page documents the semantics, not every historical OS version or exact error message. Test the target application and inspect Apple’s error indicators. [R3, R4]

See Apple’s STDEV for sample standard deviation, VARP for numeric population variance, VAR for sample variance, and AVERAGE for the mean. [A2]

Apple documentation and calculation method

Native-validation limitations: These formulas have not been executed in Numbers. Verify relevant blank/error/type behavior and displayed precision on the intended version and locale.