Home › Functions › Statistical › =BETA.DIST()
Statistical Excel 2010 ◉ 30 views

=BETA.DIST()

.DIST(x,alpha,beta,cumulative,[A],[B])

Applies To: Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=BETA.DIST(x,alpha,beta,cumulative,[A],[B])
Hover argument names in the table for details.
Output typeStatistical
Popularity5 / 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 =BETA.DIST() 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 BETA.DIST.xlsx ~ 8–12 KB · No macros

⇪ Share

Send this function to friends

🧠 🧠 Quiz this function

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

◧ Arguments

ArgumentTypeRequiredDescription
beta Number Required .DIST(x,alpha,beta,cumulative,[A],[B])
x Number Required The value between A and B at which to evaluate the function
alpha Number Required A parameter of the distribution.
cumulative Logical Required A logical value that determines the form of the function. If cumulative is TRUE, BETA.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.
a Number Optional A lower bound to the interval of x.
b Number Optional An upper bound to the interval of x.

▣ Examples

▦ Data
CellValueDescription
A2 2 Value at which to evaluate the function
A3 8 Parameter of the distribution
A4 10 Parameter of the distribution
A5 1 Lower bound
A6 3 Upper bound
A7 2 Value at which to evaluate the function
A8 8 Parameter of the distribution
A9 10 Parameter of the distribution
A10 1 Lower bound
A11 3 Upper bound
Cumulative beta probability density function, for the above parameters =BETA.DIST(A2,A3,A4,TRUE,A5,A6)
Result: 0.6854706
Beta probability density function, for the above parameters =BETA.DIST(A2,A3,A4,FALSE,A5,A6)
Result: 1.4837646

§ Remarks

  • If any argument is nonnumeric, BETA.DIST returns the #VALUE! error value.
  • If alpha ≤ 0 or beta ≤ 0, BETA.DIST returns the #NUM! error value.
  • If x < A, x > B, or A = B, BETA.DIST returns the #NUM! error value.
  • If you omit values for A and B, BETA.DIST uses the standard cumulative beta distribution, so that A = 0 and B = 1

✦ Tips

  • If you omit values for A and B, BETA.DIST uses the standard cumulative beta distribution, so that A = 0 and B = 1

⚠ Common Errors

#VALUE! If any argument is nonnumeric, BETA.DIST returns the #VALUE! error value.
Fix: همه آرگومان‌ها را بررسی کنید که عددی باشند و ارجاع‌ها خالی یا متنی نباشند.
#NUM! If alpha ≤ 0 or beta ≤ 0, BETA.DIST returns the #NUM! error value. If x < A, x > B, or A = B, BETA.DIST returns the #NUM! error value.
Fix: Correct the input value

⇄ Related Functions

=BETA.INV() .INV(probability,alpha,beta,[A],[B]) =GAMMA.DIST() Returns the gamma distribution. You can use this function to study variables that may have a skewed distribution. The gamma distribution is commonly used in queuing analysis.

💬 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.