| 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==
| |
| − | *[[Manuals/calci/FDIST | FDIST ]]
| |