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.

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.

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