Syntax<\/h3>\n
NORMSINV(x)<\/strong><\/p>\n Similar to the NORMSDIST formula, this also has got one of the most straightforward syntaxes in all of the Google Sheets functions. All we need to do is specify the value or cell reference of one single parameter. And it returns the value of the inverse standard normal distribution function for that specified value.<\/p>\n Please note that the input values should be within the confines of 0 and 1 (both not included). Otherwise, the formula returns a #NUM! error.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n While the syntax helps us to some extent, applying it practically and seeing how it behaves gives us more perspective and insights. So, let us dive right into it with a few examples created on the Google Sheets application. Please have a look at the below image.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/06\/NORMSINV-formula-Illustration-Frame-1.png” alt=”NORMSINV Formula in Google Sheets: Usage” title_text=”normsinv-formula-usage” _builder_version=”4.16″ width=”640px” max_width=”640px” height=”440px” max_height=”440px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Like most other Google Sheets formulas, the NORMSINV 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 can quickly make a chart out of these input and output values, here\u2019s how it looks like.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/06\/NORMSINV-formula-Illustration-Frame-2.webp” alt=”NORMSINV Formula in Google Sheets” title_text=”normsinv-google-sheets” _builder_version=”4.16″ width=”640px” max_width=”640px” height=”440px” max_height=”440px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n If we compared the\u00a0<\/span>standard normal cumulative distribution function<\/a>\u00a0with the graph that we just created, it certainly looks like an inverse!<\/span><\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" We are aware of the important role, the\u00a0normal cumulative distribution\u00a0plays in the field of 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. In\u00a0this post, we discussed how to calculate the value of this distribution […]<\/p>\n","protected":false},"author":40,"featured_media":8819,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"We are aware of the important role, the\u00a0normal cumulative distribution<\/a>\u00a0plays in the field of 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. In this post<\/a>, we discussed how to calculate the value of this distribution function, at a specified\u00a0distributed variable (x). But there 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 NORMSINV formula in Google Sheets helps us achieve this calculation\n\n
Usage: NORMSINV formula in Google Sheets<\/h3>\n
Syntax<\/h3>\nNORMSINV(x)<\/strong>\n
\n \t
Usage: NORMSINV formula in Google Sheets<\/h3>\nWhile the syntax helps us to some extent, applying it practically and seeing how it behaves gives us more perspective and insights. So, let us dive right into it with a few examples created on the Google Sheets application. Please have a look at the below image.\n\n
![\"NORMSINV](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/06\/NORMSINV-formula-Illustration-Frame-1.png\")
\n\nLike most other Google Sheets formulas, the NORMSINV 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\u00a0observe the output values the formula returned. If we can quickly make a chart out of these input and output values, here's how it looks like.\n\n![\"NORMSINV](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/06\/NORMSINV-formula-Illustration-Frame-2.webp\")
\n\nIf we compared the\u00a0standard normal cumulative distribution function<\/a> with the graph that we just created, it certainly looks like an inverse!","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-8772","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\/fr\/wp-json\/wp\/v2\/posts\/8772","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=8772"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/8772\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/8819"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=8772"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=8772"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=8772"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![standard normal cumulative distribution function<\/a> with the graph that we just created, it certainly looks like an inverse!","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-8772","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\/fr\/wp-json\/wp\/v2\/posts\/8772","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=8772"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/8772\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/8819"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=8772"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=8772"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=8772"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}](\"https:\/\/en.wikipedia.org\/wiki\/File:Normal_Distribution_CDF.svg\"){kind=link}