Question: Use this data to build simple and/or multiple regression models for explaining relationships between a continuous response variable and multiple continuous predictors. Check your model
Use this data to build simple and/or multiple regression models for explaining relationships between a continuous response variable and multiple continuous predictors. Check your model for compliance to regression analysis assumptions.
| Annual Total | Total Energy Consumed by the Commercial Sector | Total Energy Consumed by the Residential Sector | Total Energy Consumed by the Industrial Sector | Total Primary Energy Consumed by the Electric Power Sector |
| (Trillion Btu) | (Trillion Btu) | (Trillion Btu) | (Trillion Btu) | |
| 1949 | 3668.856 | 5599.404 | 14709.664 | 4339.47 |
| 1950 | 3893.348 | 5988.744 | 16223.978 | 4679.283 |
| 1951 | 3873.28 | 6380.397 | 17657.898 | 5070.83 |
| 1952 | 3873.442 | 6560.456 | 17289.295 | 5338.183 |
| 1953 | 3771.044 | 6558.982 | 18187.575 | 5730.355 |
| 1954 | 3732.985 | 6846.306 | 17131.525 | 5779.745 |
| 1955 | 3895.212 | 7278.249 | 19454.57 | 6461.471 |
| 1956 | 4022.935 | 7663.006 | 20176.606 | 6942.296 |
| 1957 | 3960.863 | 7712.289 | 20184.594 | 7231.035 |
| 1958 | 4119.237 | 8200.985 | 19284.926 | 7197.936 |
| 1959 | 4372.286 | 8412.235 | 20289.953 | 7794.295 |
| 1960 | 4609.504 | 9039.816 | 20795.437 | 8157.929 |
| 1961 | 4727.771 | 9286.431 | 20907.531 | 8451.561 |
| 1962 | 5036.503 | 9782.865 | 21736.21 | 9027.528 |
| 1963 | 5250.77 | 9988.955 | 22694.994 | 9624.895 |
| 1964 | 5466.127 | 10241.058 | 24051.335 | 10313.377 |
| 1965 | 5845.556 | 10639.89 | 25035.156 | 11012.229 |
| 1966 | 6324.187 | 11169.166 | 26355.735 | 11982.651 |
| 1967 | 6899.356 | 11639.868 | 26603.802 | 12694.663 |
| 1968 | 7329.194 | 12336.928 | 27869.286 | 13881.853 |
| 1969 | 7833.408 | 13169.881 | 29086.665 | 15167.253 |
| 1970 | 8346.479 | 13766.472 | 29605.448 | 16253.34 |
| 1971 | 8721.141 | 14246.925 | 29562.393 | 17117.795 |
| 1972 | 9183.616 | 14857.828 | 30901.306 | 18449.961 |
| 1973 | 9543.148 | 14898.094 | 32590.859 | 19730.632 |
| 1974 | 9393.499 | 14655.022 | 31753.219 | 19905.245 |
| 1975 | 9492.66 | 14814.067 | 29378.584 | 20270.238 |
| 1976 | 10063.511 | 15410.953 | 31356.092 | 21472.764 |
| 1977 | 10207.775 | 15662.391 | 32220.752 | 22550.63 |
| 1978 | 10512.051 | 16132.944 | 32642.955 | 23553.115 |
| 1979 | 10648.148 | 15813.167 | 33877.614 | 23943.198 |
| 1980 | 10578.373 | 15753.786 | 31993.888 | 24269.431 |
| 1981 | 10616.004 | 15261.934 | 30662.882 | 24424.767 |
| 1982 | 10860.442 | 15531.314 | 27561.25 | 23979.412 |
| 1983 | 10938.501 | 15425.469 | 27372.147 | 24613.652 |
| 1984 | 11443.999 | 15959.927 | 29509.205 | 25635.017 |
| 1985 | 11451.355 | 16041.743 | 28757.792 | 26031.597 |
| 1986 | 11606.227 | 15975.51 | 28225.642 | 26226.756 |
| 1987 | 11946.141 | 16263.66 | 29332.93 | 26987.596 |
| 1988 | 12578.22 | 17133.058 | 30627.588 | 28226.734 |
| 1989 | 13196.425 | 17790.213 | 31282.548 | 29869.088 |
| 1990 | 13317.463 | 16940.519 | 31750.247 | 30495.053 |
| 1991 | 13500.103 | 17419.82 | 31342.892 | 30856.021 |
| 1992 | 13441.216 | 17355.252 | 32514.197 | 30722.757 |
| 1993 | 13816.999 | 18212.1 | 32560.464 | 31847.065 |
| 1994 | 14097.381 | 18110.761 | 33463.393 | 32398.714 |
| 1995 | 14690.003 | 18517.171 | 33909.764 | 33478.818 |
| 1996 | 15172.012 | 19502.447 | 34837.762 | 34485.4 |
| 1997 | 15681.27 | 18962.848 | 35135.422 | 34886.291 |
| 1998 | 15967.562 | 18952.471 | 34780.124 | 36225.117 |
| 1999 | 16376.376 | 19554.197 | 34693.032 | 36975.567 |
| 2000 | 17175.438 | 20421.765 | 34588.508 | 38061.759 |
| 2001 | 17136.846 | 20038.277 | 32652.507 | 37215.174 |
| 2002 | 17345.802 | 20786.494 | 32590.106 | 38016.154 |
| 2003 | 17346.207 | 21120.03 | 32488.595 | 38028.287 |
| 2004 | 17655.555 | 21082.055 | 33443.698 | 38701.055 |
| 2005 | 17853.459 | 21613.315 | 32374.091 | 39625.526 |
| 2006 | 17707.168 | 20670.902 | 32316.794 | 39416.564 |
| 2007 | 18252.756 | 21519.623 | 32306.213 | 40370.589 |
| 2008 | 18401.935 | 21668.347 | 31260.856 | 39969.266 |
| 2009 | 17887.068 | 21082.081 | 28380.059 | 38068.718 |
| 2010 | 18057.771 | 21894.848 | 30576.941 | 39618.856 |
| 2011 | 17979.866 | 21381.887 | 30895.224 | 39292.761 |
| 2012 | 17418.77 | 19870.103 | 30956.459 | 38131.096 |
| 2013 | 17930.433 | 21051.785 | 31530.286 | 38356.585 |
| 2014 | 18264.499 | 21445.407 | 31700.144 | 38628.936 |
| 2015 | 18156.023 | 20616.598 | 31371.665 | 37887.186 |
| 2016 | 18029.599 | 20177.818 | 31362.138 | 37724.379 |
| 2017 | 17898.687 | 19885.59 | 31817.282 | 37237.99 |
| 2018 | 18441.681 | 21511.563 | 32782.904 | 38168.215 |
| 2019 | 18015.828 | 21075.978 | 32703.717 | 37010.897 |
| 2020 | 16751.168 | 20554.825 | 31247.41 | 35611.002 |
| 2021 | 17451.367 | 20840.507 | 32473.927 | 36682.905 |
| 2022 | 18154.992 | 21807.417 | 32912.154 | 37751.374 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
