Question

In: Operations Management

Create an Excel spreadsheet that will generate random numbers based on the following probability distributions. You...

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.

Solutions

Expert Solution

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 ...!!!!!


Related Solutions

Generate 200 random numbers using each of the following continuous distributions and plot the histograms (a)...
Generate 200 random numbers using each of the following continuous distributions and plot the histograms (a) Uniform (use A = 3 and B = 7) (b) Exponential (use population mean = 0.2) (c) Gamma (use parameters 3 and 2) (d) Normal (use µ = 2 and σ = 5) Attach the histogram plots and reflect on what you observe. Hint: Use RAND() to generate uniform random numbers and use inverse CDF to generate random numbers for each distribution.
To use Excel INV functions, such as XXXX.INV(probability,....) to generate random variates, replace probability by: the...
To use Excel INV functions, such as XXXX.INV(probability,....) to generate random variates, replace probability by: the mean of the distribution 0.05, the level of significance the uniform distribution formula RAND()
Use Excel to generate the probability distribution for a binomial random variable for which there are...
Use Excel to generate the probability distribution for a binomial random variable for which there are 20 trials (n = 20) and the probability of success is 0.5 (p = 0.5), and show the graph.
a. Use the multiple regression spreadsheet provided in the Excel spreadsheet to do the following: create...
a. Use the multiple regression spreadsheet provided in the Excel spreadsheet to do the following: create a new data set that is a subset of this larger provided data set. The new data set should include the dependent variable (VALUE) and the following independent variables (AGE, LOTSIZE, RMS, MOD KITCH, MOD BATH, AIRCON and FIREPL). b. For this new data set, use the Correlation option of Data Analysis in Excel and produce the correlation matrix associated with the dependent variable...
Create a page length written analysis based on the numbers in the spreadsheet. What do the...
Create a page length written analysis based on the numbers in the spreadsheet. What do the numbers mean? What should be done with the information? Ratio Wal-Mart Target Liquidity Ratios Current Ratio 0.86x 0.94x Efficiency Ratios Inventory Turnover 112.87x 8.36x Leverage Ratios Total Debt Ratio 58.45% 54.81% ProfitabiltyRatios Net Profit Margin 2.81% 3.94% Return on Equity 16.94% 24.99%
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. A firm that is in the 35% tax bracket forecasts that it can retain $4 million of new earnings plans to raise new capital in the following proportions: 60% from 30-year bonds with a flotation cost of 4% of face value. Their current bonds are selling at a price of 91...
create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel...
create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. A company is evaluating the purchase of a machine to improve product quality and output levels. The new machine would cost $1.6 million and would be depreciated for tax purposes using the straight-line method over an estimated six-year life to its expected salvage value of $100,000. The new machine would require...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. A company with EBIT of $6,000,000 is considering two financing alternatives. The first alternative would have interest expense of $2,000,000 and 1,000,000 common shares outstanding, whereas the second would have interest expense of $3,800,000 but only 750,000 shares outstanding. The company is in the 35% tax bracket. Part 1: Construct the...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. A firm had the following abbreviated income statement for 2020 and abbreviated balance sheets at the end of 2020 and 2021. 2020 Sales $600,000 Less Cost of goods sold 320,000 Gross Profit 280,000 Less Operating expenses 190,000 Less Depreciation 30,000 Operating Income (EBIT) 60,000 Less Interest expense 20,000 Earnings Before Taxes...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel...
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. A company with EBIT of $6,000,000 is considering two financing alternatives. The first alternative would have $25 million of bonds at 8% interest and 1,000,000 common shares outstanding, whereas the second would have $47.5 million of bonds at 8% interest and only 750,000 shares outstanding. The company is in the 35%...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT