Questions from Analytics

Q: Create a PivotTable to find the average amount of travel

Create a PivotTable to find the average amount of travel expenses for each sales representative in the Excel file Travel Expenses. Illustrate your results with a PivotChart

Q: Create a new worksheet in the Retirement Portfolio workbook. In

Create a new worksheet in the Retirement Portfolio workbook. In this worksheet, add a list box form control to allow the user to select one of the mutual funds on the original worksheet, and display a...

Q: A college is trying to determine if there is a

A college is trying to determine if there is a significant difference in the mean GMAT score of students from different undergraduate backgrounds who apply to the MBA program. The Excel file GMAT Scor...

Q: Using the matrix of intercity distances in the American Baseball

Using the matrix of intercity distances in the American Baseball League file, add list box form controls so that the user can choose two cities (using two list boxes) and find the distance between the...

Q: Problem 15 in Chapter 1 posed the following situation: A

Problem 15 in Chapter 1 posed the following situation: A manufacturer of mp3 players is preparing to set the price on a new model. Demand is thought to depend on the price and is represented by the mo...

Q: Problem 16 in Chapter 1 posed the following situation: The

Problem 16 in Chapter 1 posed the following situation: The demand for airline travel is quite sensitive to price. Typically, there is an inverse relationship between demand and price; when price decre...

Q: Use the Markdown Pricing Model spreadsheet model and a two-way

Use the Markdown Pricing Model spreadsheet model and a two-way data table to find the total revenue if days at full retail vary from 20 to 40 in increments of 5 and the intermediate markdown varies fr...

Q: The weekly price at an extended-stay hotel (renting by the

The weekly price at an extended-stay hotel (renting by the week for business travelers) is $950. Operating costs average $20,000 per week, regardless of the number of rooms rented. Construct a spreads...

Q: In the Excel file Credit Risk Data, test the hypotheses

In the Excel file Credit Risk Data, test the hypotheses that the number of months employed is the same for applicants with low credit risk as those with high credit risk evaluations. Use a level of si...

Q: The worksheet Base Data in the Excel file Credit Risk

The worksheet Base Data in the Excel file Credit Risk Data provides information about 425 bank customers who had applied for loans. The data include the purpose of the loan, checking and savings accou...