Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 10.2, Problem 2P
Use Excel’s functions (not @RISK) to generate 1000 random numbers from a
- a. Calculate the mean and standard deviation of these random numbers. Are they approximately what you would expect?
- b. What fraction of these random numbers are within k standard deviations of the mean? Answer for k = 1; for k = 2; for k = 3. Are the answers close to what they should be (about 68% for k = 1, about 95% for k = 2, and over 99% for k = 3)?
- c. Create a histogram of the random numbers using about 10 bins of your choice. Does this histogram have approximately the shape you would expect?
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Let’s suppose that you have a set of time-series variables, and you want to model the relationship between them. Read the situations given below and answer the questions. (200 words)a) Explain the statistical test if the linear combination (of time-series variables) is I(0).b) Which statistical test can be applied if all the series are integrated of the same order I(1). Justify your answer
What is NOT true about normal distribution?
We can expect approximately 99.7% of the possible outcomes to fall within three standard deviations above and below the mean
We can expect approximately half of the possible outcomes to be positive and half to be negative
We can expect approximately 95% of the possible outcomes to fall within two standard deviations above and below the mean
It is completely defined by two numbers: mean and standard deviation
It is bell shaped and symmetric
A) Why is the conditional variance a good measure of uncertainty? B) Outline the GARCH model and GARCH-M model. C) Outline one of the extensions to the basic GARCH family of models
Chapter 10 Solutions
Practical Management Science
Ch. 10.2 - Use the RAND function and the Copy command to...Ch. 10.2 - Use Excels functions (not @RISK) to generate 1000...Ch. 10.2 - Use @RISK to draw a uniform distribution from 400...Ch. 10.2 - Use @RISK to draw a normal distribution with mean...Ch. 10.2 - Use @RISK to draw a triangular distribution with...Ch. 10.2 - Use @RISK to draw a binomial distribution that...Ch. 10.2 - Use @RISK to draw a triangular distribution with...Ch. 10.2 - We all hate to keep track of small change. By...Ch. 10.4 - Prob. 11PCh. 10.4 - In August of the current year, a car dealer is...
Ch. 10.4 - Prob. 13PCh. 10.4 - Prob. 14PCh. 10.4 - Prob. 15PCh. 10.5 - If you add several normally distributed random...Ch. 10.5 - In Problem 11 from the previous section, we stated...Ch. 10.5 - Continuing the previous problem, assume, as in...Ch. 10.5 - In Problem 12 of the previous section, suppose...Ch. 10.5 - Use @RISK to analyze the sweatshirt situation in...Ch. 10.5 - Although the normal distribution is a reasonable...Ch. 10.6 - When you use @RISKs correlation feature to...Ch. 10.6 - Prob. 24PCh. 10.6 - Prob. 25PCh. 10.6 - Prob. 28PCh. 10 - Six months before its annual convention, the...Ch. 10 - Prob. 30PCh. 10 - A new edition of a very popular textbook will be...Ch. 10 - Prob. 32PCh. 10 - W. L. Brown, a direct marketer of womens clothing,...Ch. 10 - Assume that all of a companys job applicants must...Ch. 10 - Lemingtons is trying to determine how many Jean...Ch. 10 - Dilberts Department Store is trying to determine...Ch. 10 - It is surprising (but true) that if 23 people are...Ch. 10 - Prob. 40PCh. 10 - At the beginning of each week, a machine is in one...Ch. 10 - Simulation can be used to illustrate a number of...Ch. 10 - Prob. 43PCh. 10 - Prob. 46PCh. 10 - If you want to replicate the results of a...Ch. 10 - Suppose you simulate a gambling situation where...Ch. 10 - Prob. 49PCh. 10 - Big Hit Video must determine how many copies of a...Ch. 10 - Prob. 51PCh. 10 - Prob. 52PCh. 10 - Why is the RISKCORRMAT function necessary? How...Ch. 10 - Consider the claim that normally distributed...Ch. 10 - Prob. 55PCh. 10 - When you use a RISKSIMTABLE function for a...Ch. 10 - Consider a situation where there is a cost that is...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- Use @RISK to draw a binomial distribution that results from 50 trials with probability of success 0.3 on each trial, and use it to answer the following questions. a. What are the mean and standard deviation of this distribution? b. You have to be more careful in interpreting @RISK probabilities with a discrete distribution such as this binomial. For example, if you move the left slider to 11, you find a probability of 0.139 to the left of it. But is this the probability of less than 11 or less than or equal to 11? One way to check is to use Excels BINOM.DIST function. Use this function to interpret the 0.139 value from @RISK. c. Using part b to guide you, use @RISK to find the probability that a random number from this distribution will be greater than 17. Check your answer by using the BINOM.DIST function appropriately in Excel.arrow_forwardIf you add several normally distributed random numbers, the result is normally distributed, where the mean of the sum is the sum of the individual means, and the variance of the sum is the sum of the individual variances. (Remember that variance is the square of standard deviation.) This is a difficult result to prove mathematically, but it is easy to demonstrate with simulation. To do so, run a simulation where you add three normally distributed random numbers, each with mean 100 and standard deviation 10. Your single output variable should be the sum of these three numbers. Verify with @RISK that the distribution of this output is approximately normal with mean 300 and variance 300 (hence, standard deviation 300=17.32).arrow_forwardWhen you use @RISKs correlation feature to generate correlated random numbers, how can you verify that they are correlated? Try the following. Use the RISKCORRMAT function to generate two normally distributed random numbers, each with mean 100 and standard deviation 10, and with correlation 0.7. To run a simulation, you need an output variable, so sum these two numbers and designate the sum as an output variable. Run the simulation with 1000 iterations and then click the Browse Results button to view the histogram of the output or either of the inputs. Then click the Scatterplot button below the histogram and choose another variable (an input or the output) for the scatterplot. Using this method, are the two inputs correlated as expected? Are the two inputs correlated with the output? If so, how?arrow_forward
- Use the RAND function and the Copy command to generate 100 random numbers. a. What fraction of the random numbers are smaller than 0.5? b. What fraction of the time is a random number less than 0.5 followed by a random number greater than 0.5? c. What fraction of the random numbers are larger than 0.8? d. Freeze these random numbers. However, instead of pasting them over the original random numbers, paste them onto a new range. Then press the F9 recalculate key. The original random numbers should change, but the pasted copy should remain the same.arrow_forwardSuppose you have invested 25% of your portfolio in four different stocks. The mean and standard deviation of the annual return on each stock are shown in the file P11_46.xlsx. The correlations between the annual returns on the four stocks are also shown in this file. a. What is the probability that your portfolios annual return will exceed 30%? b. What is the probability that your portfolio will lose money during the year?arrow_forwardIf X1, X2, ... , Xn constitute a random sample from apopulation with the mean μ, what condition must beimposed on the constants a1, a2, ... , an so thata1X1 + a2X2 +···+ anXnis an unbiased estimator of μ?arrow_forward
- All MBA students have to take entry test for admission to AUAF. Scores are normally distributed with a mean of 230 and standard deviation of 40. What fraction of applicants would you expect to have scores of 300 or above? A- 0.0401 B- 0.4599 C- 0.5401 D- 0.0325arrow_forwardA carpenter is making doors that are 2058 millimeters tall. If the doors are too long they must be trimmed, and if they are too short they cannot be used. A sample of 13 doors is made, and it is found that they have a mean of 2043 millimeters with a variance of 1024. Is there evidence at the 0.025 level that the doors are too short and unusable? State the null and alternative hypotheses for the above scenario.arrow_forwardThe mean annual earning for U.S. workers with advanced degrees is $80,977 with a standard deviation of $100,895; the distribution is highly right-skewed. Use this information to answer questions 7 to 10 below. A random sample of n = 86 workers is drawn, and their annual earnings recorded. What is the expected value of the sample mean of their annual earnings? What is the standard deviation of the sample mean of their annual earnings? what is the probability that the sample mean is at least $100,000? The actual sample mean earnings for the random sample of 86 workers with advanced degrees was $82,105. What is the sampling error?arrow_forward
- The following data are from a completely randomized design. In the following calculations, use ? = 0.05. Treatment1 Treatment2 Treatment3 63 82 68 46 73 55 54 88 60 37 61 45 xj 50 76 57 sj2 123.33 138.00 92.67 (a) Use analysis of variance to test for a significant difference among the means of the three treatments. State the null and alternative hypotheses. H0: At least two of the population means are equal.Ha: At least two of the population means are different. H0: ?1 = ?2 = ?3Ha: ?1 ≠ ?2 ≠ ?3 H0: Not all the population means are equal.Ha: ?1 = ?2 = ?3 H0: ?1 = ?2 = ?3Ha: Not all the population means are equal. H0: ?1 ≠ ?2 ≠ ?3Ha: ?1 = ?2 = ?3 Find the value of the test statistic. (Round your answer to two decimal places.) Find the p-value. (Round your answer to three decimal places.) p-value = State your conclusion. Do not reject H0. There is sufficient evidence…arrow_forward41.The ______ are (is) used to determine the amount of money that an organization would save if it used a particular test in place of the test it currently uses to select employees. a. Brogden-Cronbach-Gleser formula b. Taylor-Russell Tables c.expectancy charts d. Lawshe tables 42.When the criterion validity coefficient is ____, and the selection ratio is ____, a test will have the most utility in selecting successful employees. a. large / large b. large / small c.small / small d. small / large 43.A test is considered to have _____ if there are race differences in test scores that are unrelated to the construct being measured. a. differential validity b. measurement bias c.selection bias d. adverse impact 44.If the selection rate for any of the protected groups is less than 80% of the…arrow_forward4.1 TYPES OF RANDOM VARIABLES. Which of the following describe continuous random variables? Which describe discrete random variables? The number of newspapers sold by the New York Times each month The amount of ink used in printing a Sunday edition of the New York Times The actual number of ounces in a 1-gallon bottle of laundry detergent The number of defective parts in a shipment of nuts and bolts The number of people collecting unemployment insurance each montharrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Single Exponential Smoothing & Weighted Moving Average Time Series Forecasting; Author: Matt Macarty;https://www.youtube.com/watch?v=IjETktmL4Kg;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License