Analytics

Many times when we analyze data, we have some textual, or categorical variables. For example, we can have small, medium and big. Or we can have gender as male and female. Many times our data can use Yes and No as an answer. So, it becomes problematic to analyze such categorical data because we can not perform arithmetic on them. For this purpose COUNTIF function in Google Sheets can be very useful.

…

Using COUNTIF Function in Google Sheets to Describe Categorical VariableRead More »

When I analyze data, many times, I need to group different data source one with another. In such a situation, there is a need for playing with large datasets. One of the functions that I use in many cases to make my data clean when combining different data sources is the UNIQUE function in Google Sheets. This is one of the simplest functions.

…

How to Use UNIQUE Function in Google Sheets?Read More »

I will start the Analytics category here with this important function for your analytical skills. Many times you will need to play with the data you have to make a different analysis. I will share many tutorials here related to statistics and data analytics. Here we will look at the VLOOKUP function in Google Sheets. This is only the beginning.

…

Using VLOOKUP Function in Google SheetsRead More »