[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/06\/Cumulative-Normal-Standard-Distribution-Function.png” alt=”NORMSDIST Formula” title_text=”normsdist-formula” align=”center” _builder_version=”4.23.1″ hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n
Now, if we were to know the value of the standard normal cumulative distribution function against the normally distributed variable (x), we can use the\u00a0<\/span>NORMSDIST<\/a>\u00a0formula in Google Sheets.<\/span><\/p>\n <\/p>\n NORMSDIST(x)<\/strong><\/p>\n The formula has one of the simplest syntaxes in all of Google Sheets. All it takes is the value of one single parameter, and it returns the value of the\u00a0standard normal cumulative distribution function corresponding to that input value.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n Now that we learned the syntax, let us practically apply the formula in Google Sheets application. And we may compare the graph with that of the output values. Please have a look at the following snapshot.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/06\/NORMSDIST-formula-Illustration-Frame-1.png” alt=”NORMSDIST Formula: Usage” title_text=”normsdist-formula-usage” _builder_version=”4.16″ global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n Like most other Google Sheets formulas, the NORMSDIST formula also is capable of accepting direct numeric values. And also references to the cells consisting of these numeric values. The first example has an input that is a direct numeric value. Whereas all other examples have cell references for its input.<\/p>\n Now let\u2019s\u00a0observe the output values the formula returned. If we made a quick comparison of the output values against those in the graph, it certainly looks the same. We can get a little creative and try to plot these output values on a graph using Google Sheets charts. And here\u2019s how it looks like.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/06\/NORMSDIST-formula-Illustration-Frame-2.webp” alt=”NORMSDIST Formula in Google Sheets” title_text=”normsdist-in-google-sheets” _builder_version=”4.16″ global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}”]<\/p>\n Without a doubt, it does resemble the red curve graph shown in the very first image.<\/p>\n This is how you use the NORMSDIST formula in Google Sheets. Note that\u00a0there is also a way to do the opposite. That is to find the value of the distributed variable, given the value of the distribution itself. The\u00a0<\/span>NORMSINV formula in Google Sheets<\/a>helps us achieve this calculation.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" In this post, learn how to calculate the normal cumulative distribution by using the\u00a0NORMSDIST formula\u00a0in Google Sheets. The\u00a0normal cumulative distribution\u00a0is one of the most widely used probability distributions in statistics. We can derive a specialized case of normal cumulative distribution when mean is zero and the variance is 1. This is called the standard normal […]<\/p>\n","protected":false},"author":40,"featured_media":8818,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"The normal cumulative distribution<\/a> is one of the most widely used probability distributions in statistics. We can derive a specialized case of normal cumulative distribution when mean is zero and the variance is 1. This is called the standard normal cumulative distribution function. Here's how the function looks like when we plot it on the graph - the red curve is what we have been talking about.\n\n[caption id=\"attachment_8820\" align=\"aligncenter\" width=\"720\"]Syntax<\/h3>\n
\n
Usage: NORMSDIST formula in Google Sheets<\/h3>\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/06\/Cumulative-Normal-Standard-Distribution-Function.png\")
Cumulative Normal Standard Distribution Function [Image Source: Wikipedia][\/caption]Now, if we were to know the value of the standard normal cumulative distribution function against the normally distributed variable (x), we can use the NORMSDIST<\/a> formula in Google Sheets.\nSyntax<\/h3>\nNORMSDIST(x)<\/strong>\n
\n \t
Usage: NORMSDIST formula in Google Sheets<\/h3>\nNow that we learned the syntax, let us practically apply the formula in Google Sheets application. And we may compare the graph with that of the output values. Please have a look at the following snapshot.\n\n
![\"NORMSDIST](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/06\/NORMSDIST-formula-Illustration-Frame-1.png\")
\n\nLike most other Google Sheets formulas, the NORMSDIST formula also is capable of accepting direct numeric values. And also references to the cells consisting of these numeric values. The first example has an input that is a direct numeric value. Whereas all other examples have cell references for its input.\n\nNow let's observe the output values the formula returned. If we made a quick comparison of the output values against those in the graph, it certainly looks the same. We can get a little creative and try to plot these output values on a graph using Google Sheets charts. And here's how it looks like.\n\n![\"NORMSDIST](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/06\/NORMSDIST-formula-Illustration-Frame-2.webp\")
\n\nWithout a doubt, it does resemble the red curve graph shown in the very first image.","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-8769","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/8769","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=8769"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/8769\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/8818"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=8769"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=8769"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=8769"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}