sheets.wiki

SKEW.P

2 min read

The SKEW.P function calculates the skewness of a dataset that represents the entire population. Skewness describes the symmetry of that dataset about the mean.

Parts of a SKEW.P function

SKEW.P(value1, value2)

PartDescription
value1The first value or range of the dataset.
value2Additional values or ranges to include in the dataset.

Notes

  • Although SKEW.P is specified as taking a maximum of 30 arguments, Google Sheets supports an arbitrary number of arguments for this function.
  • If the total number of values supplied as value arguments is not at least two, SKEW.P will return the #DIV/0!error.
  • Any text encountered in the value arguments will be ignored.
  • Positive skewness indicates a longer tail extending in the positive direction, to the right of the mean, while negative skewness indicates a longer tail in the negative direction, to the left. Skewness nearer to zero indicates more symmetrical distributions.

Examples

AB
1value
22
35
48
513
610
718
823
926
10
11
12Result
130.2763070768
140.4621754338
  • SKEW: Calculates the skewness of a dataset, which describes the symmetry of that dataset about the mean.
  • VARPA: Calculates the variance based on an entire population, setting text to the value 0.
  • VARP: Calculates the variance based on an entire population.
  • VARA: Calculates the variance based on a sample, setting text to the value 0.
  • VAR: Calculates the variance based on a sample.
  • STDEVPA: Calculates the standard deviation based on an entire population, setting text to the value 0.
  • STDEVP: Calculates the standard deviation based on an entire population.
  • KURT: Calculates the kurtosis of a dataset, which describes the shape, and in particular the “peakedness” of that dataset.
  • DVARP: Returns the variance of an entire population selected from a database table-like array or range using a SQL-like query.
  • DVAR: Returns the variance of a population sample selected from a database table-like array or range using a SQL-like query.
  • DSTDEVP: Returns the standard deviation of an entire population selected from a database table-like array or range using a SQL-like query.
  • DSTDEV: Returns the standard deviation of a population sample selected from a database table-like array or range using a SQL-like query.
  • DEVSQ: Calculates the sum of squares of deviations based on a sample.
  • AVEDEV: Calculates the average of the magnitudes of deviations of data from a dataset’s mean.

Graph View