- Part 1. Introduction to MM4XL
- Part 2. MM4XL Tools
- 1. Strategic Tools
- BCG Matrix
- Brand Mapping
- Brand Switch
- Decision Tree
- Forecast Manager
- McKinsey Matrix
- Profile Manager
- Quality Manager
- Risk Analyst
- Risk Analyst Expert in a Few Minutes
- Introduction to Decision Analysis
- Introducing Risk Analyst with an example
- 1. How to run Risk Analyst
- 2. Simulation Never heard of it
- 3. Examples
- 4. Functions
- 1. Property Functions
- 2. Utility Functions
- 3. Distribution Functions
- mmBETA (Scale, Shape)
- mmBETAGEN (Scale, Shape, [Optional: Lower], [Optional: Upper])
- mmBINOMIAL (Trials, Successes)
- mmCHI2 (Degrees)
- mmDISCRETE (InputRange, Probabilities)
- mmERF (Mean)
- mmERLANG (Scale, Shape)
- mmEXPON (Mean)
- mmEXTVAL (ModalValue, StDeviation)
- mmGAMMA (Scale, Shape)
- mmGAUSSINV (Mean, Scale)
- mmGEO (Trials)
- mmHYPERGEO (Sample, Defects, BatchSize)
- mmINTUNI (Lower, Upper)
- mmLOGISTIC (Mean, StDeviation)
- mmLOGNORMAL (Mean, StDeviation)
- mmNEGBIN (Failures, Successes)
- mmNORMAL (Mean, StDeviation)
- mmPARETO (Location, ModalValue)
- mmPARETO2 (Location, ModalValue)
- mmPERT (Lower, ModalValue, Upper)
- mmPOISSON (Mean)
- mmRANDBETWEEN (Lower, Upper)
- mmRAYLEIGH (ModalValue)
- mmSTUDENT (Degrees)
- mmTRI (Lower, ModalValue, Upper)
- mmUNIFORM (Lower, Upper)
- mmWEIBULL (Life, Shape)
- Probability functions
- Technicalities
- Sources
- 2. Analytical Tools
- Business Formulas
- mmBASS, Bass Diffusion Model
- mmBEI, Brand Equity Index
- mmBEP, Break-Even Point
- mmBEPR, Break-Even Point with Fixed Rate of Return
- mmBUYRATE, Purchase Rate Model
- mmCAGR, Compound Annual Growth
- mmCHIp, Chi Squared Test
- mmCODING, Coding of variables
- 1. Customer Satisfaction
- 2. Database Functions
- mmDHMS, Number to Time
- mmEI, Evolution Index
- mmEXPECT, Expected values
- 3. Forecast Errors
- mmGROWTH
- mmGROWTHBACK
- mmGRP, Gross Rating Points
- mmHERF, Herfindahl Index
- mmINTERPOLE, Linear Interpolation
- mmLEARN, Learning Curve
- mmMSAR, Market Share to Advertising Ratio
- 4. Opportunity Index
- 5. Performance Ranking
- 6. Project Management
- mmPREMIUM, Price Premium
- mmPRESS, Product Performance Index
- 7. Price Indexes
- 8. Queuing Theory
- mmRANGE
- mmREBUY, Repeat Purchase Rate
- mmREBUYS, Estimated Number of Re-Purchases
- mmRELATIVE
- mmSAMPLE, Sample Size
- mmSAMPLEMIN, Minimum Sample for Significant Values
- mmSEASON, Seasonality Indexes
- mmSHARE
- mmSIGNIF, Significance Test
- mmVARc, Coefficient of Variation
- Cluster Analysis
- CrossTab
- Descriptive Analyst
- Gravitation Analysis
- Proportion Analyst
- Sample Manager
- Segmentation Tree
- Variation Analyst
- 3. Charts and Maps
- mytest
- Version MM4XL
- contribute
- copytest
- css
- emails
- excel market analysis software
- finance
- download dbx
- download eu
- download manual
- download na
- download removed
- finance dbx
- finance eu
- finance manual
- finance na
- finance removed
- ---NO TITLE----
- ---NO TITLE----
- help
- Part 1. Introduction to MM4XL
- Part 2. MM4XL Tools
- 1. Strategic Tools
- BCG Matrix
- Brand Mapping
- Brand Switch
- Decision Tree
- Forecast Manager
- McKinsey Matrix
- Profile Manager
- Quality Manager
- Risk Analyst
- 1. How to run Risk Analyst
- 2. Simulation Never heard of it
- 3. Examples
- 4. Functions
- 1. Property Functions
- 2. Utility Functions
- 3. Distribution Functions
- mmBETA (Scale, Shape)
- mmBETAGEN (Scale, Shape, [Optional: Lower], [Optional: Upper])
- mmBINOMIAL (Trials, Successes)
- mmCHI2 (Degrees)
- mmDISCRETE (InputRange, Probabilities)
- mmERF (Mean)
- mmERLANG (Scale, Shape)
- mmEXPON (Mean)
- mmEXTVAL (ModalValue, StDeviation)
- mmGAMMA (Scale, Shape)
- mmGAUSSINV (Mean, Scale)
- mmGEO (Trials)
- mmHYPERGEO (Sample, Defects, BatchSize)
- mmINTUNI (Lower, Upper)
- mmLOGISTIC (Mean, StDeviation)
- mmLOGNORMAL (Mean, StDeviation)
- mmNEGBIN (Failures, Successes)
- mmNORMAL (Mean, StDeviation)
- mmPARETO (Location, ModalValue)
- mmPARETO2 (Location, ModalValue)
- mmPERT (Lower, ModalValue, Upper)
- mmPOISSON (Mean)
- mmRANDBETWEEN (Lower, Upper)
- mmRAYLEIGH (ModalValue)
- mmSTUDENT (Degrees)
- mmTRI (Lower, ModalValue, Upper)
- mmUNIFORM (Lower, Upper)
- mmWEIBULL (Life, Shape)
- Probability functions
- Risk Analyst Expert in a Few Minutes
- Introduction to Decision Analysis
- Introducing Risk Analyst with an example
- Technicalities
- Sources
- 2. Analytical Tools
- Business Formulas
- 1. Customer Satisfaction
- 2. Database Functions
- 3. Forecast Errors
- 4. Opportunity Index
- 5. Performance Ranking
- 6. Project Management
- 7. Price Indexes
- 8. Queuing Theory
- mmBASS, Bass Diffusion Model
- mmBEI, Brand Equity Index
- mmBEP, Break-Even Point
- mmBEPR, Break-Even Point with Fixed Rate of Return
- mmBUYRATE, Purchase Rate Model
- mmCAGR, Compound Annual Growth
- mmCHIp, Chi Squared Test
- mmCODING, Coding of variables
- mmDHMS, Number to Time
- mmEI, Evolution Index
- mmEXPECT, Expected values
- mmGROWTH
- mmGROWTHBACK
- mmGRP, Gross Rating Points
- mmHERF, Herfindahl Index
- mmINTERPOLE, Linear Interpolation
- mmLEARN, Learning Curve
- mmMSAR, Market Share to Advertising Ratio
- mmPREMIUM, Price Premium
- mmPRESS, Product Performance Index
- mmRANGE
- mmREBUY, Repeat Purchase Rate
- mmREBUYS, Estimated Number of Re-Purchases
- mmRELATIVE
- mmSAMPLE, Sample Size
- mmSAMPLEMIN, Minimum Sample for Significant Values
- mmSEASON, Seasonality Indexes
- mmSHARE
- mmSIGNIF, Significance Test
- mmVARc, Coefficient of Variation
- Cluster Analysis
- CrossTab
- Descriptive Analyst
- Gravitation Analysis
- Proportion Analyst
- Sample Manager
- Segmentation Tree
- Variation Analyst
- 3. Charts and Maps
- images
- img
- Test pages
- js
- licenses
- lightbox
- logs
- marketing resources
- picture_library
- plesk stat
- press release
- res
- brochures
- copytest
- icons
- links
- proudly_serve
- seminars
- tabs
- tools
- test
- apacheasp
- cgi
- coldfusion
- fcgi
- miva
- perl
- php
- python
- ssi
- treeview_img
- weyou
|
|
mytest > help > Part 2. MM4XL Tools > 1. Strategic Tools > Risk Analyst > 4. Functions > 3. Distribution Functions > mmGAUSSINV (Mean, Scale)
Risk Analyst mmGAUSSINV (Mean, Scale) Example
=mmGAUSSINV(1, 1) can equal 0.444967568.
Application Also called the Walds distribution, this distribution is mainly used in sequential analysis. It is often employed to test scientific models of unknown nature, to evaluate risk in the stock market, the price of a financial derivative, or, more generally, response time such as the lifetime of a component. The failure rate of this function increases until maximum is reached and then decreases towards the zero value as the lifetime approaches infinity. How to use This function models response time in sequential patterns. Say we are modeling the web surfing behavior of car buyers searching for information. From past experience we know that the number of links (pages) a visitor follows in a website before jumping to the next website is about 3 (although 1 page is the modal value) while the maximum number of pages visited is about 100. This surfing behavior can be modeled with:
=mmGAUSSINV(3, 6)
Copy the formula above in 100 cells. You will find that most simulated values will score around 1.5 rather than 3, as stated with the Mean parameter, and this is compatible with web surfing behavior. Our personal experience suggests that the Scale parameter can occasionally be found with the square root of the term (MaxValue / 3), where MaxValue stands for the largest number of, in this case, visits to pages of one individual website. Technical profile | Type | Continuous distribution. | | Syntax | =mmGAUSSINV(Mean, Scale) | | Domain |  . | | Mode |  . | | Parameters | Mean = mu > 0
Scale = b > 0 | | Remarks | If any argument is nonnumeric mmGAUSSINV returns the #VALUE! error value. | | Relationships | It is related to the Chi2 variate with 1 degree of freedom. | | Graphs | mmGAUSSINV(1, 1) mmGAUSSINV(1, 10)
  | |
