Business Analysis with Microsoft Excel, Fifth Edition

9

Forecasting and Projections

In This Chapter

Making Sure You Have a Useful Baseline

Moving Average Forecasts

Forecasting with Excel’s Regression Functions

Forecasting with Excel’s Smoothing Functions

Using the Box-Jenkins ARIMA Approach: When Excel’s Built-In Functions Won’t Do

Displaying Forecast Data with Power BI

In business management, you often use forecasting to project sales, a process that involves estimating future revenues based on past history. Your forecasts enable you to make estimates of other resources, such as overhead expenses and staffing, that you need to support the revenue stream.

The term forecasting, as this book uses it, is the result of looking back at that historic data to investigate how what happened earlier determined ...