Home
Tech info
Technology
Science
Life
Application
Electric
Program
Mobile
Windows 10
Windows 11CHISQ.INV function - The function returns the inverse of the probability of the left end of the distribution when squared in Excel
The following article introduces to you the function CHISQ.INV - 1 of the jaw among statistical functions in Excel is preferred.
Description: The function returns the inverse of the probability of the left end of the distribution when squared. Support function from Excel 2010 version.
Syntax: CHISQ.INV (probability, deg_freedom)
Inside:
- probability: Probability associated with the distribution when the square of the distribution.
- deg_freedom: Number of degrees of freedom.
Attention:
- If any of the parameters' values are not numeric -> the function returns the #VALUE! Error value .
- If deg_freedom is not an integer -> it is truncated to an integer.
- If probability <0 or probability> 1 -> the function returns the #NUM! Error value
- If deg_freedom <1 or deg_freedom> 10 ^ 10 -> the function returns the #NUM! Error value
For example:
Calculate the inverse of the probability of the left end when the square of the distribution is based on the data in the table below:
- In the cell to calculate enter the formula: = CHISQ.INV (C6, C7)
- Press Enter -> the inverse of the probability of the left end of the distribution when the square is:
- Case 1 of the values of non-left parameters is number -> the function returns the error value #VALUE!
- If the number of degrees of freedom is less than 1 or greater than 10 ^ 10 -> the function returns the #NUM! Error value
Above are instructions and some specific examples when using the CHISQ.INV function in Excel.
Good luck!
Marvin FryYou should read it
- CHISQ.DIST - Function returns the distribution when squared in Excel
- F.INV function - The function returns the inverse of the probability distribution F in Excel
- F.INV.RT function - The function returns the right-inverse head value of the probability distribution F in Excel
- CHIDIST function - Function returns the right end probability of the distribution when squared in Excel
- CHISQ.TEST function - The function returns the independence test in Excel
- GAMMA.INV function - The function returns the inverse of the gamma distribution in Excel
- T.INV function - The function returns the inverse value of the Student t distribution in Excel
- BETA.INV function - The function returns the inverse of the cumulative distribution function for a specified beta distribution in Excel
May be interested
- CHISQ.INV.RT function - The function returns the inverse of the right end probability of the distribution when squared in Excel
chisq.inv.rt function: the function returns the inverse of the right end probability of the distribution when squared. support function from excel 2010 version. syntax: chisq.inv.rt (probability, deg_freedom) - CHISQ.TEST function - The function returns the independence test in Excelchisq.test function: the function returns the independence test. the function returns the value from the distribution (({chi ^ 2})) when squared for statistics and the appropriate degrees of freedom. support function from excel 2010 version. syntax: chisq.test (actual_range, expected_range)
- CONFIDENCE.NORM function - The function returns the confidence interval of the population by using a normalized distribution in Excelconfidence.norm function: the function returns the confidence interval of the population by using normalized distributions. support functions from excel 2010 onwards. syntax: confidence.norm (alpha, standard_dev, size)
- TODAY function - The function returns the current date value in the format in Exceltoday function - the function returns the current date value in the format in excel. the today () function does not automatically update, but requires setting changes to control.
- WEEKDAY function - The function returns the weekday of a corresponding date in Excelweekday function: the function returns the weekday of a corresponding day. the return value is an integer between 1 (sunday) and 7 (saturday). syntax: weekday (serial_number, [return_type])
- WEEKNUM function - The function returns the week number of the year in Excelweeknum function - the function returns the ordinal number of the week of the year of the specified day in that week. there are 2 systems used in the function to determine the ordinal number of the week: - system 1: week with january 1 is the first week of the year and numbered as 1. - system 2:
Office information
CHISQ.INV.RT function - The function returns the inverse of the right end probability of the distribution when squared in Excel- F.INV.RT function - The function returns the right-inverse head value of the probability distribution F in Excel
- F.INV function - The function returns the inverse of the probability distribution F in Excel
- CHIDIST function - Function returns the right end probability of the distribution when squared in Excel
- GAMMA.INV function - The function returns the inverse of the gamma distribution in Excel
CHISQ.INV.RT function - The function returns the inverse of the right end probability of the distribution when squared in Excel
F.INV.RT function - The function returns the right-inverse head value of the probability distribution F in Excel
F.INV function - The function returns the inverse of the probability distribution F in Excel
CHIDIST function - Function returns the right end probability of the distribution when squared in Excel
GAMMA.INV function - The function returns the inverse of the gamma distribution in Excel