[ad_1]
How to Use the GAMMAINV Function in Microsoft Excel

Excel is the spreadsheet application which has been distributed and written by the Microsoft for Mac OS x and Windows. With the application, you can compute, make graphs, tables, etc. This features macro programming language as well which is known as the Visual Basic for the application, or VBA. It’s also one of the widely used spreadsheet application, since version 5 in the year 1993. The present versions of Excel are MS Office Excel 2010 f for Microsoft Windows and for Mac 2008. Since then, there are lots of interesting and useful features that comes with the application.

GAMMAINV Function Description

GAMMAINV Function returns the inverse of gamma cumulative distributions. When p = GAMMADIST (x…), then the GAMMAINV (p…) =x.

You can use function to study the variables whose distribution can be skewed.

GAMMAINV Function Syntax:

= GAMMAINV (probability, alpha, beta)

Where,

• Probability – is probability linked with gamma distribution

• Alpha – is parameter to distribution

• Beta – is parameter to distribution

When beta is equals to one, GAMMAINV return to the standard gamma distribution.

Notes:

• When the argument is text, the GAMMAINV return to #VALUE! Error value

• When probability one, GAMMAINV return to #NUM! Error value

• If the alpha ≤ zero or when beta ≤ zero, GAMMAINV return to #NUM! Error value

• Given the value for probability, the GAMMAINV looks that the value x like that GAMMADIST (x, alpha, beta, True) = probability. Hence, precisions of GAMMAINV vary in the precision of the GRAMMADIST. The GAMMAINV function uses iterative techniques. When the search hasn’t converged after one hundred iterations, the function return to #N/A! Error value.

How to Use GAMMAINV Function?

Excel is such a powerful tool that you can use to calculate stat information using its functions. This can probably offer any stat output that you need. For instance, to acquire an inverse function of the statistical distribution as this linked to gamma, and then you can use the GAMMAINV function in Excel.

Steps:

• Begin with opening the MS Excel program, then start. Choose Program and choose Microsoft Office, then opt for Excel.

• Look for excel file that you like to use in the GAMMAINV function. Choose File options then Open the file menu, locate excel spreadsheet file you like to apply.

• Opt for blank spreadsheet cell to put GAMMAINV function. The cell must be comfortably located in the spreadsheet or when the spreadsheet has large amount of data.

• Hit on Insert function button at the top of the he column header in spreadsheet.

• Type GAMMAINV in search function, click GAMMAINV function to run the function

• Input the probability, alpha, and beta of given information in the spreadsheet, when you don’t understand the use of these inputs; you would need to read GAMMAINV function details.

[ad_2]

Source by Christopher Fennell