Forecasting using trend analysis Oxford College of 趋势分析预测牛津学院.pptVIP

Forecasting using trend analysis * Part 1. Theory Part 2. Using Excel: a demonstration. Assignment 1, 2 Learning objectives * To compute a trend for a given time-series data using Excel To choose a best fitting trend line for a given time-series To calculate a forecast using regression equation To learn how: Main idea of the trend analysis forecasting method * Main idea of the method: a forecast is calculated by inserting a time value into the regression equation. The regression equation is determined from the time-serieas data using the “least squares method” Prerequisites: 1. Data patt