What is the ISNONTEXT Function? The ISNONTEXT Function is categorized under Excel Information functions. The function helps to check if a cell contains text or not (is anything typed into a cell?). It will return TRUE if the value is text and if not, FALSE. For example, if the given value is a number, date,…
What is the ISNA Excel Function? The ISNA Excel Function is categorized under Information functions. This function helps in checking if a cell contains the #N/A! error. It will return a FALSE value for other types of errors. As a financial analyst, we deal with data and perform analysis on it. The ISNA function helps…
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…
