Contact
12 programs
Explore the site

Zoho Sheet PHI: Standard Normal Density with Examples

Statistical Intermediate Zoho Sheet

Calculate standard-normal probability density using Zoho Sheet PHI, with reproducible z-score tables, density-versus-probability guidance, independent checks and official syntax.

Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Zoho Sheet. How formula examples are checked

Quick answer. Use =PHI(A2) to calculate the height of the standard normal probability density curve at the z-score in A2. If A2 contains 1, the mathematically expected answer is 0.241970724519. This is a density, not a 24.2% chance that a continuous measurement equals exactly 1. Zoho documents PHI(x); the displayed numeric values below were independently calculated, not executed in a Zoho Sheet session. [Z-PHI, M1]

Official syntax, argument type, and scope

PHI(x)
Position Name Required? Purpose and type Example
1 x Required A numeric z-score: the standardized distance from a normal mean in units of the standard deviation. A2, 0, 1.96, -2

There is no optional cumulative flag, no explicit mean argument, and no standard-deviation argument in the documented PHI signature. Its distribution is standard normal: mean 0, standard deviation 1. To work with a measurement on a different normal scale, first standardize it with (measurement - population_mean) / positive_population_sd. [Z-PHI, M1]

The English-language function documentation shows a single argument; this page does not independently validate how a specific account’s formula locale handles separators or decimal points. For PHI’s single numeric argument there is no separator to enter. Zoho also states that an empty referenced cell is treated as zero. That documented behavior is useful for understanding the function, but dangerous if a blank cell really means missing data: a blank reference would produce a perfectly plausible density at zero rather than drawing attention to the missing observation. [Z-PHI]

What PHI measures ā€” density, not probability

Mathematically, the standard normal probability density is

phi(z) = EXP(-(z^2) / 2) / SQRT(2 * PI())

Here EXP, SQRT, and PI express the corresponding mathematical components. A density curve’s total area is 1, whereas the height at one point is not itself the probability of a point event. To obtain the probability of a standard-normal value less than or equal to z, use the documented cumulative function NORMSDIST(z). To obtain the chance of a value between two z-scores, subtract two cumulative values. The distinction matters: multiplying or interpreting PHI(1) directly as a probability for the exact value 1 is an incorrect statistical conclusion. [Z-PHI, Z-NORMSDIST, M1]

The normal curve is symmetric: PHI(-z) = PHI(z) for any finite real z. It peaks at z = 0 and decreases as the absolute z-score increases. A positive PHI output does not indicate that the z-score itself is positive, nor does it imply a direction of deviation. If direction is required, retain the original z-score alongside the density column. [M1]

Reproducible worksheet: compare density and cumulative probability

In a new worksheet, enter the following values in A2:A8, with a header in A1. The rest of the columns are formulas rather than values. [M1]

Cell A ā€” z-score B ā€” candidate Zoho formula Independently expected PHI(z)
A2 -2 =PHI(A2) 0.053990967
A3 -1 =PHI(A3) 0.241970725
A4 0 =PHI(A4) 0.398942280
A5 0.25 =PHI(A5) 0.386668117
A6 1 =PHI(A6) 0.241970725
A7 1.8 =PHI(A7) 0.078950158
A8 5 =PHI(A8) 0.000001487

Put =PHI(A2) in B2, then fill down through B8. For cumulative results, label C1 Cumulative and put =NORMSDIST(A2) in C2; fill down. The C column should describe a different quantity: the area to the left of the entered z-score. For z = 1, the mathematically expected cumulative area is 0.841344746, not 0.241970725. For z = -1 it is 0.158655254, while the density in B is unchanged. [Z-PHI, Z-NORMSDIST, M1]

An independent formula cross-check. On the same worksheet, enter =EXP(-(A2^2)/2)/SQRT(2*PI()) in D2 and fill down. The PHI column and the analytic-formula column should agree within rounding in a mathematically conforming implementation; these two formulas were not compared in a live Zoho account. If a discrepancy appears, first check parentheses, exponent placement and that both columns use the identical A-cell value. [M1]

Advanced application: standardize quality measurements

Suppose a manufacturing measurement is modeled as normal with mean 100 units and known standard deviation 15. Enter a measured value of 130 in F2, mean 100 in G2, and standard deviation 15 in H2. Put =(F2-G2)/H2 in I2. This gives z = 2. Use =PHI(I2) in J2 to obtain a density of about 0.053990967 on the standardized z-scale. This is not the probability of seeing exactly 130 units, and not a density in the original units of measurement. [M2]

