Descriptive Statistics in Google Sheets

Often you may want to sum the values of some dataset in Google Sheets based…

In time series analysis, a moving average is simply the average value of a certain…

A line of best fit is a line that best “fits” the trend in a…

In statistics, a z-score tells us how many standard deviations away a value is from the mean. We…

One way to quantify the relationship between two variables is to use the Pearson correlation coefficient, which…

Frequencies tell us how often different values occur in a dataset. We can easily calculate frequencies…

To normalize a set of data values means to scale the values such that the…

In statistics, correlation refers to the strength and direction of a relationship between two variables. The value…

This tutorial explains how to calculate the dot product in Google Sheets. What is the…

Covariance is a measure of how changes in one variable are associated with changes in…