{"id":15558,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/norm-s-dag\/"},"modified":"2021-02-25T16:32:51","modified_gmt":"2021-02-25T16:32:51","slug":"norm-s-dist","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/norm-s-dist\/","title":{"rendered":"NORM.S.DA\u011e"},"content":{"rendered":"

Normal Standart Da\u011f\u0131l\u0131m Fonksiyonunun Kullan\u0131m\u0131<\/h1>\n

\u0130statistiksel analizlerde s\u0131kl\u0131kla kar\u015f\u0131la\u015f\u0131lan bir konu, normal da\u011f\u0131l\u0131m ve bu da\u011f\u0131l\u0131m\u0131n \u00e7e\u015fitli \u00f6zelliklerini hesaplamakt\u0131r. \u0130\u015fte bu noktada Excel ve Google E-Tablolar’daki NORM.S.DIST<\/code> fonksiyonu devreye girer. Bu fonksiyon, standardize edilmi\u015f normal da\u011f\u0131l\u0131m e\u011frisi alt\u0131nda kalan alan\u0131 hesaplamak i\u00e7in kullan\u0131l\u0131r. Bu yaz\u0131da, bu fonksiyonun s\u00f6zdiziminden ve kullan\u0131m \u00f6rneklerinden bahsedece\u011fiz.<\/p>\n

Normal Standart Da\u011f\u0131l\u0131m\u0131n Tan\u0131m\u0131 ve S\u00f6zdizimi<\/h2>\n

Normal standart da\u011f\u0131l\u0131m, ortalama de\u011feri (\u03bc) 0 ve standart sapmas\u0131 (\u03c3) 1 olan bir normal da\u011f\u0131l\u0131md\u0131r. NORM.S.DIST<\/code> fonksiyonu, bir z skorunun kar\u015f\u0131l\u0131k geldi\u011fi alan\u0131 (olas\u0131l\u0131k de\u011feri) d\u00f6nd\u00fcr\u00fcr.<\/p>\n

Fonksiyonun s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

  NORM.S.DIST(z, cumulative) <\/code> <\/pre>\n
    \n
  • z<\/strong>: Normal da\u011f\u0131l\u0131m\u0131n z skorudur. Bu, d\u00f6n\u00fc\u015f\u00fcm sonras\u0131 de\u011ferinizin normal da\u011f\u0131l\u0131m e\u011frisindeki yerini belirler.<\/li>\n
  • cumulative<\/strong>: Bu mant\u0131ksal de\u011fer (DO\u011eRU ya da YANLI\u015e) girilir. E\u011fer DO\u011eRU ise, fonksiyon k\u00fcm\u00fclatif da\u011f\u0131l\u0131m fonksiyonunu hesaplar; YANLI\u015e ise, fonksiyon olas\u0131l\u0131k yo\u011funluk fonksiyonunu hesaplar.<\/li>\n<\/ul>\n
    Pratik Uygulama \u00d6rnekleri<\/h2>\n
    \u0130\u015fte NORM.S.DIST<\/code> i\u015flevinin kullan\u0131labilece\u011fi birka\u00e7 pratik \u00f6rnek:<\/p>\n
    \u00d6rnek 1: K\u00fcm\u00fclatif Da\u011f\u0131l\u0131m Hesaplama<\/h3>\n
    Varsayal\u0131m ki bir s\u0131nav\u0131n sonu\u00e7lar\u0131 normal da\u011f\u0131l\u0131ma uygun olarak da\u011f\u0131lm\u0131\u015f ve siz, s\u0131navdan 85 puan alan bir \u00f6\u011frencinin \u00fcst\u00fcnde kalan \u00f6\u011frenci y\u00fczdesini bulmak istiyorsunuz. Ortalama 80 ve standart sapma 10 ise, Z skoru \u015fu \u015fekilde hesaplanabilir:<\/p>\n
      Z = (X - \u03bc) \/ \u03c3 = (85 - 80) \/ 10 = 0.5 <\/code> <\/pre>\n
    Bu Z skoru i\u00e7in k\u00fcm\u00fclatif da\u011f\u0131l\u0131m de\u011feri:<\/p>\n
      =NORM.S.DIST(0.5, TRUE) <\/code> <\/pre>\n
    Bu fonksiyonun sonucu, y\u00fczdelik olarak ifade edilen, bu notu alan ve bu nottan y\u00fcksek alan \u00f6\u011frenci oran\u0131n\u0131 g\u00f6sterir.<\/p>\n
    \u00d6rnek 2: Olas\u0131l\u0131k Yo\u011funluk Fonksiyonu De\u011feri<\/h3>\n
    Bir m\u00fchendis, belirli bir tolerans aral\u0131\u011f\u0131ndaki par\u00e7a \u00f6l\u00e7\u00fcmlerinin yo\u011funlu\u011funu hesaplamak istiyor. \u00d6l\u00e7\u00fcm\u00fcn z skoru 0.75 olarak hesapland\u0131\u011f\u0131nda, normal standart da\u011f\u0131l\u0131m yo\u011funlu\u011funu hesaplamak i\u00e7in:<\/p>\n
      =NORM.S.DIST(0.75, FALSE) <\/code> <\/pre>\n
    Bu de\u011fer, z = 0.75 de\u011feri i\u00e7in olas\u0131l\u0131k yo\u011funlu\u011funu verir ve m\u00fchendis bu bilgiyi kullanabilir.<\/p>\n
    Bu fonksiyonlar\u0131 kullan\u0131rken, veri setlerinizin normal da\u011f\u0131l\u0131ma uygun oldu\u011fundan emin olman\u0131z \u00f6nemlidir, \u00e7\u00fcnk\u00fc bu, sonu\u00e7lar\u0131n do\u011frulu\u011fu a\u00e7\u0131s\u0131ndan kritik bir \u00f6neme sahiptir.<\/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":[582],"tags":[],"class_list":["post-15558","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nExcel'de NORM.S.DIST (NORM.S.DA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da NORM.S.DIST (NORM.S.DA\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\/norm-s-dist\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de NORM.S.DIST (NORM.S.DA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da NORM.S.DIST (NORM.S.DA\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\/norm-s-dist\/\" \/>\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:51+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 NORM.S.DIST (NORM.S.DA\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\/norm-s-dist\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/norm-s-dist\/\",\"name\":\"Excel'de NORM.S.DIST (NORM.S.DA\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:51+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da NORM.S.DIST (NORM.S.DA\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\/norm-s-dist\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/norm-s-dist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/norm-s-dist\/#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\":\"NORM.S.DA\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 NORM.S.DIST (NORM.S.DA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da NORM.S.DIST (NORM.S.DA\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\/norm-s-dist\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de NORM.S.DIST (NORM.S.DA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da NORM.S.DIST (NORM.S.DA\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\/norm-s-dist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:32:51+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de NORM.S.DIST (NORM.S.DA\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\/norm-s-dist\/","url":"https:\/\/functiontranslator.com\/tr\/norm-s-dist\/","name":"Excel'de NORM.S.DIST (NORM.S.DA\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:51+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da NORM.S.DIST (NORM.S.DA\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\/norm-s-dist\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/norm-s-dist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/norm-s-dist\/#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":"NORM.S.DA\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\/15558","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=15558"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15558\/revisions"}],"predecessor-version":[{"id":26826,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15558\/revisions\/26826"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15558"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15558"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15558"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}