Energy Production Consumption (Quadrillion Btu) Fossil Fuels Primary Energy Primary Energy Primary Energy Fossil Fuels Total Energy Nuclear Electric Year Production Production Imports Exports Consumption Consumption Power Consumption 1949 28 748176 31 72216 1 448158 1 59176 29 002099 31 981503 0 1950 32 562667 35 540384 1 912887 1 465322 31 631956 34 615768 0 1951 35 792151 38 750615 1 892425 2 621545 34 008105 36 97403 0 1952 34 976732 37 916913 2 145984 2 365131 33 799903 36 747825 0 1953 35 349336 38 180796 2 313042 1 866013 34 826156 37 664468 0 1954 33 76433 36 51843 2 347876 1 696301 33 8773 36 639382 0 1955 37 36368 40 147667 2 789908 2 285508 37 410105 40 207971 0 1956 39 771452 42 622033 3 206741 2 945377 38 888151 41 754252 0 1957 40 133484 42 98279 3 528983 3 439441 38 925592 41 787186 0 000112 1958 37 216322 40 133327 3 884371 2 049839 38 716702 41 645028 0 001915 1959 39 045216 41 948742 4 076278 1 533808 40 550068 43 465722 0 002187 1960 39 869117 42 803347 4 187626 1 477475 42 136751 45 086455 0 006026 1961 40 307136 43 27904 4 436901 1 376584 42 758243 45 737837 0 019678 1962 41 731885 44 875724 4 994279 1 472536 44 68077 47 826437 0 026394 1963 44 037181 47 171759 5 086654 1 835183 46 509283 49 644195 0 038147 1964 45 788951 49 054018 5 447296 1 814661 48 54305 51 814788 0 039819 1965 47 234902 50 673882 5 891935 1 828933 50 576504 54 015001 0 043164 1966 50 035367 53 531987 6 145832 1 829067 53 513987 57 014332 0 064158 1967 52 597132 56 375801 6 159155 2 115402 55 126873 58 904521 0 088456 1968 54 306187 58 220376 6 905114 1 998489 58 50247 62 414507 0 141534 1969 56 285569 60 534182 7 676216 2 125659 61 361751 65 61402 0 153722 1970 59 186071 63 495439 8 341615 2 632135 63 522269 67 838325 0 239347 1971 58 04156 62 716712 9 53477 2 150898 64 595645 69 282843 0 412939 1972 58 937904 63 903664 11 387141 2 11831 67 69588 72 687867 0 583752 1973 58 241491 63 562605 14 613145 2 033086 70 31386 75 68369 0 910177 1974 56 330758 62 344692 14 304275 2 203366 67 905124 73 962369 1 272083 1975 54 733273 61 320191 14 032389 2 323251 65 356532 71 964553 1 899798 1976 54 722896 61 561168 16 760059 2 171688 69 107176 75 974826 2 111121 1977 55 100782 62 011511 19 948131 2 051891 70 991179 77 96133 2 701762 1978 55 074118 63 103684 19 10617 1 920437 71 853522 79 950406 3 024126 1979 58 005609 65 90429 19 459817 2 855114 72 890521 80 858584 2 775827 1980 59 007873 67 175384 15 796235 3 694771 69 827758 78 066668 2 739169 1981 58 529329 66 950606 13 719027 4 307241 67 571093 76 105776 3 007589 1982 57 457822 66 568607 11 861081 4 607601 63 888374 73 099185 3 131148 1983 54 415961 64 114122 11 751802 3 692931 63 151858 72 970566 3 202549 1984 58 849156 68 83955 12 470726 3 786147 66 505984 76 631701 3 552531 1985 57 538724 67 698304 11 780575 4 196178 66 09315 76 392385 4 075563 1986 56 575231 67 06648 14 151402 4 021479 66 033275 76 647005 4 380109 1987 57 166745 67 542485 15 398223 3 81195 68 520615 79 054456 4 753933 1988 57 874997 68 918719 17 29593 4 366453 71 557051 82 709172 5 586968 1989 57 482679 69 320072 18 766297 4 660899 72 911156 84 785998 5 602161 1990 58 559602 70 704629 18 817258 4 752484 72 332203 84 485118 6 10435 1991 57 871727 70 362375 18 334821 5 140965 71 880348 84 437962 6 422132 1992 57 655057 69 955616 19 372204 4 936942 73 395686 85 782977 6 479206 1993 55 822082 68 31536 21 272542 4 258366 74 835705 87 42362 6 410499 1994 58 043638 70 725632 22 389927 4 061146 76 2564 89 091331 6 693877 1995 57 540135 71 173994 22 260473 4 510868 77 259296 91 029071 7 075436 1996 58 387225 72 486072 23 701778 4 633266 79 784722 94 022218 7 086674 1997 58 856691 72 471913 25 215347 4 513993 80 873464 94 602201 6 596992 1998 59 314083 72 87623 26 580687 4 2992 81 36898 95 017912 7 067809 1999 57 614481 71 742196 27 252254 3 714985 82 427168 96 651965 7 610256 2000 57 366024 71 332158 28 972788 4 005863 84 730573 98 814473 7 862349 2001 58 541348 71 734567 30 157055 3 770671 82 901596 96 168164 8 028853 2002 56 833673 70 713029 29 408183 3 668722 83 698975 97 645141 8 145429 2003 56 032784 69 93828 31 061029 4 054219 84 013528 97 942622 7 958858 2004 55 942348 70 232902 33 543727 4 433981 85 818797 100 160004 8 221985 2005 55 044002 69 434001 34 709032 4 559902 85 794214 100 281501 8 16081 2006 55 937854 70 751869 34 678919 4 872577 84 702035 99 629524 8 215414 2007 56 435649 71 419023 34 703625 5 483466 86 21138 101 31413 8 455364 2008 57 587014 73 233667 32 993294 7 062745 83 55108 99 292861 8 427297 2009 56 670274 72 681078 29 705994 6 965738 78 486601 94 596985 8 356019 2010 58 206642 74 769217 29 877211 8 23423 81 412091 98 016397 8 434433 2011 60 563478 78 002358 28 719733 10 458598 79 896457 97 366497 8 268698 2012 62 342412 79 251064 27 074759 11 356824 77 946105 94 976067 8 050282 The Excel file Energy Production Consumption provides data on production, imports, exports, and consumption Develop line charts for each variable and identify key characteristics of the time series (e g , trends or cycles)

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 13, 2024

