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.



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:-


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>