Descriptive Statistics in Google Sheets
Descriptive Statistics in Google Sheets
How to Calculate Class Width in Google Sheets
In a frequency distribution, class width refers to the difference between the upper and lower boundaries of any class or category.
For example, the following frequency distribution...
Descriptive Statistics in Google Sheets
How to Easily Find Outliers in Google Sheets
An outlier is an observation that lies abnormally far away from other values in a dataset.
We often define an observation to be an outlier...
Descriptive Statistics in Google Sheets
How to Perform a Median IF Function in Google Sheets
You can use the following formula to perform a Median IF function in Google Sheets:
=MEDIAN(IF(GROUP_RANGE=VALUE, MEDIAN_RANGE))
This formula finds the median value of all cells...
Descriptive Statistics in Google Sheets
Google Sheets: How to Sum Values by Category
Often you may want to sum the values of some dataset in Google Sheets based on a category or group.
For example, suppose we have...
Descriptive Statistics in Google Sheets
Exponential Moving Average in Google Sheets (Step-by-Step)
In time series analysis, a moving average is simply the average value of a certain number of previous periods.
An exponential moving average is a type...
Descriptive Statistics in Google Sheets
How to Find A Line of Best Fit in Google Sheets
A line of best fit is a line that best “fits” the trend in a given dataset.
This tutorial provides a step-by-step example of how...
Descriptive Statistics in Google Sheets
How to Create a Correlation Matrix in Google Sheets
One way to quantify the relationship between two variables is to use the Pearson correlation coefficient, which is a measure of the linear association between two variables. It...
Subscribe
- Never miss a story with notifications
- Gain full access to our premium content
- Browse free from up to 5 devices at once
Must read