Using this data file, predict the natural gas usage for a typical home in April 2014. Then, forecast the ...

profileguru2009
 (Not rated)
 (Not rated)
Chat

        Attached   to this posting is a file tracking natural gas usage (for home heating) in a   typical household. Using this data file, predict the natural gas usage for a   typical home in April 2014. Then, forecast the total amount of natural gas   used in a typical home in 2015. http://www.mediafire.com/?xbjihdp410kp2ke   Produce a Regression and Time Series Analysis regarding the stated research   issue. Include a correlation analysis, regression hypothesis test, trend   analsyis season smoothing and forecast. Provide equations, computation and   results using graphical/tabular methods of displaying data and results

      Year  Units of Natural Gas Used   2008 Jan 180    Feb 152    Mar 163    Apr 128    May 46    Jun 22    Jul 18    Aug 16    Sep 18    Oct 15    Nov 42    Dec 73   2009 Jan 137    Feb 144    Mar 121    Apr 104    May 61    Jun 38    Jul 17    Aug 19    Sep 16    Oct 16    Nov 61    Dec 123   2010 Jan 145    Feb 220    Mar 182    Apr 113    May 71    Jun 30    Jul 18    Aug 19    Sep 19    Oct 17    Nov 51    Dec 99        

    • 8 years ago
    Using seasonal indexes, get the seasonally-adjusted forecasts for the above periods ...
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      Naturalgasusageforhomeheating.XLS