Questions from Analytics

Q: Data obtained from a county auditor in the Excel file

Data obtained from a county auditor in the Excel file Home Market Value provide information about the age, square footage, and current market value of houses along one street in a particular subdivisi...

Q: Create a pie chart showing the breakdown of occupations for

Create a pie chart showing the breakdown of occupations for each year in the Science and Engineering Jobs Excel file, and contrast these with simple column charts

Q: For the Koehler Vision Associates model you developed in Problem

For the Koehler Vision Associates model you developed in Problem 13, use data tables to study how revenue is affected by changes in the number of appointments accepted and patient demand.In Problem 13...

Q: For the stockbroker model you developed in Problem 10, use

For the stockbroker model you developed in Problem 10, use data tables to show how the commission is a function of the number of calls made.In Problem 10A stockbroker calls on potential clients from r...

Q: Develop a spreadsheet model to determine how much a person

Develop a spreadsheet model to determine how much a person or a couple can afford to spend on a house. Lender guidelines suggest that the allowable monthly housing expenditure should be no more than 2...

Q: For the nonprofit ballet company fundraising model you developed in

For the nonprofit ballet company fundraising model you developed in Problem 11, use a data table to show how the amount varies based on the number of solicitations.In Problem 11The director of a nonpr...

Q: Use PivotTables to find the number of loans by different

Use PivotTables to find the number of loans by different purposes, marital status, and credit risk in the Excel file Credit Risk Data. Illustrate the results on a PivotChart

Q: A bank has historically found that the average monthly charges

A bank has historically found that the average monthly charges in recent years on its credit card were $1,350. With an improving economy, they suspect that this has increased. A sample of 42 customers...

Q: For the garage-band model you developed in Problem 7, define

For the garage-band model you developed in Problem 7, define and run some reasonable scenarios using the Scenario Manager to evaluate profitability for the following scenarios:,,,

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

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