Questions from Business Analytics

Q: Create a useful dashboard for the data in the Excel file Store

Create a useful dashboard for the data in the Excel file Store and Regional Sales Database. Use appropriate charts and layouts and other visualization tools that help to convey the information. Explai...

Q: The worksheet Purchasing Survey in the Performance Lawn Care Database provides data

The worksheet Purchasing Survey in the Performance Lawn Care Database provides data related to predicting the level of business (Usage Level) obtained from a third-party survey of purchasing managers...

Q: Create a useful dashboard for the data in the Excel file Employees

Create a useful dashboard for the data in the Excel file Employees. Use appropriate charts, layouts, and other visualization tools that help to convey the information. Explain why you chose the elemen...

Q: Create a pie chart for all the given dates and a stock

Create a pie chart for all the given dates and a stock chart for the high/low/close prices for March 2018 in the Stock Excel file.

Q: The Excel file Expenditure contains data on a country’s expenditure on various

The Excel file Expenditure contains data on a country’s expenditure on various sports during a particular year. Create a pie chart showing the percentage breakdown of total expenditure.

Q: Create a stacked area chart for the monthly average sales of the

Create a stacked area chart for the monthly average sales of the different types of fuel in the Excel file Average Fuel Sales. What conclusion can you reach?

Q: The Excel file Mortgage Installment provides the monthly installment of a mortgage

The Excel file Mortgage Installment provides the monthly installment of a mortgage loan by different fixed interest rate (%) provided by different banks. Construct a scatter diagram to show the relati...

Q: The Excel file Monthly Visits provides the data for monthly visitors visited

The Excel file Monthly Visits provides the data for monthly visitors visited a playground and the number of shows prepared by the playground organizer during the specific month. Create a scatter diagr...

Q: Construct a column chart for the data in the Excel file Purchasing

Construct a column chart for the data in the Excel file Purchasing Rate to allow comparison of the rate for each product with the date. Would any other charts be better for visually conveying this inf...

Q: A survey handed out to students at a local university in Munich

A survey handed out to students at a local university in Munich, Germany, asked the following: ■ Where do you live? (1- On Campus 2- City 3- Other) ■ How do you feel today? (using a scale of 1–5, ran...