BETADIST

Formulas / BETADIST
Calculate the cumulative beta probability density function.
=BETADIST(x,alpha,beta,[A],[B])
  • x - required, the value between A and B to evaluate the function
  • alpha - required, a parameter of the distribution
  • beta - required, a parameter of the distribution
  • cumulative - required, a logical value that determines the form of the function
  • A - [OPTIONAL] lower bound to the interval of x
  • B - [OPTIONAL] upper bound to the interval of x

Examples

  • =BETADIST(A2,A3,A4,A5,A6)

    The BETADIST function is used to calculate the cumulative beta probability density function for the parameters in the table. This is done by entering the function into a cell, followed by the required parameters. For example, this function will return the cumulative beta probability density function for the parameters in the table.


Summary

The BETADIST function is used to calculate the cumulative beta probability density function. It is used to study how percentages vary across samples, however it is being replaced with the BETA.DIST function for improved accuracy.

  • The BETADIST function returns the cumulative beta probability density function and may not be available in Sourcetable.
  • The BETADIST function throws an error if any of its arguments are not numbers, alpha or beta is less than or equal to 0, x is outside the range of A and B, or A=B.
  • The new BETA.DIST function provides improved accuracy.

Frequently Asked Questions

What is the BETADIST function?
The BETADIST function computes the cumulative beta probability density function. It is used to study how the percentage of something across samples varies.
Is it available in later versions of Sourcetable?
The BETADIST function may not be available in Sourcetable. The BETA.DIST function may provide improved accuracy.
What errors may be thrown if I use the BETADIST function?
  • A #VALUE! error may occur if any of the arguments are not numeric.
  • A #NUM! error may occur if alpha or beta are less than or equal to zero.
  • A #NUM! error may occur if x is less than A.
  • A #NUM! error may occur if x is greater than B.
  • A #NUM! error may occur if A equals B.
What does the BETADIST function assume if A and B are omitted?
The BETADIST function assumes that A=0 and B=1 if A and B are omitted.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV