HomeApplicationOffice information

GAMMAINV function in Excel, how to use and examples

With simple syntax, you can easily apply the GAMMAINV function to statistical problems.

Instructions on how to use the GAMMAINV function

Syntax : GAMMAINV(probability,alpha,beta)

In there :

- probability : Required – Is the probability associated with the gamma distribution.
- Alpha : Required – Is a parameter to the distribution.
- Beta : Required – Is a parameter to the distribution.

GAMMAINV function in Excel, how to use and examples Picture 1

Consider the example

You enter into Excel the actual values ​​corresponding to the parameters of the GAMMAINV function in the excel cells. In this example, we calculate with the Probability associated with the gamma distribution is 0.0735, the Alpha Parameter of the distribution is 8 and the Alpha Parameter of the distribution is 3:

GAMMAINV function in Excel, how to use and examples Picture 2

Enter the formula in cell C9. And the calculated result of the function is 13.00013994:

GAMMAINV function in Excel, how to use and examples Picture 3

So now you know how to use the GAMMAINV function in Excel to calculate the inverse value of the cumulative gamma distribution. When the Beta parameter is 1, the function will return the standard gamma distribution, otherwise if Beta is not positive, Excel will display the #NUM! error.

The GAMMAINV function is supported on many versions such as Office 2013, Office 2010, Office 2007 and Office 2003, helping users easily apply it to probability analysis and data statistics problems. You can also combine it with functions such as GAMMADIST to analyze distributions more accurately.

4 ★ | 2 Vote
excel

You should read it

May be interested

  • DSUM function in Excel, how to use DSUM function and examplesDSUM function in Excel, how to use DSUM function and examples
    dsum function in excel, how to use dsum function and examples. the dsum function in excel is a fairly common function with a fairly simple usage. but if you do not know how to use the dsum function, you can refer to the following article to understand h
  • PMT function in Excel - Usage and examplesPMT function in Excel - Usage and examples
    the pmt function is one of the built-in financial functions of the excel software used to calculate the payment for a loan based on regular payments and a constant interest rate. the pmt function is not only useful for businesses, but also very practical for users if you want to calculate a loan.
  • How to use the MAXA function in Excel, detailed examplesHow to use the MAXA function in Excel, detailed examples
    the maxa function in excel helps find the largest value in a data set, including numbers, logical values, and text containing numbers. this is different from the max function, which only counts numbers. let's learn the syntax and usage of the maxa function with practical examples.
  • LEFT function in Excel, how to use LEFT function and illustrative examplesLEFT function in Excel, how to use LEFT function and illustrative examples
    left function in excel, how to use left function and illustrative examples. left function in excel is a function of string processing function, you use left function when you need to cut the character string to the left of the text string. if you need to learn more about mid functions, be patient
  • How to use the SUMIF function in ExcelHow 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.
  • Choose function in Excel, how to use the Choose function and illustrative examplesChoose function in Excel, how to use the Choose function and illustrative examples
    choose function in excel, how to use the choose function and illustrative examples. you are looking for ways to use the choose function in excel so you can use the choose function quickly. so, please refer to the following article to know the choose function syntax, for example how
  • DCOUNT function in Excel - Usage and practical examplesDCOUNT function in Excel - Usage and practical examples
    the dcounta function is one of many frequently used math functions in excel. the dcount function helps you count non-blank data cells in list columns or data arrays with defined conditions.
  • The function takes whole parts in Excel - Specific examplesThe function takes whole parts in Excel - Specific examples
    the function takes whole parts in excel - specific examples. excel has 2 functions that involve taking integer parts: quotient, int. there are many people who have a confusion between these two functions, only when you understand the nature of each one can you use them most accurately.
  • Random function in Excel (RAND function), how to use the Random function and examplesRandom function in Excel (RAND function), how to use the Random function and examples
    random function in excel (rand function), how to use the random function and examples. you need to get a random value in a range of values. to avoid duplicate values ​​and objectivity, you should use the rand () function. the article below gi
  • FIND function in Excel - Usage and examplesFIND function in Excel - Usage and examples
    find function in excel - usage and examples. the find function in excel is a function of the text function group, you can use the find function to find the position of a substring of text in another text. to understand more about the find function, how to use it and the examples used in the find function

Office information