Basic Excel Statistical Functions Tutorial

This video tutorial covers basic Excel statistical functions, including count, median, mode, percentile, standard deviation, variance, count blank, and max/min functions. Each function is explained with examples, demonstrating how to apply them in Excel to analyze data efficiently.

What is the primary purpose of the COUNT function in Excel?

• To calculate the sum of numbers in a range

• To count the number of numeric entries in a range

• To find the average of numbers in a range

• To count the number of text entries in a range

How many arguments can the COUNT function handle in Excel?

• 255

• 300

• 100

• 200

What does the MEDIAN function return when the number of entries is odd?

• The middle number

• The average of all numbers

• The smallest number

• The largest number

In the MEDIAN function, what happens if the number of entries is even?

• The function returns an error

• The function returns the smallest number

• The function returns the average of the two middle numbers

• The function returns the largest number

What is the purpose of the MODE function in Excel?

• To find the average of numbers

• To find the range of numbers

• To find the most frequently occurring number

• To find the sum of numbers

What error does the MODE function return if no number is repeated?

• #DIV/0!

• #VALUE!

• #REF!

• #N/A

What is the condition for the K value in the PERCENTILE function?

• K must be greater than 1

• K must be less than 0

• K can be any number

• K must be between 0 and 1

What does the STANDARD DEVIATION function calculate in Excel?

• The average of a dataset

• The sum of a dataset

• The variance of a dataset

• The standard deviation of a sample

What error does the VARIANCE function show if there are no numbers in the range?

• #DIV/0!

• #REF!

• #VALUE!

• #N/A

What is the main purpose of the VARIANCE function in Excel?

• To estimate the variance of a sample

• To calculate the sum of a dataset

• To calculate the average of a dataset

• To find the median of a dataset