Practical Management Science
5th Edition
ISBN: 9781305734845
Author: WINSTON
Publisher: Cengage
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 10.2, Problem 1P
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.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
When it first debuted, Telsa was selling its Model 3 sedan for $35,000. The Model 3 was priced substantially less than Tesla’s other models at the time, however, it had similar quality and input costs. In charging such a low price, it is most likely that Tesla is trying to:
A. Create more value without capturing more value
B. Capture more value without creating more value
C. Create and capture more value
D. None of the above
Bad simulations Explain why each of the followingsimulations fails to model the real situation properly:a) Use a random integer from 0 through 9 to representthe number of heads when 9 coins are tossed.
b) A basketball player takes a foul shot. Look at a ran-dom digit, using an odd digit to represent a good shot
and an even digit to represent a miss.c) Use random numbers from 1 through 13 to represent thedenominations of the cards in a five-card poker hand.
Models that have no random input are called iconic models.
Select one:
True
False
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 - Prob. 34PCh. 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
- You are cleaning the data for data modeling. Which of the following is NOT a data preparation step ? Group of answer choices Changing the variable type of outcome variable (Defaulted) Removing variable Index Replacing any missing value by the mean of that variable Computing the confusion matrixarrow_forwardMaximize z=4x+5y Subject to: x+y<or=4 x-y>or=-2 x<or=3 x>or=0, y>or=0arrow_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
- Given a normal distribution with μ= 105 and σ = 20, and given you select a sample of n = 16, complete parts (a) through (d). a. What is the probability that X is less than 92? P(X<92) 0.0047 (Type an integer or decimal rounded to four decimal places as needed.) b. What is the probability that X is between 92 and 93.5? P(92 X 93.5)= 0.0061 (Type an integer or decimal rounded to four decimal places as needed.) c. What is the probability that X is above 105.2? P(X 105.2)= 0.4840 (Type an integer or decimal rounded to four decimal places as needed.) d. There is a 67% chance that X is above what value? X = (Type an integer or decimal rounded to two decimal places as needed.)arrow_forwardPlease do not give solution in image format thankuarrow_forwardGiven that Z is a standard normal random variable. What is the value of Z if the area to the right of Z is 0.1401? -1.08 0.1401 1.08 2.16arrow_forward
- An airline company has 4 phone lines. If the time between calls averages 3 minutes. Use Table 17A.1. Round your answer to four decimal places. What is the probability that all lines are busy if an average call lasts 6 minutes? 1.5000arrow_forwardBest choicearrow_forwardWe can use the methods below to control extraneous variables except O Manual control O Design control O Statistical control Randomization O Matchingarrow_forward
- Suppose you sample one value from a uniform distribution with a = 0 and b=20. a. What is the probability that the value will be between 12 and 172 b. What is the probability that the value will be between 4 and 72 c. What is the mean? d. What is the standard deviation? a. The probability that the value will be between 12 and 17 is (Type an integer or a decimal)arrow_forwardWhen will you use scatter diagram?a. For 2 variables that have relationshipb. For 2 variables that have no relationshipc. For data that are inversely proportionald. For data that are directly proportionale. None of the abovearrow_forwardEven though, a bar chart and histogram looks very similar, there are several differences between the two charts. Which of the following represents a key difference? 000 0 There is actually no real difference between a bar chart and a histogram. Both A and B are correct. A bar chart is developed to analyze a continuous variable, while a histogram is used to analyze discrete variables. A bar chart typically has gaps between the bars while a histogram has no gaps.arrow_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