NORMINV in Apple Numbers: Normal Quantiles and Cutoffs

A normal CDF answers, “What fraction lies at or below x?” NORMINV answers the reverse: “At which x does the CDF reach p?” That is a useful distinction for a manufacturing cutoff, forecast percentile, or scoring threshold. Both require a credible normal-distribution assumption and population-model mean and standard deviation; those assumptions do not come from the formula. Apple’s help calls it the inverse cumulative normal distribution. [A1]

=NORMINV(probability, average, stdev)

The first argument is a cumulative probability such as 0.95—not the percentage number 95. Endpoints 0 and 1 are excluded from the documented domain: for a mathematically unbounded normal distribution they would correspond to infinite cutoffs. Apple does not document automatic clipping of invalid probabilities or a particular error-code string. The mean is the centre; standard deviation controls scale. [A1, A2, C1]

Mathematically, NORMINV(p, μ, σ) = μ + σ×Φ⁻¹(p) for 0<p<1 and σ>0, where Φ is the standard-normal CDF. This is an explanatory identity, not a Numbers reverse-engineering claim. Apple documents the special case NORMINV(p,0,1) agreeing with NORMSINV(p). [A1, C1]

In a Numbers table named NormalModel, put Target cumulative share in B1, Expected mean in C1, Population SD in D1 and Cutoff measurement in E1. Enter numeric probabilities and parameters in rows 2–6, then type =NORMINV(B2,C2,D2) in E2 and fill down. Use percentage formatting for column B only if its underlying values remain 0.025, 0.05, etc.; typing 95 into B is not the same as formatting 0.95 as 95%. [A1, A3]

The 5th percentile is about 33.5515 for this model, while the 95th percentile is about 66.4485. Those two cutoffs are symmetric around the 50-unit mean because the normal model itself is symmetric. The median/50th percentile equals the mean: =NORMINV(0.5,50,10) should yield 50. These are model results, not observed sample quantiles. [C1]

Apple provides =NORMINV(0.89,15,2.5) → 18.0663203000915. Independently, the standard normal 0.89 quantile is approximately 1.22652812003661; 15 + 2.5×1.22652812003661 produces 18.0663203000915. The statistical calculation agreed with the Apple documentation without running a Numbers spreadsheet. [A1, C1]

Verify a percentile with the forward CDF

=NORMDIST(NORMINV(0.89,15,2.5),15,2.5,1)

Independent expectation: 0.89 to floating-point precision. This is a useful audit of your mean/SD order when designing a model. Apple documents both functions, but their behaviour in every older app version is not thereby proved. [A10, C1]

Two-sided 90% central cutoffs

=NORMINV(0.05,50,10)
=NORMINV(0.95,50,10)

Expected lower cutoff 33.5514637305 and upper cutoff 66.4485362695. Under the assumed population normal model, 90% of observations lie between these thresholds. This is a population distribution interval, not automatically a frequentist confidence interval for an estimated mean (that would depend on sampling and parameter estimation). [C1]

One-sided service threshold

If durations in a queue are hypothetically normally distributed with mean 15 and SD 2.5 minutes, the threshold under which 95% of values would lie is:

=NORMINV(0.95,15,2.5)

Expected 19.1121340674 minutes. It is meaningful only if a normal model is suitable for those durations; a normal curve permits negatives, so for strictly nonnegative waiting times other models might be better. Reporting a model percentile does not validate the modelling choice. [C1]

Parameterize and compare distribution assumptions

Keep mean in C2 and stdev in D2 on table NormalModel, with a percentile request in B3. In E3 enter =NORMINV(B3,$C$2,$D$2); copying the formula down uses each probability but fixes common model parameters. If a colleague supplies a standard deviation from a different population or in different units, the quantile will scale accordingly. The existence of an SD argument does not mean Numbers estimates SD automatically; that is separate research. [A3]

Standard-normal equivalence

=NORMINV(0.95,0,1) and =NORMSINV(0.95) both have mathematical expectation 1.64485362695, as Apple explicitly notes for mean 0 and SD 1. =NORMINV(0.95,50,10) is the same z-score rescaled into 66.4485362695 measurement units. [A1, A10, C1]

Apple lists input domains for these functions but does not enumerate the precise displayed error token for every invalid input, version, imported document, or type conversion. Therefore the examples below describe the cause and corrective action, not an invented #... error string. [A1, A4]

Remember that NORMINV’s output is a quantile in original units. The equivalent standardized quantile is NORMSINV, which has no mean/SD arguments. Excel or other spreadsheet-program defaults were not used as evidence here. [A1, A10]

The worksheets above assume formulas and their source data live in the same Numbers table, so B2 identifies the first input cell under a row-1 header, and $B$2 stays fixed if copied. Unlike a one-sheet-only model, Numbers documents multiple named tables per sheet. If you move the calculation to another table, the cross-table pattern is NormalModel::B2 (when the source table is named NormalModel). A sheet-qualified form is Sheet 2::NormalModel::B2. These conventions come from Apple’s cell-reference guide, not an Excel workbook model. Use the Formula Editor to select the actual cell and avoid accidental name collisions. [A3]

