STDEV.P Function
What is the STDEV.P Function? The STDEV.P Function is categorized under Excel Statistical functions. STDEV.P will calculate the standard deviation that is based on an entire population given as arguments. It will ignore logical values and text. As a financial analyst, the STDEV.P function can be useful in, for example, calculating deviations in revenue. Portfolio...
PERCENTRANK Function
What is the PERCENTRANK Function? The PERCENTRANK Function is categorized under Excel Statistical functions. This function will return the rank of a value in a data set as a percentage. It can be used to evaluate the relative standing of a value within a data set. In corporate finance, we can use PERCENTRANK to evaluate...
PERCENTILE Function
What is the PERCENTILE Function? The PERCENTILE Function is categorized under Excel Statistical functions. PERCENTILE will return the k-th percentile of the values in a particular range. In corporate finance, we can use the function to analyze, for example, the number of employees who scored above a certain percentile on a test. In MS Excel...
COVARIANCE.S Function
What is the COVARIANCE.S Function? The COVARIANCE.S Function is categorized under Excel Statistical functions. It will calculate the sample covariance for two sets of values provided by a user. As a financial modeling analyst, the COVARIANCE.S function is very useful when we want to find the extent to which two assets move in tandem –...
CORREL Function
What is the CORREL Function? The CORREL Function is categorized under Excel Statistical functions. It will calculate the correlation coefficient between two variables. As a financial analyst, the CORREL function is very useful when we want to find the correlation between two variables, e.g., the correlation between a particular stock and a market index. Correlation...
COVAR Function
What is the COVAR Function? The COVAR Function is categorized under Excel Statistical functions. It will calculate the covariance of two sets of values. As a financial analyst, suppose we want to see how two stocks may move together in the future. Looking at their historical prices, we can determine if the prices tend to...
NORM.INV Function
What is the NORM.INV Function? The NORM.INV Function is categorized under Excel Statistical functions. It will calculate the inverse of the normal cumulative distribution for a supplied value of x, with a given distribution mean and standard deviation. The function will calculate the probability to the left of any particular point in a normal distribution....
NORM.DIST Function
What is the NORM.DIST Function? The NORM.DIST Function is categorized under Excel Statistical functions. It will calculate the probability that variable x falls below or at a specified value. 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 normal...
PEARSON Function
What is the PEARSON Function? The PEARSON Function is categorized under Excel Statistical functions. It will calculate the Pearson Product-Moment Correlation Coefficient for two sets of values. For example, we can find out the relationship between the age of a person and the appearance of grey hair. As a financial analyst, the PEARSON function is...
CONFIDENCE.T Function
T Confidence Interval in Excel The T Confidence Interval Function is categorized under Excel Statistical functions. The function calculates the confidence value that can be used to construct the confidence interval for a population mean for a supplied probability and sample size. It is often used in determining the t value for a 95 confidence...
