Find a Population Mean Using a Spreadsheet

In 2012, Toyota claimed to have the most fuel efficient passenger car fleet. Based on mileage estimates from Edmunds.com, the table below shows the mileage of passenger vehicles manufactured by Toyota.

Vehicle Miles per Gallon
Prius C 50
Camry Hybrid LE – 2.5 liter, automatic 41
Camry Hybrid XLE – 2.5 liter, automatic 40
Yaris – 1.5 liter, manual 33
Yaris – 1.5 liter, automatic 32
Corolla – 1.8 liter, manual 30
Corolla – 1.8 liter, automatic 29
Camry – 2.5 liter, automatic 28
Camry – 3.5 liter, automatic 25
Avalon – 3.5 liter, automatic 23

Use this table to find the mean miles per gallon for Toyota passenger vehicles in 2012.

Solution To find the mean using Excel, we’ll use the spreadsheet command AVERAGE.

1. Enter the data from the table into the different cells in the spreadsheet. Column A is not required, but is useful.

stats_excel001

2. Click on cell B13. This is where we will place the mean of the data. Type =AVERAGE( as shown to the right. The command will be shown in the cell as well as the function bar. To indicate the location of the data, type B2:B11. You can also click in cell B2, hold the left mouse button down and drag the cursor to cell B11. Type ) to complete the command.

stats_excel004

3. Press Enter to calculate the mean of the data.

stats_excel002