Requirements: •Windows 7 and above •.Net 4.5.2 compatibility •SQL compatibility Pricing: 500 USD Demo Video: https://youtu.be/HbI2H0-La4A You are a casino owner, gaming manager or surveillance manager. You have a feeling that something is going down at the roulette tables, but you can’t put your finger on it. Looking for a method to calculate the probabilities? Excelpunks puts the statistics into this equation with Roulette Analysis! •Includes analyses for Single and Double Zero roulette •Probability alerts immediately inform you of improbable results. •Round-By-Round Analysis and Entire Game Analysis: Occurrence of Specific numbers Win/Loss analysis on all wager types Win/Loss analysis on Specific Numbers Win/Loss analysis of the game as a whole •Custom Analysis •Win/Loss analysis of any combination of any number of games Let robust statistical principles do the math for you. Think that your player is winning more than he should? Let Roulette Analysis prove it mathematically! Get in touch with us at firstname.lastname@example.org for details!
Requirements: Windows 7 and above .NET Framework SQL server compatibility Contact us at email@example.com for details! Demonstration Video: Features: User-friendly interface with drag and drop functionality Comprehensive details presented in an easily navigable format. Compatibility with Excel – retrieve and upload large amounts of information using Excel into and out of the system. Customizable user access levels define how much access each user has to report and access data. Integrated Incident Reporting platform with Baccarat Analysis for comprehensive reporting on losing shoes. Automatic report data generates upon loading – presenting the number of reports created by respective users and categories. Print reports individually or by batch Password Protected Log-ins Password protection for all log-ins. Reports are uniquely identified by the user’s log-in name. Incident Reporting Standardized reporting made easy with drop-down lists for incident categories, locations, staff and subject profiles. Dynamic report list generation allows you to scroll through all selected reports Subject and Staff Profiles Dynamic profile list generation allows you to scroll through all selected profiles Attach
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 hold!), which registers a substantial loss. Ever wondered how that loss limit was set? In considering this question, it is useful to once again refer to our central limit theorem. Here is the graph again. (Source: http://schools-wikipedia.org/) The central limit theorem proposes that up to 99.9% of all occurrences happen between -3 to -1 and 1 to 3 σs from the average or mean. σ extends into the positive (meaning 1 to 3 σ) and negative (meaning -1 to -3 σ). In order to derive any sort of boundary in a casino game, one has to calculate the following: Probability Of Events Occurring (for more
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 of a group of slot machines, using a dependent T-Test. For the post, see here: https://excelpunks.com/comparisons-using-t-tests/ If you recall, a dependent T-test compares the differences in means of data with identical sample sizes before and after treatment – our data being the earnings of a slot machine and the treatment being a change in settings. An independent T-test allows us to compare data sets with different numbers of samples to determine if they are statistically different. Here’s an example: A casino has 2 slot zones, Zone 1, with 5 machines and Zone 2, with 10 machines. We want to find out if one area is
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. Payment is then made based on where a player has wagered on a layout displaying all the numbers on the wheel. This table assesses the wagers for Single-Zero (European) Roulette: European Roulette (Single Zero) Wager Numbers covered Probability (Win) Probability (Loss) Expectation Break-even odds Straight Up 1 0.02703 0.97297 -0.94595 36.00 Split 2 0.05405 0.94595 -0.89189 17.50 Street 3 0.08108 0.91892 -0.83784 11.33 Corner 4 0.10811 0.89189 -0.78378 8.25 6-Line 6 0.16216 0.83784 -0.67568 5.17 Dozen 12 0.32432 0.67568 -0.35135 2.08 Column 12 0.32432 0.67568 -0.35135 2.08 Small (1-18) 18 0.48649 0.51351 -0.02703 1.06 Big (19-36) 18 0.48649 0.51351 -0.02703 1.06 Red 18 0.48649 0.51351
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 polynomial multiplication. Here’s a simple way to look at this… You have 3 dice with numbers from 1 to 6 on each of them. Die 1 1 2 3 4 5 6 Die 2 1 2 3 4 5 6 Die 3 1 2 3 4 5 6 Now, add each number from Die 1 to the first number of Die 2 and then the second and so on like this. Die 1 Die 2 1 2 3 4 5 6 1 2 3 4 5 6 7 2 3 4 5 6 7 8 3 4 5 6 7 8 9 4 5 6
Mean and Standard Deviation in Gaming In the previous post, we talked about the long term expectation of games derived from the probabilities of outcomes in casino games. How about measuring results in the short-term such as when the results of shoes or player activity appear inconsistent with the expected values? Let’s face it, they usually do! For this, it is useful to apply the principles of the central limit theorem, in particular, the concepts of mean and standard deviation. But first… Central Limit Theorem The central limit theorem explains that the outcome of repeated experiments will follow a bell-shaped pattern. In terms of casino games, we can translate this as meaning that the outcomes of play will follow a certain pattern of winnings and losses. (Source: http://schools-wikipedia.org/) This is a bell-curve, so named due to its shape. The bell-curve’s centre is known as the mean or average (µ). Notice that the bell-curve is divided into 6 parts from -3σ
Do you need to compare results of an experiment or a marketing plan? Have you just changed the settings of your slot machines and aren’t sure whether the change resulted in a real difference in earnings? Have you just completed an intensive player promotion programme and need to find out whether it was effective? Statistics has a simple way of calculating if the revenue before and after resulted in a real change in performance and also the probability that the change was a DIRECT result of the changes you made! This method is known as a T-Test. A T-Test compares the averages of 2 sets of values and assesses how different the sets of data are. A companion to this is the R² measure of effect size, which calculates how much in terms of percentages that the results of your T-Test was affected directly by the change you implemented. Here’s an example: Casino A recently changed the settings of its