In: Operations Management
Create an Excel spreadsheet that will generate random numbers based on the following probability distributions. You can keep the answers to (a) (b) and (c) on the same spreadsheet. If I click on F9 key, the random numbers must be refreshed.
a. Use Excel generic function to generate randomly 50 observations following a general discrete distribution described in the table below. To keep things compact, you don’t need to put the 50 random numbers down one column, instead put them in rectangle region (e.g., 5 columns by 10 rows or 10 columns by 5 rows).
X | P(X=x) |
4 | 0.1 |
7 | 0.15 |
12 | 0.40 |
15 | 0.20 |
20 | 0.15 |
b. Use Excel generic function to randomly generate 10 observations following a normal distribution with a mean of 50 and a standard deviation of 15, and use ROUND() to round these random numbers to the nearest integer.
c. Use Excel generic function to randomly generate 10 observations following a symmetric triangular distribution (50, 65, 80), and use ROUND() to round these random numbers to the nearest integer.
Answer a
Utilize the Data Tab in Excel. From Data Tab Select Data Analysis. Starting from the pull Menu Select "Random Number Generation". Pick the number of variables to be 1, Number of random Numbers to be produced as 50 . Select the circulation as "Discrete". Select the information for X and P(x) from the excel sheet. Give the output extend where the worth is to be shown.
Answer b
The function for generaring an ordinary dispersion with mean=50 and
standard deviation =15 with rounded worth is
=ROUND(NORM.INV(RAND(),50,15),0). RAND() is the random number, 50
is the mean, 15 is the standard deviation and 0 methods the number
will be rounded to the closest integer. Drag to next 9 colums to
get 10 perceptions.
NORMAL |
80 |
70 |
54 |
55 |
45 |
36 |
41 |
55 |
46 |
56 |
Answer C-- There is no built-in nonexclusive function for symmetric triangular circulation in Excel.
Thank You Please Upvote and like my answer it will be highly appreciated and helpful . Please Like ...!!!!!