Lognormal Distribution Excel Function The Lognormal Distribution Excel Function is categorized under Excel Statistical functions. It will calculate the cumulative lognormal distribution function at a given value of x. We can use the function to analyze data that‘s been logarithmically transformed. A variable x is log-normally distributed if its natural logarithm is normally distributed. In terms of…
What is the GAUSS Function? The GAUSS Function is categorized under Excel Statistical functions. It will return the probability that a member of a standard normal population will be between the mean and a specified number of standard deviations from the mean. In other words, GAUSS gives us a way to solve a specific case…
Sum of Squared Deviations in Excel The DEVSQ Function is categorized under Excel Statistical functions. It will calculate the sum of the squared deviations from the sample mean. The function, for example, can be used to find the variation in temperatures, blood pressure readings, etc. As a financial analyst, DEVSQ is useful in understanding the…
What is the STDEVPA Function? The STDEVPA Function is categorized under Excel Statistical functions. It will calculate the standard deviation that is based on the entire population given as arguments. The function will ignore logical values and text. As a financial analyst, the STDEVPA function can be used, for example, to calculate deviations in revenue….
What is the NORMDIST Function Excel Normal Distribution? The NORMDIST Function is categorized under Excel Statistical functions. It will return the normal distribution for a stated mean and standard distribution. That is, it will calculate the normal probability density function or the cumulative normal distribution function for a given set of parameters. To understand what…
Inverse Binomial Distribution in Excel The BINOM.INV Function is categorized under Excel Statistical functions. It will calculate the inverse Binomial Distribution in Excel. That is, for a given number of independent trials, the function will return the smallest value of x (the number of successes) for a specified Cumulative Binomial Distribution probability. For example, we can…
What is the T-TEST Function? The T.TEST Function is categorized under Excel Statistical functions. It will calculate the probability that is associated with a Student’s T-Test. The function is commonly used to test the probability of two samples that have underlying populations with the same mean. In financial analysis, suppose we wish to understand the…
What is the VDB Declining Balance Function? The VDB Function is an Excel Financial function that calculates the depreciation of an asset using the Double Declining Balance (DDB) method or some other method specified by the user. VDB is a short form of Variable Declining Balance. The Excel VDB function also allows us to specify a factor…
What is the SUMIF Function? The SUMIF Function is categorized under Excel Math and Trigonometry functions. It will sum up cells that meet the given criteria. The criteria are based on dates, numbers, and text. It supports logical operators such as (>, <, <>, =) and also wildcards (*, ?). This guide to the SUMIF…
What is the BINOM.DIST.RANGE Function? The BINOM.DIST.RANGE Function is categorized under Excel Statistical functions. It will calculate the binomial distribution probability for the number of successes from a specified number of trials falling into a specified range. In financial analysis, the function can be useful in finding out the probability of, for example, the three…
