DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
MAX
|
|
|
MIN
|
|
|
COUNT
|
|
|
AVERAGE
|
Detailed explanation-1: -Description. Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.
Detailed explanation-2: -The AVERAGE Function[1] is categorized under Excel Statistical functions. It will return the average value of a given series of numbers in Excel. The function is used to calculate the arithmetic mean of a given set of arguments in Excel.
Detailed explanation-3: -Answer. The Microsoft Excel AVERAGEIF function returns the average (arithmetic mean) of all numbers in a range of cells, based on a given criteria.
Detailed explanation-4: -The AVERAGEIF function returns the average of cells in a range that meet criteria you provide.
Detailed explanation-5: -The Arithmetic Average Return is calculated by adding the rate of returns of “n” sub-periods and then dividing the result by “n". In other words, the returns of “n” sub-periods are added and then divided by “n” to find the value of the average return.