Develop line charts for each variable and identify the characteristics of the time series (that is, random, stationary, trend, seasoal, or cyclical). In forecasting the future, discuss whether all or only a portion of the data should be used.

Please explain how to do so on excel.

B E F G H O O O 1 Energy Production & Consumption (Quadrillion Btu) 2 3 4 Fossil Fuels Primary Energy Primary Energy Primary Energy Fossil Fuels Total Energy Nuclear Electric 5 Year Production Production Imports Exports Consumption Consumption Power Consumption 6 1949 28.748176 31.72216 1.448158 1.59176 29.002099 31.981503 0 7 1950 32.562667 35.540384 1.912887 1.465322 31.631956 34.615768 8 1951 35.792151 38.750615 1.892425 2.621545 34.008105 36.97403 9 1952 34.976732 37.916913 2.145984 2.365131 33.799903 36.747825 0 10 1953 35.349336 38.180796 2.313042 1.866013 34.826156 37.664468 0 11 1954 33.76433 36.51843 2.347876 1.696301 33.8773 36.639382 0 12] 1955 37.36368 40.147667 2.789908 2.285508 37.410105 40.207971 0 13 1956 39.771452 42.622033 3.206741 2.945377 38.888151 41.754252 0 14 1957 40.133484 42.98279 3.528983 3.439441 38.925592 41.787186 0.000112 15 1958 37.216322 40.133327 3.884371 2.049839 38.716702 41.645028 0.001915 16 1959 39.045216 41.948742 4.076278 1.533808 40.550068 43.465722 0.002187 17 1960 39.869117 42.803347 4.187626 1.477475 42.136751 45.086455 0.006026 18 1961 40.307136 43.27904 4.436901 1.376584 42.758243 45.737837 0.019678 19 1962 41.731885 44.875724 4.994279 1.472536 44.68077 47.826437 0.026394 20 1963 44.037181 47.171759 5.086654 1.835183 46.509283 49.644195 0.038147 21 1964 45.788951 49.054018 5.447296 1.814661 48.54305 51.814788 0.039819 22 1965 47.234902 50.673882 5.891935 1.828933 50.576504 54.015001 0.043164 23 1966 50.035367 53.531987 6.145832 1.829067 53.513987 57.014332 0.064158 24 1967 52.597132 56.375801 6.159155 2.115402 55.126873 58.904521 0.088456 25 1968 54.306187 58.220376 6.905114 1.998489 58.50247 62.414507 0.141534 26 1969 56.285569 60.534182 7.676216 2.125659 61.361751 65.61402 0.153722 27 1970 59.186071 63.495439 8.341615 2.632135 63.522269 67.838325 0.239347 28 1971 58.04156 62.716712 9.53477 2.150898 64.595645 69.282843 0.412939 29 1972 58.937904 63.903664 11.387141 2.11831 67.69588 72.687867 0.583752 30 1973 58.241491 63.562605 14.613145 2.033086 70.31386 75.68369 0.910177 31 1974 56.330758 62.344692 14.304275 2.203366 67.905124 73.962369 1.272083 32 1975 54.733273 61.320191 14.032389 2.323251 65.356532 71.964553 1.899798 33 1976 54.722896 61.561168 16.760059 2.171688 69.107176 75.974826 2.111121 34 1977 55.100782 62.011511 19.948131 2.051891 70.991179 77.96133 2.701762 35 1978 55.074118 63.103684 19.10617 1.920437 71.853522 79.950406 3.024126 36 1979 58.005609 65.90429 19.459817 2.855114 72.890521 80.858584 2.775827 37 1980 59.007873 67.175384 15.796235 3.694771 69.827758 78.066668 2.739169 38 1981 58.529329 66.950606 13.719027 4.307241 67.571093 76.105776 3.007589 39 1982 57.457822 66.568607 11.861081 4.607601 63.888374 73.099185 3.131148 40 1983 54.415961 64.114122 11.751802 3.692931 63.151858 72.970566 3.202549