SKEW.P
The SKEW.P function in Google Sheets calculates the skewness of a dataset that represents the entire population. Skewness measures the asymmetry or lack of symmetry in a distribution. Learn how to apply this statistical function with our comprehensive guide.
Function Syntax and Parameters
Syntax: SKEW.P(value1, value2)
Parameters:
value1: The first value or range representing the dataset.value2: [Optional] Additional values or ranges representing the dataset.
Step-by-Step Tutorial
- Using
SKEW.Pwith a dataset:- Example: If
A1:A5has the values5, 10, 3, 8, 7, then=SKEW.P(A1:A5)will return a skewness value.
- Example: If
Use Cases and Scenarios
- Financial Analysis: Determine the skewness of stock returns.
- Population Studies: Analyze the distribution of income in a country.
- Data Analysis: Measure the distribution of test scores in a classroom.