Use the Agricultural Time series database on "Excel Databases. Xls". Use the variable Broccoli over the first three years of the study (Months 1 – 36 only). Assume Month 1 = January. Develop an estimated regression equation that can be used to account for any seasonal and linear trend effects. Use dummy variables for the monthly seasonal effects in the data. Let Jan = 1 if January, 0 otherwise. Feb = 1 if February, 0 otherwise. Etc. This means you will have 11 dummy variables, when all dummy variables are 0, the observation corresponds to December. Compute the forecast for January (month 37) based on the linear trend and seasonal effects. Round your answer to 1 decimal place
