SKEWP Function (Calligra Sheets)

• Introduced: First release not established; the name is present in Calligra 2.4.0 source.
• Supported in: Calligra Sheets 26.08.2, with no retirement established.
• Scope: Desktop Sheets with the Statistical module. Examples use English semicolon-separated formulas.
• Checked: October 14, 2026. Selected formulas ran through the official 25.04.2 engine library. Source and independent mathematics were checked. This is engine evidence, with no GUI-cell or import verification; 26.08.2 was source-checked only.

SKEWP returns the standardized third central moment of the full-value input list. Positive and negative values describe asymmetry toward larger and smaller observations. It does not apply SKEW’s sample-size adjustment, and zero skewness alone does not establish normality or symmetry. Function-specific official reference.

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

Supply one or more values, arrays or ranges. A nonconstant list with at least two values is needed for a defined coefficient. Numeric text is parsed, failed text contributes zero and booleans contribute 1/0 in the tested engine. Brackets indicate optional arguments and are not entered in the formula. Registration and implementation.

The engine and mathematical columns are separate. Results are rounded to twelve decimal places, or thirteen significant digits in scientific notation for very small or large values. This is a display choice, not an accuracy guarantee. Inline arrays in braces are formula values, not a workbook-import test. Their semicolons separate columns and vertical bars separate rows. Strings remain explicitly quoted, and booleans use TRUE()/FALSE().

For 1,2,3,4,10, population skewness is approximately 1.138419957661. Reflecting all five numbers gives the opposite sign. Shifting by 100 or scaling by a positive constant leaves the coefficient unchanged.

The deliberately asymmetric text check =SKEWP(1;2;3;4;"9") gives approximately 1.039188922370 because the string contributes numeric 9. Replacing it with “abc” contributes zero and yields a symmetric set, so the result is zero. Equal outputs from some other symmetric examples would not establish identical conversions.

Define M2=Σ(x−mean)²/n and M3=Σ(x−mean)^3/n. SKEWP is M3/M2^(3/2). For 1,2,3,4,10, the mean is 4, M2=10 and M3=36, giving 36/10^(3/2).

For n>2, the adjusted sample coefficient is population skewness×sqrt(n(n−1))/(n−2). With five observations this gives approximately 1.697056274848. Two unequal observations have population skewness zero, but do not define that sample adjustment. The executed reflection-sum check is zero apart from any displayed rounding.

The executed advanced check was:

=SKEWP(1;2;3;4;10)+SKEWP(-1;-2;-3;-4;-10)

Its engine result was 0.

Constant data and a singleton give #VALUE!; existing division errors propagate. Mixed types are included through conversion and must match an intentional data policy. The tests cover scalar lists and inline arrays, with no native cell-range, locale or workbook-import evidence.

• Function-specific implementation
• Versioned function help
• Defaults helper
• Aggregation helper
• Average helper
• Stddev helper
• Shape Walk helper
• Conversion helper
• Array Parser helper

The statistical module and value-calculation helpers are byte-identical between the inspected 25.04.2 and 26.08.2 sources. That comparison supports the source discussion but does not establish later-version execution, GUI-cell behavior or other locales.

SKEW, AVERAGE, STDEVP.