Integrated Dataset and Correlation Analysis: GDP per Capita and Refined Petroleum Consumption (GDP-PETRO-CORR) for Selected Countries, 2023

Context and Methodology

The dataset was created to examine the correlation between a country’s GDP per capita and its annual refined petroleum consumption per capita for the 10 largest countries in the world in 2023.

The dataset was generated through the transformation and integration of two external data sources (World Bank Data, and EIA). The final integrated file (CSV) was produced using Microsoft Excel functionalities, including VLOOKUP for record matching, filtering for the reference year (2023), and specific formulas to normalize the consumption value to a per capita basis.

Technical Details

The dataset's structure consists of a single integrated table (GDP-PETRO-CORR_INTEGRATED-DATA_2023.csv), and PDF file. The files follow a descriptive and consistent naming convention (ProjectAcronym_Content_Year). To open and view the data, standard spreadsheet software (e.g., Microsoft Excel, LibreOffice Calc) is required, as the file is supplied in the non-proprietary CSV format. 

Additional Resources

Comprehensive additional resources are provided to ensure the full reproducibility of the analysis:

• Documentation: The accompanying README.txt file serves as the codebook, detailing the exact Excel formulas, unit conversions (Mb/d to annual per capita) , and full source citations .
• Report: An Analytical Report (PDF) is included, containing the final visualization and conclusions of the correlation analysis. 

Further Details

The data is derived from publicly available sources and is licensed under CC BY 4.0 , allowing for unrestricted reuse, modification, and redistribution, provided the original author (the researcher) is properly credited. The full documentation provides details on data quality checks performed during the transformation.