{"id":15559,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/normsdag\/"},"modified":"2021-02-25T16:32:52","modified_gmt":"2021-02-25T16:32:52","slug":"normsdist","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/normsdist\/","title":{"rendered":"NORMSDA\u011e"},"content":{"rendered":"

Microsoft Excel ve Google Sheets’te kullan\u0131lan NORMSDIST<\/strong> (T\u00fcrk\u00e7e’de NORMSDA\u011e<\/strong> ad\u0131yla bilinir), standart normal da\u011f\u0131l\u0131m\u0131n k\u00fcm\u00fclatif da\u011f\u0131l\u0131m fonksiyonunu (CDF) hesaplamak i\u00e7in kullan\u0131l\u0131r. Standart normal da\u011f\u0131l\u0131m, ortalama (\u03bc) s\u0131f\u0131r ve standart sapma (\u03c3) bir olan \u00f6zel bir normal da\u011f\u0131l\u0131md\u0131r. Bu fonksiyon, belirli bir z de\u011ferinin alt\u0131nda kalan alan\u0131n y\u00fczdesel de\u011ferini, yani sol kuyruktaki olas\u0131l\u0131k alan\u0131n\u0131 verir.<\/p>\n

Fonksiyon S\u00f6z Diziminin Detayl\u0131 Analizi<\/h2>\n

S\u00f6z Dizimi:<\/strong> <\/p>\n

=NORMSDIST(z)<\/code><\/pre>\n
    \n
  • z<\/strong>: Z skoru olarak da bilinen, standart normal da\u011f\u0131l\u0131m alt\u0131nda k\u00fcm\u00fclatif y\u00fczdesel da\u011f\u0131l\u0131m\u0131n\u0131 hesaplamak istedi\u011finiz de\u011ferdir.<\/li>\n<\/ul>\n
    \u00d6rnek Kullan\u0131m:<\/strong> <\/p>\n
    =NORMSDIST(1.65)<\/code><\/pre>\n
      \n
    • Bu form\u00fcl, z skoru 1.65 i\u00e7in standart normal da\u011f\u0131l\u0131m alt\u0131nda yakla\u015f\u0131k olarak %95.05 k\u00fcm\u00fclatif olas\u0131l\u0131k hesaplar. Yani, z skoru 1.65 veya daha d\u00fc\u015f\u00fck bir de\u011fer elde etme olas\u0131l\u0131\u011f\u0131n\u0131 g\u00f6sterir.<\/li>\n<\/ul>\n
      Pratik Uygulamalar<\/h2>\n
      Bu fonksiyon, istatistiksel analizlerde \u00f6zellikle de\u011fer aral\u0131klar\u0131n\u0131n olas\u0131l\u0131klar\u0131n\u0131 hesaplarken b\u00fcy\u00fck \u00f6neme sahiptir. \u0130\u015fte birka\u00e7 uygulama \u00f6rne\u011fi:<\/p>\n
      \u00d6rnek 1: Y\u00fczdelik S\u0131ralama<\/h2>\n
      Bir \u00f6\u011frencinin testten ald\u0131\u011f\u0131 puan\u0131n y\u00fczdelik olarak konumunu hesaplamak i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 kullanabiliriz. Diyelim ki \u00f6\u011frenci, ortalama 100 ve standart sapma 15 olan bir testten 120 puan ald\u0131.<\/p>\n
        1. \u0130lk ad\u0131m olarak, z skorunu hesaplama: z = (X - \u03bc) \/ \u03c3 = (120 - 100) \/ 15 \u2248 1.33 2. NORMSDIST fonksiyonu ile y\u00fczdelik s\u0131ralamay\u0131 belirleme: =NORMSDIST(1.33) Bu yakla\u015f\u0131k olarak 0.9082 de\u011ferini verir, yani bu \u00f6\u011frenci \u00fcst %9.18 i\u00e7indedir. <\/code> <\/pre>\n
      \u00d6rnek 2: Kalite Kontrol<\/h2>\n
      Bir \u00fcretim s\u00fcrecinde, par\u00e7alar\u0131n \u00f6l\u00e7\u00fcmleri normal da\u011f\u0131l\u0131ml\u0131d\u0131r ve yap\u0131lan par\u00e7alar\u0131n ka\u00e7\u0131n\u0131n tolerans d\u0131\u015f\u0131nda oldu\u011funu belirlemek istiyoruz. Ortalama uzunluk 10 cm ve standart sapma 0.5 cm olsun; tolerans \u00b10.75 cm i\u00e7inde olmal\u0131d\u0131r.<\/p>\n
        1. \u0130lk ad\u0131mda, tolerans d\u0131\u015f\u0131 limitler i\u00e7in z skorlar\u0131 hesaplan\u0131r: Alt limit z skoru = (9.25 - 10) \/ 0.5 = -1.5 \u00dcst limit z skoru = (10.75 - 10) \/ 0.5 = 1.5 2. Her iki z skoru i\u00e7in NORMSDIST de\u011ferleri hesaplan\u0131r: Alt limit i\u00e7in =NORMSDIST(-1.5) \u2248 0.0668 \u00dcst limit i\u00e7in =NORMSDIST(1.5) \u2248 0.9332 3. Tolerans aral\u0131\u011f\u0131nda kalan par\u00e7alar\u0131n y\u00fczdesini belirleme: 0.9332 - 0.0668 = 0.8664 Bu, \u00fcretilen par\u00e7alar\u0131n yakla\u015f\u0131k %86.64'\u00fcn\u00fcn tolerans aral\u0131\u011f\u0131nda oldu\u011funu g\u00f6sterir. <\/code> <\/pre>\n
      Bu analizler, i\u015f s\u00fcre\u00e7lerinin daha efektif planlanmas\u0131na ve \u00fcr\u00fcn kalitesinin net bir \u015fekilde anla\u015f\u0131lmas\u0131na katk\u0131da bulunabilir.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Standart 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-15559","post","type-post","status-publish","format-standard","hentry","category-uyumluluk"],"acf":[],"yoast_head":"\nExcel'de NORMSDIST (NORMSDA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da NORMSDIST (NORMSDA\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\/normsdist\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de NORMSDIST (NORMSDA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da NORMSDIST (NORMSDA\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\/normsdist\/\" \/>\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:52+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 NORMSDIST (NORMSDA\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\/normsdist\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/normsdist\/\",\"name\":\"Excel'de NORMSDIST (NORMSDA\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:52+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da NORMSDIST (NORMSDA\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\/normsdist\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/normsdist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/normsdist\/#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\":\"NORMSDA\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 NORMSDIST (NORMSDA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da NORMSDIST (NORMSDA\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\/normsdist\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de NORMSDIST (NORMSDA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da NORMSDIST (NORMSDA\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\/normsdist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:32:52+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de NORMSDIST (NORMSDA\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\/normsdist\/","url":"https:\/\/functiontranslator.com\/tr\/normsdist\/","name":"Excel'de NORMSDIST (NORMSDA\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:52+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da NORMSDIST (NORMSDA\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\/normsdist\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/normsdist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/normsdist\/#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":"NORMSDA\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\/15559","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=15559"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15559\/revisions"}],"predecessor-version":[{"id":26827,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15559\/revisions\/26827"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15559"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15559"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15559"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}