DEV Community

Cover image for "Day 15: Excel Essentials Unveiled - Sharing Today's Insights on My Learning Adventure! 📊🚀 #ExcelSkills #LearningJourney"
Nitin-bhatt46
Nitin-bhatt46

Posted on

"Day 15: Excel Essentials Unveiled - Sharing Today's Insights on My Learning Adventure! 📊🚀 #ExcelSkills #LearningJourney"

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)