Skill Introduction

You will be guided through a mini-case study that will illustrate the first three parts of the FACT model, with a focus on the C, or calculations part of the FACT model. First, you will perform a correlation analysis to identify two-way relationships, and analyze correlations using a correlation matrix and scatter plots. You will then build on your knowledge of correlations and learn how to perform regression analysis in Excel. Finally, you will learn how to interpret and evaluate the diagnostic metrics and plots of a regression analysis.


Learning Outcomes

Upon successful completion, you will be able to:

  • Identify two-way relationships and analyze correlations in a correlation matrix

  • Perform simple and multiple regression analyses in Excel

  • Interpret and evaluate the diagnostics metrics and plots of regression analyses

Skill Curriculum

  • 1

    Orientation

    • Introduction Video

    • Introduction to the Skill

    • Glossary
  • 2

    Content and Activities

    • Framing a Question - Larrys Commissary

    • Assembling Data

    • Data Analysis- ToolPak and Descriptive Statistics

    • Correlation

    • Knowledge Check 1

    • Linear Models

    • Simple Regression

    • Regression Diagnostics 1 - Regression Summary ANOVA and Coefficient Estimates

    • Knowledge Check 2

    • Multiple Regression

    • Regression Diagnostics 2 - Predicted Values Residuals and Standardized Residuals

    • Regression Diagnostics 3 - Line Fit Plots Adjusted R Square and Heat Maps for P Values

    • Making a Forecast with a Linear Model

    • Knowledge Check 3
  • 3

    Application Exercise

    • Instructions and Materials

    • Exercise Part 1

    • Exercise Part 2

    • Debriefing
  • 4

    Summary

    • Concluding Video

    • Final Quiz

    • Survey Instructions

    • Feedback Survey

    • Survey Verification

    • Next Steps

Begin your learning today.