NORMINV Function
What is the NORMINV Function? The NORMINV Function is categorized under Excel Statistical functions. It will calculate the inverse of the normal cumulative distribution for the specified mean and standard deviation. Suppose we are given a normally distributed random variable that is denoted by x. For the value of x, if we wish to get...
MODE.MULT Function
What is the MODE.MULT Function? The MODE.MULT Functionis categorized under Excel Statistical functions. It will return a vertical array of statistical modes within a list of given numbers. The function was introduced in MS Excel 2010 and hence is unavailable in earlier versions. As a financial analyst, MODE.MULT is useful in financial analysis, as it...
MODE.SNGL Function
What is the MODE.SNGL Function? The MODE.SNGL Function is categorized under Excel Statistical functions. It will return the most frequently occurring number in a numeric data set. The function was introduced in MS Excel 2010 and is unavailable in earlier versions. As a financial analyst, MODE.SNGL can be used to find out the most frequently...
POISSON.DIST Function
WHAT is the POISSON.DIST Function? The POISSON.DIST Function is categorized under Excel Statistical functions. It will calculate the Poisson probability mass function. As a financial analyst, POISSON.DIST is useful in forecasting revenue. Also, we can use it to predict the number of events occurring over a specific time, e.g., the number of cars arriving at...
CRITBINOM Function
What is the CRITBINOM Function? The CRITBINOM Function is categorized under Excel Statistical functions. It will return the smallest value that is greater than or equal to the criterion value. The function returns the inverse of the Cumulative Binomial Distribution. That is, for a specific number of independent trials, CRITBITNOM will return the smallest value...
F.INV.RT Function
What is the F.INV.RT Function? The F.INV.RT Function is an Excel Statistical function that calculates the inverse of the (right-tailed) F probability distribution. As a financial analyst, this function is useful in understanding the variability in two data sets. For example, we can use F.INV.RT if we wish to analyze the income diversity between two regions...
F.DIST.RT Function
What is the F.DIST.RT Function? The F.DIST.RT Function is categorized under Excel Statistical functions. It will calculate the (right-tailed) F probability distribution. It measures the degree of diversity between two data sets. For example, we can use the function if we wish to find out the variability in the test scores of female employees in...
PHI Function
What is the PHI Function? The PHI Function is an Excel Statistical function. It will return the value of the density function for a standard normal distribution for a supplied number. The function was introduced in MS Excel 2013 and hence unavailable in earlier versions. Formula =PHI(x) The PHI function uses the following argument: X...
GROWTH Function
What is the GROWTH Function? The GROWTH Function is categorized under Excel Statistical functions. The function helps calculate predicted exponential growth by using existing data. In financial analysis, GROWTH helps in preparing annual plans or forecasting revenues for a company. Let’s assume the CEO expects annual revenues to reach $1,500,000. The function can help us...
PROB Function
What is the PROB Function? The PROB Function is categorized under Excel Statistical functions. It will calculate the probability that is associated with a given range. In financial analysis, the PROB function can be useful in estimating business losses. It can also be used by a risk manager to carry out financial probability analysis. Formula...
