Spreadsheet - Gasoline

Part I -- Set Up Sheet

Make a spreadsheet to analyze gasoline consumption.

Watch this video to begin.

Make your sheet like the picture below. (Skip rows 1 through 4.)

Part II -- Fill In Sheet

Use the receipts below to fill in the sheet.  Leave "Gas Total" and "Mileage" blank.

Part III -- Use Formulas

1. Gas Totals (Price) -- How much did it cost for each fill up?
2. Calculate the Gas Mileage -- What was the gas mileage (fuel economy) between each fill up?
3. Totals -- Total all columns.
4. Averages -- Average all columns.
5. Delete -- Delete the averages that don't make any sense. Delete the totals that don't make any sense.

Part IV -- Analyze the Results

Compose an email to your teacher with the subject line: Gasoline.

Make sure you are using your teacher's correct email address, for example: wissnera@waylandunion.net

In the body of the email, number 1 through 9, and answer the following:

1. What was the average gas mileage?
2. Were there any trends in gas mileage?  If so, what was the trend?
3. How did unit price change?  Was it a continuous change?
4. What would improve gas mileage?
5. Estimate the amount of gasoline used in one full year.
6. About how many gallons of gasoline was the typical fill up?
7. How often was the car filled with gasoline?
8. Does it look like there were receipts missing?  If so, what would be the approximate dates of those receipts?
9. Estimate the number of miles the car travels in a year.

Send the email.

Raise your hand to let your teacher know you have finished this assignment

This work by Aaron Wissner is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 United States License.