Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
7 Cards in this Set
- Front
- Back
|
MEDIAN |
=MEDIAN (range)
The data is sorted and the middle number is selected. The average is skewed thus not very usefull
|
|
|
MODE |
=MODE (range) |
|
|
RANK |
= RANK (number,range)
The "number" selected is ranked ito largest to smallest
eg range = 2,3,2,55,67,33
=RANK(55,range) = 2 ie 55 is the second largest number |
|
|
RANKED |
=RANKED (number, range)
RANK.EQ(number,ref,[order]) Order = 0 - list is sorted in descending order / 1 = list is sorted in ascending
|
|
|
OTHER
MIN MAX LARGE SMALL |
=MIN (range) =MAX (range) The functions return the smallest and largest number from selected range
=LARGE (range,5) this returns the 5th largest number from specified range =SMALL (range,6) returns the 6th smalles number from range
|
|
|
COUNTBLANK |
COUNTBLANK (range)
This function counts blank cells in a range /array |
|
|
COUNT COUNTA |
COUNT (range) Will count cells that have a numerical value only
COUNTA (range) Will count cells that have ANY value |
