Historical data for water use, population, price, and precipitation in a city for a 10-year time horizon are given in Table 6. 12. Formulate a multiple regression model for estimating the water use data and comment on selecting the independent variables.

Transcribed Image Text:

TABLE 6.12 Historical Data for Water Use, Population, Price, and Precipitation for a 10-Year Time Horizon in the City of Problem 16 Price (Monetary Year Population Unit/m) Annual Precipitation (mm) Water Use (m/year) 2000 21,603 0.25 1015 2,540,513 2001 22,004 0.27 810 2,754,901 2002 23,017 0.29 838 2,722,911 2003 23,701 0.30 965 2,832,270 2004 24,430 0.31 838 2,904,727 2005 25,186 0.32 787 3,004,690 2006 26,001 0.33 720 3,309,927 2007 26,825 0.35 695 3,382,633 2008 27,781 0.31 820 3,375,392 2009 28,576 0.34 800 3,406,259