## Sunday, May 15, 2011

### New Resource for Deal or No Deal Probability Game

Mr. Faris, a reader from the Federated States of Micronesia (shout out to all of my readers around the world!) took my Deal or No Deal probability game and created a spreadsheet that calculates the bankers' offer for you.  In the original card game, the bank offer is based on a randomly drawn card, not on the prize amounts left on the board.  Thus you often get offers that make no sense, which can take away from the game experience.

As he explains: "It calculates the banker's offer for you.  I came up with the formula for the offer by studying data from game shows.  It is very accurate and useful.  One variable I think is used in the real formula which I did not use is whether the expected value has gone up or down since the previous round."  There's also a version of the score cards included as a second worksheet.

Huge thanks to Mr. Faris for sharing this resource!

Original post: Lesson Idea: Probability using Deal or No Deal

Michelle said...

I love this idea -- great for teaching data management and probability! Thank you for sharing!

Michelle (OurClassroomCDN)

Anonymous said...

I would love to use this with my class, but I can't seem to figure out how to use the spreadsheet - I can't delete anything. Any ideas?

Mr. D said...

Yes, click on File, then Download As and pick the format you'd like. Then you can edit away!