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
Share:

⬇ 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)
📥 Download SKEW.P.xlsx ~ 8–12 KB · No macros

⇪ Share

Send this function to friends

🧠 🧠 Quiz this function

%d questions — syntax, example & errors — test yourself!

◧ Arguments

ArgumentTypeRequiredDescription
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
CellValue
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!

✍️ Add comment / question

captcha
🔒 Your comment will be published after review.