Unit 1: Assignment

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

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.

Do you need help with this assignment or any other? We got you! Place your order and leave the rest to our experts.

Quality Guaranteed