Share
Explore BrainMass

Water Consumptions Purpose Summary

Between 1981 and 1991, water use in Canada increased for some purposes and decreased for others. The following table provides a summary.

Water consumption(millions of m cubed)
category of use 1981 1986 1991

agriculture 3 125 3 559 3 991
mining 648 593 363
manufacturing 9 937 7 984 7 282
thermal power 19 281 25 364 28 357
municipal 4 263 4 717 5 102
other 3 892 4 279 5 367
total 41 146 46 496 50 462

How do i use linear models to predict water consumption in 1999, by category and total??

Solution Preview

Please see the attached file.

I cant figure out the equation, i need to get answers to graph.
________________________________________
Between 1981 and 1991, water use in Canada increased for some purposes and decreased for others. The following table provides a summary.

Water consumption(millions of m cubed)
category of use 1981 1986 1991

agriculture 3 125 3 559 3 991
mining 648 593 363
manufacturing 9 937 7 984 7 282
thermal power 19 281 25 364 28 357
municipal 4 263 4 717 5 102
other 3 892 4 279 5 367
total 41 146 46 496 50 462

How do i use linear models to predict water consumption in 1999, by category and total?

1) we predict agriculture water consumption. Use Excel, we get

SUMMARY OUTPUT

Regression Statistics
Multiple R 0.966553
R Square 0.934225
Adjusted R Square 0.86845
Standard Error 162.4828
Observations 3

ANOVA
df SS MS F Significance F
Regression 1 374978 374978 14.20335 0.165117
Residual 1 26400.67 26400.67
Total 2 401378.7

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept -168496 45635.48 -3.69221 0.168383 -748350 411357.8 -748350 411357.8
X Variable 1 86.6 22.97854 3.768734 0.165117 -205.37 378.57 -205.37 378.57

The regression equation is
Y= ...

Solution Summary

A linear models to predict water consumption in 1999 by category and totals are determined.

$2.19