PROJECT DATASET: GDP-PETRO-CORR_INTEGRATED-DATA, licensed CC BY 4.0

1. IDENTIFICATION
- Project (dataset) title: What is the correlation between country’s GDP per capita and its consumption of refined petroleum products per capita in the year 2023 in ten biggest countries in the world?
- Version V1.0
- Author: Zofia Poślednik
- ORCID: 0009-0006-6701-4716
- Creation date: 28.10.2025
- Experiment goal:Examining the corelation between GDP per capita and a usage of petroleum and other liquids (converted per capita as well) for ten biggest countries in the world in the year 2023. 

2. DATA SOURCES AND LICENSES
Three datasets on which the work is based on:
- Source 1: GDP per capita and Population data
 - Provider: The World Bank Data
 - Indicators: WB_GDP_RAW and WB_POP.TOTL_RAW
 - Access links: https://data.worldbank.org/indicator/NY.GDP.PCAP.CD and https://data.worldbank.org/indicator/SP.POP.TOTL
 - License: CC BY 4.0 (Creative Commons Attribution 4.0 International)
 - Citation: Must attribute The World Bank.
- Source 2: Annual Refined Petroleum Products Consumption
 - Provider: Energy Information Administration (EIA) platform (US government data)
 - Indicators: EIA_PETROLEUM_Mb-d_RAW
 - Access link: https://www.eia.gov/international/data/world/petroleum-and-other-liquids/annual-refined-petroleum-products-consumption?pd=5&p=0000001001vg0000000000000000000000000000000000g&u=0&f=A&v=mapbubble&a=-&i=none&vo=value&t=C&g=00000000000000000000000000000000000000000000000001&l=249-ruvvvvvfvtvnvv1vrvvvvfvvvvvvfvvvou20evvvvvvvvvvnvvvs0008&s=94694400000&e=1704067200000 
 - License: Public Domain/Open Access

3. DATA DICTIONARY
Two datasets as a result:
- PDF report
- CSV file (GDP-PETRO-CORR_INTEGRATED-DATA_2023)
 COLUMNS
 - COUNTRY | The name of the country (text).
 - GDP per capita in 2023 [USD] | Gross Domestic Product per capita in current US dollar from the World Bank
 - Petroleum consumption in 2023 [Mb/d] | Total refined petroleum products consumed per day in thousands barrels from EIA
 - Petroleum consumption in 2023 [Mb/year] | Total refined petroleum products per year in thousands barrels (calculated: Petroleum consumption in 2023 [Mb/d] * 365)
 - Total population in 2023 |People living in the country from the World Bank
 - Petroleum consumption per capita in 2023 [Mb/capita] | Total refined petroleum products in thousands barrels per capita (calculated: Petroleum consumption in 2023 [Mb/year] / Total population in 2023)

4. DATA TRANSFORMATION
The data was processed using Microsoft Excel according to the below methodology outline:
 1. Raw data from both sources (WB and EIA) was loaded into separate Excel sheets. They were merged and integrated into a single sheet,and the *VLOOKUP* function was used to combine the data by the country name. 
 2. The dataset was filtered to include only ten biggest countries in the world and the reference year (2023).
 3. The EIA data, originally provided in Mb/d was converted to Mb/year (see the formula above).
 4. The final indicator was calculated (see the formula above).

5. ANALYSIS RESULTS AND PUBLICATION
- Analysis tool: Microsoft Excel (function CORREL)
- Correlation result = 0,927866888
- Limitation: This result is based on a small sample size.
- License for CSV dataset: CC BY 4.0