Questions from Analytics

Q: In the Excel file Weddings, find the averages and median

In the Excel file Weddings, find the averages and median wedding cost and the sample standard deviation. What would you tell a newly engaged couple about what cost to expect? Consider the effect of po...

Q: Create useful dashboards for each of the following databases. Use

Create useful dashboards for each of the following databases. Use appropriate charts and layouts (for example, Explain why you chose the elements of the dashboards and how a manager might use them.a....

Q: In the Excel file Cell Phone Survey, test the hypothesis

In the Excel file Cell Phone Survey, test the hypothesis that the mean responses for Value for the Dollar and Customer Service do not differ by gender

Q: Use formula (5.23) to obtain a sample of 25 outcomes

Use formula (5.23) to obtain a sample of 25 outcomes for a game of Battleship™ as described in Problem 34. Find the average and standard deviation for these 25 outcomes.In Problem 34The time required...

Q: Find the 10th and 90th percentiles and the 1st and

Find the 10th and 90th percentiles and the 1st and 3rd quartiles for the time difference between the scheduled and actual arrival times in the Atlanta Airline Data Excel file

Q: A formula in financial analysis is: Return on equity =

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

Q: A government agency is putting a large project out for

A government agency is putting a large project out for low bid. Bids are expected from 10 different contractors and will have a normal distribution with a mean of $3.5 million and a standard deviation...

Q: Discuss how you might use business analytics in your personal

Discuss how you might use business analytics in your personal life, such as managing your grocery purchasing, automobile maintenance, budgeting, sports, and so on. Be creative in identifying opportuni...

Q: A survey handed out to individuals at a major shopping

A survey handed out to individuals at a major shopping mall in a small Florida city in July asked the following:• Gender• Age• Ethnicity• Length of residency• Overall satisfaction with city services (...

Q: Develop a realistic retirement planning simulation model for your personal

Develop a realistic retirement planning simulation model for your personal situation. If you are currently employed, use as much information as you can gather for your model, including potential salar...