Google Sheets Test Google Sheets Statistical Functions 3

Question 1

What does the PERCENTILE function return in Google Sheets?

Accepted Answer

The value at a specified percentile within a dataset

Answer

The percentage a number represents relative to the total

Answer

The count of values that fall below a percentile

Answer

The rank of a value expressed as a percentage

Question 2

Which function calculates the variance of a sample dataset in Google Sheets?

Accepted Answer

VAR

Answer

STDEV

Answer

VARIANCE

Answer

VARP

Question 3

What does the CORREL function calculate in Google Sheets?

Accepted Answer

The correlation coefficient between two datasets

Answer

The sum of products of two datasets

Answer

The regression line slope of two datasets

Answer

The percentage difference between two datasets

Question 4

How does COUNTIFS differ from COUNTIF in Google Sheets?

Accepted Answer

COUNTIFS applies multiple criteria across multiple ranges simultaneously

Answer

COUNTIFS counts text; COUNTIF counts numbers

Answer

COUNTIFS is case-sensitive; COUNTIF is not

Answer

COUNTIFS only works with date values

Question 5

Which function returns the frequency distribution of values into specified intervals in Google Sheets?

Accepted Answer

FREQUENCY

Answer

COUNTIF

Answer

HISTOGRAM

Answer

DISTRIBUTION

Question 6

What does the GEOMEAN function calculate in Google Sheets?

Accepted Answer

The geometric mean of a set of positive numbers

Answer

The arithmetic average of a dataset

Answer

The median of values arranged in a geometric sequence

Answer

The mean of values plotted along a geometric axis

Question 7

What does the HARMEAN function calculate in Google Sheets?

Accepted Answer

The harmonic mean of a set of positive numbers

Answer

The arithmetic mean of a dataset

Answer

The mean with extreme values removed

Answer

The weighted mean using predefined coefficients