Explore BrainMass

Explore BrainMass

    Water Consumptions Purpose Summary

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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??

    © BrainMass Inc. brainmass.com March 4, 2021, 6:32 pm ad1c9bdddf
    https://brainmass.com/statistics/analysis-of-variance/water-consumptions-purpose-summary-49546

    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.49

    ADVERTISEMENT