Energy Production & Consumption (Quadrillion Btu) Fossil Fuels Primary Energy Primary Energy Primary Energy Fossil Fuels Total Energy Nuclear Electric Year Production Production Imports Exports

Energy Production & Consumption (Quadrillion Btu)


	Fossil Fuels	Primary Energy	Primary Energy	Primary Energy	Fossil Fuels	Total Energy	Nuclear Electric
Year	Production	Production	Imports	Exports	Consumption	Consumption	Power Consumption
1949	28.748176	31.72216	1.448158	1.59176	29.002099	31.981503	0
1950	32.562667	35.540384	1.912887	1.465322	31.631956	34.615768	0
1951	35.792151	38.750615	1.892425	2.621545	34.008105	36.97403	0
1952	34.976732	37.916913	2.145984	2.365131	33.799903	36.747825	0
1953	35.349336	38.180796	2.313042	1.866013	34.826156	37.664468	0
1954	33.76433	36.51843	2.347876	1.696301	33.8773	36.639382	0
1955	37.36368	40.147667	2.789908	2.285508	37.410105	40.207971	0
1956	39.771452	42.622033	3.206741	2.945377	38.888151	41.754252	0
1957	40.133484	42.98279	3.528983	3.439441	38.925592	41.787186	0.000112
1958	37.216322	40.133327	3.884371	2.049839	38.716702	41.645028	0.001915
1959	39.045216	41.948742	4.076278	1.533808	40.550068	43.465722	0.002187
1960	39.869117	42.803347	4.187626	1.477475	42.136751	45.086455	0.006026
1961	40.307136	43.27904	4.436901	1.376584	42.758243	45.737837	0.019678
1962	41.731885	44.875724	4.994279	1.472536	44.68077	47.826437	0.026394
1963	44.037181	47.171759	5.086654	1.835183	46.509283	49.644195	0.038147
1964	45.788951	49.054018	5.447296	1.814661	48.54305	51.814788	0.039819
1965	47.234902	50.673882	5.891935	1.828933	50.576504	54.015001	0.043164
1966	50.035367	53.531987	6.145832	1.829067	53.513987	57.014332	0.064158
1967	52.597132	56.375801	6.159155	2.115402	55.126873	58.904521	0.088456
1968	54.306187	58.220376	6.905114	1.998489	58.50247	62.414507	0.141534
1969	56.285569	60.534182	7.676216	2.125659	61.361751	65.61402	0.153722
1970	59.186071	63.495439	8.341615	2.632135	63.522269	67.838325	0.239347
1971	58.04156	62.716712	9.53477	2.150898	64.595645	69.282843	0.412939
1972	58.937904	63.903664	11.387141	2.11831	67.69588	72.687867	0.583752
1973	58.241491	63.562605	14.613145	2.033086	70.31386	75.68369	0.910177
1974	56.330758	62.344692	14.304275	2.203366	67.905124	73.962369	1.272083
1975	54.733273	61.320191	14.032389	2.323251	65.356532	71.964553	1.899798
1976	54.722896	61.561168	16.760059	2.171688	69.107176	75.974826	2.111121
1977	55.100782	62.011511	19.948131	2.051891	70.991179	77.96133	2.701762
1978	55.074118	63.103684	19.10617	1.920437	71.853522	79.950406	3.024126
1979	58.005609	65.90429	19.459817	2.855114	72.890521	80.858584	2.775827
1980	59.007873	67.175384	15.796235	3.694771	69.827758	78.066668	2.739169
1981	58.529329	66.950606	13.719027	4.307241	67.571093	76.105776	3.007589
1982	57.457822	66.568607	11.861081	4.607601	63.888374	73.099185	3.131148
1983	54.415961	64.114122	11.751802	3.692931	63.151858	72.970566	3.202549
1984	58.849156	68.83955	12.470726	3.786147	66.505984	76.631701	3.552531
1985	57.538724	67.698304	11.780575	4.196178	66.09315	76.392385	4.075563
1986	56.575231	67.06648	14.151402	4.021479	66.033275	76.647005	4.380109
1987	57.166745	67.542485	15.398223	3.81195	68.520615	79.054456	4.753933
1988	57.874997	68.918719	17.29593	4.366453	71.557051	82.709172	5.586968
1989	57.482679	69.320072	18.766297	4.660899	72.911156	84.785998	5.602161
1990	58.559602	70.704629	18.817258	4.752484	72.332203	84.485118	6.10435
1991	57.871727	70.362375	18.334821	5.140965	71.880348	84.437962	6.422132
1992	57.655057	69.955616	19.372204	4.936942	73.395686	85.782977	6.479206
1993	55.822082	68.31536	21.272542	4.258366	74.835705	87.42362	6.410499
1994	58.043638	70.725632	22.389927	4.061146	76.2564	89.091331	6.693877
1995	57.540135	71.173994	22.260473	4.510868	77.259296	91.029071	7.075436
1996	58.387225	72.486072	23.701778	4.633266	79.784722	94.022218	7.086674
1997	58.856691	72.471913	25.215347	4.513993	80.873464	94.602201	6.596992
1998	59.314083	72.87623	26.580687	4.2992	81.36898	95.017912	7.067809
1999	57.614481	71.742196	27.252254	3.714985	82.427168	96.651965	7.610256
2000	57.366024	71.332158	28.972788	4.005863	84.730573	98.814473	7.862349
2001	58.541348	71.734567	30.157055	3.770671	82.901596	96.168164	8.028853
2002	56.833673	70.713029	29.408183	3.668722	83.698975	97.645141	8.145429
2003	56.032784	69.93828	31.061029	4.054219	84.013528	97.942622	7.958858
2004	55.942348	70.232902	33.543727	4.433981	85.818797	100.160004	8.221985
2005	55.044002	69.434001	34.709032	4.559902	85.794214	100.281501	8.16081
2006	55.937854	70.751869	34.678919	4.872577	84.702035	99.629524	8.215414
2007	56.435649	71.419023	34.703625	5.483466	86.21138	101.31413	8.455364
2008	57.587014	73.233667	32.993294	7.062745	83.55108	99.292861	8.427297
2009	56.670274	72.681078	29.705994	6.965738	78.486601	94.596985	8.356019
2010	58.206642	74.769217	29.877211	8.23423	81.412091	98.016397	8.434433
2011	60.563478	78.002358	28.719733	10.458598	79.896457	97.366497	8.268698
2012	62.342412	79.251064	27.074759	11.356824	77.946105	94.976067	8.050282

The Excel fileEnergy Production & Consumptionprovides data on production, imports, exports, and consumption. Develop line charts for each variable and identify key characteristics of the time series (e.g., trends or cycles).