Questions from Business Analytics

Q: PLE collects a variety of data from special studies, many of

PLE collects a variety of data from special studies, many of which are related to the quality of its products. The company collects data about functional test performance of its mowers after assembly;...

Q: In the Excel file Automobile Quality Ranking, search for and add

In the Excel file Automobile Quality Ranking, search for and add a new column for the country of origin for each brand. Then sort the data from the lowest to highest by number of problems per 100 vehi...

Q: Create clustered column and stacked column charts for the pre-MBA

Create clustered column and stacked column charts for the pre-MBA and post-MBA salary data in the Excel file MBA Motivation and Salary Expectations. Discuss which type of chart you feel is better to u...

Q: The Excel file Transportation provides sales data about 10 different industries.

The Excel file Transportation provides sales data about 10 different industries. Construct two stacked bar charts that will allow you to compare any differences due to time or age groups and draw any...

Q: Construct an appropriate chart to show the sales per unit for the

Construct an appropriate chart to show the sales per unit for the primary industry in the Excel file Primary Industry.

Q: Construct an appropriate chart or charts to visualize the information in the

Construct an appropriate chart or charts to visualize the information in the Budget Forecasting Excel file. Explain why you chose the chart(s) you used.

Q: A survey was conduct for determine the number of vegetarians and non

A survey was conduct for determine the number of vegetarians and non-vegetarians between two different group of age of people. The survey results the followings: Convert the data into percentages for...

Q: Create a useful dashboard for the data in the Excel file President’s

Create a useful dashboard for the data in the Excel file President’s Inn Guest Database. Use the additional information stated in Problem 20 of Chapter 2: Room rates are the same for one or two guests...

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

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

Q: Create a line chart illustrating the number of AM and PM travelers

Create a line chart illustrating the number of AM and PM travelers for each month in the Excel file Traveler.