{"id":15287,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/binom-dag\/"},"modified":"2021-02-25T16:23:09","modified_gmt":"2021-02-25T16:23:09","slug":"binom-dist","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/binom-dist\/","title":{"rendered":"B\u0130NOM.DA\u011e"},"content":{"rendered":"<h1>Excel ve Google E-Tablolar&#8217;da Binom Da\u011f\u0131t\u0131m Fonksiyonunun Kullan\u0131m\u0131<\/h1>\n<p>\u0130ster bilim ve m\u00fchendislik, ister i\u015f d\u00fcnyas\u0131 ve e\u011fitim sekt\u00f6r\u00fc olsun, belirli olaylar\u0131n olas\u0131l\u0131klar\u0131n\u0131 anlamak her zaman \u00f6nemlidir. Bu yaz\u0131m\u0131zda, Microsoft Excel ve Google E-Tablolar&#8217;da kullan\u0131lan <strong>BINOM.DIST<\/strong> (Excel i\u00e7in) veya <strong>B\u0130NOM.DA\u011e<\/strong> (Google E-Tablolar i\u00e7in) fonksiyonunun nas\u0131l kullan\u0131ld\u0131\u011f\u0131n\u0131 \u00f6rneklerle beraber detayl\u0131 bir \u015fekilde inceliyoruz.<\/p>\n<h2>Fonksiyonun Kullan\u0131m\u0131 ve S\u00f6zdizimi<\/h2>\n<p>Binom da\u011f\u0131l\u0131m fonksiyonu, belirli say\u0131da ba\u011f\u0131ms\u0131z denemede ba\u015far\u0131 say\u0131s\u0131n\u0131n olas\u0131l\u0131\u011f\u0131n\u0131 hesaplar. Deneylerin sonucu ya ba\u015far\u0131l\u0131 ya da ba\u015far\u0131s\u0131z olabilir (iki sonu\u00e7lu). Ayr\u0131ca, her denemenin ba\u015far\u0131 \u015fans\u0131 sabit olmal\u0131d\u0131r.<\/p>\n<ul>\n<li><strong>Excel S\u00f6zdizimi:<\/strong> <code>=BINOM.DIST(ba\u015far\u0131_say\u0131s\u0131, deneme_say\u0131s\u0131, ba\u015far\u0131_olas\u0131l\u0131\u011f\u0131, k\u00fcm\u00fclatif)<\/code><\/li>\n<li><strong>Google E-Tablolar S\u00f6zdizimi:<\/strong> <code>=B\u0130NOM.DA\u011e(ba\u015far\u0131_say\u0131s\u0131, deneme_say\u0131s\u0131, ba\u015far\u0131_olas\u0131l\u0131\u011f\u0131, k\u00fcm\u00fclatif)<\/code><\/li>\n<\/ul>\n<p><i>Ba\u015far\u0131_say\u0131s\u0131<\/i> deneyde g\u00f6zlemlenen ba\u015far\u0131lar\u0131n say\u0131s\u0131n\u0131; <i>deneme_say\u0131s\u0131<\/i> toplam deneme say\u0131s\u0131n\u0131; <i>ba\u015far\u0131_olas\u0131l\u0131\u011f\u0131<\/i> her denemede ba\u015far\u0131 \u015fans\u0131n\u0131 temsil eder. <i>K\u00fcm\u00fclatif<\/i> parametresi TRUE (DO\u011eRU) ise fonksiyon k\u00fcm\u00fclatif da\u011f\u0131l\u0131m fonksiyonunu, FALSE (YANLI\u015e) ise olas\u0131l\u0131k k\u00fctle fonksiyonunu d\u00f6nd\u00fcr\u00fcr.<\/p>\n<h2>Pratik Uygulamalar<\/h2>\n<h3>\u00d6rnek 1: Reklam Kampanyas\u0131n\u0131n Ba\u015far\u0131 Analizi<\/h3>\n<p>Y\u00fcz farkl\u0131 ki\u015fiye bir \u00fcr\u00fcn tan\u0131t\u0131m\u0131 yapt\u0131\u011f\u0131n\u0131z\u0131 d\u00fc\u015f\u00fcnelim. Her bir ki\u015finin \u00fcr\u00fcn\u00fc sat\u0131n alma olas\u0131l\u0131\u011f\u0131 %20 olsun. En az 15 ki\u015finin \u00fcr\u00fcn\u00fc sat\u0131n almas\u0131 gerekti\u011finde bu durumun olas\u0131l\u0131\u011f\u0131n\u0131 hesaplamak isteyelim:<\/p>\n<pre><code>=BINOM.DIST(14, 100, 0.20, TRUE)<\/code><\/pre>\n<p>Bu fonksiyon, en fazla 14 ki\u015finin \u00fcr\u00fcn\u00fc sat\u0131n alma olas\u0131l\u0131\u011f\u0131n\u0131 verir. 1&#8217;den bu de\u011feri \u00e7\u0131kartarak en az 15 ki\u015finin sat\u0131n alma olas\u0131l\u0131\u011f\u0131n\u0131 bulabiliriz.<\/p>\n<h3>\u00d6rnek 2: Kalite Kontrol Testi<\/h3>\n<p>Bir \u00fcretim band\u0131nda \u00fcretilen her 100 \u00fcr\u00fcnden 4&#8217;\u00fcn\u00fcn kusurlu \u00e7\u0131kma olas\u0131l\u0131\u011f\u0131na bakal\u0131m. Rastgele se\u00e7ilen 100 \u00fcr\u00fcnden en fazla 3&#8217;\u00fcn\u00fcn kusurlu olma olas\u0131l\u0131\u011f\u0131n\u0131 hesaplayal\u0131m:<\/p>\n<pre><code>=B\u0130NOM.DA\u011e(3, 100, 0.04, TRUE)<\/code><\/pre>\n<p>Bu de\u011fer, se\u00e7ilen 100 \u00fcr\u00fcnden 0, 1, 2 veya 3 tanesinin kusurlu olma olas\u0131l\u0131\u011f\u0131n\u0131 toplam olarak verir ve kalite kontrol i\u00e7in \u00f6nemli bir g\u00f6stergedir.<\/p>\n<h2>Yorumlar ve \u0130pu\u00e7lar\u0131<\/h2>\n<p>BINOM.DIST veya B\u0130NOM.DA\u011e fonksiyonlar\u0131n\u0131 kullan\u0131rken, denemelerin ba\u011f\u0131ms\u0131z oldu\u011fundan ve ba\u015far\u0131 olas\u0131l\u0131\u011f\u0131n\u0131n sabit kald\u0131\u011f\u0131ndan emin olun. Bu fonksiyonlar, \u00f6zellikle belirsizlik i\u00e7eren durumlar\u0131 modellemek ve karar verme s\u00fcre\u00e7lerini desteklemek i\u00e7in m\u00fckemmeldir. Ayr\u0131ca, sonu\u00e7lar\u0131 daha iyi anlamak i\u00e7in \u00e7e\u015fitli senaryolar\u0131 test edin ve sonu\u00e7lar\u0131n\u0131z\u0131 grafiklerle destekleyin.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tek terimli binom da\u011f\u0131l\u0131m\u0131 olas\u0131l\u0131\u011f\u0131n\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-15287","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"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 BINOM.DIST (B\u0130NOM.DA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da BINOM.DIST (B\u0130NOM.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\/binom-dist\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de BINOM.DIST (B\u0130NOM.DA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da BINOM.DIST (B\u0130NOM.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\/binom-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:23:09+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 BINOM.DIST (B\u0130NOM.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\/binom-dist\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/binom-dist\/\",\"name\":\"Excel'de BINOM.DIST (B\u0130NOM.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:23:09+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da BINOM.DIST (B\u0130NOM.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\/binom-dist\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/binom-dist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/binom-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\":\"B\u0130NOM.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 BINOM.DIST (B\u0130NOM.DA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da BINOM.DIST (B\u0130NOM.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\/binom-dist\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de BINOM.DIST (B\u0130NOM.DA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da BINOM.DIST (B\u0130NOM.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\/binom-dist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:23:09+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de BINOM.DIST (B\u0130NOM.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\/binom-dist\/","url":"https:\/\/functiontranslator.com\/tr\/binom-dist\/","name":"Excel'de BINOM.DIST (B\u0130NOM.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:23:09+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da BINOM.DIST (B\u0130NOM.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\/binom-dist\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/binom-dist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/binom-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":"B\u0130NOM.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\/15287","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=15287"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15287\/revisions"}],"predecessor-version":[{"id":26555,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15287\/revisions\/26555"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15287"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15287"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15287"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}