{"id":15555,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/normdag\/"},"modified":"2021-02-25T16:32:47","modified_gmt":"2021-02-25T16:32:47","slug":"normdist","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/normdist\/","title":{"rendered":"NORMDA\u011e"},"content":{"rendered":"<p>Microsoft Excel ve Google Sheets, istatistiksel analizler yapmak i\u00e7in kullan\u0131lan g\u00fc\u00e7l\u00fc ara\u00e7lard\u0131r. Bu ara\u00e7lardaki <strong>NORMDIST (NORMDA\u011e)<\/strong> fonksiyonu, belirli bir ortalama ve standart sapmaya sahip normal da\u011f\u0131l\u0131m \u00e7er\u00e7evesinde bir de\u011ferin olas\u0131l\u0131k yo\u011funlu\u011funu veya k\u00fcm\u00fclatif da\u011f\u0131l\u0131m\u0131n\u0131 hesaplamak i\u00e7in kullan\u0131l\u0131r. Bu fonksiyon \u00f6zellikle finans, m\u00fchendislik ve sosyal bilimler gibi alanlarda \u00f6nemlidir.<\/p>\n<h2>S\u00f6zdizimi ve Parametreler<\/h2>\n<ul>\n<li><strong>x:<\/strong> Olas\u0131l\u0131k da\u011f\u0131l\u0131m\u0131n\u0131n hesaplanaca\u011f\u0131 de\u011fer.<\/li>\n<li><strong>ortalama:<\/strong> Normal da\u011f\u0131l\u0131m\u0131n ortalamas\u0131.<\/li>\n<li><strong>standart_sapma:<\/strong> Normal da\u011f\u0131l\u0131m\u0131n standart sapmas\u0131.<\/li>\n<li><strong>k\u00fcm\u00fclatif:<\/strong> E\u011fer bu parametre DO\u011eRU (TRUE) de\u011fer al\u0131rsa fonksiyon k\u00fcm\u00fclatif da\u011f\u0131l\u0131m fonksiyonunu, YANLI\u015e (FALSE) ise olas\u0131l\u0131k yo\u011funluk fonksiyonunu hesaplar.<\/li>\n<\/ul>\n<p>Excel&#8217;de form\u00fcl \u015fu \u015fekilde yaz\u0131l\u0131r:<\/p>\n<pre><code>=NORMDIST(x, ortalama, standart_sapma, k\u00fcm\u00fclatif)<\/code><\/pre>\n<p>Google Sheets&#8217;te ise T\u00fcrk\u00e7e versiyon \u015fu \u015fekildedir:<\/p>\n<pre><code>=NORMDA\u011e(x, ortalama, standart_sapma, k\u00fcm\u00fclatif)<\/code><\/pre>\n<h2>\u00d6rnek Kullan\u0131m Senaryolar\u0131<\/h2>\n<p><strong>\u00d6rnek 1: Pazarlama Kampanyas\u0131 Analizi<\/strong><\/p>\n<p>Bir \u015firketin pazarlama kampanyas\u0131ndan d\u00f6n\u00fc\u015f\u00fcm sa\u011flayacak m\u00fc\u015fteri say\u0131s\u0131n\u0131 tahmin etmek \u00fczere normal da\u011f\u0131l\u0131m kullan\u0131lmas\u0131 durumunda, e\u011fer ge\u00e7mi\u015f kampanyalar ortalama 100 d\u00f6n\u00fc\u015f\u00fcm ve bu d\u00f6n\u00fc\u015f\u00fcmlerin standart sapmas\u0131 15 ise, 110 veya daha fazla d\u00f6n\u00fc\u015f\u00fcm al\u0131nma olas\u0131l\u0131\u011f\u0131n\u0131 hesaplamak gerekir.<\/p>\n<pre><code>=1 - NORMDIST(110, 100, 15, TRUE)<\/code><\/pre>\n<p>Bu form\u00fcl, 110 veya daha fazla d\u00f6n\u00fc\u015f\u00fcm elde etme olas\u0131l\u0131\u011f\u0131n\u0131 hesaplar. 1&#8217;den \u00e7\u0131karmam\u0131z, bu de\u011ferin \u00fcst\u00fcndeki alan\u0131 \u2014 yani 110 veya daha fazla d\u00f6n\u00fc\u015f\u00fcm olas\u0131l\u0131\u011f\u0131n\u0131 \u2014 bulmam\u0131z\u0131 sa\u011flar.<\/p>\n<p><strong>\u00d6rnek 2: \u00dcretim Kalite Kontrol\u00fc<\/strong><\/p>\n<p>Bir \u00fcretim hatt\u0131nda \u00fcretilen par\u00e7alar\u0131n uygunlu\u011funu de\u011ferlendirmek i\u00e7in kullan\u0131l\u0131r. E\u011fer \u00fcretilen par\u00e7alar\u0131n uzunluklar\u0131 normal da\u011f\u0131t\u0131lm\u0131\u015fsa ve ortalama uzunluk 6 cm, standart sapma 0.1 cm ise, bir par\u00e7an\u0131n 6.1 cm&#8217;den k\u0131sa olma olas\u0131l\u0131\u011f\u0131n\u0131 hesaplamak i\u00e7in:<\/p>\n<pre><code>=NORMDIST(6.1, 6, 0.1, TRUE)<\/code><\/pre>\n<p>Bu kullan\u0131m, par\u00e7an\u0131n 6.1 cm veya daha k\u0131sa olma olas\u0131l\u0131\u011f\u0131n\u0131 verir ve bu de\u011fer, kalite kontrol s\u00fcre\u00e7lerinde kritik \u00f6neme sahiptir.<\/p>\n<p>Bu \u00f6rnekler, <strong>NORMDIST\/NORMDA\u011e<\/strong> fonksiyonunun ger\u00e7ek d\u00fcnya problemlerine nas\u0131l uygulanabilece\u011fini g\u00f6stermektedir. Finansal analizlerden \u00fcretim kontrollerine kadar bir\u00e7ok farkl\u0131 alanda bu fonksiyonun kullan\u0131m\u0131 m\u00fcmk\u00fcnd\u00fcr.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Normal k\u00fcm\u00fclatif da\u011f\u0131l\u0131m\u0131 verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[584],"tags":[],"class_list":["post-15555","post","type-post","status-publish","format-standard","hentry","category-uyumluluk"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de NORMDIST (NORMDA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da NORMDIST (NORMDA\u011e) 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\/normdist\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de NORMDIST (NORMDA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da NORMDIST (NORMDA\u011e) 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\/normdist\/\" \/>\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:47+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel&#039;de NORMDIST (NORMDA\u011e) 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\/normdist\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/normdist\/\",\"name\":\"Excel'de NORMDIST (NORMDA\u011e) 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:47+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da NORMDIST (NORMDA\u011e) 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\/normdist\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/normdist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/normdist\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Uyumluluk\",\"item\":\"https:\/\/functiontranslator.com\/tr\/uyumluluk\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"NORMDA\u011e\"}]},{\"@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 NORMDIST (NORMDA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da NORMDIST (NORMDA\u011e) 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\/normdist\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de NORMDIST (NORMDA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da NORMDIST (NORMDA\u011e) 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\/normdist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:32:47+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de NORMDIST (NORMDA\u011e) 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\/normdist\/","url":"https:\/\/functiontranslator.com\/tr\/normdist\/","name":"Excel'de NORMDIST (NORMDA\u011e) 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:47+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da NORMDIST (NORMDA\u011e) 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\/normdist\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/normdist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/normdist\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Uyumluluk","item":"https:\/\/functiontranslator.com\/tr\/uyumluluk\/"},{"@type":"ListItem","position":3,"name":"NORMDA\u011e"}]},{"@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\/15555","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=15555"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15555\/revisions"}],"predecessor-version":[{"id":26823,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15555\/revisions\/26823"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15555"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15555"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15555"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}