Formula: `=HSTACK(array1, [array2], ...
)`
24. WRAPCOLS Function
Definition: Wraps a range of values into multiple columns after a specified number of
elements.
Formula: `=WRAPCOLS(array, wrap_count)`
25. WRAPROWS Function
Definition: Wraps a range of values into multiple rows after a specified number of elements.
Formula: `=WRAPROWS(array, wrap_count)`
statistical full (starting from avedev to z.test) please dont leave any i want to be expert in excel
statistics
Here is the complete list of Statistical Functions in Excel, from AVEDEV to Z.TEST, with a one-line
definition and formula for each:
1. AVEDEV
Definition: Returns the average of the absolute deviations of data points from their mean.
Formula: `=AVEDEV(number1, [number2], ...)`
2. AVERAGE
Definition: Returns the average (arithmetic mean) of the given numbers.
Formula: `=AVERAGE(number1, [number2], ...)`
3. AVERAGEA
Definition: Returns the average of the arguments, including numbers, text, and logical
values.
Formula: `=AVERAGEA(value1, [value2], ...)`
4. AVERAGEIF
Definition: Returns the average of the cells that meet a specified condition.
Formula: `=AVERAGEIF(range, criteria, [average_range])`
5. AVERAGEIFS
Definition: Returns the average of cells that meet multiple criteria.
Formula: `=AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2],
[criteria2], ...)`
6. BINOM.DIST
Definition: Returns the individual term binomial distribution probability.
Formula: `=BINOM.DIST(number_s, trials, probability_s, cumulative)`
7. BINOM.DIST.RANGE
Definition: Returns the probability of a range of values in a binomial distribution.
Formula: `=BINOM.DIST.RANGE(trials, probability_s, number_s, [number_s2])`
8. BINOM.INV
Definition: Returns the smallest value for which the cumulative binomial distribution is
greater than or equal to a given probability.
Formula: `=BINOM.INV(trials, probability_s, alpha)`
Printed using Save ChatGPT as PDF, powered by PDFCrowd HTML to PDF API. 108/114
9. CHIDIST
Definition: Returns the one-tailed probability of the chi-squared distribution.
Formula: `=CHIDIST(x, degrees_freedom)`
10. CHIINV
Definition: Returns the inverse of the one-tailed probability of the chi-squared distribution.
Formula: `=CHIINV(probability, degrees_freedom)`
11. CHISQ.DIST
Definition: Returns the chi-squared distribution (cumulative).
Formula: `=CHISQ.DIST(x, degrees_freedom, cumulative)`
12. CHISQ.DIST.RT
Definition: Returns the right-tailed chi-squared distribution.
Formula: `=CHISQ.DIST.RT(x, degrees_freedom)`
13. CHISQ.INV
Definition: Returns the inverse of the chi-squared distribution.
Formula: `=CHISQ.INV(probability, degrees_freedom)`
14. CHISQ.INV.RT
Definition: Returns the inverse of the right-tailed chi-squared distribution.
Formula: `=CHISQ.INV.RT(probability, degrees_freedom)`
15. CONFIDENCE
Definition: Returns the confidence interval for a population mean, using a normal
distribution.
Formula: `=CONFIDENCE(alpha, standard_dev, size)`
16. CONFIDENCE.NORM
Definition: Returns the confidence interval for a population mean, using a normal
distribution.
Formula: `=CONFIDENCE.NORM(alpha, standard_dev, size)`
17. CONFIDENCE.T
Definition: Returns the confidence interval for a population mean, using the Student's t-
distribution.
Formula: `=CONFIDENCE.T(alpha, standard_dev, size)`
18. CORREL
Definition: Returns the correlation coefficient between two datasets.
Formula: `=CORREL(array1, array2)`
19. COUNT
Definition: Returns the count of numeric values in a dataset.
Formula: `=COUNT(value1, [value2], ...)`
20. COUNTA
Definition: Returns the count of all non-empty cells.
Formula: `=COUNTA(value1, [value2], ...)`
21. COUNTBLANK
Definition: Returns the number of blank cells in a range.
Formula: `=COUNTBLANK(range)`
22. COUNTIF
Definition: Returns the count of cells that meet a specified condition.
Printed using Save ChatGPT as PDF, powered by PDFCrowd HTML to PDF API. 109/114
Formula: `=COUNTIF(range, criteria)`
23. COUNTIFS
Definition: Returns the count of cells that meet multiple criteria.
Formula: `=COUNTIFS(range1, criteria1, [range2], [criteria2], ...)`
24. COVARIANCE.P
Definition: Returns the covariance of two datasets based on the entire population.
Formula: `=COVARIANCE.P(array1, array2)`
25. COVARIANCE.S
Definition: Returns the covariance of two datasets based on a sample.
Formula: `=COVARIANCE.S(array1, array2)`
26. DEVSQ
Definition: Returns the sum of the squares of deviations from the sample mean.
Formula: `=DEVSQ(number1, [number2], ...)`
27. EXPON.DIST
Definition: Returns the exponential distribution.
Formula: `=EXPON.DIST(x, lambda, cumulative)`
28. F.DIST
Definition: Returns the F probability distribution.
Formula: `=F.DIST(x, degrees_freedom1, degrees_freedom2, cumulative)`
29. F.DIST.RT
Definition: Returns the right-tailed F probability distribution.
Formula: `=F.DIST.RT(x, degrees_freedom1, degrees_freedom2)`
30. F.INV
Definition: Returns the inverse of the F probability distribution.
Formula: `=F.INV(probability, degrees_freedom1, degrees_freedom2)`
31. F.INV.RT
Definition: Returns the inverse of the right-tailed F probability distribution.
Formula: `=F.INV.RT(probability, degrees_freedom1, degrees_freedom2)`
32. FTEST
Definition: Returns the result of an F-test, which compares the variances of two datasets.
Formula: `=FTEST(array1, array2)`
33. INTERCEPT
Definition: Returns the y-intercept of the linear regression line.
Formula: `=INTERCEPT(known_y's, known_x's)`
34. KURT
Definition: Returns the kurtosis of a dataset (the "peakedness").
Formula: `=KURT(number1, [number2], ...)`
35. LARGE
Definition: Returns the k-th largest value in a dataset.
Formula: `=LARGE(array, k)`
36. LINEST
Definition: Returns statistics that describe a linear trend, based on known data points.
Formula: `=LINEST(known_y's, known_x's, [const], [stats])`
37. LOGEST
Printed using Save ChatGPT as PDF, powered by PDFCrowd HTML to PDF API. 110/114
Definition: Returns statistics for an exponential trend, based on known data points.
Formula: `=LOGEST(known_y's, known_x's, [const], [stats])`
38. MAX
Definition: Returns the largest number in a dataset.
Formula: `=MAX(number1, [number2], ...)`
39. MAXA
Definition: Returns the largest value in a dataset, including logical values and text.
Formula: `=MAXA(value1, [value2], ...)`
40. MEDIAN
Definition: Returns the median of the dataset.
Formula: `=MEDIAN(number1, [number2], ...)`
41. MIN
Definition: Returns the smallest number in a dataset.
Formula: `=MIN(number1, [number2], ...)`
42. MINA
Definition: Returns the smallest value in a dataset, including logical values and text.
Formula: `=MINA(value1, [value2], ...)`
43. MODE
Definition: Returns the most frequently occurring value in a dataset.
Formula: `=MODE(number1, [number2], ...)`
44. MODE.MULT
Definition: Returns multiple modes in a dataset.
Formula: `=MODE.MULT(number1, [number2], ...)`
45. NORM.DIST
Definition: Returns the normal distribution for a specified mean and standard deviation.
Formula: `=NORM.DIST(x, mean, standard_dev, cumulative)`
46. NORM.INV
Definition: Returns the inverse of the normal distribution for a specified mean and standard
deviation.
Formula: `=NORM.INV(probability, mean, standard_dev)`
47. NORM.S.DIST
Definition: Returns the standard normal distribution (mean = 0, standard deviation = 1).
Formula: `=NORM.S.DIST(z, cumulative)`
48. NORM.S.INV
Definition: Returns the inverse of the standard normal distribution.
Formula: `=NORM.S.INV(probability)`
49. PERCENTILE.EXC
Definition: Returns the k-th percentile of a dataset, excluding the 0th and 100th percentiles.
Formula: `=PERCENTILE.EXC(array, k)`
50. PERCENTILE.INC
Definition: Returns the k-th percentile of a dataset, including the 0th and 100th percentiles.
Formula: `=PERCENTILE.INC(array, k)`
51. PERMUT
Definition: Returns the number of permutations for a given number of items.
Printed using Save ChatGPT as PDF, powered by PDFCrowd HTML to PDF API. 111/114
Formula: `=PERMUT(number, number_chosen)`
52. PERMUTATIONA
Definition: Returns the number of permutations with repetitions for a given number of
items.
Formula: `=PERMUTATIONA(number, number_chosen)`
53. POISSON.DIST
Definition: Returns the Poisson distribution for a specified number of events.
Formula: `=POISSON.DIST(x, mean, cumulative)`
54. PROB
Definition: Returns the probability that a value falls between two numbers in a dataset.
Formula: `=PROB(range, prob_range, lower_limit, upper_limit)`
55. QUARTILE.EXC
Definition: Returns the k-th quartile of a dataset, excluding the 0th and 100th quartiles.
Formula: `=QUARTILE.EXC(array, quart)`
56. QUARTILE.INC
Definition: Returns the k-th quartile of a dataset, including the 0th and 100th quartiles.
Formula: `=QUARTILE.INC(array, quart)`
57. RANK
Definition: Returns the rank of a number in a dataset.
Formula: `=RANK(number, ref, [order])`
58. RANK.AVG
Definition: Returns the rank of a number in a dataset, but averages the ranks for duplicate
values.
Formula: `=RANK.AVG(number, ref, [order])`
59. RANK.EQ
Definition: Returns the rank of a number in a dataset, with tied values getting the same rank.
Formula: `=RANK.EQ(number, ref, [order])`
60. SKEW
Definition: Returns the skewness (asymmetry) of a dataset.
Formula: `=SKEW(number1, [number2], ...)`
61. SLOPE
Definition: Returns the slope of the linear regression line based on known data points.
Formula: `=SLOPE(known_y's, known_x's)`
62. SMALL
Definition: Returns the k-th smallest value in a dataset.
Formula: `=SMALL(array, k)`
63. STDEV.P
Definition: Returns the standard deviation of a dataset based on the entire population.
Formula: `=STDEV.P(number1, [number2], ...)`
64. STDEV.S
Definition: Returns the standard deviation of a dataset based on a sample.
Formula: `=STDEV.S(number1, [number2], ...)`
65. STDEVA
Definition: Returns the standard deviation of a dataset, including logical values and text.
Printed using Save ChatGPT as PDF, powered by PDFCrowd HTML to PDF API. 112/114
Formula: `=STDEVA(value1, [value2], ...)`
66. STDEVP
Definition: Returns the standard deviation based on the entire population, including logical
values and text.
Formula: `=STDEVP(value1, [value2], ...)`
67. STT.DIST
Definition: Returns the t-distribution.
Formula: `=T.DIST(x, degrees_freedom, cumulative)`
68. T.DIST.2T
Definition: Returns the two-tailed t-distribution.
Formula: `=T.DIST.2T(x, degrees_freedom)`
69. T.DIST.RT
Definition: Returns the right-tailed t-distribution.
Formula: `=T.DIST.RT(x, degrees_freedom)`
70. T.INV
Definition: Returns the t-distribution's inverse.
Formula: `=T.INV(probability, degrees_freedom)`
71. T.TEST
Definition: Returns the probability of the t-test for the two datasets.
Formula: `=T.TEST(array1, array2, tails, type)`
72. TREND
Definition: Returns the linear trend for a given set of known values.
Formula: `=TREND(known_y's, known_x's, new_x's, [const])`
73. VAR.P
Definition: Returns the variance based on the entire population.
Formula: `=VAR.P(number1, [number2], ...)`
74. VAR.S
Definition: Returns the variance based on a sample.
Formula: `=VAR.S(number1, [number2], ...)`
75. VARA
Definition: Returns the variance of a dataset, including logical values and text.
Formula: `=VARA(value1, [value2], ...)`
76. VARP
Definition: Returns the variance based on the entire population, including logical values and
text.
Formula: `=VARP(value1, [value2], ...)`
77. Z.TEST
Definition: Returns the one-tailed probability-value of a z-test.
Formula: `=Z.TEST(array, x, [sigma])`
thank you so much
Printed using Save ChatGPT as PDF, powered by PDFCrowd HTML to PDF API. 113/114
You're very welcome! I'm glad I could help. If you have any more questions or need further assistance,
😊📊
feel free to ask. Best of luck with mastering Excel statistics!
Printed using Save ChatGPT as PDF, powered by PDFCrowd HTML to PDF API. 114/114
