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

PERCENTILE(data, percentile) returns the value at the given percentile, e.g., PERCENTILE(A1:A10, 0.9) gives the 90th percentile value.

Question 2

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

Accepted Answer

VAR

Answer

VAR(value1, value2, ...) calculates variance for a sample using n-1 in the denominator.

Question 3

What does the CORREL function calculate in Google Sheets?

Accepted Answer

The correlation coefficient between two datasets

Answer

CORREL(data_y, data_x) returns a value between -1 and 1 representing the linear relationship strength between two variables.

Question 4

How does COUNTIFS differ from COUNTIF in Google Sheets?

Accepted Answer

COUNTIFS applies multiple criteria across multiple ranges simultaneously

Answer

COUNTIFS(range1, criterion1, range2, criterion2, ...) allows you to specify multiple range-criterion pairs, counting rows where all conditions are met.

Question 5

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

Accepted Answer

FREQUENCY

Answer

FREQUENCY(data, bins) returns a vertical array showing how many values from the data fall into each bin interval.

Google Sheets Test Practice Test

Google Sheets Test Practice Test

Google Sheets Test Google Sheets Statistical Functions 3