Formulas and Functions: Microsoft® Excel 2010

16. Using Regression to Track Trends and Make Forecasts

IN THIS CHAPTER

Choosing a Regression Method

Using Simple Regression on Linear Data

Case Study: Trend Analysis and Forecasting for a Seasonal Sales Model

Using Simple Regression on Nonlinear Data

Using Multiple Regression Analysis

Setting Up and Performing a Find

In these complex and uncertain times, forecasting business performance is increasingly important. Today, more than ever, 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 6 months, a year, or even 3 years down the road, managers can anticipate related needs such as employee acquisitions, warehouse space, and raw material ...