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