Which of the following is not true about statistical functions?

a. The MEDIAN function finds the average value that has as many values above it in the group as are below it.
b. The SUM function is a predefined formula that adds all the numbers in a selected range of cells.
c. Statistical functions, which include the AVERAGE, MEDIAN, MIN, and MAX functions, are useful to
analyze a group of measurements.
d. The AVERAGE function adds a group of values, and then divides the result by the number of values in the group.


Ans: a. The MEDIAN function finds the average value that has as many values above it in the group as are below it.

Computer Science & Information Technology

You might also like to view...

In which topology does data travel back and forth along the cable, which is terminated at both ends?

a.Bus b.Ring c.Star d.Hybrid

Computer Science & Information Technology

When an array is instantiated, each cell is ____________________ until reset to a new object.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

______ is the process of initiating contact between two Bluetooth devices.

A. Tethering B. Initiating C. Coupling D. Pairing

Computer Science & Information Technology

EXX Case 2-1Jaquelyn is creating a literary magazine for her high school.  She is creating a template in Excel to estimate costs for the magazine's sponsors.  There are several error values in the worksheet.  Before she begins using the template, Jaquelyn needs to check for errors and troubleshoot the formulas. Jaquelyn wants to use a SUMIFS function in one of the worksheets. She will type _____ before typing a conditional function and arguments.

A. # B. = C. {} D. "<"

Computer Science & Information Technology