SKEWP 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.

SKEWP computes the population-style standardized third central moment. It describes asymmetry of the supplied numeric set without SKEW’s finite-sample adjustment. Positive, negative and zero values indicate direction or absence of third-moment asymmetry; they do not by themselves identify a distribution. Versioned function help.

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

• value1,...: numbers or ranges. Two distinct numeric values are sufficient.
• Referenced text, booleans and blank cells are excluded. Current direct-text conversion is described separately 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.

For all five observations 1,2,3,4,10, =SKEWP(F2:F6) returns approximately 1.138419957661. This is the descriptive coefficient for that complete set. If the values are a sample and the adjusted convention is required, SKEW gives approximately 1.697056274848 instead.

Do not label one convention as more accurate without specifying the statistic being estimated. A useful report gives the function name, numeric count and the data-selection rule.

With M2 = Σ(x−m)²/n and M3 = Σ(x−m)^3/n, the coefficient is M3/M2^(3/2). F2:F6 has mean 4, M2=10 and M3=36. Therefore 36/(10^(3/2))≈1.138419957661.

For n=5, the native cross-check =SKEWP(F2:F6)*SQRT(5*4)/(5-2) gives the adjusted SKEW coefficient. This conversion requires n>2. Two unequal values have SKEWP zero but do not have a defined adjusted SKEW coefficient. A common shift and positive rescaling preserve SKEWP; reflection reverses its sign.

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.

An empty numeric set, singleton or constant set produces #DIV/0!. Referenced numeric-looking text is not a third observation. Direct TRUE is also ignored by the current SKEWP callback; do not assume the sample and population variants use identical direct-boolean flags.

• 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.