NORMSDIST function

PRO

The NORMSDIST function in Jspreadsheet Formulas Pro is used to return the standard normal cumulative distribution function. In simpler terms, it calculates the probability that a random variable with a standard normal distribution (mean of 0 and standard deviation of 1) is less than or equal to a specified value. This function is commonly used in statistical analysis and predictions. Hence, it's a useful tool for data analysis and interpretation in Jspreadsheet Formulas Pro.

Documentation

Returns the standard normal cumulative distribution function.

Syntax

NORMSDIST(z)

Parameter	Description
`z`	The value for which you want the distribution.

Behavior

The NORMSDIST function calculates the standard Normal cumulative distribution (also known as the Gaussian distribution) for a supplied value. It is predominantly used in statistics, probability and data analysis.

It expects a single numerical value as input. This number represents the value for which you want to calculate the distribution.
The function does not handle empty cells; it requires a valid numerical input to execute.
If a text string is supplied instead of a number, the function will return a #VALUE! error.
If a boolean value is supplied, it will be treated as 0 for FALSE and 1 for TRUE.

Common Errors

Error	Description
#VALUE!	This error occurs if the provided argument is non-numeric or if the provided argument is a text string.

Best practices

Always ensure that the input value is a valid numerical value to avoid any errors.

Remember that NORMSDIST function assumes a mean of 0 and a standard deviation of 1.

Use the NORMSDIST function when you need to understand the probability of a particular outcome, especially in data analysis and forecasting.

Be aware that NORMSDIST function is not suitable for datasets that do not follow a normal distribution. In such cases, other statistical functions might be more appropriate.

Usage

A few examples using the NORMSDIST function.

NORMSDIST(-1.96) → 0.025 (probability that Z ≤ -1.96)  
NORMSDIST(0) → 0.5 (probability that Z ≤ 0)  
NORMSDIST(1.64) → 0.9495 (probability that Z ≤ 1.64)  
NORMSDIST(2) → 0.97725 (probability that Z ≤ 2)

Interactive Spreadsheet Demo

<html>
<script src="https://jspreadsheet.com/v11/jspreadsheet.js"></script>
<script src="https://jsuites.net/v5/jsuites.js"></script>
<link rel="stylesheet" href="https://jsuites.net/v5/jsuites.css" type="text/css" />
<link rel="stylesheet" href="https://jspreadsheet.com/v11/jspreadsheet.css" type="text/css" />

<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Material+Icons" />
<script src="https://cdn.jsdelivr.net/npm/@jspreadsheet/formula-pro/dist/index.min.js"></script>

<div id="spreadsheet"></div>

<script>
// Set your JSS license key (The following key only works for one day)
jspreadsheet.setLicense('OTgxMTFkODY3NGU4NTIyNjFhYWRiOTg1Nzg1OTAwZmVkNzQyZTczOWEwMGE0Y2NmMTE0MmQ0MDhjNDFkOTljYTMyMmU0ZmVhYTIxYjcwNTYyY2FlNGVhNTU3ZDcxMjhkMmIyZmY5ZWQ2NDE2MjRhMjk0ZDU1ODQzMTlhY2M1NWQsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE9UVTBNalU0TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
  worksheets: [{
    data: [
    [
        "Z-Score",
        "Probability"
    ],
    [
        -1.96,
        "=NORMSDIST(A2)"
    ],
    [
        0,
        "=NORMSDIST(A3)"
    ],
    [
        1.64,
        "=NORMSDIST(A4)"
    ],
    [
        2.33,
        "=NORMSDIST(A5)"
    ]
]
  }]
});
</script>
</html>

import React, { useRef } from "react";
import { Spreadsheet, Worksheet, jspreadsheet } from "@jspreadsheet/react";
import formula from "@jspreadsheet/formula-pro";
import "jsuites/dist/jsuites.css";
import "jspreadsheet/dist/jspreadsheet.css";

