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 (the Y variables) used for the forecasted close. ...