- Have any questions?
- +1 339 970-5514
- +44 744 1907919
- support@bishopswritingbureau.com

fuel economies

Automobiles have different fuel economies (mpg), and commuters drive different

distances to work and school. Suppose that you are interested in estimating the

average monthly fuel consumption of commuters in Valparaiso for the upcoming

month of October. You might consider collecting information from a sample of

residents and students in Valparaiso about their estimated number of miles driven

each day in October, the days they expect to drive each day in October, and the

number of miles per gallon (mpg) for each oftheir vehicles.

1. Create a spreadsheet model that will predict the number of gallons of

gasoline a resident or student will to purchase each month.

2. Suppose that a Landon expects to commute 24 miles round trip 20 days in

October in a Honda Civic that achieves 3ompg fuel economy.

What is the total number of miles Landon is expected to drive in October?

How many gallons of gasoline should the resident expect to use in October?

3. Suppose that Landon is considering purchasing one of the following vehicles.

Use the VLOOKUP function so that when you enter the model vehicle, the

correct “mpg” will be displayed and used in your model calculations.

Model MPG

Audi 19

Chevrolet 26

Ford 28

Honda 32

Kia 21

Volvo 25

Organize your spreadsheet effectively, use formatting, and functions appropriately:

0 Color the “input cell(s)s” yellow, the “processing” cell(s)s orange, and the

output” result cell(s) green.

0 Place a border around cells that display a number.

0 Include a heading on your spreadsheet on a row above your model.

0 Format the heading as Arial, 14pt

0 Format the cell containing the gallons used as Number with 2 decimals

PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET AN AMAZING DISCOUNT 🙂