In the last chapter, I went through all the basics needed to work with Distributions. Let us now use them to do Analysis in Excel. NORM.DIST I always use datasets that are current and great to give insights. …

I will say, Data Visualization(charts)/Descriptive statistics is important in Analysis for the Analysts to get an idea of the data he is working on/How to go about it. But to interpret /conclude his Analysis these are not sufficient. Therefore Inferential statistics is our need. To be an expert in doing…

This first part of the chapter is not so important but I still decided to cover these formulae that are actually under the Measures of Frequency. I feel we use Excel so much and these are very frequently used so do not require any explanation. Counting: COUNT-Counts the number of…

We finished Measures of central tendency Measures of dispersion Now we will go through Measures of Position: Rank and Percentiles. We had mean, then why median, we had Measures of central tendency(mean, median, mode) then why variance, we had Variance then why standard deviation. …

Measures of Central tendency(Mean, median, mode) is a great way of summarizing but statisticians cannot rely on them as they do not give all the information of the data. Now comes Measures of dispersion: Variance STandrad deviation Range If I have two groups with heights of students 48,48,48,48,48 and second…

When you are doing Analysis in Statistics you have two main categories : a.Graphical Analysis(Data Visualization) b.Descriptive and Inferential Statistics I already went through all the visualizations possible through the chart types, but as an analyst that is only giving you a bigger picture of the data and is not…

When I started studying Data Analytics and Data science I had to go back to my high school textbooks to learn what these charts meant and where I can use them. …

In this chapter, I want to finish some of the not most important charts altogether. Surface Radar Treemap and Sunburst. The surface chart is a 3-dimensional way to show the results of combining one variable with another. I am using my same Kaggle dataset of covid vaccinations. COVID-19 World Vaccination Progress Daily and Total Vaccination for COVID-19 in the World from Our World in Datawww.kaggle.com

Before moving forward to learn about a new chart type, it is good to know where it can be used. I hope as Analysts we all are aware of the concept of Linear Regression. In fact, I remember learning this concept first time in high school. Linear regression is a…