Trend-Regression Technique

Trend-Regression Technique - Values Periods Check Labels...

This preview shows pages 1–2. Sign up to view the full content.

Regression Technique for Trend Models Situation: Model has been determined by regression (low p-value for β 1 ) to have linear trend over 20 periods Required: Forecast for the next 4 periods (21-24) using regression. 1. Perform Regression

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Values Periods Check Labels Select Output Area 2. REGRESSION RESULTS 3. CALCULATE FORECASTS 1. In C2 Enter =E17+E18*A2 2. In C2 Highlight E17+E18 -- Hit F4 function key RESULT: =\$E\$17+\$E\$18*A2 3. Drag C2 to C3:C25...
View Full Document

This note was uploaded on 08/29/2011 for the course STATISTICS 361 taught by Professor Gupta during the Spring '11 term at California State University , Monterey Bay.

Page1 / 2

Trend-Regression Technique - Values Periods Check Labels...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online