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.
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
When an array is instantiated, each cell is ____________________ until reset to a new object.
Fill in the blank(s) with the appropriate word(s).
______ is the process of initiating contact between two Bluetooth devices.
A. Tethering B. Initiating C. Coupling D. Pairing
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. "<"