United States US: Prevalence of HIV: Total: % of Population Aged 15-49 data was reported at 0.500 % in 2014. This stayed constant from the previous number of 0.500 % for 2013. United States US: Prevalence of HIV: Total: % of Population Aged 15-49 data is updated yearly, averaging 0.500 % from Dec 2008 (Median) to 2014, with 7 observations. The data reached an all-time high of 0.500 % in 2014 and a record low of 0.500 % in 2014. United States US: Prevalence of HIV: Total: % of Population Aged 15-49 data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s USA – Table US.World Bank: Health Statistics. Prevalence of HIV refers to the percentage of people ages 15-49 who are infected with HIV.; ; UNAIDS estimates.; Weighted Average;

Introduction

• HIV (human immunodeficiency virus) is a virus that attacks the body's immune system. If HIV is not treated, it can lead to AIDS (acquired immunodeficiency syndrome) which currently has no cure. Once people get HIV, they have it for life. But with proper medical care, HIV can be controlled. Symptoms: Influenza-like illness; Fatigue… Treatments: Management of HIV/AIDS Type of infectious agent: Virus (Human Immunodeficiency Virus) • AIDS (acquired immune deficiency syndrome) is the name used to describe a number of potentially life-threatening infections and illnesses that happen when one’s immune system has been severely damaged by the HIV virus. While AIDS cannot be transmitted from 1 person to another, the HIV virus can.

Dataset

The data set contains data of the following:- 1. The top causes of deaths in the world 2. Total number of deaths due to HIV/AIDS 3. ART (Anti Retro-viral Therapy) coverage among people living with HIV 4. Knowledge among young citizens (15-24years) about HIV/AIDS 5. Population of HIV/AIDS patients living with TB and their death rate 6. Life expectancy rate among HIV/AIDS patients 7. HIV/AIDS Patients in different age groups 8. Women population living with HIV 9. Young women in India having the knowledge of HIV/AIDS 10. HIV/AIDS deaths in Indian states

Data was scrapped from the official website of UNICEF -https://data.unicef.org/ and https://data.gov.in/

Ask Phase

• Data gives the trend of increasing no. of HIV/AIDS patients across the world • The information available for each country is percentage of total Global AIDS patients • Time period traced is 2000-2019 • Key Questions to answer:  Which countries and regions are affected the most?  How are the different age groups affected?  How much is the ART (Anti Retro-viral Therapy) coverage among the patients and what is the life expectancy rate?  What percentage of the population is aware of the prevention and causes of HIV/AIDS

Prepare phase.

• By tabulating and filtering the data the required data was obtained to bring out observations. • Data was formatted to the desired format to perform further calculations. • Sorting of data region wise. • Columns with inconsistent and empty cells were deleted. • The data of India was extracted for further analysis • Duplicate entries and undesired data was removed

Process phase

For cleaning the dataset for further analysis MS Excel was used due to small data. • Used sumifs() functions to aggregate the data region wise • Used sumif() to segregate the no. of patients within different age groups • Used sumifs() to find the total number of TB patients among HIV deaths. • Used countif() to find the percentage of male and female patients. • Sorted data to find the top and bottom nation with most and least HIV/AIDS patients

Analyze phase

• Formed the following pivot tables to answer key target questions  Year v/s number of death rates  Country v/s death numbers to bring out nation wise deaths  Causes of death v/s the number of deaths to bring at which position AIDS causes causality  Year v/s percentage of life expectancy to observe the pattern of no. of survivors

Visualization phase

The data was visualized using Tableau.

Presentaion

The final presentation was prepared by accumulating all observations and inferences which is linked below https://docs.google.com/presentation/d/1NEX10Vz5u5Va3CrTLVbvsUHZjO-fn8EOeiOHkP03T3Q/edit?usp=sharing

HIV prevalence of World remained constant at 0.7 % over the last 10 years. Prevalence of HIV refers to the percentage of people ages 15-49 who are infected with HIV.

