avedev-whole-numbers |
AVEDEV |
=AVEDEV(A1:A5) |
value |
1 |
avedev-inline |
AVEDEV |
=AVEDEV(1, 2, 3, 4, 5) |
value |
1 |
avedev-single-value |
AVEDEV |
=AVEDEV(7) |
value |
1 |
avedev-two-values |
AVEDEV |
=AVEDEV(1, 3) |
value |
1 |
average-whole-numbers |
AVERAGE |
=AVERAGE(A1:A5) |
value |
|
average-inline |
AVERAGE |
=AVERAGE(2, 4, 6) |
value |
|
average-ignores-text-in-range |
AVERAGE |
=AVERAGE(A1:A3) |
value |
|
average-empty-range |
AVERAGE |
=AVERAGE(A1:A3) |
value |
|
average-weighted-basic |
AVERAGE.WEIGHTED |
=AVERAGE.WEIGHTED({1,2,3}, {1,1,1}) |
value |
2 |
average-weighted-skewed |
AVERAGE.WEIGHTED |
=AVERAGE.WEIGHTED({1,2,3}, {1,2,3}) |
value |
2 |
average-weighted-grid |
AVERAGE.WEIGHTED |
=AVERAGE.WEIGHTED(A1:A3, B1:B3) |
value |
2 |
averagea-whole-numbers |
AVERAGEA |
=AVERAGEA(A1:A5) |
value |
1 |
averagea-mixed-types-coerce |
AVERAGEA |
=AVERAGEA(C1:C5) |
value |
1 |
averagea-inline-booleans |
AVERAGEA |
=AVERAGEA(1, 2, TRUE) |
value |
|
averagea-text-literal |
AVERAGEA |
=AVERAGEA(1, "hello", 2) |
value |
2 |
averageif-label-a |
AVERAGEIF |
=AVERAGEIF(D1:D5, "A", E1:E5) |
value |
|
averageif-greater-than |
AVERAGEIF |
=AVERAGEIF(A1:A5, ">2") |
value |
|
averageif-no-match |
AVERAGEIF |
=AVERAGEIF(A1:A3, ">100") |
value |
|
averageif-exact-value |
AVERAGEIF |
=AVERAGEIF(A1:A4, 2) |
value |
|
averageifs-single-criterion |
AVERAGEIFS |
=AVERAGEIFS(E1:E5, D1:D5, "A") |
value |
1 |
averageifs-two-criteria |
AVERAGEIFS |
=AVERAGEIFS(E1:E5, D1:D5, "A", E1:E5, ">15") |
value |
1 |
averageifs-no-match |
AVERAGEIFS |
=AVERAGEIFS(A1:A3, B1:B3, "q") |
value |
1 |
count-inline-statistical-descriptive |
COUNT |
=COUNT(1, 2, 3, 4, 5) |
value |
|
count-ignores-text |
COUNT |
=COUNT(A1:A5) |
value |
|
count-ignores-booleans-in-range |
COUNT |
=COUNT(C1:C5) |
value |
1 |
count-empty-range |
COUNT |
=COUNT(A1:A3) |
value |
|
counta-all-non-empty |
COUNTA |
=COUNTA(C1:C5) |
value |
1 |
counta-with-empty-cell |
COUNTA |
=COUNTA(A1:A3) |
value |
1 |
counta-inline |
COUNTA |
=COUNTA(1, "x", TRUE) |
value |
2 |
counta-empty-string-cell |
COUNTA |
=COUNTA(A1:A3) |
value |
|
devsq-whole-numbers |
DEVSQ |
=DEVSQ(A1:A5) |
value |
1 |
devsq-inline |
DEVSQ |
=DEVSQ(1, 2, 3, 4, 5) |
value |
1 |
devsq-single-value |
DEVSQ |
=DEVSQ(7) |
value |
1 |
devsq-two-values |
DEVSQ |
=DEVSQ(2, 4) |
value |
1 |
geomean-of-1 |
GEOMEAN |
=GEOMEAN(1, 1, 1) |
value |
1 |
geomean-perfect-square |
GEOMEAN |
=GEOMEAN(2, 8) |
value |
2 |
geomean-1-5 |
GEOMEAN |
=GEOMEAN(A1:A5) |
value |
|
geomean-with-zero |
GEOMEAN |
=GEOMEAN(0, 2, 4) |
value |
2 |
harmean-all-ones |
HARMEAN |
=HARMEAN(1, 1, 1) |
value |
1 |
harmean-two-values |
HARMEAN |
=HARMEAN(2, 6) |
value |
1 |
harmean-1-5 |
HARMEAN |
=HARMEAN(A1:A5) |
value |
|
harmean-with-zero |
HARMEAN |
=HARMEAN(0, 2, 4) |
value |
2 |
large-1st-statistical-descriptive |
LARGE |
=LARGE(A1:A5, 1) |
value |
|
large-3rd-statistical-descriptive |
LARGE |
=LARGE(A1:A5, 3) |
value |
|
large-k-too-big |
LARGE |
=LARGE({1,2,3}, 5) |
value |
1 |
large-k-zero |
LARGE |
=LARGE({1,2,3}, 0) |
value |
1 |
max-whole-numbers |
MAX |
=MAX(A1:A5) |
value |
|
max-inline-negatives |
MAX |
=MAX(-3, -1, -7) |
value |
|
max-ignores-text |
MAX |
=MAX(A1:A3) |
value |
|
max-empty-range |
MAX |
=MAX(A1:A3) |
value |
|
min-whole-numbers |
MIN |
=MIN(A1:A5) |
value |
|
min-inline-negatives |
MIN |
=MIN(-3, -1, -7) |
value |
|
min-ignores-text |
MIN |
=MIN(A1:A3) |
value |
|
min-empty-range |
MIN |
=MIN(A1:A3) |
value |
|
maxa-whole-numbers |
MAXA |
=MAXA(A1:A5) |
value |
1 |
maxa-mixed-types |
MAXA |
=MAXA(C1:C5) |
value |
1 |
maxa-negatives-with-text |
MAXA |
=MAXA(A1:A3) |
value |
1 |
maxa-inline-boolean |
MAXA |
=MAXA(-2, -1, TRUE) |
value |
1 |
mina-whole-numbers |
MINA |
=MINA(A1:A5) |
value |
1 |
mina-mixed-types |
MINA |
=MINA(C1:C5) |
value |
1 |
mina-positives-with-text |
MINA |
=MINA(A1:A3) |
value |
1 |
mina-inline-boolean-false |
MINA |
=MINA(2, 3, FALSE) |
value |
1 |
maxifs-single-criterion |
MAXIFS |
=MAXIFS(E1:E5, D1:D5, "A") |
value |
1 |
maxifs-comparator |
MAXIFS |
=MAXIFS(A1:A5, A1:A5, "<4") |
value |
1 |
maxifs-no-match |
MAXIFS |
=MAXIFS(A1:A3, A1:A3, ">100") |
value |
1 |
minifs-single-criterion |
MINIFS |
=MINIFS(E1:E5, D1:D5, "A") |
value |
1 |
minifs-comparator |
MINIFS |
=MINIFS(A1:A5, A1:A5, ">2") |
value |
1 |
minifs-no-match |
MINIFS |
=MINIFS(A1:A3, A1:A3, ">100") |
value |
1 |
median-odd-count-statistical-descriptive |
MEDIAN |
=MEDIAN(A1:A5) |
value |
1 |
median-even-count-statistical-descriptive |
MEDIAN |
=MEDIAN(1, 2, 3, 4) |
value |
1 |
median-single-value |
MEDIAN |
=MEDIAN(7) |
value |
1 |
median-unsorted |
MEDIAN |
=MEDIAN(5, 1, 3, 2, 4) |
value |
1 |
mode-tied-dataset |
MODE |
=MODE(B1:B5) |
value |
1 |
mode-clear-winner |
MODE |
=MODE(1, 2, 2, 3, 4) |
value |
1 |
mode-no-repeats |
MODE |
=MODE(1, 2, 3, 4, 5) |
value |
2 |
mode-sngl-clear-winner |
MODE.SNGL |
=MODE.SNGL(1, 2, 2, 3, 4) |
value |
1 |
mode-sngl-tied-dataset |
MODE.SNGL |
=MODE.SNGL(B1:B5) |
value |
1 |
mode-sngl-no-repeats |
MODE.SNGL |
=MODE.SNGL(1, 2, 3) |
value |
1 |
mode-mult-tied-dataset |
MODE.MULT |
=MODE.MULT(B1:B5) |
value |
|
mode-mult-single-mode |
MODE.MULT |
=MODE.MULT(1, 2, 2, 3, 4) |
value |
|
mode-mult-no-repeats |
MODE.MULT |
=MODE.MULT(1, 2, 3) |
value |
|
percentile-25th-on-1-5 |
PERCENTILE |
=PERCENTILE(A1:A5, 0.25) |
value |
1 |
percentile-50th-on-1-5 |
PERCENTILE |
=PERCENTILE(A1:A5, 0.5) |
value |
1 |
percentile-0th |
PERCENTILE |
=PERCENTILE({1,2,3,4,5}, 0) |
value |
1 |
percentile-100th |
PERCENTILE |
=PERCENTILE({1,2,3,4,5}, 1) |
value |
1 |
percentile-inc-25th-on-1-5 |
PERCENTILE.INC |
=PERCENTILE.INC(A1:A5, 0.25) |
value |
1 |
percentile-inc-50th-on-1-5 |
PERCENTILE.INC |
=PERCENTILE.INC(A1:A5, 0.5) |
value |
1 |
percentile-inc-75th-on-1-5 |
PERCENTILE.INC |
=PERCENTILE.INC(A1:A5, 0.75) |
value |
1 |
percentile-exc-25th-on-1-5 |
PERCENTILE.EXC |
=PERCENTILE.EXC(A1:A5, 0.25) |
value |
1 |
percentile-exc-50th-on-1-5 |
PERCENTILE.EXC |
=PERCENTILE.EXC(A1:A5, 0.5) |
value |
1 |
percentile-exc-75th-on-1-5 |
PERCENTILE.EXC |
=PERCENTILE.EXC(A1:A5, 0.75) |
value |
1 |
percentile-exc-0th-invalid |
PERCENTILE.EXC |
=PERCENTILE.EXC({1,2,3,4,5}, 0) |
value |
1 |
percentrank-midpoint |
PERCENTRANK |
=PERCENTRANK(A1:A5, 3) |
value |
1 |
percentrank-minimum |
PERCENTRANK |
=PERCENTRANK(A1:A5, 1) |
value |
1 |
percentrank-maximum |
PERCENTRANK |
=PERCENTRANK(A1:A5, 5) |
value |
1 |
percentrank-inc-midpoint |
PERCENTRANK.INC |
=PERCENTRANK.INC(A1:A5, 3) |
value |
1 |
percentrank-inc-minimum |
PERCENTRANK.INC |
=PERCENTRANK.INC(A1:A5, 1) |
value |
1 |
percentrank-inc-quarter |
PERCENTRANK.INC |
=PERCENTRANK.INC(A1:A5, 2) |
value |
1 |
percentrank-exc-midpoint |
PERCENTRANK.EXC |
=PERCENTRANK.EXC(A1:A5, 3) |
value |
1 |
percentrank-exc-minimum-value |
PERCENTRANK.EXC |
=PERCENTRANK.EXC(A1:A5, 1) |
value |
|
percentrank-exc-interior |
PERCENTRANK.EXC |
=PERCENTRANK.EXC(A1:A5, 2) |
value |
1 |
permut-basic |
PERMUT |
=PERMUT(5, 2) |
value |
1 |
permut-full |
PERMUT |
=PERMUT(5, 5) |
value |
1 |
permut-zero |
PERMUT |
=PERMUT(5, 0) |
value |
1 |
permut-invalid |
PERMUT |
=PERMUT(3, 5) |
value |
2 |
permutationa-basic |
PERMUTATIONA |
=PERMUTATIONA(5, 2) |
value |
1 |
permutationa-triple |
PERMUTATIONA |
=PERMUTATIONA(3, 3) |
value |
1 |
permutationa-zero-pick |
PERMUTATIONA |
=PERMUTATIONA(5, 0) |
value |
2 |
permutationa-negative |
PERMUTATIONA |
=PERMUTATIONA(-1, 2) |
value |
1 |
quartile-q1-on-1-5 |
QUARTILE |
=QUARTILE(A1:A5, 1) |
value |
1 |
quartile-q2-on-1-5 |
QUARTILE |
=QUARTILE(A1:A5, 2) |
value |
1 |
quartile-q3-on-1-5 |
QUARTILE |
=QUARTILE(A1:A5, 3) |
value |
1 |
quartile-invalid |
QUARTILE |
=QUARTILE({1,2,3,4,5}, 5) |
value |
2 |
quartile-inc-q1-on-1-5 |
QUARTILE.INC |
=QUARTILE.INC(A1:A5, 1) |
value |
1 |
quartile-inc-q2-on-1-5 |
QUARTILE.INC |
=QUARTILE.INC(A1:A5, 2) |
value |
1 |
quartile-inc-q3-on-1-5 |
QUARTILE.INC |
=QUARTILE.INC(A1:A5, 3) |
value |
1 |
quartile-exc-q1-on-1-5 |
QUARTILE.EXC |
=QUARTILE.EXC(A1:A5, 1) |
value |
1 |
quartile-exc-q2-on-1-5 |
QUARTILE.EXC |
=QUARTILE.EXC(A1:A5, 2) |
value |
1 |
quartile-exc-q3-on-1-5 |
QUARTILE.EXC |
=QUARTILE.EXC(A1:A5, 3) |
value |
1 |
quartile-exc-q0-invalid |
QUARTILE.EXC |
=QUARTILE.EXC({1,2,3,4,5}, 0) |
value |
1 |
rank-descending |
RANK |
=RANK(20, A1:A4) |
value |
1 |
rank-ascending |
RANK |
=RANK(20, A1:A4, 1) |
value |
1 |
rank-top-value |
RANK |
=RANK(5, A1:A5) |
value |
1 |
rank-missing-value |
RANK |
=RANK(5, A1:A3) |
value |
1 |
rank-eq-descending-with-tie |
RANK.EQ |
=RANK.EQ(20, A1:A4) |
value |
1 |
rank-eq-ascending |
RANK.EQ |
=RANK.EQ(3, A1:A5, 1) |
value |
1 |
rank-eq-top |
RANK.EQ |
=RANK.EQ(5, A1:A5) |
value |
1 |
rank-avg-descending-with-tie |
RANK.AVG |
=RANK.AVG(20, A1:A4) |
value |
1 |
rank-avg-no-tie |
RANK.AVG |
=RANK.AVG(3, A1:A5) |
value |
1 |
rank-avg-triple-tie |
RANK.AVG |
=RANK.AVG(20, A1:A5) |
value |
1 |
small-1st-statistical-descriptive |
SMALL |
=SMALL(A1:A5, 1) |
value |
|
small-3rd |
SMALL |
=SMALL(A1:A5, 3) |
value |
|
small-k-too-big |
SMALL |
=SMALL({1,2,3}, 5) |
value |
1 |
small-k-zero |
SMALL |
=SMALL({1,2,3}, 0) |
value |
1 |
standardize-at-mean |
STANDARDIZE |
=STANDARDIZE(10, 10, 2) |
value |
1 |
standardize-one-stdev-above |
STANDARDIZE |
=STANDARDIZE(12, 10, 2) |
value |
1 |
standardize-two-stdev-below |
STANDARDIZE |
=STANDARDIZE(6, 10, 2) |
value |
1 |
standardize-zero-stdev |
STANDARDIZE |
=STANDARDIZE(5, 10, 0) |
value |
2 |
stdev-sample-1-5 |
STDEV |
=STDEV(A1:A5) |
value |
|
stdev-two-values |
STDEV |
=STDEV(1, 3) |
value |
|
stdev-identical-values |
STDEV |
=STDEV(5, 5, 5) |
value |
1 |
stdev-single-value |
STDEV |
=STDEV(5) |
value |
1 |
stdev-s-sample-1-5 |
STDEV.S |
=STDEV.S(A1:A5) |
value |
|
stdev-s-identical |
STDEV.S |
=STDEV.S(5, 5, 5) |
value |
1 |
stdev-s-single-value |
STDEV.S |
=STDEV.S(5) |
value |
1 |
stdev-p-population-1-5 |
STDEV.P |
=STDEV.P(A1:A5) |
value |
|
stdev-p-two-values |
STDEV.P |
=STDEV.P(2, 6) |
value |
1 |
stdev-p-identical |
STDEV.P |
=STDEV.P(5, 5, 5) |
value |
1 |
stdevp-population-1-5 |
STDEVP |
=STDEVP(A1:A5) |
value |
|
stdevp-two-values |
STDEVP |
=STDEVP(2, 6) |
value |
1 |
stdevp-identical |
STDEVP |
=STDEVP(5, 5, 5) |
value |
1 |
stdeva-numeric-only |
STDEVA |
=STDEVA(A1:A5) |
value |
|
stdeva-mixed-types |
STDEVA |
=STDEVA(C1:C5) |
value |
|
stdeva-inline-boolean |
STDEVA |
=STDEVA(1, 2, TRUE) |
value |
|
stdevpa-numeric-only |
STDEVPA |
=STDEVPA(A1:A5) |
value |
|
stdevpa-mixed-types |
STDEVPA |
=STDEVPA(C1:C5) |
value |
|
stdevpa-inline-boolean |
STDEVPA |
=STDEVPA(1, 2, TRUE) |
value |
|
trimmean-40pct-on-1-5 |
TRIMMEAN |
=TRIMMEAN(A1:A5, 0.4) |
value |
1 |
trimmean-zero-percent |
TRIMMEAN |
=TRIMMEAN(A1:A5, 0) |
value |
1 |
trimmean-skewed-dataset |
TRIMMEAN |
=TRIMMEAN({1,2,3,4,100}, 0.4) |
value |
1 |
trimmean-invalid-percent |
TRIMMEAN |
=TRIMMEAN({1,2,3}, 1) |
value |
2 |
var-sample-1-5 |
VAR |
=VAR(A1:A5) |
value |
1 |
var-two-values |
VAR |
=VAR(1, 3) |
value |
1 |
var-identical |
VAR |
=VAR(5, 5, 5) |
value |
1 |
var-single-value |
VAR |
=VAR(5) |
value |
1 |
var-s-sample-1-5 |
VAR.S |
=VAR.S(A1:A5) |
value |
1 |
var-s-identical |
VAR.S |
=VAR.S(5, 5, 5) |
value |
1 |
var-s-single-value |
VAR.S |
=VAR.S(5) |
value |
1 |
var-p-population-1-5 |
VAR.P |
=VAR.P(A1:A5) |
value |
1 |
var-p-two-values |
VAR.P |
=VAR.P(2, 6) |
value |
1 |
var-p-identical |
VAR.P |
=VAR.P(5, 5, 5) |
value |
1 |
varp-population-1-5 |
VARP |
=VARP(A1:A5) |
value |
1 |
varp-two-values |
VARP |
=VARP(2, 6) |
value |
1 |
varp-identical |
VARP |
=VARP(5, 5, 5) |
value |
1 |
vara-numeric-only |
VARA |
=VARA(A1:A5) |
value |
1 |
vara-mixed-types |
VARA |
=VARA(C1:C5) |
value |
|
vara-inline-boolean |
VARA |
=VARA(1, 2, TRUE) |
value |
|
varpa-numeric-only |
VARPA |
=VARPA(A1:A5) |
value |
1 |
varpa-mixed-types |
VARPA |
=VARPA(C1:C5) |
value |
|
varpa-inline-boolean |
VARPA |
=VARPA(1, 2, TRUE) |
value |
|