1.
AVERAGE
Formula: =AVERAGE(A1:A10)
Example: For the data {10, 20, 30, 40, 50}, the result is 30.
2. MEDIAN
Formula: =MEDIAN(A1:A10)
Example: For the data {10, 20, 30, 40, 50}, the result is 30.
3. MODE.SNGL
Formula: =MODE.SNGL(A1:A10)
Example: For the data {10, 20, 20, 30, 40}, the result is 20.
4. MODE.MULT
Formula: =MODE.MULT(A1:A10)
Example: For the data {10, 20, 20, 30, 30}, the result is 20 and 30.
5. STDEV.P
Formula: =STDEV.P(A1:A10)
Example: For the data {10, 20, 30, 40, 50}, the result is 14.14.
6. STDEV.S
Formula: =STDEV.S(A1:A10)
Example: For the same data, the result is 15.81.
7. VAR.P
Formula: =VAR.P(A1:A10)
Example: For the data {10, 20, 30, 40, 50}, the result is 200.
8. VAR.S
Formula: =VAR.S(A1:A10)
Example: For the data {10, 20, 30, 40, 50}, the result is 250.
9. MAX
Formula: =MAX(A1:A10)
Example: For the data {10, 20, 30, 40, 50}, the result is 50.
10. MIN
Formula: =MIN(A1:A10)
Example: For the data {10, 20, 30, 40, 50}, the result is 10.
11. COUNT
Formula: =COUNT(A1:A10)
Example: For the data {10, 20, "Text", 30, 40}, the result is 4.
12. COUNTA
Formula: =COUNTA(A1:A10)
Example: For the data {10, 20, "Text", 30, 40}, the result is 5.
13. PERCENTILE.INC
Formula: =PERCENTILE.INC(A1:A10, 0.8)
Example: For the data {10, 20, 30, 40, 50}, the result is 40.
14. PERCENTILE.EXC
Formula: =PERCENTILE.EXC(A1:A10, 0.8)
Example: For the data {10, 20, 30, 40, 50}, the result is 40.
15. RANK.EQ
Formula: =RANK.EQ(A1, A1:A10, 0)
Example: For the data {50, 40, 30, 20, 10}, if A1 = 30, the result is 3.
16. RANK.AVG
Formula: =RANK.AVG(A1, A1:A10, 0)
Example: For the data {50, 40, 40, 20, 10}, if A1 = 40, the result is 2.5.
17. T.TEST
Formula: =T.TEST(A1:A10, B1:B10, 2, 1)
Example: For two sets of data, it returns the probability value of the t-test.
18. NORM.DIST
Formula: =NORM.DIST(50, 40, 10, TRUE)
Example: For a mean of 40 and standard deviation of 10, it returns 0.8413.
19. FREQUENCY
Formula: =FREQUENCY(A1:A10, {20, 40, 60})
Example: For the data {10, 20, 30, 40, 50}, it creates bins:
o Below 20: 1
o 20 to 40: 2
o Above 40: 2
20. CORREL
Formula: =CORREL(B1:B10, C1:C10)
Example: For B1:B10 = {1, 2, 3, 4, 5} and C1:C10 = {2, 4, 6, 8, 10}, the
result is 1.
21. COVARIANCE.P
Formula: =COVARIANCE.P(A1:A10, B1:B10)
Example: For A1:A5 = {1, 2, 3, 4, 5} and B1:B5 = {2, 4, 6, 8, 10}, the result
is 2.5.
Simplified Meaning: Measures the degree to which two variables change together (entire
population).
22. COVARIANCE.S
Formula: =COVARIANCE.S(A1:A10, B1:B10)
Example: For the same data as above, the result is 2.5.
Simplified Meaning: Measures the degree to which two variables change together
(sample).
23. LINEST
Formula: =LINEST(Y-values, X-values)
Example: For Y = {3, 5, 7} and X = {1, 2, 3}, it provides slope 2 and intercept 1.
Simplified Meaning: Returns the equation for a straight line based on data.
24. TREND
Formula: =TREND(Y-values, X-values)
Example: For Y = {3, 5, 7} and X = {1, 2, 3}, it predicts future values like 9 when
X = 4.
Simplified Meaning: Predicts trends in data based on existing values.
25. FORECAST.LINEAR
Formula: =FORECAST.LINEAR(4, Y-values, X-values)
Example: For Y = {3, 5, 7} and X = {1, 2, 3}, it forecasts 9 when X = 4.
Simplified Meaning: Predicts a value along a linear trend.
26. FORECAST.ETS
Formula: =FORECAST.ETS(A1:A10, 12)
Example: For seasonal sales data, it forecasts sales for the 12th month.
Simplified Meaning: Makes predictions based on exponential smoothing for seasonal
data.
27. RSQ
Formula: =RSQ(Y-values, X-values)
Example: For Y = {2, 4, 6} and X = {1, 2, 3}, the result is 1 (perfect correlation).
Simplified Meaning: Returns the square of the correlation coefficient.
28. CHISQ.TEST
Formula: =CHISQ.TEST(observed_range, expected_range)
Example: For observed values {10, 20} and expected values {15, 15}, it gives 0.07.
Simplified Meaning: Tests the independence of two variables.
29. Z.TEST
Formula: =Z.TEST(A1:A10, 40)
Example: For A1:A10 = {30, 35, 40, 45, 50} and mean 40, it returns 0.5.
Simplified Meaning: Returns the probability of a z-score in a normal distribution.
30. F.TEST
Formula: =F.TEST(A1:A10, B1:B10)
Example: For two datasets, it returns the probability that variances are equal.
Simplified Meaning: Tests if two data sets have the same variance.
31. SKEW
Formula: =SKEW(A1:A10)
Example: For data {1, 2, 2, 3, 10}, it returns 1.45.
Simplified Meaning: Measures asymmetry in data distribution.
32. KURT
Formula: =KURT(A1:A10)
Example: For data {1, 2, 2, 3, 10}, it returns 2.65.
Simplified Meaning: Measures peakedness of a data distribution.
33. LARGE
Formula: =LARGE(A1:A10, 2)
Example: For data {10, 20, 30, 40, 50}, the 2nd largest value is 40.
Simplified Meaning: Returns the nth largest value in a range.
34. SMALL
Formula: =SMALL(A1:A10, 2)
Example: For data {10, 20, 30, 40, 50}, the 2nd smallest value is 20.
Simplified Meaning: Returns the nth smallest value in a range.
35. QUARTILE.EXC
Formula: =QUARTILE.EXC(A1:A10, 3)
Example: For {10, 20, 30, 40, 50}, the 3rd quartile is 40.
Simplified Meaning: Divides data into quartiles (excludes min/max).
36. QUARTILE.INC
Formula: =QUARTILE.INC(A1:A10, 3)
Example: For {10, 20, 30, 40, 50}, the 3rd quartile is 40.
Simplified Meaning: Divides data into quartiles (includes min/max).
37. CONFIDENCE.NORM
Formula: =CONFIDENCE.NORM(0.05, 10, 50)
Example: For a 95% confidence level, SD = 10, size = 50, it returns 2.77.
Simplified Meaning: Calculates margin of error for normal distributions.
38. CONFIDENCE.T
Formula: =CONFIDENCE.T(0.05, 10, 50)
Example: Similar to above, but uses the t-distribution.
39. DEVSQ
Formula: =DEVSQ(A1:A10)
Example: For {10, 20, 30}, the result is 200.
Simplified Meaning: Sum of squared deviations from the mean.
40. GEOMEAN
Formula: =GEOMEAN(A1:A10)
Example: For {1, 2, 3}, the result is 1.82.
Simplified Meaning: Calculates the geometric mean of values.
41. HARMEAN
Formula: =HARMEAN(A1:A10)
Example: For the data {1, 4, 4}, the result is 2.
Simplified Meaning: Returns the harmonic mean, useful for rates or ratios.
42. BINOM.DIST
Formula: =BINOM.DIST(2, 5, 0.5, TRUE)
Example: For 2 successes in 5 trials with a probability of 0.5, the result is 0.6875.
Simplified Meaning: Calculates the probability of a certain number of successes in a
binomial distribution.
43. BINOM.INV
Formula: =BINOM.INV(5, 0.5, 0.8)
Example: For 5 trials, 0.5 probability, and 0.8 cumulative probability, the result is 3.
Simplified Meaning: Finds the smallest number of successes that meet a cumulative
probability.
44. POISSON.DIST
Formula: =POISSON.DIST(2, 4, TRUE)
Example: For a mean of 4, and a count of 2, the result is 0.2381.
Simplified Meaning: Calculates probabilities in a Poisson distribution, such as rare
events.
45. EXPON.DIST
Formula: =EXPON.DIST(2, 0.5, TRUE)
Example: For x = 2, lambda = 0.5, the result is 0.6321.
Simplified Meaning: Calculates probabilities for exponential distributions (time between
events).
46. NORM.INV
Formula: =NORM.INV(0.95, 100, 15)
Example: For 95% probability, mean = 100, SD = 15, the result is 124.674.
Simplified Meaning: Finds the value corresponding to a given probability in a normal
distribution.
47. NORM.S.DIST
Formula: =NORM.S.DIST(1.5, TRUE)
Example: For Z = 1.5, the cumulative probability is 0.9332.
Simplified Meaning: Returns the standard normal distribution value (mean = 0, SD = 1).
48. NORM.S.INV
Formula: =NORM.S.INV(0.95)
Example: For 95% probability, the result is 1.645.
Simplified Meaning: Finds the Z-score corresponding to a given cumulative probability.
49. LOGNORM.DIST
Formula: =LOGNORM.DIST(4, 0, 1, TRUE)
Example: For x = 4, mean = 0, SD = 1, the result is 0.8413.
Simplified Meaning: Calculates probabilities for a log-normal distribution.
50. LOGNORM.INV
Formula: =LOGNORM.INV(0.8413, 0, 1)
Example: For a probability of 0.8413, mean = 0, SD = 1, the result is 4.
Simplified Meaning: Returns the value for a given probability in a log-normal
distribution.
51. CHISQ.DIST
Formula: =CHISQ.DIST(2, 3, TRUE)
Example: For x = 2, degrees of freedom = 3, the result is 0.4276.
Simplified Meaning: Calculates the left-tailed probability of a chi-squared distribution.
52. CHISQ.DIST.RT
Formula: =CHISQ.DIST.RT(2, 3)
Example: For the same data as above, the right-tailed result is 0.5724.
Simplified Meaning: Calculates the right-tailed probability of a chi-squared distribution.
53. CHISQ.INV
Formula: =CHISQ.INV(0.95, 3)
Example: For 95% probability and 3 degrees of freedom, the result is 7.8147.
Simplified Meaning: Finds the chi-squared value for a given cumulative probability.
54. CHISQ.INV.RT
Formula: =CHISQ.INV.RT(0.05, 3)
Example: For 5% right-tail probability and 3 degrees of freedom, the result is 7.8147.
Simplified Meaning: Finds the chi-squared value for a given right-tail probability.
55. F.DIST
Formula: =F.DIST(2, 4, 5, TRUE)
Example: For x = 2, numerator df = 4, denominator df = 5, the result is 0.7104.
Simplified Meaning: Calculates the cumulative F-distribution probability.
56. F.DIST.RT
Formula: =F.DIST.RT(2, 4, 5)
Example: For the same data as above, the result is 0.2896.
Simplified Meaning: Returns the right-tail F-distribution probability.
57. F.INV
Formula: =F.INV(0.95, 4, 5)
Example: For 95% probability, numerator df = 4, denominator df = 5, the result is
6.3882.
Simplified Meaning: Finds the F-value for a given cumulative probability.
58. F.INV.RT
Formula: =F.INV.RT(0.05, 4, 5)
Example: For 5% right-tail probability, the result is 6.3882.
Simplified Meaning: Finds the F-value for a given right-tail probability.
59. GAMMA.DIST
Formula: =GAMMA.DIST(2, 3, 2, TRUE)
Example: For x = 2, alpha = 3, beta = 2, the result is 0.3233.
Simplified Meaning: Calculates the cumulative gamma distribution probability.
60. GAMMA.INV
Formula: =GAMMA.INV(0.5, 3, 2)
Example: For a probability of 0.5, alpha = 3, beta = 2, the result is 4.304.
Simplified Meaning: Finds the value for a given cumulative gamma probability.
61. GAMMALN
Formula: =GAMMALN(4)
Example: For 4, the result is 1.7918.
Simplified Meaning: Returns the natural logarithm of the gamma function, useful in
advanced statistics.
62. GAMMALN.PRECISE
Formula: =GAMMALN.PRECISE(4)
Example: Similar to GAMMALN, for 4, the result is 1.7918.
Simplified Meaning: Provides the precise natural logarithm of the gamma function.
63. HYPGEOM.DIST
Formula: =HYPGEOM.DIST(1, 6, 3, 12, TRUE)
Example: For 1 success, 6 draws, 3 successes in population, population size 12, the result
is 0.8182.
Simplified Meaning: Calculates probabilities in hypergeometric distributions (like
sampling without replacement).
64. NEGBINOM.DIST
Formula: =NEGBINOM.DIST(10, 5, 0.3, TRUE)
Example: For 10 failures, 5 successes, and a 0.3 success probability, the result is 0.8385.
Simplified Meaning: Calculates probabilities for a negative binomial distribution.
65. PHI
Formula: =PHI(1.5)
Example: For 1.5, the result is 0.1295.
Simplified Meaning: Returns the value of the standard normal distribution’s probability
density function.
66. WEIBULL.DIST
Formula: =WEIBULL.DIST(2, 3, 4, TRUE)
Example: For x = 2, alpha = 3, beta = 4, the result is 0.0902.
Simplified Meaning: Calculates probabilities for the Weibull distribution (useful in
reliability analysis).
67. BETA.DIST
Formula: =BETA.DIST(0.5, 2, 3, TRUE, 0, 1)
Example: For x = 0.5, alpha = 2, beta = 3, range 0 to 1, the result is 0.6875.
Simplified Meaning: Returns the cumulative beta distribution, useful in statistics for
proportions.
68. BETA.INV
Formula: =BETA.INV(0.6875, 2, 3, 0, 1)
Example: For a probability of 0.6875, alpha = 2, beta = 3, range 0 to 1, the result is 0.5.
Simplified Meaning: Finds the value of x for a given probability in a beta distribution.
69. PERMUT
Formula: =PERMUT(5, 3)
Example: For 5 items taken 3 at a time, the result is 60.
Simplified Meaning: Calculates the number of permutations (order matters).
70. PERMUTATIONA
Formula: =PERMUTATIONA(5, 3)
Example: For 5 items taken 3 at a time with repetition allowed, the result is 125.
Simplified Meaning: Calculates permutations with repetition.
71. COMBIN
Formula: =COMBIN(5, 3)
Example: For 5 items taken 3 at a time, the result is 10.
Simplified Meaning: Calculates combinations (order doesn’t matter).
72. COMBINA
Formula: =COMBINA(5, 3)
Example: For 5 items taken 3 at a time with repetition allowed, the result is 35.
Simplified Meaning: Calculates combinations with repetition.
73. PERCENTILE.EXC
Formula: =PERCENTILE.EXC(A1:A10, 0.9)
Example: For {10, 20, 30, 40, 50}, the 90th percentile is 46.
Simplified Meaning: Returns the k-th percentile of values, excluding min and max.
74. PERCENTILE.INC
Formula: =PERCENTILE.INC(A1:A10, 0.9)
Example: For {10, 20, 30, 40, 50}, the 90th percentile is 46.
Simplified Meaning: Returns the k-th percentile of values, including min and max.
75. PERCENTRANK.EXC
Formula: =PERCENTRANK.EXC(A1:A10, 40)
Example: For {10, 20, 30, 40, 50}, 40 has a rank of 0.8.
Simplified Meaning: Returns the rank of a value as a percentage, excluding min/max.
76. PERCENTRANK.INC
Formula: =PERCENTRANK.INC(A1:A10, 40)
Example: For {10, 20, 30, 40, 50}, 40 has a rank of 0.8.
Simplified Meaning: Returns the rank of a value as a percentage, including min/max.
77. MODE.MULT
Formula: =MODE.MULT(A1:A10)
Example: For {1, 2, 2, 3, 3, 4}, it returns 2 and 3.
Simplified Meaning: Finds multiple modes in a dataset.
78. MODE.SNGL
Formula: =MODE.SNGL(A1:A10)
Example: For {1, 2, 2, 3, 4}, the result is 2.
Simplified Meaning: Finds a single mode in a dataset.
79. TRIMMEAN
Formula: =TRIMMEAN(A1:A10, 0.2)
Example: For {10, 20, 30, 40, 50}, trimming 20% removes the highest and lowest
values, resulting in 30.
Simplified Meaning: Calculates the mean by excluding a percentage of extreme values.
80. RANK.AVG
Formula: =RANK.AVG(A1, A1:A10)
Example: For {10, 20, 20, 40}, the rank of 20 is 2.5.
Simplified Meaning: Returns the rank of a number, averaging tied ranks.
81. RANK.EQ
Formula: =RANK.EQ(A1, A1:A10)
Example: For {10, 20, 20, 40}, the rank of 20 is 2.
Simplified Meaning: Returns the rank of a number in a list, giving the same rank to tied
values.
82. SMALL
Formula: =SMALL(A1:A10, 2)
Example: For {10, 20, 30, 40}, the second smallest value is 20.
Simplified Meaning: Finds the nth smallest value in a dataset.
83. LARGE
Formula: =LARGE(A1:A10, 2)
Example: For {10, 20, 30, 40}, the second largest value is 30.
Simplified Meaning: Finds the nth largest value in a dataset.
84. STANDARDIZE
Formula: =STANDARDIZE(50, 40, 10)
Example: For x = 50, mean = 40, SD = 10, the result is 1.
Simplified Meaning: Calculates the z-score of a value based on the mean and standard
deviation.
85. COVARIANCE.P
Formula: =COVARIANCE.P(A1:A10, B1:B10)
Example: For two data sets, it calculates how much the variables move together. Result:
5.3.
Simplified Meaning: Returns the population covariance of two datasets.
86. COVARIANCE.S
Formula: =COVARIANCE.S(A1:A10, B1:B10)
Example: For two data sets, it calculates their sample covariance. Result: 5.4.
Simplified Meaning: Returns the sample covariance of two datasets.
87. CORREL
Formula: =CORREL(A1:A10, B1:B10)
Example: For two data sets, it returns their correlation coefficient, e.g., 0.89.
Simplified Meaning: Measures the strength and direction of the relationship between
two datasets.
88. FORECAST.LINEAR
Formula: =FORECAST.LINEAR(10, A1:A10, B1:B10)
Example: Predicts a value at x = 10 based on the relationship between A1:A10 and
B1:B10. Result: 35.
Simplified Meaning: Predicts a future value using linear regression.
89. SLOPE
Formula: =SLOPE(B1:B10, A1:A10)
Example: For x = {1, 2, 3} and y = {2, 4, 6}, the slope is 2.
Simplified Meaning: Returns the slope of a linear regression line.
90. INTERCEPT
Formula: =INTERCEPT(B1:B10, A1:A10)
Example: For x = {1, 2, 3} and y = {3, 5, 7}, the intercept is 1.
Simplified Meaning: Returns the y-intercept of a regression line.
91. RSQ
Formula: =RSQ(B1:B10, A1:A10)
Example: For two datasets, the R-squared value is 0.95.
Simplified Meaning: Measures how well a regression line fits the data.
92. STEYX
Formula: =STEYX(B1:B10, A1:A10)
Example: Calculates the standard error of the predicted y-values for x = {1, 2, 3} and y =
{3, 5, 7}. Result: 0.58.
Simplified Meaning: Provides the standard error for a regression line.
93. T.DIST
Formula: =T.DIST(1.5, 10, TRUE)
Example: For t = 1.5 and 10 degrees of freedom, the result is 0.9332.
Simplified Meaning: Returns the cumulative probability for a t-distribution.
94. T.DIST.RT
Formula: =T.DIST.RT(1.5, 10)
Example: For the same data, the right-tail result is 0.0668.
Simplified Meaning: Returns the right-tailed probability of a t-distribution.
95. T.DIST.2T
Formula: =T.DIST.2T(1.5, 10)
Example: For t = 1.5 and 10 degrees of freedom, the result is 0.1336.
Simplified Meaning: Calculates the two-tailed probability of a t-distribution.
96. T.INV
Formula: =T.INV(0.95, 10)
Example: For 95% probability and 10 degrees of freedom, the result is 1.8125.
Simplified Meaning: Finds the t-value for a given cumulative probability.
97. T.INV.2T
Formula: =T.INV.2T(0.05, 10)
Example: For 5% two-tailed probability and 10 degrees of freedom, the result is 2.228.
Simplified Meaning: Returns the t-value for a given two-tailed probability.
98. F.TEST
Formula: =F.TEST(A1:A10, B1:B10)
Example: For two datasets, the result is 0.03.
Simplified Meaning: Returns the result of an F-test to compare variances.
99. CHISQ.TEST
Formula: =CHISQ.TEST(A1:A10, B1:B10)
Example: For observed and expected data, the result is 0.15.
Simplified Meaning: Calculates the chi-squared test statistic.
100. Z.TEST
Formula: =Z.TEST(A1:A10, 20)
Example: For a dataset and hypothesized mean of 20, the result is 0.0455.
Simplified Meaning: Returns the one-tailed probability of a z-test.
101. CHISQ.DIST
Formula: =CHISQ.DIST(2, 5, TRUE)
Example: For a value of 2 with 5 degrees of freedom, the cumulative result is 0.1573.
Simplified Meaning: Returns the cumulative probability of a chi-squared distribution.
102. CHISQ.DIST.RT
Formula: =CHISQ.DIST.RT(2, 5)
Example: For the same value, the right-tailed result is 0.8427.
Simplified Meaning: Calculates the probability for the upper tail of the chi-squared
distribution.
103. CHISQ.INV
Formula: =CHISQ.INV(0.95, 5)
Example: For a 95% cumulative probability and 5 degrees of freedom, the result is
11.07.
Simplified Meaning: Finds the chi-squared value for a given cumulative probability.
104. CHISQ.INV.RT
Formula: =CHISQ.INV.RT(0.05, 5)
Example: For a 5% upper-tail probability, the result is 11.07.
Simplified Meaning: Returns the chi-squared value for the upper-tail probability.
105. BINOM.DIST
Formula: =BINOM.DIST(3, 10, 0.5, TRUE)
Example: For 3 successes in 10 trials with a 50% success rate, the result is 0.1719.
Simplified Meaning: Calculates probabilities for binomial distributions.
106. BINOM.DIST.RANGE
Formula: =BINOM.DIST.RANGE(10, 0.5, 3, 5)
Example: For 3 to 5 successes in 10 trials, the result is 0.3438.
Simplified Meaning: Returns the probability of successes within a range.
107. BINOM.INV
Formula: =BINOM.INV(10, 0.5, 0.95)
Example: For 95% cumulative probability in 10 trials, the result is 7.
Simplified Meaning: Finds the smallest number of successes that meets a given
cumulative probability.
108. POISSON.DIST
Formula: =POISSON.DIST(3, 5, TRUE)
Example: For 3 events and a mean of 5, the cumulative result is 0.265.
Simplified Meaning: Calculates probabilities for Poisson distributions (events per
interval).
109. EXPON.DIST
Formula: =EXPON.DIST(0.5, 2, TRUE)
Example: For x = 0.5 and lambda = 2, the cumulative result is 0.6321.
Simplified Meaning: Returns the probability for an exponential distribution, useful in
time-between-events analysis.
110. GEOMEAN
Formula: =GEOMEAN(A1:A10)
Example: For {1, 3, 9}, the geometric mean is 3.
Simplified Meaning: Calculates the geometric mean, useful for growth rates.
111. HARMEAN
Formula: =HARMEAN(A1:A10)
Example: For {2, 3, 4}, the harmonic mean is 2.7692.
Simplified Meaning: Computes the harmonic mean, useful for rates like speed.
112. CONFIDENCE.NORM
Formula: =CONFIDENCE.NORM(0.05, 2.5, 100)
Example: For a 5% alpha, SD = 2.5, and n = 100, the confidence interval is 0.49.
Simplified Meaning: Calculates the confidence interval for a normal distribution.
113. CONFIDENCE.T
Formula: =CONFIDENCE.T(0.05, 2.5, 100)
Example: For the same data, the confidence interval is 0.50.
Simplified Meaning: Computes the confidence interval using the t-distribution.
114. F.DIST
Formula: =F.DIST(2, 10, 15, TRUE)
Example: For x = 2 with 10 and 15 degrees of freedom, the result is 0.8322.
Simplified Meaning: Calculates the cumulative F-distribution probability.
115. F.DIST.RT
Formula: =F.DIST.RT(2, 10, 15)
Example: For the same data, the right-tail probability is 0.1678.
Simplified Meaning: Returns the upper-tail probability of the F-distribution.
116. F.INV
Formula: =F.INV(0.95, 10, 15)
Example: For a 95% cumulative probability, the result is 2.764.
Simplified Meaning: Finds the F-value for a given cumulative probability.
117. F.INV.RT
Formula: =F.INV.RT(0.05, 10, 15)
Example: For a 5% upper-tail probability, the result is 2.764.
Simplified Meaning: Returns the F-value for the upper-tail probability.
