Skip to main content
Library homepage
 
Statistics LibreTexts

4.1 Uniform Probabilities using the Excel Spreadsheet provided

  • Page ID
    22450
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)\(\newcommand{\AA}{\unicode[.8,0]{x212B}}\)

    To use the Excel spreadsheet provided for the continuous probability distributions, download the Excel Spreadsheet here.

    Definition: Uniform Distribution

    When a variable is continuous, its probability is the area under the curve and the x-axis.  The total probability sums to one.  In the case of a Uniform distribution, the area is a rectangle.  

    Suppose you have a random variable X that is Uniformly distributed, X ~ U(1, 55).  Compute the following using the Excel Spreadsheet provided.

    1. Mean
    2. Standard Deviation
    3. Probability Distribution Function
    4. P(X > 21)
    5. P(X < 34)
    6. P(X< 40| X> 30)
    7. P(X > 15| X< 45)
    8. P(13<X< 35)
    9. Find the 67th percentile

    The first thing you will do is open the Excel Spreadsheet and click on the Uniform Distribution tab at the bottom.  Then enter 1 in cell B1 and 55 in cell B2.

    1. The mean is in cell B4, 28.
    2. The standard deviation is in cell B5, 15.5885.
    3. The probability distribution function is in cell B3, 1/54.
    4. To compute the probability P(X > 21), change the c value to 21 in cell B6.  The answer is in cell B10, 0.6296. (Make sure 1 is in cell B1 and 55 is in cell B2)
    5. To compute the probability P(X < 34), change the c value to 34 in cell B6.  The answer is in cell B9, 0.6111.  (Make sure 1 is in cell B1 and 55 is in cell B2)
    6. Since the probability is a conditional probability, it changes the shape of the distribution.  X greater than 30 means we change B1, the minimum to 30 in cell B1.  The maximum value is still 55 so we do not change B2.  Next, we change the value of c in cell B6 to 40.  The answer to the probability question is in cell B9, 0.4000.
    7. Since the probability is a conditional probability, it changes the shape of the distribution.  X less than 45 means the maximum value is changed to 45 in cell B2.  However, we do not change the minimum value from 1.  So make sure 1 is in cell B1.  Finally, enter 15 in cell B6.  The answer is in cell B10, 0.6818.
    8. To find the probability that X is between 13 and 35, make sure 1 is in cell B1 and 55 is in cell B2.  Then enter 13 in cell B6 and 35 in cell B7.  The answer is in cell B11, 0.4074.
    9. To find the 67th percentile, make sure 1 is in cell B1 and 55 is in cell B2.  Then enter .67 in cell E1.  The answer is 37.18.

    Interactive Element


    4.1 Uniform Probabilities using the Excel Spreadsheet provided is shared under a not declared license and was authored, remixed, and/or curated by LibreTexts.

    • Was this article helpful?