Download XLSX (MS Excel 2010+)

This MS Excel file is a self-contained case study exploring how structuring the # of available positions can be helpful or destructive to a company for a given candidate pool.

Recommended for every intelligent hiring manager!

SPOILERS:  Under my assumptions, creative firms need only offer 1 position, while standard-intensive firms need to offer more than 1 position in order to reduce mismatch costs.

• Create a Monte Carlo simulation when marginal probabilities (priors) change upon certain triggers (e.g. when you get hired, you get a 10% bonus to the probability of being the top candidate in a future job).
• Reinforcing Bayesian inferences to find that the “experienced” candidates you hire may not be what they seem.

These 2 issues listed above grant you a distinct challenge which you might not find in many other MS Excel learning offerings.

Requirements:

• A basic understanding of Conditional Probabilities (e.g. Multiplicative Identity and Bayes’ Theorem)
• A basic understanding of IF and OR functions
• A good sense of humor!

Download File (MS Excel 2010+)

This MS Excel file is a self-contained case study to teach Excel users how to create a Monte Carlo simulation while exploring how to handle the United States wealth gap.  For most of you, the essential skill-building includes:

• Creating a Monte Carlo simulation when the outcomes do not have equal probabilities.
• Creating a random outcome the probability of which is dependent on the survivors of previous generation (proportions change when dealing with generations of the fruit fly, drosophila melanogaster, for example).

These 2 issues listed above grant you a distinct challenge which you might not find in many other MS Excel learning offerings. 

Requirements:

• A basic understanding of dominant and recessive traits from high school biology
• A basic understanding of IF and AND functions
• A good sense of humor!