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.
Continuous Probability Distributions
Probability distributions are of two types, which are continuous probability distributions and discrete probability distributions. A continuous probability distribution contains an infinite number of values. For example, if time is infinite: you could count from 0 to a trillion seconds, billion seconds, so on indefinitely. A discrete probability distribution consists of only a countable set of possible values.
Normal Distribution
Suppose we had to design a bathroom weighing scale, how would we decide what should be the range of the weighing machine? Would we take the highest recorded human weight in history and use that as the upper limit for our weighing scale? This may not be a great idea as the sensitivity of the scale would get reduced if the range is too large. At the same time, if we keep the upper limit too low, it may not be usable for a large percentage of the population!
All work is done in Excel and I have no idea how to draw the graph. Could someone please give me step by step instructions as to how to draw the graph. Also, if you could give Excel
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
a Graph the probability density function.
b What is the probability of generating a random number between 0.25 and 0.75?
c What is the probability of generating a random number with a value less than or equal to 0.3?
d What is the probability of generating a random number with the value greater than 0.6?
e Generate 50 random numbers by entering = RAND() int 50 cells of an Excel worksheet.
f Compute the mean and standard deviation for the random numbers in part e.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 4 images
