Statistical
Excel 2013
◉ 19 views
=SKEW.P()
1, number 2,… Number 1 is , subsequent numbers are Number 1, number 2,… are 1 to 254 numbers or names, arrays, or reference that contain numbers for which you want the population skewness.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=SKEW.P(number 1, [number 2],…)
Hover argument names in the table for details.
Output typeNumber
Popularity4 / 100
VolatileNo
Dynamic ArrayNo
📥 Download sample .xlsx ▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =SKEW.P() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
🧠 🧠 Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
number |
Range | Optional | 1, number 2,… Number 1 is , subsequent numbers are Number 1, number 2,… are 1 to 254 numbers or names, arrays, or reference that contain numbers for which you want the population skewness. |
▣ Examples
▦ Data
| Cell | Value |
|---|---|
A2 |
Population Data Set |
A3 |
3 |
A4 |
4 |
A5 |
5 |
A6 |
2 |
A7 |
3 |
A8 |
4 |
A9 |
5 |
A10 |
6 |
A11 |
4 |
A12 |
7 |
A13 |
Population Data Set |
A14 |
3 |
A15 |
4 |
A16 |
5 |
A17 |
2 |
A18 |
3 |
A19 |
4 |
A20 |
5 |
A21 |
6 |
A22 |
4 |
A23 |
7 |
Skewness of a distribution based on the population of the data set in A2:A11 (0.303193).
=SKEW.P(A2:A11)
Result:
0.303193
§ Remarks
- Arguments can either be numbers or names, arrays, or references that contain numbers.
- Logical values and text representations of numbers that you type directly into the list of arguments are counted.
- If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero (0) are included.
- SKEW.P uses the standard deviation of an entire population, not a sample.
- If arguments are values that are not valid, SKEW.P returns the #NUM! error value.
- If arguments use data types that are not valid, SKEW.P returns the #VALUE! error value.
- If there are fewer than three data points, or the sample standard deviation is zero, SKEW.P returns the #DIV/0! Error value.
✦ Tips
- Arguments can either be numbers or names, arrays, or references that contain numbers.
- Logical values and text representations of numbers that you type directly into the list of arguments are counted.
- If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero (0) are included.
- SKEW.P uses the standard deviation of an entire population, not a sample.
⚠ Common Errors
#NUM!
If arguments are values that are not valid, SKEW.P returns the #NUM! error value.
Fix: مقادیر عددی معتبر وارد کنید و مطمئن شوید دادهها در محدوده قابل محاسبه هستند.
#VALUE!
If arguments use data types that are not valid, SKEW.P returns the #VALUE! error value.
Fix: مطمئن شوید آرگومانها عدد، نام، آرایه یا مرجع حاوی اعداد هستند و متن غیرقابل تبدیل وارد نکردهاید.
#DIV/0!
If there are fewer than three data points, or the sample standard deviation is zero, SKEW.P returns the #DIV/0!
Fix: Check the number and values of the data
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!