Author: excelpunks
-
The Logic of the Losing Shoe For those in the casino industry, especially for us surveillance folks, the words ‘losing shoe’ are all too familiar. A losing shoe is a period of play, normally lasting the length of one shoe of cards (which may be from one to as many decks as the shoe can…
-
Predict Your Casino’s Future Earnings from Past Data – Linear Regression Linear regression is a statistical tool for projecting future outcomes based on previous historical data. A good example of this would be using the average wager to win/loss data from patrons to project how much a casino would be making for a particular period.…
-
Creating A Casino Game We’ve discussed the process for the creation of a casino game, namely: Calculating possibilities using combinatorial analysis Calculating the expectation Setting the odds Let’s use a simple example – something I saw in a Chinese drama. The game involves using 5 coins and tumbling them in an opaque container. The container…
-
For My Driving Instructor Download: https://drive.google.com/file/d/0B1pEq2dN7H9AWi1qNHdBY2J1QVk/view?usp=sharing I came across an interesting situation with my driving instructor. He was collating a list of all the lessons the instructors in his team had taught for the day and the result of the lesson, being a pass or fail. He was collating this data by hand and I…
-
We have seen how knowing the expectation enables us to set the odds of games. If you recall, the formula for calculating the expectation for any wager is : (Probability of winning x the amount a wager would win) – (Probability of losing x the amount a wager would lose) So, if you wanted to…
-
Hi Everyone, Requirements: Excel ver. 2007 Download: Essential Excel in a Day Excelpunks would like to present its very own Excel course, Essential Excel in A Day. The course includes: Step-by-step instructions on some of the most useful Excel functions, like CONCATENATE, SUMIF and Pivot Tables Sample data to practise with Examples of each lesson…
-
What if you wanted to compare different areas with different numbers of machines on your gaming floor? What if you wanted to know if a certain area was receiving more profit than another? In a previous post, we looked at how we can measure the effects of a change in machine settings on the earnings…
-
Roulette – An Analysis Roulette is played by spinning a ball around a wheel. The wheel contains 37 to 38 numbered pockets from 0 to 36 for a 37-numbered wheel and 00 and 0 to 36 for a 38-numbered wheel. The winning number is decided by which numbered pocket the ball comes to rest on. …
-
Chi2 The Chi2 distribution tests for the difference between the observed and the expected in terms of frequencies. We can apply this to a simple example: In double-zero roulette, we have 38 numbers and the expected probability of any one of these numbers appearing is 1/38 or 0.026316 or 2.6316%. Now, assuming you track all…
-
Sic-Bo is really popular in Asia. This game involves 3 dice in a tumbler or variant which is tumbled, with varying payments for specific combinations of the dice. There is an amazing way to calculate how many possible outcomes for a particular score from 3 six-sided dice there can be. This involves the use of…
excelpunks. Training - Consultancy - Solutions. 