Zoho Sheet STANDARDIZE: Z-Scores, Examples and Quality Checks

Use STANDARDIZE to convert one numeric value into a z-score relative to a specified mean and standard deviation. The score tells you how many standard deviations the value is above or below the chosen baseline. For example, =STANDARDIZE(42;40;1.5) has an independently calculated expected result of 1.333333333, because (42 − 40) / 1.5 = 1.333333333.... Official Zoho STANDARDIZE help, checked 2026-10-12.

A result of zero means the observation equals the supplied mean. A positive result means above it; a negative result means below it. This function does not compute the mean or standard deviation for you—you must provide those numbers or formulas that calculate them. A z-score is a descriptive normalization, not proof that an observation is erroneous or normally distributed.

Evidence statement: The formulas and argument order are supported by Zoho documentation. The expected outputs below are verified with independent mathematical calculations, not by opening Zoho Sheet or capturing screenshots.

Zoho’s English function reference prints:

STANDARDIZE(n; μ; σ)

The formula uses three required arguments and Zoho’s reference does not specify a default for any. The Greek letters are explanatory placeholders from the official syntax; you should enter your numeric values or cell references, not the letters unless your workbook has explicitly defined compatible named values. Semicolons are shown because that is the delimiter in the English Zoho reference; check a workbook’s language and locale before copying Excel or Google Sheets formulas that use commas. Source Z1.

The mathematical calculation is:

z = (n - mean) / standard_deviation

The numerator is the distance from the baseline average in the input’s units. Dividing by the baseline standard deviation converts it to a unit-free score, which can be compared across datasets that have different scales. A score of 1.5 has the same standardized distance meaning whether the original measurement is in minutes, dollars or temperature units, provided the baseline definition is appropriate.

Make a quick three-cell practice table: enter 42 in A2, 40 in A3, and 1.5 in A4. Put this formula in B2:

=STANDARDIZE(A2;A3;A4)

Expected numeric result: 1.333333333. First calculate 42 − 40 = 2. Then divide 2 / 1.5. The input 42 is approximately 1.33 standard deviations higher than the mean 40. The equivalent direct formula =STANDARDIZE(42;40;1.5) should express the same calculation if the function operates as documented. Zoho’s published examples independently include =STANDARDIZE(A2;B2;C2) with result 4.5, though the reference page does not reproduce every embedded input value in ordinary page text. Source Z1.

Suppose five completed orders took 10, 12, 14, 16 and 18 minutes. Use a clean sheet and type Minutes in B1; enter 10 in B2, 12 in B3, 14 in B4, 16 in B5 and 18 in B6. The following calculation uses a sample standard deviation, so it is a demonstration of standardizing relative to a five-observation sample, not automatically a complete-population estimate.

1. In D2 type Mean and in E2 enter =AVERAGE(B2:B6). The expected result is 14.
2. In D3 type Sample standard deviation and in E3 enter =STDEV(B2:B6). Its independently calculated expected result is 3.162277660. The sum of squared deviations is 40, and the sample variance is 40/(5−1)=10, so its square root is √10.
3. In C1 type Z-score, and in C2 enter =STANDARDIZE(B2;$E$2;$E$3). The dollar signs keep the baseline cells fixed when the formula is copied down.
4. Fill the formula from C2 through C6. Compare your sheet to the mathematical reference below. If your application returns different numbers, investigate the range, cell types, rounding, locale or calculation mode before assuming the documentation is wrong.

For B6, the check is (18−14)/√10 = 1.264911064.... The values are symmetric in this deliberately simple dataset. Most real business metrics will not be perfectly symmetric, and that is not a calculation error. Zoho AVERAGE, Zoho STDEV, checked 2026-10-12.

Sample or population? Keep the baseline definition consistent

STDEV is documented by Zoho as the sample standard deviation. If your five observations truly constitute the entire defined population rather than a sample, the mathematically corresponding population standard deviation is √8 = 2.828427125. Under that definition the value 18 standardizes to (18−14)/√8 = 1.414213562 instead of 1.264911064. You cannot compare these values as if the baseline formulas were identical. Zoho separately documents STDEVP for a full population; consult its official reference and verify mixed-data details before selecting it for a real workbook. Zoho STDEV; Zoho STDEVP official catalogue, checked 2026-10-12.

The choice of sample or population is a business-definition decision. A full week’s recorded orders may be a complete population for that week but a sample of the process over a year. Write the chosen period, unit and baseline method next to the dashboard so a later reader does not mistake a relative ranking for an absolute quality target.

The earlier example normalizes historical observations using a baseline calculated from those same observations. In operational monitoring, you often need to evaluate a new order without letting it change the baseline used for evaluation.

