Google Sheets Guides

This page lists every Google Sheets tutorial on Statology.

Operations
How to Round to Significant Figures in Google Sheets
How to Auto Increment Values in Google Sheets
How to Use COUNTIF with Multiple Ranges in Google Sheets
How to Use COUNTIF From Another Sheet in Google Sheets
How to Use COUNTIF with OR in Google Sheets
How to Use COUNTIFS with Date Range in Google Sheets
How to Use SUMIF with Multiple Columns in Google Sheets
How to Use Multiple IF Statements in Google Sheets
How to Sum Filtered Rows in Google Sheets
How to Filter Multiple Columns in Google Sheets
How to Filter for Cells that Contain Text in Google Sheets
How to Count Number of Occurrences in Google Sheets
How to Replace Blank Cells with Zero in Google Sheets
How to Replace Text in Google Sheets
How to Check if Value is in Range in Google Sheets
How to Convert Between Month Name & Number in Google Sheets
How to Compare Two Columns in Google Sheets
How to Combine the IF and OR Functions in Google Sheets
How to Combine the IF and AND Functions in Google Sheets
How to Calculate the Difference Between Dates in Google Sheets
How to Filter by Date Range in Google Sheets
How to Add & Subtract Days in Google Sheets
How to AutoFill Dates in Google Sheets
How to Link to Another Tab in Google Sheets
How to Randomize a List in Google Sheets
How to Count Unique Values in Google Sheets
How to Select a Random Sample in Google Sheets
How to Extract Substring in Google Sheets
How to Combine Columns in Google Sheets
How to Calculate Compound Interest in Google Sheets
How to Use the PMT Function in Google Sheets
How to Sum Across Multiple Sheets in Google Sheets
How to Add Calculated Field to Pivot Table in Google Sheets
How to Format Pivot Tables in Google Sheets
How to Perform What-If Analysis in Google Sheets
Google Sheets: A Simple Formula for “If Contains”

Descriptive Statistics
How to Calculate Descriptive Statistics in Google Sheets
How to Calculate a Five Number Summary in Google Sheets
How to Calculate the Interquartile Range in Google Sheets
How to Calculate Standard Deviation 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 Class Width in Google Sheets
How to Calculate the Mean Absolute Deviation in Google Sheets
How to Calculate Z-Scores in Google Sheets
How to Calculate Percent Change in Google Sheets
How to Calculate Cumulative Percentage in Google Sheets
How to Find Outliers 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 Calculate CAGR 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 Pie Chart in Google Sheets
How to Create a Dot Plot in Google Sheets
How to Create a Bell Curve in Google Sheets
How to Create a Combo Chart in Google Sheets
How to Create a Double Bar Graph in Google Sheets
How to Create a Stacked Bar Chart in Google Sheets
How to Create a Candlestick Chart in Google Sheets
How to Create a Table in Google Sheets
How to Add Error Bars to Charts in Google Sheets
How to Add Labels to Scatterplot Points in Google Sheets
How to Add a Horizontal Line to a Chart in Google Sheets
How to Add Trendline to Chart in Google Sheets
How to Create Chart with Multiple Ranges of Data 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
How to Calculate Confidence Intervals 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 Filter by Date Range
Google Sheets Query: How to Use the COUNT Function
Google Sheets Query: How to Use the SUM Function
Google Sheets Query: How to Query From Another Sheet
Google Sheets Query: How to Query From Multiple Sheets
Google Sheets Query: How to Use Cell Reference in Formula
Google Sheets Query: How to Use Multiple Criteria in Query
Google Sheets Query: How to Use Wildcard Characters
Google Sheets Query: How to Use the Label Clause