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, Problem 38P
It is surprising (but true) that if 23 people are in the same room, there is about a 50% chance that at least two people will have the same birthday. Suppose you want to estimate the probability that if 30 people are in the same room, at least two of them will have the same birthday. You can proceed as follows.
- a. Generate random birthdays for 30 different people. Ignoring the possibility of a leap year, each person has a 1/365 chance of having a given birthday (label the days of the year 1 to 365). You can use the RANDBETWEEN function to generate birthdays.
- b. Once you have generated 30 people’s birthdays, how can you tell whether at least two people have the same birthday? One way is to use Excel’s RANK function. (You can learn how to use this function in Excel’s online help.) This function returns the rank of a number relative to a given group of numbers. In the case of a tie, two numbers are given the same rank. For example, if the set of numbers is 4, 3, 2, 5, the RANK function returns 2, 3, 4, 1. (By default, RANK gives 1 to the largest number.) If the set of numbers is 4, 3, 2, 4, the RANK function returns 1, 3, 4, 1.
- c. After using the RANK function, you should be able to determine whether at least two of the 30 people have the same birthday. What is the (estimated) probability that this occurs?
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
by the end of 2013, the IPL port was operational and the naphtha was flowing to the Himachal Fertilizer Corporation (HFC) plant in Central India after being granted the
port contract in Summer 2012. The plant was located in an industrial area that had several pipelines in the general geographic area including a crude oil pipeline leading to
a refinery, and a pipeline carrying pesticides to be processed and redistributed to local farms in the area.
In July 2014, Ajay Patel, the logistics general manager received notification that there were some minor leaks along the pipeline that were being fixed. Workers in the area
had experienced sudden headaches and lightheadedness and the company immediately moved to investigate the leak and address faulty seams that had eroded and
weakened. The flow of naphtha was temporarily stopped for 72 hours so two portions of the pipeline could be removed, and the eroded portions replaced. Patel put
enormous pressure on the repair team to get the repair…
in the MABE: learning to be multinational case report, what is the reccomended course of action?
In the MABE case report what would be the reccomened course of action?
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
- Question 6. An electrical engineering company is designing two types of solar panel systems: Standard Panels (S) and High-Efficiency Panels (H). The company has certain constraints regarding the hours of labor and material available for production each week. Each Standard Panel requires 4 hours of labor and 2 units of material and each High-Efficiency Panel requires 3 hours of labor and 5 units of material. The company has a maximum of 60 hours of labor and 40 units of material available per week. The profit from each Standard Panel is GH¢80, and the profit from each High-Efficiency Panel is GH¢100. The company wants to determine how many of each type of panel to produce in order to maximize profit. i) Solve this LPP by using graphical analysis ii) What will be the slack at the optimal solution point? Show calculation.arrow_forwardqusestion 6. An electrical engineering company is designing two types of solar panel systems: Standard Panels (S) and High-Efficiency Panels (H). The company has certain constraints regarding the hours of labor and material available for production each week. Each Standard Panel requires 4 hours of labor and 2 units of material and each High-Efficiency Panel requires 3 hours of labor and 5 units of material. The company has a maximum of 60 hours of labor and 40 units of material available per week. The profit from each Standard Panel is GH¢80, and the profit from each High-Efficiency Panel is GH¢100. The company wants to determine how many of each type of panel to produce in order to maximize profit. i. Formulate a linear programming model of the problem for the company. ii Convert the linear programming model formulated in (a) to a standard form.arrow_forwardG ווח >>> Mind Tap Cengage Learning 1- CENGAGE MINDTAP Chapter 09 Excel Activity: Exponential Smoothing Question 1 3.33/10 e Submit 自 A ng.cengage.com C Excel Online Student Work G A retail store records customer demand during each sales period. 1. What is the f... Q Search this course ? ✓ Co Excel Online Tutorial Excel Online Activity: Exponential Smoothing A-Z A retail store records customer demand during each sales period. The data has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develop the single exponential smoothing forecast and answer the following questions. Office Video X Open spreadsheet Questions 1. What is the forecast for the 13th period based on the single exponential smoothing? Round your answer to two decimal places. 25.10 2. What is the MSE for the single exponential smoothing forecast? Round your answer to two decimal places. 21.88 Activity Frame ? 3. Choose the correct graph for the single exponential…arrow_forward
- Not use ai pleasearrow_forwardItems removed from the work area (5S) were taken to a storage area called ___________. Choose from: SORT, STORD, KNUJ, STUFF, FUDG SORT STORD KNUJ STUFF FUDGarrow_forwardCould you please help explain How was the poor strategic decisions lead to economic downturns of Circuit City Company? What are the sequences of key events and problems that contribute to its collapse. Could you please explain each one them and give the examples If Circuit City would apply Lean Six Sigma. would it helped prevent businesses from collapsed?? How Qualitative and quantitative Research Methodology in Case Study Research would affect Circuit City?arrow_forward
- Apple is a global technology company renowned for its innovation and design. To create its products, Apple has established a world class global supply chain to bring their products to market. What strategies is Apple using to source and manufacture its products? How does Apple view its responsibility to its suppliers and those who build its products?arrow_forwardCritical Path Method (CPM) is an important Project Management Tool that has wide industry application in modern day Project Management. By using an example of the project of your choice, critically examine the practical application of CPM as a Project Management Tool.arrow_forwardwhat is an other difination for principle?arrow_forward
- Need help or ideas to design out two slides as my script and writing quite long to squeese into two slides. But can just point form in slides with correct title and a good script for me to present two slides in only 2.5 mins. Following is my draft, pls guide me step by step on powerpoint creation and good script to present findings. My draft: Slide 1: Foreign Labor Exploitation in Dyson's Supply Chain Introduction Dyson's former Malaysian supplier, ATA IMS Bhd, became embroiled in serious labor exploitation allegations in 2021. These concerns surfaced when whistleblowers exposed unethical labor practices affecting migrant workers, primarily from Nepal and Bangladesh. Key Forms of Exploitation Debt Bondage Due to Recruitment Fees Workers were forced to pay exorbitant recruitment fees before securing employment, often taking loans at high interest rates. This financial burden trapped them in debt bondage, leaving them with little choice but to accept exploitative working…arrow_forwardNot use ai pleasearrow_forwardThe Business Development Bank of Canada. (2023). Canadian economic outlook for 2024: Shifting into neutral. https://www.bdc.ca/en/articles-tools/blog/canadian-economic-outlook-for-2024-shifting-into-neutral “Despite persistently high inflation and rising interest rates, the news was generally better than expected for the Canadian economy in 2023” (BDC Blog 2024). Discussion Question: In your view, what are the most pressing problems for Canadian companies or consumers in 2024? Explain your answer using current examples of companies or consumer concerns.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