{"id":332,"date":"2025-07-15T13:34:46","date_gmt":"2025-07-15T13:34:46","guid":{"rendered":"https:\/\/functiontranslator.com\/2021\/02\/12\/norm-s-dist\/"},"modified":"2021-02-13T11:35:39","modified_gmt":"2021-02-13T11:35:39","slug":"norm-s-dist","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/en\/norm-s-dist\/","title":{"rendered":"NORM.S.DIST"},"content":{"rendered":"

Welcome to the comprehensive guide on using the NORM.S.DIST function in Microsoft Excel and Google Sheets. This function is essential for calculating the standard normal distribution, commonly used in statistics and probability calculations. It allows users to determine how data is distributed around the mean in a symmetrical, bell-shaped curve. In this guide, we’ll explore the specifics of the function and demonstrate how to use it in your spreadsheet tasks effectively.<\/p>\n

Function Overview:<\/h2>\n

The NORM.S.DIST function provides the standard normal distribution value corresponding to a specific z-score. Here is the syntax of the function:<\/p>\n

=NORM.S.DIST(z, cumulative)<\/code><\/pre>\n
    \n
  • z<\/code>: The z-score for which the standard normal distribution is desired.<\/li>\n
  • cumulative<\/code>: A logical value that specifies the function mode:\n
      \n
    • cumulative = TRUE<\/code> returns the cumulative distribution function, representing the probability that a random variable with a standard normal distribution is less than or equal to z.<\/li>\n
    • cumulative = FALSE<\/code> returns the probability density function, which describes the relative likelihood for this random variable to take on a given value.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
      Usage in Excel:<\/h2>\n
      The NORM.S.DIST function can be effectively utilized in Excel to compute values based on the standard normal distribution. Below are a couple of examples to illustrate its usage:<\/p>\n\n\n\n\n
      Z-Score (z)<\/th>\nCumulative (TRUE\/FALSE)<\/th>\nStandard Normal Distribution<\/th>\n<\/tr>\n
      1.96<\/td>\nTRUE<\/td>\n=NORM.S.DIST(1.96, TRUE)<\/td>\n<\/tr>\n
      -0.5<\/td>\nFALSE<\/td>\n=NORM.S.DIST(-0.5, FALSE)<\/td>\n<\/tr>\n<\/table>\n
      The first example calculates the cumulative standard normal distribution for a z-score of 1.96, which is useful in statistics, such as when determining confidence intervals. The second example computes the probability density function for a z-score of -0.5.<\/p>\n
      Usage in Google Sheets:<\/h2>\n
      Google Sheets supports the NORM.S.DIST function in the same way as Excel, enabling users to perform similar standard normal distribution calculations:<\/p>\n\n\n\n\n
      Z-Score (z)<\/th>\nCumulative (TRUE\/FALSE)<\/th>\nStandard Normal Distribution<\/th>\n<\/tr>\n
      2.5<\/td>\nTRUE<\/td>\n=NORM.S.DIST(2.5, TRUE)<\/td>\n<\/tr>\n
      0<\/td>\nFALSE<\/td>\n=NORM.S.DIST(0, FALSE)<\/td>\n<\/tr>\n<\/table>\n
      For example, the first formula calculates the cumulative value for a z-score of 2.5, often used in probability calculations. The second formula provides the probability density at a z-score of 0, the peak of the bell curve.<\/p>\n
      By mastering the NORM.S.DIST function in both Excel and Google Sheets, you can enhance your ability to analyze statistical data and perform detailed probability assessments based on the standard normal distribution.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Returns the standard normal cumulative distribution<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[203],"tags":[],"class_list":["post-332","post","type-post","status-publish","format-standard","hentry","category-statistical"],"acf":[],"yoast_head":"\nExcel NORM.S.DIST Function \u2013 How It Works, Formula Examples and Syntax<\/title>\n<meta name=\"description\" content=\"Learn what the Excel NORM.S.DIST function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/en\/norm-s-dist\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel NORM.S.DIST Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta property=\"og:description\" content=\"Learn what the Excel NORM.S.DIST function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/en\/norm-s-dist\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-13T11:35:39+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel NORM.S.DIST Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/en\/norm-s-dist\/\",\"url\":\"https:\/\/functiontranslator.com\/en\/norm-s-dist\/\",\"name\":\"Excel NORM.S.DIST Function \u2013 How It Works, Formula Examples and Syntax\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:46+00:00\",\"dateModified\":\"2021-02-13T11:35:39+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Learn what the Excel NORM.S.DIST function does. Clear syntax explanation and useful formula examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/en\/norm-s-dist\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/en\/norm-s-dist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/en\/norm-s-dist\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Function Excel\",\"item\":\"https:\/\/functiontranslator.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Statistical\",\"item\":\"https:\/\/functiontranslator.com\/en\/statistical\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"NORM.S.DIST\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/en\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel NORM.S.DIST Function \u2013 How It Works, Formula Examples and Syntax","description":"Learn what the Excel NORM.S.DIST function does. Clear syntax explanation and useful formula examples.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/en\/norm-s-dist\/","og_locale":"en_US","og_type":"article","og_title":"Excel NORM.S.DIST Function \u2013 How It Works, Formula Examples and Syntax","og_description":"Learn what the Excel NORM.S.DIST function does. Clear syntax explanation and useful formula examples.","og_url":"https:\/\/functiontranslator.com\/en\/norm-s-dist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:46+00:00","article_modified_time":"2021-02-13T11:35:39+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel NORM.S.DIST Function \u2013 How It Works, Formula Examples and Syntax","twitter_misc":{"Written by":"glavadmin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/en\/norm-s-dist\/","url":"https:\/\/functiontranslator.com\/en\/norm-s-dist\/","name":"Excel NORM.S.DIST Function \u2013 How It Works, Formula Examples and Syntax","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:46+00:00","dateModified":"2021-02-13T11:35:39+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Learn what the Excel NORM.S.DIST function does. Clear syntax explanation and useful formula examples.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/en\/norm-s-dist\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/en\/norm-s-dist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/en\/norm-s-dist\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Function Excel","item":"https:\/\/functiontranslator.com\/en\/"},{"@type":"ListItem","position":2,"name":"Statistical","item":"https:\/\/functiontranslator.com\/en\/statistical\/"},{"@type":"ListItem","position":3,"name":"NORM.S.DIST"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/en\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/332","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/comments?post=332"}],"version-history":[{"count":3,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/332\/revisions"}],"predecessor-version":[{"id":3223,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/332\/revisions\/3223"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/media?parent=332"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/categories?post=332"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/tags?post=332"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}