Excel Data analysis

Running head: MIS APPLICATION SOFTWARE EXERCISE SOLUTION 1

MIS APPLICATION SOFTWARE EXERCISE SOLUTION 2

Week Two: Hands-on MIS Application Software Exercise Solution

Woan Ru Liao

National University

MGT608

Professor Timothy Pettit

October 5, 2020

World Health Statistics

Human immunodeficiency virus (HIV) is two kinds of lentivirus that infect humans. HIV can lead to Acquired Immunodeficiency Syndrome. In this case, the gradual failure of the immune system can cause life-threatening opportunistic infections and cancer to develop rapidly. HIV is a sexually transmitted infection that occurs through contact or transfer with blood, pre-ejaculation, semen, and vaginal fluid. Nowadays, people are sexually open and easily spread AIDS. After some arduous research, the following are the results of some health statistics people found covering the world. This article is going to present the statistics of the top countries with the largest number of citizens infected by HIV; which country has the healthiest population; which country has the longest life expectancy, which country has a high birth rate, and which country has a low birth rate.

First, through this research, we can know that disease has covered most of the world and discovered the top 10 countries where the number of HIV infections remains high. Refer to Figure 1, people can notice that nine out of ten countries live on the African continent. From the list, all countries in Africa accounted for 96.6% of the infected population. Lesotho ranks first with 23.6% of the population (around 484,000 out of a population of 2.049 million) who are carriers of the disease. The top 10 is Ukraine, with 1.1% of its population infected (around 509,000 out of 46.258 million). It can be seen that this virus has been plagued in the African continent.

Figure 1. Top 10 Countries with highest HIV.

Next, from studying the research, we also discovered some of the healthiest countries in the world. According to the research, Costa Rica is considered to be one of the healthiest countries, and about 26.1% of the population will face death within the adult age of around 78. The HIV infection rate of 0.3% is very low. Moreover, Djibouti is still one of the healthiest countries, even though it is also the country with the most people infected with HIV by 2.6%. All other countries have very low HIV infection rates except for Djibouti. See Figure 2. Only a small part of most countries suffer from this virus. One noticeable fact is that a large number of people live in rural areas of the country. About one-third of people live in rural areas of Costa Rica. They have the highest proportion of life as an adult; they also have one of the lowest HIV prevalence rates.

Figure 2. Top 10 highest countries.

After studying the data, we know that Australia has the highest and developed life expectancy. Refer to Figure 3. From the information, it can see that there is a positive correlation between developed countries and life expectancy. Except for a few countries (Costa Rica, Chile, and Malta), life expectancy in most developed countries is high. Furthermore, Figure 3 also represents the correlation between the healthy, elderly population and the average living age of each person in these countries/regions. Australia leads ahead in this category, with an average age under 81.4, while Slovakia is 78.77.

Figure 3. Top 10 countries with highest life expectancy.

Last, from the research, we found that Africa ranks among the top five in the world in terms of the average birth rate per 1000 people. See Figure 4. Overall, most underdeveloped countries have higher birth rates. However, some countries such as Samoa, Bosnia and Herzegovina have low birth rates and are underdeveloped. In developing countries, young people need to work and take care of the elderly. Besides, due to the low level of female education and lack of birth control measures, the birth rate in developing countries is often higher. In developed countries, the birth rate of people is often low. Children may become an economic burden, also women have / take higher education. People can easily access some birth control tools. This is the reason why the birth rate is not high in developed countries.

Figure 4. Top 10 countries with birth rate.

To summarize, the countries with the highest HIV epidemic are Lesotho, Solomon Islands, and New Zealand. The healthiest country is Costa Rica. Australia has the highest life expectancy. Niger is the highest birth rate, and Bosnia and Herzegovina is the lowest birth rate.

Healthiest Countries

