How to use the RAND formula in Google Sheets In fields including but not limited statistics, science, gaming, cryptography etc. the use or random numbers is a commonplace. For instance, statisticians may use randomness in a randomized experiment to test their...

How to use the COLUMNS formula in Google Sheets Let us say we have a range of cells in a spreadsheet, and we want to know how many columns it has spread across. If there are only a few of them, we could probably do a quick observation and manually count the number....

How to use the FLOOR formula in Google Sheets While there are infinite rational numbers in mathematics, we don’t usually deal with all of them. That’s because, in real life, it isn’t even feasible. Consider currency for instance. We may make many money transaction...

How to use the LOG formula in Google Sheets In this post, we learned the behavior of natural logarithm and the usage of LN formula. While we can agree that the logarithm evaluated upon base e is quite useful in many fields, it isn’t as flexible. For instance, we can...

How to use the ROUND formula in Google Sheets While working with spreadsheets, we tend to come across many numbers that are rational. Some of them have more decimal values after the decimal point than desired. And our requirement may be such that we need to confine...

How to use the COUNTUNIQUE Google Sheets formula While working with spreadsheets, we are bound to do many sorts of calculations. And we will, at times need to calculate unique occurrences of a dataset. The number of unique customers that shopped at a store, for...

How to use the LARGE formula in Google Sheets Number crunching is one of the primary activities that the spreadsheets applications are built for. We all know how to find out the maximum value from a dataset, using the MAX formula. What if we need to find out the...

How to use the COVAR formula in Google Sheets Analyzing the data leads us to multiple interpretations as to what the underlying nature is. And we have many important statistical tools and metrics that help us with this exercise. One such important metric that...

How to use the CORREL formula in Google Sheets Analyzing data entails going through various statistical measures to understand the underlying nature and trends. Probably, one of the most commonly used statistical methods is Correlation. We use it to gauge the extent...

How to use the NORMSDIST formula in Google Sheets In this post, learn how to calculate the normal cumulative distribution by using the NORMSDIST formula in Google Sheets. The normal cumulative distribution is one of the most widely used probability distributions in...

How to use the NORMSINV formula in Google Sheets We are aware of the important role, the normal cumulative distribution plays in the field of statistics. We can derive a specialized case of normal cumulative distribution when mean is zero and the variance is 1. This...

How to use the STDEV formula in Google Sheets We carry out most of our data analysis tasks on spreadsheets applications. And we will need to arrive at some key statistical metrics to understand the nature of the dataset. Standard deviation is one such metric that...