Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelSKEW.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.

### You May Also Like

#### SKEW Function in Excel

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

#### RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021

#### RANK Function in Excel

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