Questions from Analytics

Q: Refer back to the college admission director scenario (Problem 36

Refer back to the college admission director scenario (Problem 36 in Chapter 11). Develop a spreadsheet model and identify uncertain distributions that you believe would be appropriate to conduct a Mo...

Q: Use the Outsourcing Decision Model Excel file to compute the

Use the Outsourcing Decision Model Excel file to compute the cost of in-house manufacturing and outsourcing for the following levels of demand: 800, 1000, 1200, and 1400. Use this information to set u...

Q: For the car-rental situation described in Problem 3, assume that

For the car-rental situation described in Problem 3, assume that you researched insurance industry statistics and found out that the probability of a major accident is 0.05% and that the probability o...

Q: For the DoorCo Corporation decision in Problems 2 and 9,

For the DoorCo Corporation decision in Problems 2 and 9, construct a decision tree and compute the rollback values to find the best expected value decision.In Problems 9For the DoorCo Corporation deci...

Q: For the car-rental decision in Problems 3 and 10, construct

For the car-rental decision in Problems 3 and 10, construct a decision tree and compute the rollback values to find the best expected value decision.In Problems 10For the car-rental situation describe...

Q: Bev’s Bakery specializes in sourdough bread. Early each morning, Bev

Bev’s Bakery specializes in sourdough bread. Early each morning, Bev must decide how many loaves to bake for the day. Each loaf costs $1.25 to make and sells for $3.50. Bread left over at the end of t...

Q: Using the data in the Excel file Freshman College Data,

Using the data in the Excel file Freshman College Data, use ANOVA to determine whether significant differences exist in the mean retention rate for the different colleges over the 4-year period. Secon...

Q: A patient arrives at an emergency room complaining of abdominal

A patient arrives at an emergency room complaining of abdominal pain. The ER physician must decide on whether to operate or to place the patient under observation for a non-appendix-related condition....

Q: Create a PivotTable for the data in the Excel file

Create a PivotTable for the data in the Excel file Weddings to analyze the wedding cost by type of payor and value rating. What conclusions do you reach?

Q: The Excel file President’s Inn Guest Database provides a list

The Excel file President’s Inn Guest Database provides a list of customers, rooms they occupied, arrival and departure dates, number of occupants, and daily rate for a small bed-and-breakfast inn duri...