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>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube