WELCOME TO THE VIP PAGE
I’m glad that you are here. Below I have listed all of my best free content, including all of my cheat sheets and bonus content for my books. Check them out and make sure to book mark this page, because I will update it whenever I have any new free material.
The material I have written so far is broadly classified into 3 categories, Machine Learning, Statistics, and tips on using Excel
Upcoming Releases
If you would like to get a reviewer’s pre-release PDF of future books, please email me here
Information On Machine Learning
Random Forests – Random Forests are a way of combining multiple decision trees into one single ensemble solution. This is a fairly robust form of machine learning that is reasonably easy to understand
- Two Page PDF Cheat Sheet of How Decision Trees Work
- This is also available as a physical, laminated cheat sheet on Amazon here http://geni.us/DecisionTrees
- One Page PDF Cheat Sheet of Random Forest code in Python
- 5 Different Python Examples of Random Forests, and an Excel file of how they work
Boosting – Boosting also uses decision trees, just like Random Forests do. Boosting runs the decision trees in series, feeding each one the leftover error from the previous ones. Random Forests run the decision trees in parallel and average the results.
Information On Statistics
Linear Regression – Linear Regression is a way of fitting a straight line to messy real world data. This also works with multiple independent variables
Bayes Theorem – Bayes theorem is a way of updating probability as you get more information
Hypothesis Testing – This is a way of determining if an event happened by random chance, or had some outside influence
Permutations and Combinations – This is a way of calculating how many different possible orders or groups of things you can have
Binomial Theorem – The binomial theorem is a way of calculating the probability of a certain outcome from a number of trials. For instance, what are the odds of getting exactly 12 heads in 20 flips of a coin?
Excel Tips
- Excel Tips And Settings – This is a PDF with my favorite tips on how to make Excel work better
- Excel Pivot Tables – This Excel file uses the U.S. census data to show different examples of how pivot tables work
- Excel Data Filters – This Excel file uses data filters to sort and manage large columns of data. Data filters are one of my favorite tools in Excel
- Excel Random Numbers – This Excel file gives examples of how to generate random numbers in Excel, including numbers in a normal distribution
- Excel Conditional Formatting – This Excel file shows how to format a cell based on the value of that cell