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
- Gas Totals (Price) -- How much did it cost for each fill up?
- Calculate the Gas Mileage -- What was the gas mileage
economy) between each fill up?
- Totals -- Total all columns.
- Averages -- Average all columns.
- 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:
In the body of the email, number 1 through 9, and answer the following:
- What was the average gas mileage?
- Were there any trends in gas mileage? If so, what was the trend?
- How did unit price change? Was it a continuous change?
- What would improve gas mileage?
- Estimate the amount of gasoline used in one full year.
- About how many gallons of gasoline was the typical fill up?
- How often was the car filled with gasoline?
- Does it look like there were receipts missing? If so, what would be
the approximate dates of those receipts?
- 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.