Home
Tech info
Technology
Science
Life
Application
Electric
Program
Mobile
Windows 10
Windows 11CHISQ.INV.RT function - The function returns the inverse of the right end probability of the distribution when squared in Excel
The following article introduces you to CHISQ.INV.RT function - one of the functions in the statistical function group is very popular in Excel.
Description: The function returns the inverse of the probability of the right end of the distribution when squared. Support function from Excel 2010 version.
Syntax: CHISQ.INV.RT (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 value of the parameter is not numeric -> the function returns the error value #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 value of the right-headed probability 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.RT (C6, C7)
- Press Enter -> the inverse of the probability of the right end of the distribution when the square is:
- Case 1 of the values of the parameters is not a 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.RT 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.TEST function - The function returns the independence test in Excel
chisq.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:
- The WORKDAY function - The function returns a date before or after the start date of a number of working days in Excelworkday - the function returns a date before or after the start date of a specified number of working days. weekends and public holidays do not count toward business days. syntax: workday (start_date, days, [holidays])
Office information
CHISQ.INV function - The function returns the inverse of the probability of the left end 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 function - The function returns the inverse of the probability of the left end 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