For the original measurement scale, the normal density is PHI(z)/Ļƒ; a candidate worksheet expression would be =PHI(I2)/H2, giving roughly 0.0035993978 per measurement unit. Alternatively, the official Zoho NORMDIST(x; Ī¼; Ļƒ; mode) returns the normal density when mode is 0 or FALSE. The mathematically corresponding candidate is =NORMDIST(F2;G2;H2;FALSE). This use of NORMDIST is supported by its published syntax; direct equality across the two Zoho formulas remains untested here. [Z-NORMDIST, M2]

To estimate the chance of a measurement above 130 instead, use =1-NORMDIST(F2;G2;H2;TRUE); the independent normal model gives approximately 0.022750132, or 2.275%. That is an area of the curve and therefore a probability. The TRUE argument is explicitly documented by Zoho as cumulative mode. [Z-NORMDIST, M2]

A second advanced use: visualize a bell curve safely

Make a grid of z-scores from -3 to +3 in steps of 0.5. Place =PHI(A2) beside each z-score and plot an XY scatter chart rather than treating the vertical axis as whole percentages. The y-axis label should read standard-normal density. For comparison, another chart based on =NORMSDIST(A2) gives a rising cumulative curve between zero and one. Visualizing the two together as separate series helps readers avoid confusing the shape of the density curve with cumulative likelihood. [M1]

If you need to approximate a probability over a narrow interval, a density times interval width can be a local approximation: for small Ī”, PHI(z)*Ī” ā‰ˆ P(zā‰¤Zā‰¤z+Ī”). The accurate normal model uses NORMSDIST(z+Ī”)-NORMSDIST(z); the approximation becomes less reliable when the interval is wide or far into the tails. Do not label an interval approximation as a native Zoho test. [M1]

Errors, limits and troubleshooting

Symptom Likely cause Useful check
#NAME! Misspelled function or invalid named reference. Type PHI exactly and inspect whether the formula begins with =.
#VALUE! Nonnumeric data or an incompatible argument type. Inspect the source cell; ensure the z-score is numeric, not text such as 1 SD.
#REF! Broken cell reference after moving or deleting rows. Repair the source address in the PHI formula.
Blank source gives an unexpected peak Officially documented empty-cell-as-zero handling. Check missing-data inputs before evaluating; don’t silently treat blanks as real z = 0 observations.
Density is very small / visually zero Input lies in the far tails or display rounding hides digits. Increase displayed decimals and use scientific notation if appropriate.
Density seems to exceed a probability interpretation A continuous density is being interpreted as a point probability. Use NORMSDIST for cumulative probabilities, or a difference of CDFs for intervals.

The error list on Zoho’s PHI page includes generic #N/A! help text that explicitly discusses lookup functions. Do not infer that PHI has a special lookup-mode failure from that generic text. Numerical underflow thresholds, overflow treatment and precision boundaries were not verified for a particular Zoho version or account. [Z-PHI]

Compatibility, platform and edition notes

  • Zoho Sheet (documented): PHI(x) is listed on the public Zoho Help site in the Statistical functions section; only the English-language help syntax and examples were inspected. No Zoho session, workbook import, desktop/mobile app, or locale-specific configuration was executed. No first-supported version or plan entitlement is asserted. [Z-PHI]
  • Microsoft Excel (independently documented): Microsoft also documents PHI(x) as standard-normal density. This is evidence of a similar published interface, not a claim that files round-trip identically, that all Excel error behavior transfers, or that Zoho uses the same numerical algorithm. [MS-PHI]
  • Google Sheets/other products: No function-equivalence claim is made without a directly checked vendor reference. Even when formulas have familiar names, cross-platform availability, separators and precision must be tested for the target product.

NORMSDIST obtains left-tail cumulative probabilities: https://help.zoho.com/portal/en/kb/sheet/functions/statistical/articles/normsdist. NORMDIST supports arbitrary mean and standard deviation with density/cumulative selection: https://help.zoho.com/portal/en/kb/sheet/functions/statistical/articles/normdist. The related GAUSS reference returns area relative to the center: https://help.zoho.com/portal/en/kb/sheet/functions/statistical/articles/gauss. These are official function references, not a guarantee that every related internal website link already exists. [Z-NORMSDIST, Z-NORMDIST, Z-GAUSS]

Source and validation ledger ā€” checked October 13, 2026

Syntax and claims checked against accessible official help. No native Zoho Sheet formula execution, user-account/version/locale validation, screenshots or deployment is claimed.