Practical Management Science
6th Edition
ISBN: 9781337671989
Author: WINSTON
Publisher: Cengage
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 10, Problem 34P
Assume that all of a company’s job applicants must take a test, and that the scores on this test are
- a. Show that if the company wants to accept only the top 25% of all applicants, it should accept applicants whose test scores are at least 0.674 standard deviation above average. (No simulation is required here. Just use the appropriate Excel normal function.)
- b. Now generate 1000 test scores from a normal distribution with mean 0 and standard deviation 1. The average test score of those selected is the average of the scores that are at least 0.674. To determine this, use Excel’s DAVERAGE function. To do so, put the heading Score in cell A3, generate the 1000 test scores in the range A4:A1003, and name the range A3:A1003 Data. In cells C3 and C4, enter the labels Score and >0.674. (The range C3:C4 is called the criterion range.) Then calculate the average of all applicants who will be hired by entering the formula =DAVERAGE(Data, "Score", C3:C4) in any cell. This average should be close to the theoretical average, 1.27. This formula works as follows. Excel finds all observations in the Data range that satisfy the criterion described in the range C3:C4 (Score>0.674). Then it averages the values in the Score column (the second argument of DAVERAGE) corresponding to these entries. See online help for more about Excel’s database “D” functions.
- c. What information would the company need to determine an optimal selection ratio? How could it determine the optimal selection ratio?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
High Incidence of Pressure Injuries Due to Delayed Risk Identification: The unit currently relies on manual assessments and paper-based documentation to identify patients at risk of pressure injuries. This often leads to delayed interventions, increasing patient discomfort, length of stay, and costs. An electronic risk assessment and monitoring system could enable earlier identification and timely preventive care. Focus on describing in more detail the business nature of the problem.
How is it manifested in the business process (i.e., how do you know it is a problem),
When does it work?
Durban woman, Nombulelo Mkumla, took to social media last week to share how she discovered the rodent.In a lengthy Facebook post, she said she purchased the loaf of bread from a local shop after work on August 27.For the next days, Mkumla proceeded to use slices of bread from the load to make toast."Then, on the morning of August 31, I took the bread out of the fridge to make toast and noticed something disgusting andscary. I took a picture and sent it to my friends, and one of them said, 'Yi mpuku leyo tshomi' [That's a rat friend]“."I was in denial and suggested it might be something else, but the rat scenario made sense - it's possible the rat got into thebread at the factory, and no one noticed," Mkumla said.She went back to the shop she'd bought the bread from and was told to lay a complaint directly with the supplier.She sent an email with a video and photographs of the bread.Mkumla said she was later contacted by a man from Sasko who apologised for the incident.According to…
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
- PepsiCo South Africa says the incident where a woman discovered part of a rodent in her loaf of bread, is anisolated occurrence.Durban woman, Nombulelo Mkumla, took to social media last week to share how she discovered the rodent.In a lengthy Facebook post, she said she purchased the loaf of bread from a local shop after work on August 27.For the next days, Mkumla proceeded to use slices of bread from the load to make toast."Then, on the morning of August 31, I took the bread out of the fridge to make toast and noticed something disgusting andscary. I took a picture and sent it to my friends, and one of them said, 'Yi mpuku leyo tshomi' [That's a rat friend]“."I was in denial and suggested it might be something else, but the rat scenario made sense - it's possible the rat got into thebread at the factory, and no one noticed," Mkumla said.She went back to the shop she'd bought the bread from and was told to lay a complaint directly with the supplier.She sent an email with a video and…arrow_forwardPepsiCo South Africa says the incident where a woman discovered part of a rodent in her loaf of bread, is anisolated occurrence.Durban woman, Nombulelo Mkumla, took to social media last week to share how she discovered the rodent.In a lengthy Facebook post, she said she purchased the loaf of bread from a local shop after work on August 27.For the next days, Mkumla proceeded to use slices of bread from the load to make toast."Then, on the morning of August 31, I took the bread out of the fridge to make toast and noticed something disgusting andscary. I took a picture and sent it to my friends, and one of them said, 'Yi mpuku leyo tshomi' [That's a rat friend]“."I was in denial and suggested it might be something else, but the rat scenario made sense - it's possible the rat got into thebread at the factory, and no one noticed," Mkumla said.She went back to the shop she'd bought the bread from and was told to lay a complaint directly with the supplier.She sent an email with a video and…arrow_forwardThe deaths are included in the discharges; this includes deaths occurring in less than 48 hours and postoperative deaths. Rehabilitation had 362 discharges, 22 deaths, 1<48 hours, 0 Postoperative. what is the gross death rate for the rehabilitation service?arrow_forward
- A copy machine is available 24 hours a day. On a typical day, the machine produces 100 jobs. Each job takes about 3 minutes on the machine, 2 minutes of which is processing time and 1 minute is setup time (logging in, defining the job). About 20 percent of the jobs need to be reworked, in which case the setup time and the processing time have to be repeated. The remainder of the time, the equipment is idle. What is the OEE of the equipment?arrow_forwardHow do you think we can keep updating Toyota's ideas as new technologies come out and what customers want keeps changing?arrow_forwardGiven how TPS has helped change things in so many fields, do you think there are parts of it that might be hard to use in areas that aren’t about making things, like in healthcare or services? If so, why do you think that might be?arrow_forward
- Do you feel there is anything positive about rework?arrow_forwardDo you think technology can achieve faster setup times? How would it be implemented in the hospital workforce?arrow_forwardIn your experience or opinion, do you think process changes like organizing workspaces make a bigger difference, or is investing in technology usually the better solution for faster setups?arrow_forward
- Have you seen rework done in your business, and what was done to prevent that from occurring again?arrow_forwardResearch a company different than case studies examined and search the internet and find an example of a business that had to rework a process. How was the organization affected to rework a process in order to restore a good flow unit? Did rework hurt a process or improve the organization's operational efficiency? • Note: Include a reference with supportive citations in the discussion reply in your post.arrow_forwardSetup time is very important in affecting a process and the capacity of a process. How do you reduce setup time? Give examples of reducing setup time. Please Provide a referenecearrow_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