Description

, Chapter: 13 -Problem: 10 >> Calls to the service center at AutoMax occur at a rate of 27 per hour and follow a Poisson distribution. A single operator answers the calls and can handle an average 25 calls per hour with service times following an exponential distribution. If a call arrives while the operator of AutoMax’s phone system is busy with another customer, up to 2 callers may be placed in a queue to await service. If a
Answer Preview: Use the M/M/s with finite queue template in Q xlsx with arrival rate = 27, se…

,

,

,

, Chapter: 9 -Problem: 16 >> Goldtone Chemical Company is developing a new stain-resistant liquid product that can be applied to different types of fabric. The product can be manufactured in different ways that result in different costs and differing levels of stability for application once the product is opened and exposed to air. The stability of the product (measured in minutes) (Y) depends on its acidity (measured by pH l
Answer Preview: Solution: a. The plot suggests that a quadratic model might be appropriate: b. Eight regression func…

, Chapter: 12 -Problem: 5 >> A debate recently erupted about the optimal strategy for playing a game on the TV show called “Let’s Make a Deal.” In one of the games on this show, the contestant would be given the choice of prizes behind three closed doors. A valuable prize was behind one door and worthless prizes were behind the other two doors. After the contestant selected a door, the host would open one of the two remaining
Answer Preview: a. Suppose a contestant is allowed to play this game 500 times, always picks door number 1, and never switches when given the option. If the valuable …

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

, Chapter: 9 -Problem: 5 >> Suppose you are interested in creating a prediction interval for Y at a particular value of X1 (denoted by X1h) using a simple linear regression model and data has not yet been collected. For a given sample size n, how you would attempt to collect the sample data to make the most accurate prediction?
Answer Preview: Answer; To make the most of accurate prediction, consider the following points: For example, in the …

,

,

, Chapter: 10 -Problem: 11 >> Colleges and universities are often interested in identifying their peer institutions. The file named Colleges.xlsm that accompanies this book contains a number of (artificial) metrics for 307 higher education institutions in the United States.a. Use k-means clustering to create 4 clusters for this data (use normalized input data and 100 iterations).b. How many schools are in each cluster?c. How w
Answer Preview: a. The 4 clusters for this data include: i) New England liberal arts colleges ii) Mid-Atlantic research universities (i e., University of Pennsylvania …

, Chapter: 13 -Problem: 2 >> Of the queuing configurations shown in Figure 13.2, which would you prefer to wait in? Explain your response. Figure 13.2 Transcribed Image Text: Customer Arrives Customer Arrives O Waiting Line Waiting Line *** *** O Server Server 1 Server 2 Server 3 Customer Leaves Customer Leaves Customer Leaves
Answer Preview: Naming the options available on a diagram from top to bottom as queueing model 1, model 2, and model …

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

, Chapter: 10 -Problem: 2 >> What is a centroid?
Answer Preview: A centroid is a vector or set of …

,

, Chapter: 14 -Problem: 33 >> Identify a consumer electronics product that you want to purchase (e.g., a TV, digital camera, tablet computer, and so on). Identify at least three models of this product that you would consider purchasing. Identify at least three criteria on which these models differ (e.g., price, quality, warranty, options).a. Create a multicriteria scoring model and radar charts for this decision problem. Using
Answer Preview: a. The product that I will choose is called the Samsung Seri…

,

,

,

,

,

,

,

,

,

,

,

,

, Chapter: 12 -Problem: 25 >> Road Racer Sports, Inc. is a mail-order business dedicated to the running enthusiast. The company sends out full-color catalogs several times a year to several hundred thousand people on its mailing list. Production and mailing costs are fairly expensive for direct mail advertising, averaging about $3.25 per catalog. As a result, management does not want to continue sending catalogs to persons who
Answer Preview: Answer a. The expected profit from a customer who receives six catalogs without placing an order is …

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

Additional Information

10 Reviews for Spreadsheet Modeling And Decision Analysis A Practical Introduction To Business Analytics Textbook Questions And Answers