Fit a simple Linear Regression forecasting Model Year Year Period U.S. Nat Gas T
ID: 3250164 • Letter: F
Question
Fit a simple Linear Regression forecasting Model
Year
Year
Period U.S. Nat Gas Total Consumption (Bcf) X Forecasted 2008 Jan 2733.969 1 2008 Feb 2503.42 2 2008 Mar 2278.15 3 2008 Apr 1823.866 4 2008 May 1576.387 5 2008 Jun 1604.248 6 2008 Jul 1708.64 7 2008 Aug 1682.923 8 2008 Sep 1460.924 9 2008 Oct 1635.826 10 2008 Nov 1868.947 11 2008 Dec 2399.701 12 2009 Jan 2729.714 13 2009 Feb 2332.539 14 2009 Mar 2170.708 15 2009 Apr 1741.293 16 2009 May 1504 17 2009 Jun 1527.833 18 2009 Jul 1657.997 19 2009 Aug 1736.462 20 2009 Sep 1574.974 21 2009 Oct 1666.519 22 2009 Nov 1776.171 23 2009 Dec 2491.864 24 2010 Jan 2809.788 25 2010 Feb 2480.949 26 2010 Mar 2142.925 27 2010 Apr 1691.813 28 2010 May 1617.273 29 2010 Jun 1649.514 30 2010 Jul 1825.827 31 2010 Aug 1878.926 32 2010 Sep 1637.491 33 2010 Oct 1664.937 34 2010 Nov 1973.294 35 2010 Dec 2714.054 36 2011 Jan 2888.639 37 2011 Feb 2452.403 38 2011 Mar 2230.493 39 2011 Apr 1825.023 40 2011 May 1667.395 41 2011 Jun 1657.334 42 2011 Jul 1890.515 43 2011 Aug 1891.782 44 2011 Sep 1655.633 45 2011 Oct 1744.453 46 2011 Nov 2031.871 47 2011 Dec 2541.878 48 2012 Jan 2756.179 49 2012 Feb 2500.654 50 2012 Mar 2127.76 51 2012 Apr 1953.07 52 2012 May 1873.834 53 2012 Jun 1868.356 54 2012 Jul 2069.773 55 2012 Aug 2008.815 56 2012 Sep 1807.208 57 2012 Oct 1901.084 58 2012 Nov 2167.841 59 2012 Dec 2503.907 60 2013 Jan 2878.784 61 2013 Feb 2567.154 62 2013 Mar 2521.108 63 2013 Apr 1967.458 64 2013 May 1752.469 65 2013 Jun 1742.917 66 2013 Jul 1926.329 67 2013 Aug 1927.379 68 2013 Sep 1766.972 69 2013 Oct 1866.762 70 2013 Nov 2316.908 71 2013 Dec 2920.825 72 2014 Jan 3204.128 73 2014 Feb 2741.239 74 2014 Mar 2557.89 75 2014 Apr 1961.677 76 2014 May 1810.221 77 2014 Jun 1745.35 78 2014 Jul 1881.017 79 2014 Aug 1933.06 80 2014 Sep 1809.291 81 2014 Oct 1912.81 82 2014 Nov 2357.52 83 2014 Dec 2679.165 84 2015 Jan 3115.624 85 2015 Feb 2926.686 86 2015 Mar 2592.374 87 2015 Apr 2012.767 88 2015 May 1863.453 89 2015 Jun 1908.353 90 2015 Jul 2076.833 91 2015 Aug 2061.224 92 2015 Sep 1909.306 93 2015 Oct 1994.017 94 2015 Nov 2254.757 95 2015 Dec 2590.887 96 2016 Jan 3097.348 97 2016 Feb 2655.581 98 2016 Mar 2359.435 99 2016 Apr 2089.816 100 2016 May 1971.878 101 2016 Jun 2004.084 102 2016 Jul 2190.001 103 2016 Aug 2214.282 104 2016 Sep 1950.141 105 2016 Oct 1925.741 106 2016 Nov 2168.122 107 2016 Dec 2870.782 108 2017 Jan 2882.404 109 2017 Feb 2317.955 110 2017 Mar 2219.546 111 2017 Apr 2198.452 112 2017 May MSEExplanation / Answer
Forecasted equation here was calculated by taking regression trhough excel and found it
y = 3.879x + 1901
Period X U.S. Nat Gas Total Consumption (Bcf) X Forecasted Diff. d^2 Year 2008 Jan 1 2733.969 1 1904.879 829.09 687390.2 2008 Feb 2 2503.42 2 1908.758 594.662 353622.9 2008 Mar 3 2278.15 3 1912.637 365.513 133599.8 2008 Apr 4 1823.866 4 1916.516 -92.65 8584.023 2008 May 5 1576.387 5 1920.395 -344.008 118341.5 2008 Jun 6 1604.248 6 1924.274 -320.026 102416.6 2008 Jul 7 1708.64 7 1928.153 -219.513 48185.96 2008 Aug 8 1682.923 8 1932.032 -249.109 62055.29 2008 Sep 9 1460.924 9 1935.911 -474.987 225612.7 2008 Oct 10 1635.826 10 1939.79 -303.964 92394.11 2008 Nov 11 1868.947 11 1943.669 -74.722 5583.377 2008 Dec 12 2399.701 12 1947.548 452.153 204442.3 2009 Jan 13 2729.714 13 1951.427 778.287 605730.7 2009 Feb 14 2332.539 14 1955.306 377.233 142304.7 2009 Mar 15 2170.708 15 1959.185 211.523 44741.98 2009 Apr 16 1741.293 16 1963.064 -221.771 49182.38 2009 May 17 1504 17 1966.943 -462.943 214316.2 2009 Jun 18 1527.833 18 1970.822 -442.989 196239.3 2009 Jul 19 1657.997 19 1974.701 -316.704 100301.4 2009 Aug 20 1736.462 20 1978.58 -242.118 58621.13 2009 Sep 21 1574.974 21 1982.459 -407.485 166044 2009 Oct 22 1666.519 22 1986.338 -319.819 102284.2 2009 Nov 23 1776.171 23 1990.217 -214.046 45815.69 2009 Dec 24 2491.864 24 1994.096 497.768 247773 2010 Jan 25 2809.788 25 1997.975 811.813 659040.3 2010 Feb 26 2480.949 26 2001.854 479.095 229532 2010 Mar 27 2142.925 27 2005.733 137.192 18821.64 2010 Apr 28 1691.813 28 2009.612 -317.799 100996.2 2010 May 29 1617.273 29 2013.491 -396.218 156988.7 2010 Jun 30 1649.514 30 2017.37 -367.856 135318 2010 Jul 31 1825.827 31 2021.249 -195.422 38189.76 2010 Aug 32 1878.926 32 2025.128 -146.202 21375.02 2010 Sep 33 1637.491 33 2029.007 -391.516 153284.8 2010 Oct 34 1664.937 34 2032.886 -367.949 135386.5 2010 Nov 35 1973.294 35 2036.765 -63.471 4028.568 2010 Dec 36 2714.054 36 2040.644 673.41 453481 2011 Jan 37 2888.639 37 2044.523 844.116 712531.8 2011 Feb 38 2452.403 38 2048.402 404.001 163216.8 2011 Mar 39 2230.493 39 2052.281 178.212 31759.52 2011 Apr 40 1825.023 40 2056.16 -231.137 53424.31 2011 May 41 1667.395 41 2060.039 -392.644 154169.3 2011 Jun 42 1657.334 42 2063.918 -406.584 165310.5 2011 Jul 43 1890.515 43 2067.797 -177.282 31428.91 2011 Aug 44 1891.782 44 2071.676 -179.894 32361.85 2011 Sep 45 1655.633 45 2075.555 -419.922 176334.5 2011 Oct 46 1744.453 46 2079.434 -334.981 112212.3 2011 Nov 47 2031.871 47 2083.313 -51.442 2646.279 2011 Dec 48 2541.878 48 2087.192 454.686 206739.4 2012 Jan 49 2756.179 49 2091.071 665.108 442368.7 2012 Feb 50 2500.654 50 2094.95 405.704 164595.7 2012 Mar 51 2127.76 51 2098.829 28.931 837.0028 2012 Apr 52 1953.07 52 2102.708 -149.638 22391.53 2012 May 53 1873.834 53 2106.587 -232.753 54173.96 2012 Jun 54 1868.356 54 2110.466 -242.11 58617.25 2012 Jul 55 2069.773 55 2114.345 -44.572 1986.663 2012 Aug 56 2008.815 56 2118.224 -109.409 11970.33 2012 Sep 57 1807.208 57 2122.103 -314.895 99158.86 2012 Oct 58 1901.084 58 2125.982 -224.898 50579.11 2012 Nov 59 2167.841 59 2129.861 37.98 1442.48 2012 Dec 60 2503.907 60 2133.74 370.167 137023.6 2013 Jan 61 2878.784 61 2137.619 741.165 549325.6 2013 Feb 62 2567.154 62 2141.498 425.656 181183 2013 Mar 63 2521.108 63 2145.377 375.731 141173.8 2013 Apr 64 1967.458 64 2149.256 -181.798 33050.51 2013 May 65 1752.469 65 2153.135 -400.666 160533.2 2013 Jun 66 1742.917 66 2157.014 -414.097 171476.3 2013 Jul 67 1926.329 67 2160.893 -234.564 55020.27 2013 Aug 68 1927.379 68 2164.772 -237.393 56355.44 2013 Sep 69 1766.972 69 2168.651 -401.679 161346 2013 Oct 70 1866.762 70 2172.53 -305.768 93494.07 2013 Nov 71 2316.908 71 2176.409 140.499 19739.97 2013 Dec 72 2920.825 72 2180.288 740.537 548395 2014 Jan 73 3204.128 73 2184.167 1019.961 1040320 2014 Feb 74 2741.239 74 2188.046 553.193 306022.5 2014 Mar 75 2557.89 75 2191.925 365.965 133930.4 2014 Apr 76 1961.677 76 2195.804 -234.127 54815.45 2014 May 77 1810.221 77 2199.683 -389.462 151680.6 2014 Jun 78 1745.35 78 2203.562 -458.212 209958.2 2014 Jul 79 1881.017 79 2207.441 -326.424 106552.6 2014 Aug 80 1933.06 80 2211.32 -278.26 77428.63 2014 Sep 81 1809.291 81 2215.199 -405.908 164761.3 2014 Oct 82 1912.81 82 2219.078 -306.268 93800.09 2014 Nov 83 2357.52 83 2222.957 134.563 18107.2 2014 Dec 84 2679.165 84 2226.836 452.329 204601.5 2015 Jan 85 3115.624 85 2230.715 884.909 783063.9 2015 Feb 86 2926.686 86 2234.594 692.092 478991.3 2015 Mar 87 2592.374 87 2238.473 353.901 125245.9 2015 Apr 88 2012.767 88 2242.352 -229.585 52709.27 2015 May 89 1863.453 89 2246.231 -382.778 146519 2015 Jun 90 1908.353 90 2250.11 -341.757 116797.8 2015 Jul 91 2076.833 91 2253.989 -177.156 31384.25 2015 Aug 92 2061.224 92 2257.868 -196.644 38668.86 2015 Sep 93 1909.306 93 2261.747 -352.441 124214.7 2015 Oct 94 1994.017 94 2265.626 -271.609 73771.45 2015 Nov 95 2254.757 95 2269.505 -14.748 217.5035 2015 Dec 96 2590.887 96 2273.384 317.503 100808.2 2016 Jan 97 3097.348 97 2277.263 820.085 672539.4 2016 Feb 98 2655.581 98 2281.142 374.439 140204.6 2016 Mar 99 2359.435 99 2285.021 74.414 5537.443 2016 Apr 100 2089.816 100 2288.9 -199.084 39634.44 2016 May 101 1971.878 101 2292.779 -320.901 102977.5 2016 Jun 102 2004.084 102 2296.658 -292.574 85599.55 2016 Jul 103 2190.001 103 2300.537 -110.536 12218.21 2016 Aug 104 2214.282 104 2304.416 -90.134 8124.138 2016 Sep 105 1950.141 105 2308.295 -358.154 128274.3 2016 Oct 106 1925.741 106 2312.174 -386.433 149330.5 2016 Nov 107 2168.122 107 2316.053 -147.931 21883.58 2016 Dec 108 2870.782 108 2319.932 550.85 303435.7 2017 Jan 109 2882.404 109 2323.811 558.593 312026.1 2017 Feb 110 2317.955 110 2327.69 -9.735 94.77023 2017 Mar 111 2219.546 111 2331.569 -112.023 12549.15 2017 Apr 112 2198.452 112 2335.448 -136.996 18767.9 2017 May MSE MSE 159178.29Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.