Questions from Business Analytics

Q: Return on investment (ROI) is profit divided by investment.

Return on investment (ROI) is profit divided by investment. In marketing, ROI is determined as incremental sales times gross margin minus marketing investment, all divided by marketing investment. Sup...

Q: In the Accounting Professionals database, use Excel functions to find

In the Accounting Professionals database, use Excel functions to find a. the maximum number of years of service. b. the average number of years of service. c. the number of male employees in the datab...

Q: A company forecasts its net revenue for the next three years as

A company forecasts its net revenue for the next three years as $172,800, $213,580, and $293,985. Find the net present value of these cash flows, assuming a discount rate of 4.2%.

Q: Use the Histogram chart to construct histograms for weekly usage and waiting

Use the Histogram chart to construct histograms for weekly usage and waiting time in the Excel file Car Sharing Survey.

Q: Elizabeth Burke has received several questions from other PLE managers regarding quality

Elizabeth Burke has received several questions from other PLE managers regarding quality, customer satisfaction, and operational performance. She would like you to summarize some data from the Perform...

Q: Figure 2.41 shows the 2016 U.S. federal

Figure 2.41 shows the 2016 U.S. federal income tax rates for the four different types of filing status. Suppose an individual is single. Write one logical IF function that will determine the correct t...

Q: For the Base Data in the Excel file Credit Risk Data,

For the Base Data in the Excel file Credit Risk Data, use the Histogram chart to develop a histogram with a bin width of 5 for the number of months as a customer of the bank.

Q: Create box-and-whisker charts for each type of cost

Create box-and-whisker charts for each type of cost of living adjustment in the Excel file Cost of Living Adjustments.

Q: Define range names for all the data and model entities in the

Define range names for all the data and model entities in the Break-Even Decision Model spreadsheet and apply them to the formulas in the model.

Q: Define range names for all the entities in the Crebo Manufacturing Model

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