Category: Formulas

LOGNORMDIST Function

Formulas

Hi there,

 

PRE-HISTORY:

LOGNORMDIST is basically a function which returns the cumulative lognormal distribution of x, where ln(x) is normally distributed with mean and standard_dev.

 

This function is available in compatibility functions in Excel 2010 version. There is an improved and most accurate function which can be achieved through (2010 and above) LOGNORM.DIST.

Full story »

FTEST FUNCTION

Formulas

Hi there,

 

PRE-HISTORY:

FTEST is basically a function which returns the F-Test results, which means there is an array1 and array2 variances that has not much significant differences.

 

Eg: This function actually finds the difference between the diversity of two events on the same report. Say we have Government Schools and Private Schools which actually provides test scores and, to find whether these schools have different levels of test score diversity.

 

This function is available in compatibility functions in Excel 2010 version. There is an improved and most accurate function which can be achieved through (2010 and above) F.TEST.

Full story »

EXPONDIST FUNCTION

Formulas

Hi there,

 

PRE-HISTORY:

EXPONDIST is basically a function which returns the exponential distribution value for the given x value.

 

Eg: This function actually finds the time between the events such as ATM machine gives the money so, this function helps us to find the exact time taken to deliver the money from the ATM to the customer.

The other example can be, the time taken between the click of a button on a camera to a photo still to capture into a camera. (Ridiculous example but true &#59;) )

 

This function is available in compatibility functions in Excel 2010 version. Before the users are using this function however, we can also use the latest function (2010 and above) EXPON.DIST.

Full story »

CHIDIST FUNCTION

Formulas

Hi there,

 

PRE-HISTORY:

CHIDIST is basically a function which calculates the right tailed probability of chi-squared distribution

 

Eg: Comparing the observed results with the predicted results. In other words, In 2014 elections, the expected seats for each parties vs the actual seats won by each parties.

 

This function is listed in COMPATIBILITY FUNCTIONS of Excel 2010 version. Now, the users are using CHISQ.DIST.RT function which is similar to CHIDIST with slight improvements in the function.

Full story »

BETA.DIST Function

Formulas

Hi there,

 

PRE-HISTORY:

BETA.DIST is basically a function which calculates the cumulative beta distribution or to study variation in the percentage of something across the activities.

 

Eg: Percentage of people spend their fraction of day on our blog (www.exceltoxl.com).

 

This function is introduced in Excel 2010 version. Before the users are using BETADIST function which is less accuracy than BETA.DIST

Full story »

List of Excel Functions (2003, 2007, 2010, 2013)

Formulas, Excel2013

Hi there,

 

When compared to Excel Functions with human parts, we can compare it with Human Brain. See what others are. There are many reasons why I compared and why we can accept. However, lets proceed to see the list of functions in all versions from 2003 to 2013 (461 functions).

 

COMPATIBILITY FUNCTIONS:

BETA.DIST

BETAINV

BINOMDIST

CHIDIST

CHIINV

CHITEST

CONFIDENCE

COVAR

CRITBINOM

EXPONDIST

FDIST

FINV

FTEST

GAMMADIST

GAMMAINV

HYPGEOMDIST

LOGINV

LOGNORMDIST

MODE

NEGBINOMDIST

NORMDIST

NORMINV

NORMSDIST

NORMSINV

PERCENTILE

PERCENTRANK

POISSON

QUARTILE

RANK

STDEV

STDEVP

TDIST

TINV

TTEST

VAR

VARP

WEIBULL

ZTEST

 

Pages: 1· 2· 3· 4· 5· 6· 7· 8· 9· 10· 11· 12· 13

Contact / Help. ©2019 by Abhilash VK. Design & icons by N.Design Studio. Skin by Tender Feelings / EvoFactory.