How to use Excel EXPON.DIST Function

Introduction:-     EXPON.DIST function in excel is a statistical function. This function is used to find the exponential distribution. It is an update over EXONDIST function and is available in Excel 2010 and newer versions. It is a worksheet function and can be entered into the cell in which value is required. Syntax:-                                     =EXPON.DIST(X, Lambda, Cumulative) Arguments:- X: It is the value of the function. Lambda:  It is the value of the parameter. Cumulative: It is a logical value which helps…

Continue Reading

How to use Excel DEVSQ Function

Introduction:- DEVSQ function in excel is a statistical function. This function is used to find the sum of the squared deviations from the mean from a sample. It is a worksheet function and can be entered into the cell in which value is required. Syntax:-                         =DEVSQ(Number1,Number2, ……) Arguments:- Number1: First value or reference to the cell containing first value. Number2: Second value or reference to a cell containing second value. Keynotes:- Arguments may be in form of numbers, names, arrays,…

Continue Reading

How to use Excel COVARIANCE.S Function

Introduction:- COVARIANCE.S function in excel is a statistical function. This function is used to find the sample co-variance of two data sets. For example it can be used to keep  check on how to assets are moving together. This is a worksheet function and can be entered into the cell in which count is required. Syntax:-                          =COVARIANCE.S(Array1, Array2) Arguments:- Array1: 1st range of cells. Array2: 2nd range of cells. Keynotes:- The arguments used should be numbers or range of cells…

Continue Reading

How to use Excel COVARIANCE.P Function

Introduction:- COVARIANCE.P function in excel is a statistical function. This function is used to find the variability of two data sets which are co-variant to each other. For example if we needs to find whether greater levels of inflation leads to greater levels of inflation, than we can use excel function. This is a worksheet function and can be entered into the cell in which count is required. Syntax:-                     =COVARIANCE.P(Array1, Array2) Arguments:- Array1: 1st range of cells. Array2: 2nd range…

Continue Reading

How to use Excel COUNTIFS Function

Introduction:- COUNTIFS function in excel is a statistical function. This function is used to count the number of cells that meet a certain one or more criteria. It can be used to count cells containing dates, numbers, text etc. provided they match certain criteria. This function also supports logical operators and wildcards. This is a worksheet function and can be entered into the cell in which count is required. Syntax:- =COUNTIFS(Range1, Criteria1, Range2, Criteria2,……) Arguments:- Range1: It is the 1st…

Continue Reading

How to use Excel COUNTIF Function

Introduction:- COUNTIF function in excel is a statistical function. This function is used to count the number of cells that meet a certain single criteria. It can be used to count cells containing dates, numbers, text etc. provided they match certain criteria. This function also supports logical operators and wildcards. This is a worksheet function and can be entered into the cell in which count is required. Syntax:- =COUNTIF(Range, Criteria) Arguments:- Range:  It is the range of cells which will…

Continue Reading

How to use Excel COUNTBLANK Function

Introduction:- COUNTBLANK function in excel is a statistical function. This function is used to count empty cells and cells containing text values, numbers, logical values etc. are not used in counting. This is a worksheet function and can be entered into the cell in which COUNTBLANK is required. Syntax:- =COUNTBLANK(Range) Arguments:- Range: It is the range of cells from which blank cells will be counted. Keynotes:- COUNTBLANK function can use up to 255 additional values.Text values, logical values, empty cells…

Continue Reading

How to use Excel COUNTA Function

Introduction:- COUNTA function in excel is a statistical function. This function is used to count the number of values that are numbers, text, error values, logical values, empty text; usually these are the cells that contain numbers, text, error values, logical values, empty text. This is a worksheet function and can be entered into the cell in which count is required. Syntax:- =COUNTA(value1, value2, …., …) Arguments:- Value1:   1st range of values or reference to a cell Value2:   2nd range…

Continue Reading

How to use Excel COUNT Function

Introduction:- COUNT function in excel is a statistical function. This function is used to count the number of values that are numbers; usually these are the cells that contain numbers. This is a worksheet function and can be entered into the cell in which count is required. Syntax:- =COUNT(value1, value2, …., …) Arguments:- Value1:   1st range of values or reference to a cell Value2:   2nd range of values or reference to a cell Keynotes:- COUNT function can use up to…

Continue Reading

How to use Excel CORREL Function

Introduction:- CORREL function in excel is a statistical function. It is used to find correlation between two variables and gives correlation coefficient having value between +1 and -1. A value of +1 means a perfect directly proportional relation is present and a value of -1 means a perfect inversely proportional relation is present.  It is a worksheet function and can be entered into the cell in which value is required. Syntax:- =CORREL(array1, array2) Arguments:- Array1:   1st range of values Array2:  …

Continue Reading
Close Menu
×

Cart