Data Forecasting and Segmentation Using Microsoft Excel

Table of Contents

1. Understanding Data Segmentation
2. Applying Linear Regression
3. What is Time Series?
4. An Introduction to Data Grouping
5. Finding the Optimal Number of Single Variable Groups
6. Finding the Optimal Number of Multi-Variable Groups
7. Analyzing Outliers for Data Anomalies
8. Finding the Relationship between Variables
9. Building, Training, and Validating a Linear Model
10. Building, Training, and Validating a Multiple Regression Model
11. Testing Data for Time Series Compliance
12. Working with Time Series Using the Centered Moving Average and a Trending Component
13. Training, Validating, and Running the Model