Questions from Business Analytics

Q: Construct PivotTables showing the counts of region versus social media platform market

Construct PivotTables showing the counts of region versus social media platform market share, and tablet versus mobile device usage in Asia in the Excel file Social Media Market share. What might you...

Q: The time required to play the Pandemic board game is uniformly distributed

The time required to play the Pandemic board game is uniformly distributed between 45 and 60 minutes. Use formula to obtain a sample of 50 outcomes and compute the mean, minimum, maximum, and standard...

Q: The exponential distribution of the amount of time a car battery lasts

The exponential distribution of the amount of time a car battery lasts has a mean of 4 years. Generate 20 random variates from this distribution as whole Numbers.

Q: Historical data shows that the birth weight of a random pool of

Historical data shows that the birth weight of a random pool of 3,226 newborn babies with a mean of 3.39 kg and a standard deviation of 0.55 kg per baby, is normally distributed, but never more than 6...

Q: A formula in financial analysis is the following: Return on equity

A formula in financial analysis is the following: Return on equity = net profit margin * total asset turnover * equity multiplier. Suppose that the equity multiplier is fixed at 3.5, but that the net...

Q: A government body is putting a large project out for low bid

A government body is putting a large project out for low bid. Bids are expected from eight contractors and will have a normal distribution with a mean of $4.2 million and a standard deviation of $0.27...

Q: Suggest additional generic examples of linear optimization models in the format based

Suggest additional generic examples of linear optimization models in the format based on your work experience, personal interests (hobbies, etc.), or information found in business articles.

Q: Malloy Milling grinds calcined alumina to a standard granular size. The

Malloy Milling grinds calcined alumina to a standard granular size. The mill produces two different size products from the same raw material. Regular grind can be produced at a rate of 10,000 pounds p...

Q: Implement the linear optimization model that you developed for Valencia Products on

Implement the linear optimization model that you developed for Valencia Products on a spreadsheet and use Solver to find an optimal solution. Interpret the Solver Answer Report, identify the binding c...

Q: Implement the linear optimization model that you developed for ColPal Products on

Implement the linear optimization model that you developed for ColPal Products on a spreadsheet and use Solver to find an optimal solution. Interpret the Solver Answer Report, identify the binding con...