Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions
  • Excel Advanced Lookup using Index and Match Functions
  • How to use Excel MMULT Function
  • VLOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • Convert text string to valid reference in Excel using Indirect function

Data Analysis Examples

  • Excel Bar Chart
  • Conditional Formatting New Rule with Formulas in Excel
  • How To Sort One Column or Multiple Columns in Excel
  • Get column index in Excel Table
  • How to calculate average last N values in a table in Excel

Data Validation Examples

  • Excel Data validation no punctuation
  • Excel Data validation specific characters only
  • Excel Data validation allow weekday only
  • Excel Data validation exists in list
  • Data validation must not exist in list

GAMMA.INV function: Description, Usage, Syntax, Examples and Explanation

by

What is GAMMA.INV function in Excel?

GAMMA.INV function is one of Statistical functions in Microsoft Excel that returns the inverse of the gamma cumulative distribution. If p = GAMMA.DIST(x,…), then GAMMA.INV(p,…) = x. You can use this function to study a variable whose distribution may be skewed.

Syntax of GAMMA.INV function

GAMMA.INV(probability,alpha,beta)

The GAMMA.INV function syntax has the following arguments:

  • Probability     Required. The probability associated with the gamma distribution.
  • Alpha     Required. A parameter to the distribution.
  • Beta     Required. A parameter to the distribution. If beta = 1, GAMMA.INV returns the standard gamma distribution.

GAMMA.INV formula explanation

  • If any argument is text, GAMMA.INV returns the #VALUE! error value.
  • If probability < 0 or probability > 1, GAMMA.INV returns the #NUM! error value.
  • If alpha ≤ 0 or if beta ≤ 0, GAMMA.INV returns the #NUM! error value.

Given a value for probability, GAMMA.INV seeks that value x such that GAMMA.DIST(x, alpha, beta, TRUE) = probability. Thus, precision of GAMMA.INV depends on precision of GAMMA.DIST. GAMMA.INV uses an iterative search technique. If the search has not converged after 64 iterations, the function returns the #N/A error value.

Example of GAMMA.INV function

Steps to follow:

1. Open a new Excel worksheet.

2. Copy data in the following table below and paste it in cell A1

Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.

You can adjust the column widths to see all the data, if need be.

Data Description
0.068094 Probability associated with the gamma distribution
9 Alpha parameter to the distribution
2 Beta parameter to the distribution
Formula Description Result
=GAMMA.INV(A2,A3,A4) Inverse of the gamma cumulative distribution for the probability, alpha, and beta arguments in A2, A3, and A4. 10.0000112

Post navigation

Previous Post:

GAMMA.DIST function: Description, Usage, Syntax, Examples and Explanation

Next Post:

GAMMALN function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • T function: Description, Usage, Syntax, Examples and Explanation
  • How to get top level domain (TLD) in Excel
  • CHAR function: Description, Usage, Syntax, Examples and Explanation
  • How to extract last two words from text string in Excel
  • UNICODE function: Description, Usage, Syntax, Examples and Explanation
  • Extract time from a date and time in Excel
  • How to calculate working days left in month in Excel
  • Get days between dates in Excel
  • How to calculate next anniversary date or birthday in Excel
  • How to calculate percent of year complete in Excel
  • CUMIPMT function: Description, Usage, Syntax, Examples and Explanation
  • PRICE function: Description, Usage, Syntax, Examples and Explanation
  • YIELD function: Description, Usage, Syntax, Examples and Explanation
  • FV function: Description, Usage, Syntax, Examples and Explanation
  • IRR function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles