Chapter 13

Applying regression to track trends and make forecasts

In this chapter, you will:

  • Understand regression analysis

  • Learn how to use simple regression on linear data

  • Plot and calculate best-fit trendlines

  • Plot and calculate forecasted values

  • Learn how to use simple regression on nonlinear data

  • Understand and use multiple regression analysis

In these complex and uncertain times, forecasting business performance is increasingly important. Today, more than ever before, managers at all levels need to make intelligent predictions of future sales and profit trends as part of their overall business strategy. By forecasting sales six months, a year, or even three years down the road, managers can anticipate related needs such as employee ...

Get Microsoft Excel 2019 Formulas and Functions, First Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.