Google Sheets Guides

This page lists every Google Sheets tutorial on Statology.

Operations
How to Round to Significant Figures in Google Sheets
How to Round to the Nearest 5 in Google Sheets
How to Use COUNTIF with Multiple Ranges in Google Sheets
How to Format Pivot Tables in Google Sheets
Google Sheets: A Simple Formula for “If Contains”

Descriptive Statistics
How to Calculate a Five Number Summary in Google Sheets
How to Calculate the Interquartile Range in Google Sheets
How to Calculate the Midrange in Google Sheets
How to Calculate the Coefficient of Variation in Google Sheets
How to Calculate Skewness & Kurtosis in Google Sheets
How to Calculate Standard Error of the Mean in Google Sheets
How to Create a Covariance Matrix in Google Sheets
How to Create a Correlation Matrix in Google Sheets
How to Calculate the Dot Product in Google Sheets
How to Calculate Spearman Rank Correlation in Google Sheets
How to Normalize Data in Google Sheets
How to Calculate Frequencies in Google Sheets
How to Calculate the Mean Absolute Deviation in Google Sheets
How to Calculate Z-Scores in Google Sheets
How to Find A Line of Best Fit in Google Sheets
How to Find an Exponential Moving Average in Google Sheets
How to Sum Values by Category in Google Sheets
How to Perform a Median IF Function in Google Sheets

Visualizations
How to Create a Boxplot in Google Sheets
How to Create a Bubble Chart in Google Sheets
How to Create a Pareto Chart in Google Sheets
How to Create a Table in Google Sheets
How to Add a Horizontal Line to a Chart in Google Sheets

Hypothesis Tests
How to Perform t-Tests in Google Sheets
How to Perform the F-Test in Google Sheets
How to Find P-Values in Google Sheets
How to Find Critical Values in Google Sheets

Regression
How to Perform Linear Regression in Google Sheets
How to Perform Polynomial Regression in Google Sheets

ANOVA
One-Way ANOVA in Google Sheets
Repeated Measures ANOVA in Google Sheets

Chi-Square Tests
Chi-Square Goodness of Fit Test in Google Sheets

Query Functions
Google Sheets Query: How to Select Multiple Columns
Google Sheets Query: Select Rows that Contain String
Google Sheets Query: How to Create a Pivot Table
Google Sheets Query: How to Use Order By
Google Sheets Query: How to Use Group By
Google Sheets Query: How to Query From Another Sheet