SKEW.P Function

 

SKEW.P Function

Excel 2013 has introduced a new function i.e., SKEW.P function.  This function returns the skewness of a distribution based on a population.

 

Syntax:-

SKEWP(number 1, [number 2],…)

 

where number 1, number 2 are the reference to data.

 

Example:- Skewness based on the population for the data set {5,6,5,6,5} is 0.41 and the formula would look like:-

=SKEW.P(5,6,5,6,5)

Note: if arguments references results in in-valid values, formula will return the #NUM! error and if the data types are not valid, formula will return #VALUE! error

Also, if there are fewer than 3 data points, formula will return #DIV/0! error



Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>