How to use SKEW.P Function in Excel?

# SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft Excel.

## SKEW.P Function in Excel

The SKEW.P function in excel returns the skewness of a distribution, which is a measure of symmetry. A positive result indicates distributions that extend towards the right. A negative result indicates a distribution that extends towards the left.

#### Syntax

`SKEW.P(number 1, [number 2],…)`

Arguments:

• Number1, number2, …    Number1 is required, Other subsequent numbers are optional.

The argument can range from 1 to 255 arguments for which you want to calculate skewness.

You can also use a single array or a reference to an array instead of arguments separated by commas.

SKEW.P uses the following equation:

## Possible Errors and Usage Notes

• Arguments can either be numbers or names, arrays, or references that contain numbers.
• Logical values and text representations of numbers that you enter are counted.
• When an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
• SKEW.P uses the standard deviation of an entire population, not a sample.
• When the arguments with values that are not valid is entered, the SKEW.P function returns the #NUM! error value.
• When the arguments with data types that are not valid is entered, the SKEW.P function returns the #NUM! error value.
• In case of fewer than three data points, or the sample standard deviation is zero, SKEW.P returns the #DIV/0! Error value.

## How to use the SKEW.P function in Excel?

Using this function in a WS is simple; all you need to do is enter the function as a formula of the cell in the formula bar.

Take a look at the given example

Enter the data in the respective columns and enter the SKEW.P function formula.

Formula: =SKEW.P(A2:A11)

Here, A2 refers to the cell name or the cell address. Column A denotes the Array.