Next,
use the functionality in Microsoft Excel to predict the Federal Reserve
rate over the next six days. You want these calculated values to appear
in a table and in a line plot.
To simulate the Federal
Reserve rate for the next six days:
-
Create a new worksheet
called
Basic Forecasting.
-
In the new worksheet,
specify Date and Rate as column headings.
-
From the Original Data
worksheet, copy the data from 2010-04-27 through 2010-05-20, and paste
it into the Basic Forecasting worksheet.
-
In the Date column,
add rows for 2010-05-21 through 2010-05-26.
-
In the Rate column,
specify the following formula for the new dates:
In this example, the
formula for the B23 cell is B22+(RANDBETWEEN(-100,100)/100)/2.
Although the calculated
values could vary, your results should appear similar to this display:
