Questions from Business Analytics

Q: For the engineering admissions, apply two-way data tables to

For the engineering admissions, apply two-way data tables to analyze the impact on extra funds needed and the number of students who accept scholarships as the acceptance rate and number of offers var...

Q: Vision Clinic in Brussels, Belgium, specializes in laser-assisted

Vision Clinic in Brussels, Belgium, specializes in laser-assisted corrective eye surgery. Prospective patients make appointments for prescreening exams to determine their candidacy for the surgery. If...

Q: A company is trying to predict the long-run market share

A company is trying to predict the long-run market share of a new men’s deodorant.10 Based on initial marketing studies, they believe that 40% of new purchasers in this market will ultimately try this...

Q: For the Sunday bazaar model that you developed, use the Scenario

For the Sunday bazaar model that you developed, use the Scenario Manager to evaluate profitability for the following scenarios:

Q: Think of any retailer that operates many stores throughout the country,

Think of any retailer that operates many stores throughout the country, such as Old Navy, Hallmark Cards, or Vineyard Vines, to name just a few. The retailer is often seeking to open new stores and ne...

Q: For the gasoline usage, apply the Goal Seek tool to find

For the gasoline usage, apply the Goal Seek tool to find the fuel economy needed to consume 20 gallons per month, with all other data being constant.

Q: Suppose that an electricity supplier in your country offers specific rates to

Suppose that an electricity supplier in your country offers specific rates to domestic consumers. For the first 2,000 units of electricity consumed, it charges €0.14 per unit; and if more than 2,000 u...

Q: For the stockbroker, use the Goal Seek tool to find the

For the stockbroker, use the Goal Seek tool to find the number of calls needed to achieve a broker commission of $5,000.

Q: For the ballet company, use the Goal Seek tool to find

For the ballet company, use the Goal Seek tool to find the number of solicitations required to achieve $150,000 in total donations.

Q: A manufacturing company make their sales by visiting the customers personally to

A manufacturing company make their sales by visiting the customers personally to market their products. They want to determine the impact of these sales visits on the total profit earned by their sale...