Business Solutions Formulas and Functions with Microsoft® Office Excel 2007

Chapter 16. Using Regression to Track Trends and Make Forecasts

IN THIS CHAPTER

• Choosing a Regression Method 386

• Using Simple Regression on Linear Data 386

• Trend Analysis and Forecasting for a Seasonal Sales Model 400

• Using Simple Regression on Nonlinear Data 409

• Using Multiple Regression Analysis 423

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 six months, a year, or even three years down the road, managers can anticipate related needs such as employee acquisitions, warehouse space, and raw material requirements. Similarly, ...