Questions from Business Analytics

Q: Identify the bins for number of letters, width, and height

Identify the bins for number of letters, width, and height in the provided data in the Excel file Letter. Then use the Histogram tool to compute frequency distributions and cumulative relative frequen...

Q: Use a PivotTable to construct a frequency distribution and histogram of lunch

Use a PivotTable to construct a frequency distribution and histogram of lunch sales amounts in the Restaurant Sales database.

Q: Part 1: The Performance Lawn Equipment Database contains data needed to

Part 1: The Performance Lawn Equipment Database contains data needed to develop a pro forma income statement. Dealers selling PLE products all receive 18% of sales revenue for their part of doing busi...

Q: Use a PivotTable to develop a frequency distribution with six bins for

Use a PivotTable to develop a frequency distribution with six bins for the age of individuals in the Base Data worksheet in the Credit Risk Data file. Compute and chart the relative and cumulative rel...

Q: Use a PivotTable to construct a frequency distribution and histogram for GPA

Use a PivotTable to construct a frequency distribution and histogram for GPA in the Excel file Grade Point Averages.

Q: Find the 25th and 70th percentiles of the costs in the Excel

Find the 25th and 70th percentiles of the costs in the Excel file Road Construction. Use formula (4.3), the Excel PERCENTILE.INC function, and the Rank and Percentile tool, and compare the results.

Q: Find the first, second, and third quartiles for the combined

Find the first, second, and third quartiles for the combined amounts of checking and savings accounts in the Excel file Credit Risk Data and interpret the results.

Q: Find the first, second, and third quartiles for the sales

Find the first, second, and third quartiles for the sales amounts in the Sales Transactions database and interpret the results.

Q: Use PivotTables to construct cross-tabulations for (1) neighborhood

Use PivotTables to construct cross-tabulations for (1) neighborhood and improvement and (2) neighborhood and structure home for the Excel file Home.

Q: Use PivotTables to construct cross-tabulations between each pair of variables

Use PivotTables to construct cross-tabulations between each pair of variables in the Excel file Beverage Preferences