KURTP Function (Gnumeric)

• Introduced: First release not established; present in the retained 1.12.57 source.
• Supported in: Gnumeric 1.12.62; no retirement is established.
• Scope: Desktop Gnumeric with its Statistics plugin. English comma-separated formulas are shown.
• Checked: October 14, 2026. The tables and named advanced check use 1.12.57 ssconvert. Current 1.12.62 source was inspected; that release was not executed.

KURTP returns population excess kurtosis, the fourth central moment divided by the squared second central moment, minus 3. Use the descriptive population definition when the listed observations are the complete set you intend to describe. KURTP does not apply the finite-sample correction used by KURT. Versioned function help.

=KURTP(value1[,value2,...])

• value1,...: numeric observations or ranges. At least two distinct numeric values are needed.
• Referenced text, booleans and blanks are ignored. Direct numeric text has a later-version difference, explained below.

Brackets mark optional arguments; do not type them. Current implementation.

Enter these columns as numbers, except for the explicitly typed H column. F7 and H7 are genuinely empty.

Use an apostrophe entry marker if needed to store H5 as text; it is not part of the stored value. The results below are native outputs rounded to 12 decimal places for readability, rather than application screenshots.

To describe the complete five-value set 1,2,3,4,10, use =KURTP(F2:F6). Its excess kurtosis is −0.212. Adding 3 gives the unshifted moment ratio 2.788; use =KURTP(F2:F6)+3 when that convention is required. State which convention is being reported.

For 1,2,3,4, KURTP is −1.36, whereas sample KURT is −1.2. Changing the function is a change of statistical definition, not simply a different display precision.

For mean m, define M2 = Σ(x−m)²/n and M4 = Σ(x−m)^4/n. Then KURTP = M4/M2²−3. In F2:F6, m=4, M2=10 and M4=278.8, which gives 278.8/100−3=−0.212.

The statistic is unchanged by adding a constant, multiplying by a nonzero constant, or reflecting every observation. The shifted O2:O6 and scaled P2:P6 columns demonstrate this. Two unequal observations give −2, the minimum possible excess kurtosis for an equally weighted two-point set. A constant set has zero denominator and has no defined kurtosis.

The 1.12.57 callback ignores direct strings and logical values. The 1.12.62 callback adds direct-string parsing: numeric text becomes a number and failed numeric conversion gives #VALUE!. Only the sample variants KURT and SKEW also add direct-boolean conversion. Referenced strings and booleans remain excluded. See the current collector.

The exact first release of these collection changes is not established. The comparison concerns the stated English inputs; locale-dependent numeric text was not tested.

A singleton, an empty numeric set or a constant set produces #DIV/0!. The two-value case is supported; it is not necessary to have four observations for KURTP. Do not substitute a zero result when the variance is zero.

• Current worksheet implementation
• Tested-version worksheet implementation
• Current moment calculation

Both the stale SUM cache and the uncached SUM recalculated correctly. Saved formula identities and typed inputs were checked in the native workbook exports. The importer reported unsupported style-extension elements; this does not establish complete formatting support. GUI entry, other locales and later-version execution were not tested.

AVERAGE, VARP, STDEVP.