The tips of the sunset’s orange light begin caressing the beach sand, with a soft mist in tow. The mist grows denser, soon enveloping the shoreline and adjacent palm trees. A dark shadow rises, growing larger and larger, as if something were approaching the shore, however it is impossible to judge the distance due to
Game Theory is a branch of mathematics which economists happen to find very useful. The reason is that Game Theory concerns itself with situations involving some type of competition, or “games,” where players can make moves independent of one another. This setup is analogous to companies, the players, competing for customers, and whichever can gain
The logic problem goes as follows: ” There are one hundred prisoners, each numbered one through one hundred. In an adjacent room, there are 100 boxes, also numbered one through one hundred. Each box holds a slip of paper, also numbered one through one hundred however each slip of paper is randomly inserted into each
For this post I will be showing you how to build a dice rolling simulator and, more largely, how to calculate then simulate problems known as “coupon collector” problems, all using Excel and VBA. Starting off with the question, how many rolls of a die would you expect to need in order to roll all six sides
So, you want to run a linear regression in Excel. Maybe you need to do some forecasting, maybe you want to tease out a relationship between two (or more) variables. Maybe you have to explain some phenomenon and predict it, but you don’t have a clue how it works or why it does what it
日本語の場合は、上隅にある旗をクリックして「日本語」を選択します。 Part two of this Plant growing blog will focus on adding flowers to the stems that we learned how to grow in part 1. There are a few sections, the first focuses on colors, the second deals with how and where the flowers will actually be growing. Then we look at the varieties of flowers available in
日本語の場合は、上隅にある旗をクリックして「日本語」を選択します Think of this as something like a gardening simulator in Excel. Using random numbers we will grow a plant from a flower pot on a sheet. This will cover a variety of Excel topics including the proper VBA syntax for: RGB colors, cell borders, color gradients, random number generators, and there will also be some data
Everything in this blog post will be about those uniquely fascinating numbers known as prime numbers. I will be explaining how to build something known as the Sieve of Eratosthenes, which I will explain in detail later. The sieve will be able to spit out all the prime numbers between 2 and an arbitrarily large number of
In this post we are going to build a maze solver in Excel using VBA, to do this we will simulate a little person walking through a maze, they will be practicing the “right-hand rule,” that is, you can successfully escape any maze by placing your right hand (or left I suppose, as long as
This will be the third and final blog post regarding the Monty Hall problem. The aim of the build this time is to make something that is both highly functional and stunningly beautiful. Since all we are concerned with this time is raw data it would be nice to have an exciting way of presenting