Sum of Health Djibouti New Zealand Costa Rica Norway Portugal Chile Australia Peru United Kingdom Mexico 849,000 4,269,000 4,519,000 4,768,000 10,622,000 16,804,000 21,432,000 28,837,000 61,407,000 106,350,000 0.15340131140000002 0.1832653377 0.26092581379999996 0.16675721660000001 0.15435693540000001 0.1556843554 0.17098927559999999 0.1558879256 0.15120665960000002 0.14957102580000001 Sum of HIV Djibouti New Zealand Costa Rica Norway Portugal Chile Australia Peru United Kingdom Mexico 849,000 4,269,000 4,519,000 4,768,000 10,622,000 16,804,000 21 ,432,000 28,837,000 61,407,000 106,350,000 2.5999999999999999E-2 1E-3 3.0000000000000001E-3 1E-3 5.0000000000000001E-3 4.0000000000000001E-3 1E-3 4.0000000000000001E-3 2E-3 3.0000000000000001E-3 Sum of Rural Djibouti New Zealand Costa Rica Norway Portugal Chile Australia Peru United Kingdom Mexico 849,000 4,269,000 4,519,000 4,768,000 10,622,000 16,804,000 21,432,000 28,837,000 61,407,000 106,350,000 0.127 0.13439999999999999 0.3674 0.22520000000000001 0.40539999999999998 0.11559999999999999 0.11260000000000001 0.28599999999999998 0.10059999999999999 0.22800000000000001

Country

% Population of Healthy / Infected

Countries with Highest Life Expectancy

Sum of LifeExpectancy 21,432,000 10,708,000 4,519,000 7,309,000 489,000 412,000 4,269,000 4,768,000 2,021,000 61,407,000 Australia Belgium Costa Rica Israel Luxembourg Malta New Zealand Norway Slovenia United Kingdom 81.395121950000004 80.426829269999999 78.918024389999999 81.002439019999997 80.087804879999993 79.431707320000001 80.351219510000007 80.592682929999995 78.765853660000005 79.599999999999994 Sum of Health 21,432,000 10,708,000 4,519,000 7,309,000 489,000 412,000 4,269,000 4,768,000 2,021,000 61,407,000 Australia Belgium Costa Rica Israel Luxembourg Malta New Zealand Norway Slovenia United Kingdom 0.17098927559999999 0.14842694140000001 0.26092581379999996 0.10024707570000001 0.13715663109999998 0.12282870210000001 0.1832653377 0.16675721660000001 0.12911058089999999 0.15120665960000002 Sum of ElderlyPop 21,432,000 10,708,000 4,519,000 7,309,000 489,000 412,000 4,269,000 4,768,000 2,021,000 61,407,000 Australia Belgium Costa Rica Israel Luxembourg Malta New Zealand Norway Slovenia United Kingdom 0.1341461655 0.17242595120000001 6.1833637740000003E-2 0.1004248814 0.1403650407 0.1401736126 0.125430821 0.14645588809999999 0.16026755670000001 0.16301912460000001

Country

% Life Expectancy

Countries with Birth Rate

0 3773000 80713000 9833000 38765000 2266000 3358000 412000 14704000 10622000 31657000 Bosnia and Herzegovina Ethiopia Guinea Kenya Latvia Lithuania Malta Niger Portugal Uganda 39.633000000000003 53.536000000000001 46.151000000000003 1 3773000 80713000 9833000 38765000 2266000 3358000 412000 14704000 10622000 31657000 Bosnia and Herzegovina Ethiopia Guinea Kenya Latvia Lithuania Malta Niger Portugal Uganda 9.0969999999999995 38.229999999999997 38.767000000000003 2 3773000 80713000 9833000 38765000 2266000 3358000 412000 14704000 10622000 31657000 Bosnia and Herzegovina Ethiopia Guinea Kenya Latvia Lithuania Malta Niger Portugal Uganda 10.6 10.4 10 9.8000000000000007

Country

Birth Rate

Countries with the Highest HIV

Total Infected Population Ukraine Guinea Gambia, The Djibouti Central African Republic Kenya Uganda Namibia South Africa Lesotho 508837.99999999994 137662 18122 22074 221289 2442195 2026048 291810 8733947 483564 Population Ukraine Guinea Gambia, The Djibouti Central African Republic Kenya Uganda Namibia South Africa Lesotho 46258000 9833000 1066000 849000 4339000 38765000 31657000 2130000 48793000 2049000

Country

% of population infected