Using Linear Regression In Your Modeling

Using Linear Regression tools can help create stronger projections. In this video we'll show how to leverage that information in Excel.

Back to Videos

In Part Five of our Baseball Lineup Model, T is showing step-by-step how he used linear regression via the built-in Data Analysis Tools in Excel to project a pitcher strikeout percentage. This video builds on concepts covered in Part One, Part Two, Part Three, and Part Four.

Key Concepts

  • Using Regression Analysis To Build A Projection
  • Analyzing Results of Regression Testing Such As R² and p-value.