What is the ISLOGICAL Function? The ISLOGICAL Function is categorized underExcel Information functions. The function will test the value or expression provided and return a logical value. That is, it will evaluate the value or expression to provide a TRUE or FALSE result. ISLOGICAL is part of a group of functions called the IS functions,…
What is the ISEVEN Function? The ISEVEN Function is categorized under Excel Information functions. ISEVEN will return TRUE if the number is even or FALSE if the number is not even, or odd. In financial analysis, we need to deal with numbers. The ISEVEN function is useful in data analysis where we need to understand…
What is the STDEVA Function? The STDEVA Function is categorized under Excel Statistical functions. It will estimate the standard deviation based on a sample. As a financial analyst, STDEVA can be useful in finding out the rate of return on an investment and measuring the investment’s volatility. If a stock is volatile, it will have a…
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…
