Done Statistical Analysis on the 2011 Indian population census data to extract crucial insights about the different factors such as total population, population growth rate, sex_ratio, literacy_rate, and population density that represent the demographic, social, economic, and culture of the Indian population by solving some key questions using SQL.
1e3a62_1bfb5338078842639e7b7b12de6e882b~mv2
A census is a process that includes collecting demographic, social, cultural, and economic data about a country or a part of a country, which is then sent to the data centers where data is analyzed and presented to the running government so it can take useful measures and make policies and thus present in the public domain for the people of a country to know. " In India, the population census is conducted after every ten years. It is one of the world's largest administrative exercises. The last census in India was conducted in 2011. The next census was scheduled for 2021, but was postponed due to the COVID-19 pandemic. The next census is expected to be held after the 2024 general election."
The population growth rate (PGR) is a factor that represents the rate of population growth or the change in number of people over a specific period. It can indicate growth, decline, or equilibrium of population size.
In India, the sex ratio is defined as the number of females per 1000 males (disregarding other genders), whereas in almost all the UN publications/International publications, it is expressed as males to per 100 females.
The birth rate is the number of live births per 1000 people in a given area during a specific period. The death rate is the number of deaths per 1000 people in a given area during a specific period.
The literacy rate in India is calculated by dividing the total number of literate people aged 7 or above by the total number of population aged 7 or above and multiplying the result by 100
Population Density is the number of people living in a specific area. It is calculated by dividing the total population of an area by its total land area. It is expressed as "per kilometer square". It is used to describe the location, growth, and migration of organisms.
- PᴏꜱᴛɢʀᴇSQL
- PGAᴅᴍɪɴ
- MS Exᴄᴇʟ (EDA)