Wayne Banker is in charge of planning water usage for agriculturally intensive Burke County. August is the peak month of water usage for Burke County. Wayne has collected the following statistics from the past 15 years, showing the total March–June rainfall (in inches), average daily high temperature in July, and number of acre-feet of water used in August by farms in the area. Wayne wants to know if he can predict how much water will be needed in August, given the March–June rainfall and July temperature data.
Use Excel’s regression function to develop a multiple regression forecast for Wayne. What is the R2 for the model?
Use the model to forecast water usage for 1998–2013. Calculate the MFE and MAPE for the model. In your opinion, how good is the model?

Transcribed Image Text:

AVERAGE INCHES OF PEAK DAILY ACRE-FEET OF RAINFALL, TEMPERATURE, WATER USED, YEAR MARCH-JUNE JULY AUGUST 1998 12.5 78.4 39,800 43,700 1999 11.2 74.9 2000 12.2 84.1 45,100 54,500 32,900 31,500 35,500 35,800 2001 10.6 85.1 2002 9.3 70.6 2003 11.7 71.0 2004 10.0 87.4 2005 13.3 91.4 2006 8.4 98.3 69,700 48,100 2007 14.9 99.6 10.0 12.6 2008 91.7 53,700 40,300 2009 91.6 2010 10.6 81.5 32,600 34,100 2012 7.1 77.0 2013 11.3 83.9 36,800