1. The Excel file Energy Production & Consumption provides various energy data since 1949. a. Construct an area chart showing the fossil fuel consumption as a proportion of total energy consumption. b. Construct line charts for total energy production and total energy imports. c. Construct a scatter diagram for total energy consumption and total energy production. 2. Consider the information contained in the Excel file Gas and Electric. a. Construct appropriate charts to visually display this information. b. What conclusions can you draw from these charts?