// Set license
jspreadsheet.setLicense('OTgxMTFkODY3NGU4NTIyNjFhYWRiOTg1Nzg1OTAwZmVkNzQyZTczOWEwMGE0Y2NmMTE0MmQ0MDhjNDFkOTljYTMyMmU0ZmVhYTIxYjcwNTYyY2FlNGVhNTU3ZDcxMjhkMmIyZmY5ZWQ2NDE2MjRhMjk0ZDU1ODQzMTlhY2M1NWQsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE9UVTBNalU0TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

export default function App() {
    // Spreadsheet array of worksheets
    const spreadsheet = useRef();

    // Worksheet data
    const data = [
    [
        "Z-Score",
        "Probability"
    ],
    [
        -1.96,
        "=NORMSDIST(A2)"
    ],
    [
        0,
        "=NORMSDIST(A3)"
    ],
    [
        1.64,
        "=NORMSDIST(A4)"
    ],
    [
        2.33,
        "=NORMSDIST(A5)"
    ]
];

    // Render component
    return (
        <Spreadsheet ref={spreadsheet}>
            <Worksheet data={data} />
        </Spreadsheet>
    );
}

<template>
    <Spreadsheet ref="spreadsheet">
        <Worksheet :data="data" />
    </Spreadsheet>
</template>

<script>
import { Spreadsheet, Worksheet, jspreadsheet } from "@jspreadsheet/vue";
import "jsuites/dist/jsuites.css";
import "jspreadsheet/dist/jspreadsheet.css";
import formula from "@jspreadsheet/formula-pro";

// Set license
jspreadsheet.setLicense('OTgxMTFkODY3NGU4NTIyNjFhYWRiOTg1Nzg1OTAwZmVkNzQyZTczOWEwMGE0Y2NmMTE0MmQ0MDhjNDFkOTljYTMyMmU0ZmVhYTIxYjcwNTYyY2FlNGVhNTU3ZDcxMjhkMmIyZmY5ZWQ2NDE2MjRhMjk0ZDU1ODQzMTlhY2M1NWQsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE9UVTBNalU0TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

export default {
    components: {
        Spreadsheet,
        Worksheet,
    },
    data() {
        // Worksheet data
        const data = [
    [
        "Z-Score",
        "Probability"
    ],
    [
        -1.96,
        "=NORMSDIST(A2)"
    ],
    [
        0,
        "=NORMSDIST(A3)"
    ],
    [
        1.64,
        "=NORMSDIST(A4)"
    ],
    [
        2.33,
        "=NORMSDIST(A5)"
    ]
]

        return {
            data
        };
    }
}
</script>

import { Component, ViewChild, ElementRef } from "@angular/core";
import jspreadsheet from "jspreadsheet";
import * as formula from "@jspreadsheet/formula-pro";

// Set your JSS license key (The following key only works for one day)
jspreadsheet.setLicense('OTgxMTFkODY3NGU4NTIyNjFhYWRiOTg1Nzg1OTAwZmVkNzQyZTczOWEwMGE0Y2NmMTE0MmQ0MDhjNDFkOTljYTMyMmU0ZmVhYTIxYjcwNTYyY2FlNGVhNTU3ZDcxMjhkMmIyZmY5ZWQ2NDE2MjRhMjk0ZDU1ODQzMTlhY2M1NWQsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE9UVTBNalU0TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

@Component({
    standalone: true,
    selector: "app-root",
    template: `<div #spreadsheet></div>`
})
export class AppComponent {
    @ViewChild("spreadsheet") spreadsheet: ElementRef;
    // Worksheets
    worksheets: jspreadsheet.worksheetInstance[];

    // Create a new data grid
    ngAfterViewInit() {
        // Create spreadsheet
        this.worksheets = jspreadsheet(this.spreadsheet.nativeElement, {
            worksheets: [{
                data: [
    [
        "Z-Score",
        "Probability"
    ],
    [
        -1.96,
        "=NORMSDIST(A2)"
    ],
    [
        0,
        "=NORMSDIST(A3)"
    ],
    [
        1.64,
        "=NORMSDIST(A4)"
    ],
    [
        2.33,
        "=NORMSDIST(A5)"
    ]
]
            }]
        });
    }
}

Edit this page on GitHub