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!

Isabella Humphrey

Update 19 May 2020

You should read it

May be interested

How to use Excel's VALUE function
excel's value function will convert a string to a digital form, which can be combined with other functions such as left function, right function, mid function.
How to use the WRAPROWS function in Excel
having trouble with handling large data sets in excel? then learn how to use the wraprows function to split them into more manageable rows.
How to use the IFS function in Excel 2016
the ifs function in excel is a logical function introduced in excel 2016. this function is a function that replaces the nested if function and is much easier to use. the ifs function checks one or more conditions and returns a value that meets the first true condition.
How to use the NPER function in Excel to plan loans and savings
do you want to effectively manage and control your personal finances? then we invite you to learn how to use excel's nper function.
How to use the function to delete spaces in Excel
deleting white space with functions in excel makes it easier for users to handle content, instead of traditional editing.
How to fix the SUM function doesn't add up in Excel
in the process of summing with sum in excel, you will encounter some errors such as not jumping the number, not adding the sum. so how to handle this problem?
How to use the SUBTOTAL function in Excel
the subtotal function in excel is used in many different cases, helping you to sum subtotals in a list or database, unlike the sum function in excel such as counting cells, calculating average, finding the largest / smallest value. or sum the filtered list values in excel
Save time with these text formatting functions in Microsoft Excel
microsoft excel is a main application for anyone who has to work with numbers, from students to accountants. but its usefulness extends beyond a large database, it can do a lot of great things with text. the functions listed below will help you analyze, edit, convert, change text and save many hours of boring and repetitive tasks.
SUMPRODUCT function in Excel: Calculates the sum of corresponding values
the sumproduct function is an extremely useful function when you have to deal with a lot of data numbers in microsoft excel. here are the things you need to know about the sumproduct function in excel.
How to use the SUMIF function in Excel
the sumif function in excel is a function used to compute values in a specified range. the sumif function can be used for summing cells based on the date, data and text that are connected to the specified area.