Mpg excel spreadsheet

fundamental skill in business data analysis is generating and presenting descriptive statistics. Luckily for you, MS Excel has all the tools you need. For this assignment, you are to download a text file, import the file into Excel, use Excel to generate central tendency and dispersion measures, and interpret those measures. You will be using data for gas mileage in cars.

Instructions:

Download the following two files: auto-mpg-names.txtPreview the document and auto-mpg-data.txt. The first file provides a description of the data and the second is the data set itself.
Import the auto-mpg-data file into Excel. For a refresher on importing this file, see the following:
Written explanation (Links to an external site.)
Video explanation (Links to an external site.)
Rename the sheet with the data.
Calculate and interpret central tendency measures (i.e., mean, median and mode) for the following variables: mpg, displacement, horsepower, weight, and acceleration.
Note there are built-in Excel functions for each of these measures.
Place your results in a summary table on a separate sheet, appropriately labelled.
Place your interpretations in a text box beneath the summary table. You might want to compose the interpretations in a word processor then Cut & Paste into the text box.
Calculate and interpret the following dispersion/spread measures for variables listed in Bullet 3: Range, Variance and Standard Deviation.
Again, there are built in Excel function for each of these measures.
Place your results in a summary table on a separate sheet, appropriately labelled. You will now have three sheets.
Place your interpretations in a text box beneath the summary table. You might want to compose the interpretations in a word processor then Cut & Paste into the text box.