NORM.S.DIST in Collabora Office: Calculate Standard-Normal Areas and Density
Use Collabora NORM.S.DIST with an explicit cumulative flag, interpret z scores, and calculate interval or upper-tail areas.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =NORM.S.DIST(1;1) has independently expected result approximately 0.841344746. It gives the standard-normal area at or to the left of z=1.
Syntax and mode
=NORM.S.DIST(Number; Cumulative)
Number is the standardized evaluation point, with model mean zero and standard deviation one. Cumulative is required: zero or FALSE selects density; the dedicated help says any other value or TRUE selects the cumulative distribution. Use explicit zero or one for readable formulas.
A z score is (measurement-mean)/standard_deviation for a positive standard deviation. Enter a standardized value here, not an unscaled raw measurement merely because both are numbers.
Despite the help’s short description emphasizing the cumulative function, its syntax explicitly supports the density mode. Retain that distinction when choosing a worksheet label.
Example 1: compare area and height
Enter −1, 0, 1 in A2:A4. Put =NORM.S.DIST(A2;1) in B2 and fill down. The independently expected cumulative results are approximately 0.158655254, 0.5, 0.841344746.
Put =NORM.S.DIST(A2;0) in C2 and fill down. The density targets are approximately 0.241970725, 0.398942280, 0.241970725.
The equal densities at −1 and 1 reflect symmetry. Their cumulative values differ because left-tail area increases as the evaluation point moves right. A density is not the probability of observing exactly that z score.
Example 2: standardize a measured value
If a modeled measurement has mean 63 and standard deviation five, a measurement of 70 gives z=(70−63)/5 = 1.4. =NORM.S.DIST((70-63)/5;1) has independent target approximately 0.919243341.
The corresponding ordinary-normal call is =NORM.DIST(70;63;5;1). Both describe the same area under the same model, expressed on different scales. Passing 70 directly to NORM.S.DIST would instead evaluate seventy standard deviations above the mean.
Advanced application: combine two tails
The probability between −1 and 1 is =NORM.S.DIST(1;1)-NORM.S.DIST(-1;1), independently approximately 0.682689492.
The probability outside that central interval is one minus that result, approximately 0.317310508. By symmetry, each tail contributes approximately 0.158655254.
For a single upper tail at z=1, =1-NORM.S.DIST(1;1) targets 0.158655254. Use a clearly labeled column to distinguish one-tail and two-tail quantities; doubling a one-tail value without a symmetry justification can answer the wrong question.
Advanced application: verify a quantile
Use z approximately 1.959963985, obtained from =NORM.S.INV(0.975). A forward NORM.S.DIST calculation should target 0.975. With the symmetric negative cutoff, the central area targets 0.95.
Keep the full quantile formula in its cell. Replacing it with 1.96 is a useful rounded approximation for some contexts but changes the exact area slightly. State whether a result is exact to the model or a rounded convenience.
Errors and troubleshooting
Ensure Cumulative is present. The legacy NORMSDIST name has a different documented call shape; do not delete the dot and assume every argument remains the same. This guide concerns the exact NORM.S.DIST identity.
Extreme tails may round to zero or one in finite-precision arithmetic. Subtracting a value close to one can lose precision; the moderate worked examples avoid that regime. Native extreme-tail and invalid-input behavior were not tested.
A standardized input does not by itself prove that the source data are normally distributed. The result is conditional on the chosen standard-normal model.
Availability and verification
The exact function is documented in Collabora Office 26.04 desktop help. Its source snapshot was retrieved on 2026-10-13 and hash-verified for this guide on October 15, 2026. Desktop documentation is not proof of Online or mobile support.
First introduced release and last functioning version are unknown. No native Collabora or WPS run occurred. The numerical values are independent mathematical expectations; they do not certify application-specific numerical tolerances, error codes or every edge case. Formulas use English names and semicolon separators.
The dedicated help identifies the namespace COM.MICROSOFT.NORM.S.DIST and says this function is outside the cited OpenFormula 1.3 standard. That is a format-namespace disclosure, not evidence of identical behavior in another product. Retain the exact dotted name when checking an imported workbook.