Generating Random Variates Using Excel Functions The weekly demand of a slow-moving product has the following probability mass function: Demand, X Probability, f(x) 0 0.2 3 0.4 4 or more 0.3 Use VLOOKUP to generate 25 random Variates from this distribution.
Added by Esperanza G.
Close
Step 1
Demand, X | Probability, f(x) | Cumulative Probability 0 | 0.2 | 0.2 1 | 0.4 | 0.6 2 | 0.3 | 0.9 3 | 0.1 | 1.0 Show more…
Show all steps
Your feedback will help us improve your experience
Qudsiya Anis and 71 other Intro Stats / AP Statistics educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
The Excel function for generating random numbers is: a. =RAND() b. =RAND() c. =RAND(1) d. =RAND()
Rylie H.
Excel RAND Function. Most computer languages include a function that can be used to generate random numbers. In Excel, the RAND function can be used to generate random numbers between 0 and $1 .$ If we let $x$ denote a random number generated using RAND, then $x$ is a continuous random variable with the following probability density function. $f(x)=\left\{\begin{array}{ll}1 & \text { for } 0 \leq x \leq 1 \\ 0 & \text { elsewhere }\end{array}\right.$ a. Graph the probability density function. b. What is the probability of generating a random number between .25 and $.75 ?$ c. What is the probability of generating a random number with a value less than or equal to $.30 ?$ What is the probability of generating a random number with a value greater than $.60 ?$ e. Generate 50 random numbers by entering $=R A N D()$ into 50 cells of an Excel worksheet. f. Compute the mean and standard deviation for the random numbers in part (e).
Most computer languages include a function that can be used to generate random numbers. In Excel, the RAND function can be used to generate random numbers between 0 and 1. If we let x denote a random number generated using RAND, then x is a continuous random variable with the following probability density function. a. Select the probability density function.
Jacob F.
Recommended Textbooks
Elementary Statistics a Step by Step Approach
The Practice of Statistics for AP
Introductory Statistics
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD