Business Analytics

Unit 1: Assignment

In this Assignment, you will be assessed based on the following outcome: GB513-1: Illustrate business situations through graphs and tables.

This Assignment requires you to use Excel to answer the questions and create the charts as specified in the file below. However, when presenting reports in business, you will find that most managers will prefer to read Word documents or PowerPoint slides rather than go through Excel sheets. Being able to move your work from Excel to Word is a valuable skill. For this Assignment, prepare a report by copying all your charts and comments to a Word document and submit that Word file as your Assignment. Clearly label all questions and charts as well as your answers. Make sure to review your grading Rubric.

Using Data Analysis in Excel

Before any data analysis can be performed using Excel, the Data Analysis Tool must first be installed on your computer. This will help you to successfully follow this tutorial.

Once the tool is installed, you can input data to create descriptive statistics. Follow the steps in the video tutorial and try to get the correct result.

Question 1

According to T-100 Domestic Market, the top seven airlines in the United States by domestic boarding in a recent year were Southwest Airlines Co. with 81.1 million, Delta Air Lines Inc. with 79.4 million, American Airlines, Inc. with 72.6 million, United Airlines, Inc. with 56.3 million, Northwest Airlines Corp. with 43.3 million, US Airways with 37.8 million, and Continental Airlines with 31.5 million. Using Excel, construct a pie chart and a bar graph to depict this information.

Question 2

Review the Week 2 Data Set.

Create and calculate the following in Excel^®:

1. Create a Pie Chart which summarizes colors of the cars in the sample.
2. Create a Bar Chart which summarizes the frequency of the models of the cars in the sample.
3. Create a Frequency Table for classes of MPG, including Frequency and Relative Frequency for the cars in the sample
4. Calculate the mean Days in Inventory for the cars in the sample and compare that to the median and the mode. Highlight the value that would be a better representation of the “typical” days in inventory.
5. Calculate the standard deviation of the Days in Inventory for the cars in the sample.
6. Calculate the 5 number summary for the suggested retail prices of the cars in the sample. This consists of the 1st, 2nd, 3rd, 4th quartile and the IQR.