# Using descriptive statistics | Mathematics homework help

In the news, we are constantly bombarded by statistics such as unemployment rates, stock market swings, or changes in the housing market. A vast majority of the statistical information presented to us is in the form of descriptive statistics. In descriptive statistics, a sample is taken, and values such as mean, median, mode, standard deviation, and variance are determined. These values are used to compare to other samples or are used as a measure of the current state of a population. The use of descriptive statistics is a common practice in the decision-making process in many professional fields.

Don't use plagiarized sources. Get Your Custom Essay on
Using descriptive statistics | Mathematics homework help
Just from \$13/Page

In this assignment, you will use descriptive statistics to make an informed decision—in this case, to decide whether you are going to purchase a new car. Consider the following scenario:

The manufacturer claims that the Brillton EX gets 25 miles per gallon (MPG) in the city and 35 MPG on the highway. However, you are skeptical. You manage to retrieve data for the first Brillton EX models that were tested by a consumer protection agency. This data is available in the following spreadsheet. Click here to review the Excel spreadsheet.

This spreadsheet consists of several tabs:

• Samples: This tab contains all of the different samples tested. These are randomly selected Brillton EX cars. The MPG levels of these cars were measured in the city and on the highway.
• Descriptive Statistics: This tab contains the formulas that will calculate the mean, median, mode, standard deviation, and variance from the sample data.
• Population: This tab contains the mean, median, mode, standard deviation, and variance for the entire population of Brillton EX models.

Instructions:

• On the Samples tab, chose one of the data samples.
• Input the data from the sample you selected into the Sample Data columns on the Descriptive Statistics tab. When you are done, the spreadsheet will automatically determine the mean, median, mode, standard deviation, and variance for this sample.
Note: There is a tab labeled Example to show you how this should work if done properly.