{"id":15556,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/normters\/"},"modified":"2021-02-25T16:32:49","modified_gmt":"2021-02-25T16:32:49","slug":"norminv","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/norminv\/","title":{"rendered":"NORMTERS"},"content":{"rendered":"

Microsoft Excel ve Google Sheets’teki NORMINV<\/strong> (Excel’de) ve NORM.TERS<\/strong> (Google Sheets ve Excel’in daha yeni s\u00fcr\u00fcmlerinde) fonksiyonu, belirli bir y\u00fczdelik de\u011fere kar\u015f\u0131l\u0131k gelen normal da\u011f\u0131l\u0131m de\u011ferini hesaplamak i\u00e7in kullan\u0131l\u0131r. Finansal analizler, istatistiksel analizler ve m\u00fchendislik hesaplamalar\u0131 gibi alanlarda olduk\u00e7a kullan\u0131\u015fl\u0131d\u0131r.<\/p>\n

Fonksiyonun S\u00f6zdizimi ve \u00d6rnekleri<\/h2>\n

NORMINV<\/strong> ve NORM.TERS<\/strong> fonksiyonunun s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

=NORMINV(olas\u0131l\u0131k, ortalama, standart_sapma)<\/code><\/pre>\n
\u0130\u015fte her bir parametrenin a\u00e7\u0131klamas\u0131:<\/p>\n
    \n
  • olas\u0131l\u0131k<\/strong>: Normal da\u011f\u0131l\u0131m e\u011frisi alt\u0131ndaki alan\u0131n y\u00fczdesi. Bu de\u011fer 0 ile 1 aras\u0131nda (dahil) olmal\u0131d\u0131r.<\/li>\n
  • ortalama<\/strong>: Normal da\u011f\u0131l\u0131m\u0131n ortalamas\u0131.<\/li>\n
  • standart_sapma<\/strong>: Da\u011f\u0131l\u0131m\u0131n standart sapmas\u0131. Bu de\u011fer pozitif olmal\u0131d\u0131r.<\/li>\n<\/ul>\n
    \u00d6rnek kullan\u0131m a\u015fa\u011f\u0131daki gibidir:<\/p>\n
    =NORMINV(0.95, 100, 10)<\/code><\/pre>\n
    Bu \u00f6rnekte, ortalama de\u011feri 100 ve standart sapmas\u0131 10 olan normal da\u011f\u0131l\u0131mda, y\u00fczdelik de\u011feri %95 olan de\u011fer hesaplan\u0131r.<\/p>\n
    Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n
    Senaryo 1: Risk De\u011ferlendirme<\/h3>\n
    Yat\u0131r\u0131m\u0131n maksimum kay\u0131p de\u011ferinin hesaplanmas\u0131 i\u00e7in NORMINV fonksiyonu kullan\u0131labilir. \u00d6rne\u011fin, bir yat\u0131r\u0131m\u0131n y\u0131ll\u0131k getirisinin ortalama %8 ve standart sapmas\u0131 %2 oldu\u011funu varsayal\u0131m. Bir yat\u0131r\u0131mc\u0131, en k\u00f6t\u00fc %5’lik olas\u0131l\u0131k i\u00e7in y\u0131ll\u0131k getiri beklentisini hesaplamak istiyor:<\/p>\n
    =NORMINV(0.05, 8, 2)<\/code><\/pre>\n
    Bu hesaplama, y\u0131ll\u0131k getirinin en k\u00f6t\u00fc %5 durumunda yakla\u015f\u0131k %4.2 olaca\u011f\u0131n\u0131 \u00f6ng\u00f6r\u00fcr.<\/p>\n
    Senaryo 2: \u00dcr\u00fcn Kalite Kontrol\u00fc<\/h3>\n
    \u00dcretim s\u00fcrecinde, \u00fcr\u00fcnlerin belirli bir kalite standard\u0131n\u0131n \u00fczerinde olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in kullan\u0131l\u0131r. Diyelim ki, bir \u00fcretim s\u00fcrecinin ortalama \u00f6l\u00e7\u00fcs\u00fc 100 ve standart sapmas\u0131 15. \u00dcr\u00fcnlerin %90’\u0131n\u0131n bu \u00f6l\u00e7\u00fcn\u00fcn alt\u0131nda kalmas\u0131 gerekti\u011fini belirlemek istiyoruz:<\/p>\n
    =NORMINV(0.90, 100, 15)<\/code><\/pre>\n
    Bu hesaplama, \u00fcr\u00fcnlerin %90’\u0131n\u0131n 117.1 veya daha d\u00fc\u015f\u00fck bir \u00f6l\u00e7\u00fcde olaca\u011f\u0131n\u0131 g\u00f6sterir, bu da kalite kontrol s\u00fcrecinde \u00f6nemli bir rehber olu\u015fturur.<\/p>\n
    Yukar\u0131da sunulan \u00f6rnekler, NORMINV ve NORM.TERS fonksiyonlar\u0131n\u0131n nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 ve \u00e7e\u015fitli uygulama senaryolar\u0131nda hangi de\u011ferleri sa\u011flayabilece\u011fini g\u00f6stermektedir. Bununla birlikte, kullan\u0131c\u0131lar\u0131n bu fonksiyonlar\u0131n dayand\u0131\u011f\u0131 normal da\u011f\u0131l\u0131m varsay\u0131m\u0131n\u0131n verilerini do\u011fru bir \u015fekilde temsil etti\u011finden emin olmalar\u0131 \u00f6nemlidir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Normal k\u00fcm\u00fclatif da\u011f\u0131l\u0131m\u0131n tersini verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[582],"tags":[],"class_list":["post-15556","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nExcel'de NORMINV (NORMTERS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da NORMINV (NORMTERS) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\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\/tr\/norminv\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de NORMINV (NORMTERS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da NORMINV (NORMTERS) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/norminv\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:32:49+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel'de NORMINV (NORMTERS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/norminv\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/norminv\/\",\"name\":\"Excel'de NORMINV (NORMTERS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:52+00:00\",\"dateModified\":\"2021-02-25T16:32:49+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da NORMINV (NORMTERS) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/norminv\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/norminv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/norminv\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u0130statistik\",\"item\":\"https:\/\/functiontranslator.com\/tr\/istatistik\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"NORMTERS\"}]},{\"@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\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@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\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de NORMINV (NORMTERS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da NORMINV (NORMTERS) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","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\/tr\/norminv\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de NORMINV (NORMTERS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da NORMINV (NORMTERS) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/norminv\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:32:49+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de NORMINV (NORMTERS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/norminv\/","url":"https:\/\/functiontranslator.com\/tr\/norminv\/","name":"Excel'de NORMINV (NORMTERS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:52+00:00","dateModified":"2021-02-25T16:32:49+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da NORMINV (NORMTERS) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/norminv\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/norminv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/norminv\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"\u0130statistik","item":"https:\/\/functiontranslator.com\/tr\/istatistik\/"},{"@type":"ListItem","position":3,"name":"NORMTERS"}]},{"@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":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@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\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15556","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15556"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15556\/revisions"}],"predecessor-version":[{"id":26824,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15556\/revisions\/26824"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15556"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15556"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15556"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}