AM: Incidence of HIV: per 1,000 Uninfected Population data was reported at 0.190 Ratio in 2022. This stayed constant from the previous number of 0.190 Ratio for 2021. AM: Incidence of HIV: per 1,000 Uninfected Population data is updated yearly, averaging 0.070 Ratio from Dec 1990 (Median) to 2022, with 33 observations. The data reached an all-time high of 0.190 Ratio in 2022 and a record low of 0.010 Ratio in 1999. AM: Incidence of HIV: per 1,000 Uninfected Population data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Armenia – Table AM.World Bank.WDI: Social: Health Statistics. Number of new HIV infections among uninfected populations expressed per 1,000 uninfected population in the year before the period.;UNAIDS estimates.;Weighted average;This is the Sustainable Development Goal indicator 3.3.1 [https://unstats.un.org/sdgs/metadata/].

The average for 2022 based on 135 countries was 1.66 percent. The highest value was in Swaziland: 25.9 percent and the lowest value was in Afghanistan: 0.1 percent. The indicator is available from 1990 to 2022. Below is a chart for all countries where data are available.

The states with the highest rates of HIV diagnoses in 2022 included Georgia, Louisiana, and Florida. However, the states with the highest number of people with HIV were Texas, California, and Florida. In Texas, there were around 4,896 people diagnosed with HIV. HIV/AIDS diagnoses In 2022, there were an estimated 38,043 new HIV diagnoses in the United States, a slight increase compared to the year before. Men account for the majority of these new diagnoses. There are currently around 1.2 million people living with HIV in the United States. Deaths from HIV The death rate from HIV has decreased significantly over the past few decades. In 2023, there were only 1.3 deaths from HIV per 100,000 population, the lowest rate since the epidemic began. However, the death rate varies greatly depending on race or ethnicity, with the death rate from HIV for African Americans reaching 19.2 per 100,000 population in 2022, compared to just three deaths per 100,000 among the white population.

HIV prevalence of United States of America remained constant at 0.4 % over the last 10 years. Prevalence of HIV refers to the percentage of people ages 15-49 who are infected with HIV.

Bulgaria BG: Prevalence of HIV: Total: % of Population Aged 15-49 data was reported at 0.100 % in 2022. This stayed constant from the previous number of 0.100 % for 2021. Bulgaria BG: Prevalence of HIV: Total: % of Population Aged 15-49 data is updated yearly, averaging 0.100 % from Dec 1990 (Median) to 2022, with 33 observations. The data reached an all-time high of 0.100 % in 2022 and a record low of 0.100 % in 2022. Bulgaria BG: Prevalence of HIV: Total: % of Population Aged 15-49 data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Bulgaria – Table BG.World Bank.WDI: Social: Health Statistics. Prevalence of HIV refers to the percentage of people ages 15-49 who are infected with HIV.;UNAIDS estimates.;Weighted average;

Women's share of population ages 15+ living with HIV of Viet Nam slipped by 1.35% from 30.1 % in 2021 to 29.7 % in 2022. Since the 0.03% improve in 2016, women's share of population ages 15+ living with HIV declined by 4.64% in 2022. Prevalence of HIV is the percentage of people who are infected with HIV. Female rate is as a percentage of the total population with HIV.

HIV prevalence of Trinidad and Tobago dropped by 9.09% from 1.1 % in 2021 to 1.0 % in 2022. Since the 7.14% slump in 2012, HIV prevalence plummeted by 23.08% in 2022. Prevalence of HIV refers to the percentage of people ages 15-49 who are infected with HIV.

Women's share of population ages 15+ living with HIV of Chad went up by 0.44% from 62.0 % in 2021 to 62.3 % in 2022. Since the 0.42% improve in 2012, women's share of population ages 15+ living with HIV jumped by 6.13% in 2022. Prevalence of HIV is the percentage of people who are infected with HIV. Female rate is as a percentage of the total population with HIV.

Women's share of population ages 15+ living with HIV of Germany went up by 0.41% from 19.9 % in 2021 to 20.0 % in 2022. Since the 0.80% improve in 2012, women's share of population ages 15+ living with HIV jumped by 13.34% in 2022. Prevalence of HIV is the percentage of people who are infected with HIV. Female rate is as a percentage of the total population with HIV.

HIV prevalence among population aged 15-49 of Lao People’s Democratic Republic remained constant at 0.4 % over the last 3 years. Prevalence of HIV refers to the percentage of people ages 15-49 who are infected with HIV.

Health Nutrition and Population Statistics database provides key health, nutrition and population statistics gathered from a variety of international and national sources. Themes include global surgery, health financing, HIV/AIDS, immunization, infectious diseases, medical resources and usage, noncommunicable diseases, nutrition, population dynamics, reproductive health, universal health coverage, and water and sanitation.

Cuba CU: Prevalence of HIV: Total: % of Population Aged 15-49 data was reported at 0.600 % in 2022. This stayed constant from the previous number of 0.600 % for 2021. Cuba CU: Prevalence of HIV: Total: % of Population Aged 15-49 data is updated yearly, averaging 0.200 % from Dec 1990 (Median) to 2022, with 33 observations. The data reached an all-time high of 0.600 % in 2022 and a record low of 0.100 % in 2003. Cuba CU: Prevalence of HIV: Total: % of Population Aged 15-49 data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Cuba – Table CU.World Bank.WDI: Social: Health Statistics. Prevalence of HIV refers to the percentage of people ages 15-49 who are infected with HIV.;UNAIDS estimates.;Weighted average;

Uruguay UY: Prevalence of HIV: Total: % of Population Aged 15-49 data was reported at 0.600 % in 2016. This stayed constant from the previous number of 0.600 % for 2015. Uruguay UY: Prevalence of HIV: Total: % of Population Aged 15-49 data is updated yearly, averaging 0.600 % from Dec 1990 (Median) to 2016, with 27 observations. The data reached an all-time high of 0.600 % in 2016 and a record low of 0.100 % in 1993. Uruguay UY: Prevalence of HIV: Total: % of Population Aged 15-49 data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Uruguay – Table UY.World Bank: Health Statistics. Prevalence of HIV refers to the percentage of people ages 15-49 who are infected with HIV.; ; UNAIDS estimates.; Weighted Average;

Women's share of population ages 15+ living with HIV of Israel went up by 0.12% from 28.1 % in 2021 to 28.2 % in 2022. Since the 0.05% improve in 2012, women's share of population ages 15+ living with HIV improved by 1.14% in 2022. Prevalence of HIV is the percentage of people who are infected with HIV. Female rate is as a percentage of the total population with HIV.

Antiretroviral therapy coverage (% of people living with HIV) in World was reported at 76 % in 2022, according to the World Bank collection of development indicators, compiled from officially recognized sources. World - Antiretroviral therapy coverage (% of people with advanced HIV infection) - actual values, historical data, forecasts and projections were sourced from the World Bank on September of 2025.

HIV prevalence among population aged 15-49 of Italy remained constant at 0.2 % over the last 4 years. Prevalence of HIV refers to the percentage of people ages 15-49 who are infected with HIV.

Women's share of population ages 15+ living with HIV of United States of America slipped by 0.13% from 21.9 % in 2021 to 21.9 % in 2022. Since the 0.20% downward trend in 2012, women's share of population ages 15+ living with HIV declined by 2.10% in 2022. Prevalence of HIV is the percentage of people who are infected with HIV. Female rate is as a percentage of the total population with HIV.