The "Odds O Matic" Excel Spreadsheet
This sheet is designed to help you practice the differences between probability, odds, odds ratio, and relative risk.
Learning About Logistic Regression - Cold Call Case Parameter Play
This sheet is designed to help you develop an intuition for how changing the Beta parameters in a Logistic Regression model impacts the shape of the prediction curve.
Confusion Matrix Metrics Excel Worksheet
A confusion matrix is an essential output of any prediction model for categorical outcomes. Provided you have the raw count results of a prediction model & know which categorical group is your target of interest, this Excel worksheet will automatically calculate key confusion matrix metrics for you and also provide a written interpretation of those values.
Conjoint Analysis in Enginius - Video Case Spreadsheets:
1. Enginius Conjoint Analysis - Cooler Case Study Design - The first two tabs of this sheet have all the information used in the Cooler simulation shown in the videos. You can do it yourself!
2. Applying Choice Rules Illustrated - Corresponds to the “Applying Choice Rules…” video. Demonstrates first-choice, share of preference, logit, and alpha rules.
3. Enginius Conjoint Partsworth Results - Annotated Partsworth Results - This corresponds to the “Interpreting Preference Partsworth” video. The Enginius output has been lightly annotated, and I added a “preference simulator”.
Price Bundling Optimization in Excel (.xlsx file)
A spreadsheet that demonstrates how to determine the optimal price mix for a marketer looking to maximize profits of their sale of a computer chair, desk, and monitor stand.
Pricing Analytics - The Gabor-Granger Method - Video Case Spreadsheets:
1. Basic and Advanced Application of the Gabor-Granger Method in Excel (.xlsx file)
2. Purchase Intentions to Purchase Probabilities Spreadsheet Illustration (.xlsx file)
Intro to Predictive Model Training and Validation - Opinions on GMO Foods - Illustrated in RapidMiner - See the YouTube Video here
1. Training Data (n=1000) [Excel] (.xlsx file)
2. Validation (n=500) [Excel] (.xlsx file)
RapidMiner Process Files (the build up across the video):
1. Part 1 - GMO Beliefs - Reading in Training Prediciton Performance Datasets.rmp
2. Part 2 - GMO Beliefs - Building the Prediction Models.rmp
3. Part 3 - GMO Beliefs - Validating the Prediction Models.rmp