Excel compatible function

The following article introduces in detail the functions that are in the compatible function group in excel.

Excel compatible function Picture 1

1. BETADIST function

Returns the cumulative probability density Beta. The function is used to study the percentage change. However, now there is a new function that is more accurate and closer to reality. Depending on the requirements you choose accordingly.

2. BETAINV function

Support you calculate the inverse value of the BETADIST function for a specific Beta distribution. Use this function most appropriately in planning contingency.

3. BINOMDIST function

Performing binomial probability distribution, the function is often used in statistical probability.

4. Ham CHDIST

Performs the probability calculation of a left or right end of the distribution when squared.

5. Ham CHIINV

Performs the inverse value calculation of a probability and allows expected results to be compared with the results found.

6. CHITEST function

Realizing the value of probability from distribution when squared with given figures.

7. CONCATENATE function

The function allows connecting strings of characters together. Particularly in data sorting, this function is needed to concatenate a First and Last Name string.

8. CONFIDENCE function

Calculate and give a confidence interval of the average of the sum. With this function you need to determine the standard deviation and the importance of the data.

9. COVAR function

Use to calculate the variance and product mean of deviations for each data pair in two different sets. Use this function to determine the relationship between the two data sets.

10. CRITBINOM function

The function returns the smallest value, which is used in checking product quality in a factory or factory.

11. EXPONDIST function

Returns how the exponential value range is distributed. This function is used to model the amount of time it takes to process a workload.

12. The FDIST function

Perform the probability distribution F for two data sets. Use this function to determine the diversity of these two functions.

13. Ham FINV

Perform the inverse value of the probability distribution F at the right end. This function is used to compare transformations between two data sets.

14. FORECAST function

Based on current values ​​perform predictions that predict the trend of that value in the future. Use this function in estimating product development or inventory adjustment.

15. The FLOOR function

The function rounds to the nearest multiple of the value, which tends to work in the direction of zero.

16. FTEST function

Perform probability values ​​with Studen t tests.

17. GAMMADIST function

Perform gamma distribution distributions, which are applied to study the variability of skewed distribution values.

18. Ham HYPGEOMDIST

Perform calculation super return distribution.

19. LOGINV function

Performing the calculation returns the inverse of the cumulative logarithm distribution function.

20. LOGNORMDIST function

Returns the normal distribution value of the cumulative logarithm function of a certain x value.

21. Ham MODE

Returns the remainder of a division.

22. Ham NEGBINOMDIST

Performing a calculation returns the binomial distribution but has a negative value.

23. Ham NORMDIST

Returns the normalized distribution value with the normalized mean and standard deviation.

24. Ham NORMINV

Returns the inverse of the normalized distribution with the normalized mean and the standard deviation.

25. NORMSDIST function

Returns a standardized cumulative distribution function.

26. Ham NORMSINV

Performing a calculation returns the inverse value of the normalized cumulative distribution.

27. PERCENTILE function

The function returns the kth percentile in the value set. The function is used to determine the acceptable threshold or range of a value set.

28. Ham PERCENTIRANK

Returns the rank of a value, which is calculated based on a percentage comparison of values ​​in an array or data set.

29. POISSON function

Returns the Poisson distribution that determines whether the value of X equals the value of xi in the dataset.

30. QUARTILE function

Returns the quartile of a dataset, an application for grouping, arranging positions.

31. Ham RANK

Returns its rank in the list of numbers. Attention only use in numeric data.

32. STDEV function

Use the function to get an estimate of the standard deviation based on a set of samples.

33. Ham TDIST

Returns the distribution as percentage points for the Student's t-distribution.

34. Ham TINV

Returns the Sutudent t distribution but that value is the inverse value.

35. Ham TTEST

Returns the probability of the Student's t-distribution, this function is used to determine whether two samples are from the same root set.

36. VAR function

Use functions for the purpose of estimating variance values ​​based on a given pattern.

37. VARP function

Performing a calculation returns the tolerance value based on the overall data.

38. Ham WEIBULL

Returns the Weibull distribution, using the function to determine a device's life based on available data.

39. ZTEST function

Returns the probability value, but that value is only one side of the z test.

The above is a summary of all functions in the compatible function group. Hope you identify it when you need it.

Good luck!