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…
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…
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…
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…
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…
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…
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…
What is the Home Equity Line of Credit (HELOC) Calculator? The Home Equity Line of Credit (HELOC) calculator can calculate the maximum line of credit available for a homeowner. A HELOC is similar to a mortgage, as both types of loans use a house as collateral. However, there are no fixed principal repayments or pre-set…
What is Delta? Delta is a risk sensitivity measure used in assessing derivatives. It is one of the many measures that are denoted by a Greek letter. The series of risk measures that use such letters are fittingly referred to as the Greeks. They are often also called risk measures, hedge parameters, or risk sensitivities….
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…
