Gold has long been a very popular investment choice during times of economic crisis. This has resulted in a significant increase in the price of gold per ounce in recent years. The Excel file gold prices.xlsx shows the average price of an ounce of gold from 1992 until 2012.

a. Construct a graph showing the price per ounce of gold over time.

b. Forecast the average price of gold for 2013 using a trend projection.

c. Calculate the MAD for this forecast.

d. Check for the presence of positive autocorrelation.

e. Based on these results, does this forecasting method seem appropriate for these data?