EXCEL - 14
STATISTICAL FUNCTION :-
AVERAGE
MEDIAN
MODE
STDEV.P and STDEV.S
VAR.P and VAR.S
CORREL
COVAR
RANK.EQ and RANK.AVG
PERCENTILE.INC and PERCENTILE.EXC
QUARTILE.INC and QUARTILE.EXC
Z.TEST
T.TEST
F.TEST
NORM.S.DIST and NORM.DIST
NORM.INV
EXPLANATION :-
AVERAGE:
Calculates the arithmetic mean of a range of values.
=AVERAGE(number1, number2, ...)
MEDIAN:
Returns the median (middle) value in a range of values.
=MEDIAN(number1, number2, ...)
MODE:
Returns the most frequently occurring value in a range of values.
=MODE(number1, number2, ...)
STDEV.P and STDEV.S:
Calculate the standard deviation of a sample (STDEV.S) or an entire population (STDEV.P).
=STDEV.P(number1, number2, ...)
=STDEV.S(number1, number2, ...)
VAR.P and VAR.S:
Calculate the variance of a sample (VAR.S) or an entire population (VAR.P).
=VAR.P(number1, number2, ...)
=VAR.S(number1, number2, ...)
CORREL:
Calculates the correlation coefficient between two sets of values.
=CORREL(array1, array2)
COVAR:
Calculates the covariance between two sets of values.
=COVAR(array1, array2)
RANK.EQ and RANK.AVG:
RANK.EQ assigns ranks to values in a data set, with ties receiving the same rank. RANK.AVG assigns average ranks to tied values.
=RANK.EQ(number, ref, [order])
=RANK.AVG(number, ref, [order])
PERCENTILE.INC and PERCENTILE.EXC:
PERCENTILE.INC returns the k-th percentile of values in a range. PERCENTILE.EXC excludes the actual data values from the calculation.
=PERCENTILE.INC(array, k)
=PERCENTILE.EXC(array, k)
QUARTILE.INC and QUARTILE.EXC:
QUARTILE.INC returns the k-th quartile of values in a range. QUARTILE.EXC excludes the actual data values from the calculation.
=QUARTILE.INC(array, quart)
=QUARTILE.EXC(array, quart)
Z.TEST:
Calculates the one-tailed probability-value of a z-test.
=Z.TEST(array, x, [sigma])
T.TEST:
Calculates the probability associated with a Student's t-test.
=T.TEST(array1, array2, [tails], [type])
F.TEST:
Calculates the two-tailed probability-value of an F-test.
=F.TEST(array1, array2)
NORM.S.DIST and NORM.DIST:
NORM.S.DIST returns the standard normal cumulative distribution function.
=NORM.S.DIST(z, [cumulative])
NORM.DIST returns the normal cumulative distribution function.
=NORM.DIST(x, [mean], [standard_dev], [cumulative])
NORM.INV:
Returns the inverse of the normal cumulative distribution.
=NORM.INV(probability, [mean], [standard_dev])
These functions are fundamental for various tasks in Excel, including text manipulation, logical operations, conditional formatting, and data analysis.
Follow me on this where every day will be added if i learn something new about it :- https://dev.to/nitinbhatt46
Thank you for your time.
Top comments (0)