Questions from Business Analytics

Q: Define range names for all the entities in the Hotel Overbooking Model

Define range names for all the entities in the Hotel Overbooking Model spreadsheet and apply them to the formulas in the model.

Q: Discuss the use of business analytics in sports, such as tennis

Discuss the use of business analytics in sports, such as tennis, cricket, swimming, and football. Identify as many opportunities as you can for each.

Q: A tablet manufacturer is preparing to set the price of a new

A tablet manufacturer is preparing to set the price of a new model. It examines the demand and cost structure, and determines the following model to represent the relationship between demand and price...

Q: In this chapter, we noted the importance of defining and analyzing

In this chapter, we noted the importance of defining and analyzing a problem prior to attempting to find a solution. Consider this example: One of the earliest operations research groups during World...

Q: A part-time professor of a business program at a university

A part-time professor of a business program at a university in Germany always tells her students that one of the first questions they should ask their new employers is whether the organization has a g...

Q: How might analytics be used in the following situations? a

How might analytics be used in the following situations? a. Planning a business b. Understanding customer behavior c. Solving human resource problems

Q: For the Cereal database, write a logical IF function that enters

For the Cereal database, write a logical IF function that enters “Review” in column M if the rating is more than 45 and the sales is less than 150; if not, then enter a blank.

Q: Swissotel, London, is working on improving customer satisfaction and engagement

Swissotel, London, is working on improving customer satisfaction and engagement. At the same time, Swissotel wants to ensure that the staff members are also satisfied. It has noticed that there are se...

Q: Develop a spreadsheet for computing the demand for any values of the

Develop a spreadsheet for computing the demand for any values of the input variables in the linear demand and nonlinear demand.

Q: Construct histograms using the Histogram chart for the gross sales and gross

Construct histograms using the Histogram chart for the gross sales and gross profit data in the Excel file Sales Data.