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.P
with a dataset:- Example: If
A1:A5
has 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.