Brain Teasers

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
I think everbody knows this one

4 hostages being held by an armed guard. 3 are one side of a wall and the other is on the other. Each has had a hat put on their head, there are two blue hats and two red hats. Everyone is facing the wall and can't turn round. The guard says that if anyone can correcly guess the colour of their hat the will all be saved, but if anyone guesses wrongly they will all be killed.
Who shoulld call out their colour to guarantee their safety.


x.................x......................x......................¦......................x
 
Can the person by himself see over the wall?

If so, then he can see what the other three hats are and he should call his own color based on this information.
 
No He can't

As a bit of a clue, the person to call out can be one of two people depending on the circumstance

Also just to clarify in case it wasn't clear, the person furthest from the wall can see the two in front, and the middle person can see the one in front of him
 
Last edited:
If the guy farthest from the wall sees two hats of the same color (say, red), he knows his is of the opposite color (blue).

If the guy farthest from the wall hesitates/doesn't say anything, the middle guy would know that he has a different colored hat than the one guy he can see and could speak up accordingly.

Here's one for you (from Seth Godin's blog):

Let's say your goal is to reduce gasoline consumption.

And let's say there are only two kinds of cars in the world. Half of them are Suburbans that get 10 miles to the gallon and half are Priuses that get 50.

If we assume that all the cars drive the same number of miles, which would be a better investment:

(1) Get new tires for all the Suburbans and increase their mileage a bit to 13 miles per gallon.
(2) Replace all the Priuses and rewire them to get 100 miles per gallon (doubling their average!)
 
Let's say your goal is to reduce gasoline consumption.

And let's say there are only two kinds of cars in the world. Half of them are Suburbans that get 10 miles to the gallon and half are Priuses that get 50.

If we assume that all the cars drive the same number of miles, which would be a better investment:

(1) Get new tires for all the Suburbans and increase their mileage a bit to 13 miles per gallon.
(2) Replace all the Priuses and rewire them to get 100 miles per gallon (doubling their average!)
Tires win:)
For every thousand milles driven by each group, increasing the Suburban mpg by 30% ( 10 mpg to 13 mpg) reduces gas consumption by ~23 gallons, while doubling the mpg of the prius group (50 mpg to 100 mpg) only saves 10 gallons.
 
This question has 2 possible answers.

1. Reducing gasoline consumption

or

2. Reduction Percentage to the vehicles standard MPG

If you go with option 2 then Cindy is correct, but if you go with option 1, then the Prius is still the best investment, because you will reduce gasoline consumption overall.

In other words, while the GMC reduced its gasoline usage by more gallons, it still used way more gasoline than the Prius.

At it's best it uses approximately 76 gallons of gasoline, while the Prius only uses 10. I would go with the Prius.

Excel Workbook
ABCD
1Miles Driven: 1000
2
3
4SuburbanGallons UsedPriusGallons Used
510 mpg10050 mpg20
613 mpg76.92307692100 mpg10
7Gallons Saved23.0810
8(Rounded to 2 decimal places)
Sheet1
 
Last edited:
Correction, the Suburban used more gasoline overall.
 
??
The way I read it, we don't get to change the proportion of cars or the proportion of miles driven (50/50 proportion, and equal miles driven by each), so the best investment for "society" or for a company trying to reduce gasoline consumption would be to do the tire change.
Before any change, 2000 miles driven overall (half by prius and half by suburban) would require 120 gallons of gas. If we invest in doubling the mpg of prius, with no other change, the same 2000 miles would now require 110 gallons of gas. On the other hand, if we change the tires on the suburban to magic tires that get 13 mpg instead of 10 mpg, the same 2000 miles requires only ~87 gallons of gas.
 
My example uses the same number of miles for both vehicles: 1000

For the Suburban to travel 1000 miles at 13 mpg, it takes a little less than 77 gallons to do it.

A Prius to travel 1000 miles at 100 mpg, takes 10 gallons.

The car that takes 10 gallons to drive a 1000 miles uses significantly less gasoline than the vehicle that travels at 13 mpg.

Since the goal is to reduce gasoline consumption, the Prius does a better job of this than the Suburban does.

Before any change both vehicles combined used 120 gallons of gas.
After both vehicles were changed, the combined usage of gasoline was approximately 86.92 gallons, the majority of this was used by the Suburban. The Prius only using 10 gallons of it.

You can pick any mileage amount you want as long as they are equal for both vehicles, but proportionately the results will be the same.
 
Last edited:

Forum statistics

Threads
1,223,757
Messages
6,174,327
Members
452,555
Latest member
colc007

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top