Keep B2:B6 as the historical baseline and its E2=14 and E3≈3.162277660 results. Enter a new value of 25 minutes in B7. In C7, enter:

=STANDARDIZE(B7;$E$2;$E$3)

The independent expected result is 3.478505426 because (25−14)/√10 ≈ 3.478505426. Add this status formula to D7:

=IF(ABS(C7)>=2;"Investigate";"Within baseline range")

The expected status is Investigate. It is a selected review threshold, not a statistical finding that the order is faulty. A large z-score can reflect a longer legitimate job, a new process, a small or skewed reference sample, or an exceptional incident. Check original facts before acting. Zoho IF and Zoho ABS, both checked 2026-10-12.

Important: Do not change the E2 and E3 formulas to include B7 if the goal is to evaluate B7 against the original fixed baseline; doing so would change the comparison frame. For a rolling-reference dashboard, make the recalculation deliberate and display the baseline date and sample size. This distinction is more important than the choice of color on an alert cell.

• #NUM! with zero or negative sigma: The Zoho help explicitly says σ ≤ 0 causes #NUM!. Example: =STANDARDIZE(12;12;0) requests division by zero and must not be interpreted as a z-score of zero. Fix the baseline or choose a metric for which variation exists. Source Z1.
• #NAME!: Check STANDARDIZE spelling and whether you’ve entered literal Greek letters rather than numeric arguments. Zoho lists incorrect function names and invalid defined names among common causes. The reference documentation uses Greek letters only to describe arguments, not as predefined variables. Source Z1.
• #VALUE! or an odd result: Examine whether the value, mean and sigma are truly numeric, especially if pasted from a web report or imported as text. Zoho’s reference contains a generic invalid-argument type error; it does not enumerate every mixed-type coercion pathway, so do not make an unsupported promise about numeric text conversion. Source Z1.
• #REF!: A missing or moved mean/sigma cell can break the formula. Verify your absolute references, ranges, and any named ranges. Zoho documents #REF! for invalid references. Source Z1.
• Incorrect baseline: Standardizing a price against a processing-time mean is meaningless even if it returns a number. Confirm matching units, matched observations and the intended measurement period.
• Population-versus-sample confusion: A z-score is relative to whatever sigma you give it. Use the appropriate standard-deviation definition, and disclose it in the report. Do not use an unexplained combination of different populations.
• Non-normal data: STANDARDIZE can calculate a standardized score even if measurements are skewed; a z-score by itself does not make the observations normally distributed or establish a p-value. Outlier thresholds require context, not just a conventional number.
• Rounding: Displaying 1.26 is a formatting choice; keep underlying calculation precision for subsequent steps. Avoid comparing only rounded display strings.
• Missing native evidence: The official reference does not describe all blank-cell and error-propagation cases. Validate them explicitly in the intended Zoho edition instead of extrapolating from Microsoft Excel or Google Sheets.

The underlying arithmetic formula is the same mathematical standardization described by all three vendors, but vendor evidence is separate:

Sources: Zoho Z1, Microsoft E1, Google G1, checked 2026-10-12. Do not infer identical treatment of text/blank/error cells, platform rollouts or formula separators. Excel’s supported-version list is about Excel, not a first-supported Zoho release. A Google locale may translate a function name or delimiter; check the target editor before pasting formulas wholesale.

Zoho availability and edition notes

The canonical Zoho function page does not give a first-supported version, a universal account-plan requirement or a specific minimum desktop build. Zoho’s desktop beta announcement says the Windows and macOS applications support many built-in functions while other web capabilities remain under development. That announcement is not proof that STANDARDIZE and every example here operate identically in all desktop builds or accounts. Review the actual target edition and locale before making a compatibility claim. Zoho desktop beta announcement, checked 2026-10-12.

• Zoho STANDARDIZE (Z1) — direct official syntax, sample results and error table, checked 2026-10-12.
• Zoho AVERAGE — source of a baseline mean, checked 2026-10-12.
• Zoho STDEV — sample standard deviation for a reference dataset, checked 2026-10-12.
• Zoho ABS and IF — absolute-value check and conditional alert, checked 2026-10-12.
• Excel STANDARDIZE (E1) — Excel-specific syntax and nonpositive-sigma error, checked 2026-10-12.
• Google Sheets STANDARDIZE (G1) — Sheets-specific syntax and mean/sigma advice, checked 2026-10-12.

Validation: Official-reference research and independent mathematical calculations completed. Native Zoho executions and screenshots: 0. Edition parity, locale and cell coercion remain unverified.