The SKEW.P function in Google Sheets calculates the skewness of a data set that represents an entire population, measuring the asymmetry of the distribution around its mean. It's useful whenever you have complete population data rather than just a sample. Dive into our comprehensive guide to master its application.
Parameters
value1: The first value or range of the population data set.value2: Additional values or ranges to include in the population data set.
Step-by-Step Tutorial
- Calculating population skewness:
- Example: If
A1:A6contains4, 8, 15, 16, 23, 42, then=SKEW.P(A1:A6)will return the skewness of the entire population.
- Example: If
Use Cases and Scenarios
- Population Statistics: Measure the symmetry of a complete data set, such as all employee salaries in a company.
- Risk Analysis: Evaluate whether returns in a financial data set skew positively or negatively.
- Quality Control: Detect asymmetries in manufacturing measurements across an entire production run.
Related Functions
SKEW: Calculates the skewness of a data set that represents a sample of a population.KURT: Calculates the kurtosis of a data set.STDEV.P: Calculates the standard deviation of an entire population.