Study to analyze the data using Excel to figure out the effect of Covid_19 on populations and distribution of it using Excel only Business analysis project using statistical tests.
First of all, we got the dataset from an official site, WHO organization, after confirmed vaccination rates around the world. The dataset contained more than 300 rows of data.
1- Data cleaning and Pre-processing: Making sure our dataset is clean, clear, contains the right format for each type of data in the excel sheet with maintaining consistency by handling null and missing values.
2- Creating the right data visulaization chart/graph based on the type of story we will be telling including:
A- Showing the percentages of vaccinated people compared to the population of the content in the entire world - Bar chart.
B- Studying the coorelation between school closure after vaccination dates - Pie chart , the dates of school closure in the dataset showed that after certain percentages of death rates in each continent , the schools closed for a different amount of time in each continent.
C- Performing predictive analytics through linear regression using the Anova Test to predict the correlation between the death rates and the vaccinated poulation having the death rates as the dependent variable and predicted outcome and the vaccinated rates where it showed a strong correlation between the vaccination and death rates for populations under 2 billion.