| Line 1: |
Line 1: |
| | + | <div style="font-size:30px">'''UNIFORMDISTRIBUTED(x,ll,ul)'''</div><br/> |
| | + | *<math>x </math> is the value of the function. |
| | + | *<math>ll </math> is the lower limit. |
| | + | *<math> ul </math> is the upper limit of the function. |
| | | | |
| | + | ==Description== |
| | + | *This function gives the probability of the uniform distribution. |
| | + | *Uniform distribution is a symmetric probability distribution. |
| | + | *It is also called rectangular distribution. |
| | + | *In <math>UNIFORMDISTRIBUTED(x,ll,ul)</math> ,<math> x </math> is the numeric value to find the probability of the distribution, <math>ll </math> is the lower limit value and <math> ul </math> is the upper limit value. |
| | + | *The probability density function of the uniform distribution in the interval (a,b) are |
| | + | ==equation== |
| | + | <math> |
| | + | P(x)= |
| | + | \begin{cases} |
| | + | 0, &for &x<a \\ |
| | + | 1/b-a, &for &a<x<b \\ |
| | + | 0, &for &x>b |
| | + | \end{cases} |
| | + | </math> |
| | + | |
| | + | ==Examples== |
| | + | #UNIFORMDISTRIBUTED(4,2,3) = 4030484680552036 2.6280935418326408 2.2810050058178604 2.97846262995153679 |
| | + | #UNIFORMDISTRIBUTED(5,3,6) = 5.522187389200553 3.566177821950987 5.04674904467538 5.301322509767488 4.9094569575972855 |
| | + | |
| | + | ==See Also== |
| | + | *[[Manuals/calci/FDIST | FDIST ]] |
| | + | *[[Manuals/calci/TDIST | TDIST ]] |
| | + | *[[Manuals/calci/NORMSDIST | NORMSDIST ]] |
| | + | *[[Manuals/calci/NORMDIST | NORMDIST ]] |
| | + | |
| | + | ==References== |