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
4.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 month
The 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?
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.)
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
- The average weekly earnings of bus drivers in a city are $950 (that is μ) with a standard deviation of $45 (that is σ). Assume that we select a random sample of 81 bus drivers. What is the probability that the sample mean will be greater than $960? 0.99 0.66 0.023 1 Sample: n= Mean= SD= Probability[P(X>)]= z= Probability[P(Z)]= Answer: Graph:arrow_forwardThe average weekly earnings of bus drivers in a city are $950 (that is μ) with a standard deviation of $45 (that is σ). Assume that we select a random sample of 81 bus drivers. What is the probability that the sample mean will be greater than $960? (Keep 4 digits of the result)arrow_forward4. ABC Dog Food Company located in Ottawa sells large bags of dog food to warehouse clubs. ABC uses an automatic filling process to fill the bags. Weights of the filled bags are approximately normally distributed with a mean of 50 kilograms and a standard deviation of 1.25 kilograms. (a) What is the probability that a filled bag will weigh less than 49.5 kilograms? (b) What is the probability that a randomly sampled filled bag will weigh between 48.5 and 51 kilograms? (c) What is the minimum weight a bag of dog food could be and remain in the top 15% of all bags filled? (d) ABC is unable to adjust the mean of the filling process. However, it is able to adjust the standard deviation of the filling process. What would the standard deviation need to be so that 2% of all filled bags weigh more than 52 kilograms?arrow_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_forwardChoose the correct statement with regard to the given distributions: a. Poisson: If mean is u, standard deviation will beu b. Exponential: If mean is u, standard deviation will be c. Standard Normal distribution: If mean is 0, standard deviation will be All of the above Answer A B C Darrow_forwardSAT scores have an average of 1200 with a standard deviation of 60. A sample of 36 scores is selected. What is the probability that the sample mean will be less than 1230? 0.999 0.222 0.899 1 Answer Sample: n= Mean= SD= Probability[P(X<)]= z= Probability[P(Z<)]/Normal Distribution= Grapharrow_forward
- Please do not give solution in image format thankuarrow_forwardA bank has kept records of the checking balances of its customers and determined that the average daily balance of its customers is $300 with a standard deviation of $48. A random sample of 144 checking accounts is selected. What is the probability that the sample mean will be more than $306.60? 0.049 1 0.55 0.88 Answer Sample: n= Mean= SD= Probability[P(X>)]= z= Probability[P(Z)]= Grapharrow_forwardFor the next 6 numbers: Refer to the Management Scientist output of a maximization LP problem. The constraints are defined as follows: Constraint 1: advertising budget ( ) Constraint 2: sales force availability ( ) Constraint 3: production level (=) Constraint 4: retail stores requirement ( ) Optimal Solution Objective Function Value - Variable. Constraint X1 X2 X1 X2 X3 X4 X3 X4 1 2 Variable 1 2 3 3 4 OBJECTIVE COEFFICIENT RANGES 4 Constraint RIGHT HAND SIDE RANGES Value Slack/Surplus Lover Limit 25.000 425.000 150.000 0.000 84.000 50.000 No Lover Linit No Lover Linit Lover Limit 48450.000 0.000 25.000 0.000 0.000 4950.000 1775.000 515.000 0.000 Reduced Costs Dual Prices Current Value 90.000 84.000 70.000 60.000 Current Value 0.000 0.000 0.000 45.000 5000.000 1800.000 600.000 150.000 3.000 0.000 60.000 -17.000 Upper Limit No Upper Linit 90.000 87.000 105.000 Upper Linit 5850.000 No Upper Limit 603.571 200.000arrow_forward
- SAT scores have an average of 1200 with a standard deviation of 60. A sample of 36 scores is selected. What is the probability that the sample mean will be less than 1230? A 0.999 B 0.222 C 0.899 D 1 Please solve for: Apply this questionaire to excel. find the probability(P(X<)] Z= Probability[P(Z<)] / Normal distributionShow work on how you solved the problemarrow_forwardA researcher is studying whether being a smoker causes people to get colds more often. Classify each method as a survey, an experiment, or an observational study. Then explain which method would be the most reliable. Method A: Choose people who already smoke and who do not and monitor how many colds they get in a period of years. Method B: Choose 100 people at random. Have 50 people smoke regularly for six months and 50 people not smoke for six months. Then monitor how many of the 100 people get colds within the next six months. Method C: Ask people who currently have a cold whether or not they smoke. Tell whether each method of gathering data is a survey, an observational study, or an experiment. Which option would give the most reliable results?arrow_forwardA normal population has σ = 4. A random samplehas: n = 50 and X-bar = 22. Find the 90% PI for asingle new value from the population.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