Lab 7. Pivot tables
Based on the following data set on world energy use:
http://www.inforum.uni.lodz.pl/dat/Arkusze/energy_data.xlsx
(source of raw data: www.wiod.org) prepare pivot tables/charts showing:
1) Total world energy use of all types in subsequent years [table].
2) Energy use in the world economy in subsequent years (in columns), and by sectors (in rows) [table].
3) Shares (in %) of energy sources in the sector “Electricity, gas and water supply” in a selected year [table and pie chart].
4) Rank of sectors by joint use of DIESEL and GASOLINE in a selected year, and a selected country, sorted descending [table and bar/column chart].
5) Changes in hard coal use (HCOAL) in subsequent sectors (in TJ) relative to the year 1995 [table].
6) Growth rates (% changes relative to the previous year) of electricity use by sectors in subsequent sectors, in a selected country [table].
7) Same as in point 6, but based on totals for a group of 3 selected countries [table].
8) A custom pivot table of your interest.