SIDEBAR: SETTING UP AN EXCEL SPREADSHEET
ARTICLE SYNOPSIS...SETTING UP AN EXCEL SPREADSHEET
Following is an example of setting up an Excel spreadsheet for creating a forecast using a five-day linear
regression for tomorrow's close. Sidebar Figure 1, Column A, lists the dates and Column D lists the
closing prices
AUTHOR: Technical Analysis, Inc.DATE: MAY 1992
AUTHOR: Dennis D. PetersonDATE: OCT 2000