Loading Courses

« All Courses

  • This course has passed.

Simple Predictive Modeling with Microsoft® Excel (Th/F, 8:30am – 4:30pm) – Virtual Live

December 3, 2020 @ 8:30 am - December 4, 2020 @ 4:30 pm

|Recurring Courses (See all)

An event every day that begins at 8:30 am, repeating until December 4, 2020



The numbers below include tickets for this event already in your cart. Clicking "Get Tickets" will allow you to edit any existing attendee information as well as change ticket quantities.
Tickets are no longer available

Simple Predictive Modeling with Microsoft® Excel teaches participants how to apply appropriate statistical procedures and models to answer business questions and, most importantly, effectively communicate impact to stakeholders.

Students participating in this 2-day course will learn how to:

Students will leave the course able to use Excel to build statistical models that answer questions like:

  • What’s the relationship between a variable and an outcome?
  • If I adjust X, what will be the impact on Y? Are there natural limits I should be aware of?
  • Are we meeting expectations?
  • What’s coming next? Are we going up or down and by how much?
  • Why are we going up or down? How impactful is each variable? (in other words, what should I focus on first?)
  • Are there any unusual outliers? What caused those? Do I need to do something about this?
  • How likely is any given idea or decision or campaign to be successful?
  • Did any given change or decision make a material business impact?

Section I: Background Information

  • Why Use Statistics?
  • Installing the Data Analysis Tool Pack add-in for Excel

Section II: Analysis Fundamentals

  • Exploring and visualizing data
  • Descriptive statistics o Uses for specific measures and how to visualize
  • Samples vs. populations
  • Average, median, standard deviation, quartiles, percentiles, z-scores
  • Looking at the shape of the data and the impact of outliers
  • Cautions and common pitfalls (e.g. Anscombe’s Quartet)
  • Examining Relationships
  • Overview of Probability
  • Sampling Distributions and the Central Limit Theorem
  • Overview of Inference o Confidence intervals and p-values

Section III: Predictive Models

  • Method for Creating Predictive Models
  • How to Choose and Assess an Appropriate Model
  • Regression
  • When to use it
  • How to interpret meaningfully
  • For nonlinear data
  • Exponential Regression
  • Logarithmic Regression
  • Polynomial Regression
  • Chi-Square
  • Time Series & Forecasting
  • Logis


December 3, 2020 @ 8:30 am
December 4, 2020 @ 4:30 pm
Courses Categories:
, ,


Virtual Live

Leave a Comment

Your email address will not be published. Required fields are marked *