SheetFX
≡
<< Go back to all functions

PHI

The PHI function in Google Sheets returns the value of the normal distribution with mean 0 and standard deviation 1. With the PHI function, you can calculate probabilities and perform statistical analysis efficiently.

Function Syntax and Parameters

Syntax: PHI(x)

Parameters:

  • x: The value for which you want to calculate the standard normal cumulative distribution.

Step-by-Step Tutorial

  1. Calculating the standard normal cumulative distribution:
    • Example: =PHI(1.96)
    • Result: 0.97500210485178

Use Cases and Scenarios

  1. Probability Calculations: Calculate probabilities under the normal distribution curve.
  2. Z-Score Calculation: Determine the z-score for a given value.
  3. Risk Assessment: Assess the probability of a certain event occurring.

Related Functions

  • NORMSDIST: Calculate the standard normal cumulative distribution.
  • NORMSINV: Calculate the inverse of the standard normal cumulative distribution.

Related Articles