NTFDISTINV
Returns the inverse of the cumulative distribution function for a specified F distribution.
Syntax
NTFDISTINV(
prob,
N1,
N2
)
Parameters
- prob is a probability corresponding to the normal distribution .
- N1 is a parameter of the distribution (Positive integer).
- N2 is a parameter of the distribution (Positive integer).
Example
- The example may be easier to understand if you copy it to a blank worksheet
How to copy an example
-
Create a blank workbook or worksheet.
-
Select the example in the Help topic.
Note Do not select the row or column headers.
Selecting an example from Help
-
Press CTRL+C.
-
In the worksheet, select cell A1, and press CTRL+V.
-
To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.
| A | B | |
|---|---|---|
| 1 | Data | Description |
| 2 | 0.5 | Probability associated with the F distribution |
| 3 | 4 | Value of parameter N1 |
| 4 | 30 | Value of parameter N2 |
| 5 | Formula | Description (Result) |
| 6 | =NTFDISTINV(A2,A3,A4) | Inverse of the cumulative distribution function for the terms above |