DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
PMT
|
|
|
Count
|
|
|
Rank
|
|
|
Mode
|
Detailed explanation-1: -To calculate the mode of a group of numbers, use the MODE function. MODE returns the most frequently occurring, or repetitive, value in an array or range of data.
Detailed explanation-2: -You can find it using the INDEX, MODE and MATCH functions. The generic function to find the most frequently occurring text is, =INDEX(range, MODE(MATCH(range, range, 0 ))).
Detailed explanation-3: -The MAX function in Excel returns the highest value in a set of data that you specify. The syntax is as follows: MAX(number1, [number2], …) Where number can be represented by a numeric value, array, named range, a reference to a cell or range containing numbers.
Detailed explanation-4: -∴ Our answer is option B) Mode.
Detailed explanation-5: -Use Range (arg), where arg names the range, to return a Range object that represents a single cell or a range of cells. The following example places the value of cell A1 in cell A5. The following example fills the range A1:H8 with random numbers by setting the formula for each cell in the range.