The worksheet in this tutorial uses scalar formulas per row, not a dynamic-array spill convention. Enter row-1 headers first, enter numeric values in source columns, put the formula into the indicated output cell, then fill it down. If copy/fill moves a parameter that should be fixed, use a fixed reference like $C$2, or explicitly refer to the same source row. Numbers documents the difference between A1 and $A$1; copying a formula may change the former but not the latter. [A3]

This page uses the English function name NORMINV and English-language examples with a period as decimal point and a comma between arguments. Apple’s Brazilian Portuguese 15.4 help for the same function instead titles the corresponding function INV.NORM and demonstrates syntax with the locale-appropriate separator; an independently checked example is =INV.NORM(0,89; 15; 2,5). This is a verified localized name tied to the same official help identifier. [A9]

Copying an English formula verbatim to a Portuguese-Brazil installation can therefore fail or be interpreted differently. Inspect the insertion suggestion in that installation’s Functions Browser and match the spreadsheet’s language/region settings. In particular, a comma in 0,89 is a decimal separator in the Brazilian example while semicolons separate arguments. The B2:C6 colon in a range is neither of those separators. Apple documents the general Functions Browser on Mac/iPhone/iPad. [A5, A9]

The reference version used here is Apple Formulas and Functions Help 15.4 (English, checked 2026-10-13 UTC). Apple lists the 15.4 Numbers release on Mac and iPhone, and the current release notes specify macOS 26 or later for Numbers 15.4 on Mac and iOS 26 or later on iPhone. Those are app-level requirements, not proof that this particular function was tested on either device, available in every earlier version, or available identically in Pages, Keynote and iCloud. [A5, A6, A7]

These functions are documented in Apple Formulas and Functions Help 15.4; the release notes do not establish the earliest version that introduced this specific function. Do not convert the current documentation-version number into an unsupported first-supported-version claim. [A1, A6, A7]

A different spreadsheet may use a similarly named normal-distribution function or different punctuation and defaults. This article makes no claims about Excel, Google Sheets, or other spreadsheet engines, and it does not silently treat their behavior as evidence for Numbers. Where the function page omits a property (for example exact error strings, limits for extreme finite values, coercion of blank/text cells, or internal floating-point precision), this guide deliberately marks it unverified rather than inventing it. [A1, A4]

Validation boundary: Every displayed numeric expectation was independently calculated in a Python/SciPy statistical calculation environment using the displayed formulas and inputs; this is not native execution in Apple Numbers. The official examples were also compared with the published values. No screenshot, Numbers file, import/export conversion, formula-error display, or cross-platform execution test was produced. Roundoff and the number of decimals shown in a Numbers result cell depend on numeric calculation/display choices; compare sufficiently many digits before assuming a mistake. [C1]

• NORMINV: exact syntax and published examples — this page’s authoritative English reference. [A1]
• NORMDIST — general normal cumulative probability or density selected explicitly by mode. [A10]
• NORMINV — inverse of the general normal CDF. [A10]
• NORMSDIST — standard normal cumulative probability (not a density). [A10]
• NORMSINV — inverse of the standard normal CDF. [A10]
• PHI — standard normal density at one z-score. [A10]

• [A1] Apple — NORMINV (Formulas and Functions Help 15.4) — function name, purpose, signature, type/domain, named examples, help-linked relationships; checked 2026-10-13.
• [A2] Apple — Types of arguments and values — Apple definitions of numeric/modal arguments (where the individual function specifies a modal choice); checked 2026-10-13.
• [A3] Apple — Refer to cells in formulas — B2, B2:B6, table and sheet :: notation, relative and absolute references; checked 2026-10-13.
• [A4] Apple — Review formula errors and best practices — general formula debugging, not a source of invented exact errors; checked 2026-10-13.
• [A5] Apple — Formulas and Functions Help welcome — Functions Browser and iWork app context; checked 2026-10-13.
• [A6] Apple — What’s new in Numbers on Mac — Numbers 15.4 release and OS requirement; checked 2026-10-13.
• [A7] Apple — What’s new in Numbers on iPhone — Numbers 15.4 release and OS requirement; checked 2026-10-13.
• [A8] Apple — New functions in Numbers on iPad — names PHI specifically among current new statistical functions; checked 2026-10-13.
• [A9] Apple — Portuguese-Brazil help for INV.NORM — function translation and locale-specific formula example; checked 2026-10-13.
• [A10] Apple — linked normal-distribution family pages — independently checked each of the five named official Apple help URLs on 2026-10-13; these establish relative purpose without asserting spreadsheet cross-engine compatibility.
• [C1] Mathematical calculations using independent Python/SciPy (scipy.stats.norm) and standard normal PDF/CDF identities; using the displayed example values. Never a native Numbers run.