Math.NormInv
------------

Calculates NormInv function like in Excel.

| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
|---|---|---|---|---|---|---|
| [Math](component_Math.md) | [11.1](newinversion111.md) | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |

MBS( "Math.NormInv"; p { ; µ; σ } ) 

**MBS**( **"Math.NormInv";** /\* Calculates NormInv function like in Excel. \*/  
**$p**; /\* Probability.e.g. 0.56 \*/   
**$µ**; /\* Optional; The arthmetic mean of the distribution.e.g. 5 \*/   
**$σ**) /\* Optional; Sigma.  
Standard deviation of the distribution.e.g. 2 \*/ 

### Parameters

| Parameter | Description | Example | Flags |
|---|---|---|---|
| p | Probability. | 0.56 |  |
| µ | The arthmetic mean of the distribution. | 5 | Optional |
| σ | Sigma.   Standard deviation of the distribution. | 2 | Optional |

### Result

Returns OK or error.

### Description

Calculates NormInv function like in Excel.  
### Examples

Try it:

 MBS ("Math.NormInv"; 0,56; 5; 2)  
<small>  
Example result: 5.3019384309935544408</small>### Release notes

- **Version 11.1**
    - Added [Math.NormInv](https://www.mbsplugins.eu/MathNormInv.shtml) function.

### Blog Entries

- [MBS FileMaker Plugin, June 2021 News](https://www.mbsplugins.de/archive/2021-06-01/MBS_FileMaker_Plugin_June_2021/monkeybreadsoftware_blog_filemaker)
- [MBS FileMaker Plugin 11.1](https://www.mbsplugins.de/archive/2021-03-16/MBS_FileMaker_Plugin_111/monkeybreadsoftware_blog_filemaker)
- [Neues MBS FileMaker Plugin 11.1](https://www.mbsplugins.de/archive/2021-03-09/Neues_MBS_FileMaker_Plugin_111/monkeybreadsoftware_blog_filemaker)
- [MBS FileMaker Plugin 11.1](https://www.mbsplugins.de/archive/2021-03-09/MBS_FileMaker_Plugin_111/monkeybreadsoftware_blog_filemaker)
- [MBS FileMaker Plugin, version 11.1pr1](https://www.mbsplugins.de/archive/2021-02-01/MBS_FileMaker_Plugin_version_1/monkeybreadsoftware_blog_filemaker)

This function is free to use.

Created 30th January 2021 , last changed 30th January 2023

  
[Math.Multiply](MathMultiply.md) - [Math.NumberToText](MathNumberToText.md)

[HTML Version](MathNormInv.shtml)