Category: Be an Excel Star!
-
This is a sample Power BI report: 3 databases are used and they have been linked via data relationships Measures have been used to generate the Z % statistic All data is fictional https://app.powerbi.com/reportEmbed?reportId=383de9ad-5f39-416d-9da9-df35c6ee4b79&autoAuth=true&ctid=edc840fb-b90c-4705-82bb-8dae82b1bb43&config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly93YWJpLWNhbmFkYS1jZW50cmFsLXJlZGlyZWN0LmFuYWx5c2lzLndpbmRvd3MubmV0LyJ9
-
This is a sample of how to analyze an aspect of a marketing campaign. For this example we use a combination of T-tests, along with Hedge’s G and effect size tests to determine statistical confidence and significance. We also used linear regression and standard error analysis to determine the projected efficacy of the campaign.
-
We were at the aquarium and we saw a pair of siblings, a boy and a girl, run towards an exhibit. It was one of a few exhibits that only allowed one person to use it at a time. The two then had a dispute over who got there first and who would get to…
-
In trying to understand the boundaries of a game, it is helpful to look at all the possible permutations of events possible. We shall do this with baccarat – bull-dozing through the math. The total number of permutations for baccarat is 416!/410! = 4,998,398,275,503,360. This is because there are 416 cards in an 8-deck shoe,…
-
Excelpunks is proud to offer a mobile communications application featuring an online database. Download on GooglePlay: https://play.google.com/store/apps/details?id=com.excelpunks.agent This application was designed with casino junkets in mind. The concept is a Controller-Agent communications system where agents send player win/loss data via mobile app to their respective controllers, who edit, correct and approve reports for management. This…
-
Excelpunks is proud to offer the Baccarat Analysis for Casinos (Excel) spreadsheet. The system is lightweight and provides the discerning surveillance analyst the following information on a baccarat game: Bias of the shoe towards each result Wager fluctuation between winning and losing wagers 1st Card advantage analysis Comparison of the player’s winning hands versus the…
-
In this article, we shall go over the various components of baccarat: Effect of individual cards on probability Effect of different card combinations in a coup Effect of individual cards on probability The following 3 line-charts show the effect of removing each value of card on the probabilities on the next hand of the Banker,…
-
Ever wondered how casinos determine the payouts for games? Ever wondered how casino games are created? Are you working in a casino and are wondering how the casino decides when a player is winning too much? Learn all this and more at Excelpunks’ Casino Maths and Probability course! Gain a deeper understanding of 4 of the…
-
Programming is essentially an exercise in concentration. After several months learning this from the ground-up, I have come to 3 conclusions. The best solutions to problems are always simple and elegant. Attack problems with a clear mind. You can solve a problem in 5 minutes well rested, while 10 hours with a tired mind will…
-
Hi everyone, I apologize for not posting much over the past few months as I have been acquiring new skills. I am now proud to announce that Excelpunks will be expanding its scope to include the creation of stand-alone .exe programs. Minimum system requirements are a computer that runs on Windows Vista or higher. If…
excelpunks. Training - Consultancy - Solutions. 