Excel Assignment Use the sample forecasting-problem spreadsheets and charts from class as a guide. 10 values for creating models and measuring confidence and one value to compare the accuracy of the different models. There can be no gaps in the data. Do not use the same data as someone else.
Time is the independent variable and the other data is the dependent variable.
See back of this sheet for more instruction. Circle the forecast for the 11 th period on each method. State the method in which you had the most confidence and why . State the method that turned out to be most accurate and how you can tell . On the spreadsheet there should be no italics except in column headings, if you wish.