Google Sheets Statistical Functions Flashcards
7 cards from real Google Sheets Test practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Google Sheets Statistical Functions flashcards as text
What does the PERCENTILE function return in Google Sheets?
Answer: The value at a specified percentile within a dataset
PERCENTILE(data, percentile) returns the value at the given percentile, e.g., PERCENTILE(A1:A10, 0.9) gives the 90th percentile value.
Which function calculates the variance of a sample dataset in Google Sheets?
Answer: VAR
VAR(value1, value2, ...) calculates variance for a sample using n-1 in the denominator.
What does the CORREL function calculate in Google Sheets?
Answer: The correlation coefficient between two datasets
CORREL(data_y, data_x) returns a value between -1 and 1 representing the linear relationship strength between two variables.
How does COUNTIFS differ from COUNTIF in Google Sheets?
Answer: COUNTIFS applies multiple criteria across multiple ranges simultaneously
COUNTIFS(range1, criterion1, range2, criterion2, ...) allows you to specify multiple range-criterion pairs, counting rows where all conditions are met.
Which function returns the frequency distribution of values into specified intervals in Google Sheets?
Answer: FREQUENCY
FREQUENCY(data, bins) returns a vertical array showing how many values from the data fall into each bin interval.
What does the GEOMEAN function calculate in Google Sheets?
Answer: The geometric mean of a set of positive numbers
GEOMEAN multiplies all values together and takes the nth root, making it useful for growth rates and ratios.
What does the HARMEAN function calculate in Google Sheets?
Answer: The harmonic mean of a set of positive numbers
HARMEAN returns the reciprocal of the average of reciprocals, making it appropriate for averaging rates like speeds.
How this page was made: written with AI tools. We have not yet matched this exam's facts to an official source, so confirm fees, dates and rules with the exam body. Not reviewed by a subject-matter expert. Editorial policy