Trend Analysis: A bar chart detailing the rise in chronic kidney disease cases from 1990 to 2019, identifying key factors contributing to the trend.
Cleaned Sheet after Power Query.
Correlation Study: A scatter plot examining the relationship between conflict, terrorism, and deaths by fire, heat, and hot substances, with a fitted trend line suggesting a positive correlation.
Disease Impact Over Time: A scatter plot showing the fluctuation in deaths due to HIV/AIDS over the years, highlighting the disease’s impact.
Original Uncleaned Sheet.
Data Cleaning: Screenshots of Excel and Power Query demonstrate the cleaning process, where null values are replaced with zeroes to ensure accuracy in subsequent calculations.
Self inflicted Deaths 1998 - 2020.
Geographical Analysis: A choropleth map detailing deaths in Africa due to protein-energy malnutrition, providing insights into regional disparities.
>Descriptive Statistics: Utilization of the Data Analysis Add-in in Excel to compute key statistical metrics for various causes of death.