Questions from Business Analytics

Q: Construct an influence diagram for profit in the single-period purchase

Construct an influence diagram for profit in the single-period purchase decision (Newsvendor Model) discussed in this chapter. Use Excel’s Formula Auditing capability to demonstrate the relationship b...

Q: Construct an influence diagram for the net revenue in the overbooking decision

Construct an influence diagram for the net revenue in the overbooking decision model discussed in this chapter. Use Excel’s Formula Auditing capability to demonstrate the relationship between the spre...

Q: Construct an influence diagram for the staffing model in Example 11.

Construct an influence diagram for the staffing model in Example 11.7. Data from Example 11.7: Suppose that the manager of a loan-processing department wants to know how many employees will be need...

Q: Use the RAND function to generate 100 exponential random variates with the

Use the RAND function to generate 100 exponential random variates with the mean 1.5, and create a frequency distribution and a histogram with bins of width 0.5. Apply the chi-square goodness of fit te...

Q: A metal pistons manufacturer conducts a marketing research and finds that for

A metal pistons manufacturer conducts a marketing research and finds that for every 10 pistons made, an average of 12% of its pistons are rejected because they are not correctly sized. Generate 20 ran...

Q: In the Olympic bid proposal discussed, ticket sales revenue was estimated

In the Olympic bid proposal discussed, ticket sales revenue was estimated to be a triangular distribution with minimum= $560 million, maximum= $600 million, and most likely = $600 million. Generate a...

Q: A research study on the duration of two-month-old

A research study on the duration of two-month-old babies’ smile was carried out. Analysts created the following distribution, which were assumed to be uniform over various intervals,...

Q: Develop an Excel template for computing the IQ scores obtained by males

Develop an Excel template for computing the IQ scores obtained by males and females based on the brain size (in count obtained from MRI scans, count/10,000), height (in inches) and weight (in pounds)....

Q: Use the profit model developed to implement a financial simulation model for

Use the profit model developed to implement a financial simulation model for a new product proposal and determine a distribution of profits using the discrete distributions below for the unit cost, de...

Q: The Excel file Outsourcing Decision Model is a spreadsheet implementation of the

The Excel file Outsourcing Decision Model is a spreadsheet implementation of the model. The model calculates the total cost for manufacturing and outsourcing. The key outputs in the model are the diff...