Google Sheets Tutorials

Confidence interval is a useful metric used in statistics that will tell you how well your sample represents the population. If you’re wondering how to calculate confidence the interval in …

Google Sheets has many useful functions for making statistical calculations. One such function is the Z.TEST function, which will return a one-tailed P-value of a Z-test. In this tutorial, I …

Calculating Z-Score in Google Sheets is fairly easy once you learn the proper formula to do this. In this tutorial, I will show you how to calculate Z-Score in Google …

When working in Google Sheets there may be times where you want to show the normal distribution for a dataset. One great way to do that is to make a …

In Google Sheets, you can set up notifications that will email you whenever a spreadsheet is changed. Setting up these kinds of alerts is useful when you want to stay …

When you have three numeric variables in your dataset and you want to create a chart to display this data, a bubble chart might be the perfect chart type for …

There are many different ways to create data visualizations in Google Sheets depending on what elements of your data you want to view. One great way to help summarize your …

If you want to sort a dataset, but only return a certain number of items in Google Sheets, the SORTN function will come in handy. Not many people are aware …

If you are working with a set of data in Google Sheets and you want to find the minimum value in a range of cells based on a set of …

There are a few useful functions in Google Sheets that you can use to return substrings from a specific string. One such function is the right function. Using this formula …