Level: Intermediate

Exploring Problem Spaces

Given its primary role as a database product, it’s easy sometimes to forget what a great teaching tool FileMaker Pro can be. One of my favorite educational uses for it is building models to explore problem spaces, for example…

  • viewing all possible outcomes for a problem with boundary conditions
  • conducting trials to confirm the likelihood of a predicted outcome
  • using “brute force” to find the solution to a complex problem

..and today we’re going to look at an example of each of these.

Dice Roll


Demo Files: Dice Roll, v1 and Dice Roll, v2

Continue reading “Exploring Problem Spaces”

Level: Intermediate, Version: FM 12 or later

Benford’s Law

A common exercise in freshman courses on statistics and probability is to divide the students into two groups, let’s call them A and B.

8-11-2013 9-39-15 PMEach student in group A is instructed to flip a coin 100 times and record the resulting sequence of heads and tails. Each student in group B is instructed to merely pretend to have done so, and write down the fictional sequence. The sequences are submitted anonymously to the professor, but invariably the professor correctly determines which group they belong to.

Take a look at the example at right. If you were the professor would you assume it comes from group A or from group B? Would it strike you as suspicious that the first six tosses alternate between T and H with perfect regularity, or that starting with toss 12, there are five H’s in a row?

Continue reading “Benford’s Law”