Questions from Business Analytics

Q: Use a PivotTable to find the mean annual income by level of

Use a PivotTable to find the mean annual income by level of education for the data in the Excel file Education and Income.

Q: In the Excel file Debt and Retirement Savings, use a PivotTable

In the Excel file Debt and Retirement Savings, use a PivotTable to find the mean and standard deviation of income, long-term debt, and retirement savings for both single and married individuals.

Q: The CFO at Performance Lawn Equipment, Brian Ferguson, wishes to

The CFO at Performance Lawn Equipment, Brian Ferguson, wishes to design a minimum variance portfolio of index funds to invest some of the firm’s cash reserves. The funds selected for...

Q: Using PivotTables, find the mean and standard deviation of sales by

Using PivotTables, find the mean and standard deviation of sales by region in the Sales Transactions database.

Q: Use the Excel file Graduation Employment to analyze the average salary and

Use the Excel file Graduation Employment to analyze the average salary and the average percentage of failure rate in interviews among the graduates from the different colleges. What conclusions do you...

Q: For the Peoples Choice Bank database, use PivotTables to find the

For the Peoples Choice Bank database, use PivotTables to find the average transaction amount for each account and branch.

Q: Find the correlation between weekly food expenditure and monthly household income in

Find the correlation between weekly food expenditure and monthly household income in the Excel file Food Expenditure.

Q: Use the Excel file Test Scores and Sales, developed by nine

Use the Excel file Test Scores and Sales, developed by nine salespersons during the past year, to find the coefficient of correlation between the test scores and sales.

Q: The Excel file House Sales lists a sample of the area (

The Excel file House Sales lists a sample of the area (in sq. ft) and prices (in dollars) of various houses. Compute the covariance and correlation between the area and prices.

Q: For the Excel file TV Viewing Survey, is there a significant

For the Excel file TV Viewing Survey, is there a significant correlation between (1) the number of TVs in a home and the hours of viewing per week, and (2) age and hours of viewing per week?