{"id":15342,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/kritikbinom\/"},"modified":"2021-02-25T16:24:30","modified_gmt":"2021-02-25T16:24:30","slug":"critbinom","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/critbinom\/","title":{"rendered":"KR\u0130T\u0130KB\u0130NOM"},"content":{"rendered":"<h2>CRITBINOM\/KR\u0130T\u0130KB\u0130NOM \u0130\u015flevine Genel Bak\u0131\u015f<\/h2>\n<p><code>CRITBINOM<\/code> veya T\u00fcrk\u00e7e ismiyle <code>KR\u0130T\u0130KB\u0130NOM<\/code>, Microsoft Excel ve Google E-Tablolar&#8217;da kullan\u0131lan istatistiksel bir i\u015fleve i\u015faret eder. Bu i\u015flev, belirli bir olas\u0131l\u0131k da\u011f\u0131l\u0131m\u0131 alt\u0131nda, k\u00fcm\u00fclatif olas\u0131l\u0131\u011f\u0131n belirli bir de\u011feri ge\u00e7mesi i\u00e7in gerekli olan minimum ba\u015far\u0131 say\u0131s\u0131n\u0131 hesaplamak i\u00e7in kullan\u0131l\u0131r. \u00d6zellikle binom da\u011f\u0131l\u0131m\u0131nda kullan\u0131l\u0131r.<\/p>\n<h2>\u0130\u015flev S\u00f6zdizimine Geni\u015f \u00c7apta Bak\u0131\u015f<\/h2>\n<p> S\u00f6z konusu fonksiyonun genel s\u00f6zdizimi \u015fu \u015fekildedir: <\/p>\n<pre><code>=CRITBINOM(trials, probability_s, alpha)<\/code><\/pre>\n<ul>\n<li><code>trials<\/code>: Deneme say\u0131s\u0131n\u0131 belirtir, yani ba\u011f\u0131ms\u0131z deneme say\u0131s\u0131.<\/li>\n<li><code>probability_s<\/code>: Her denemede ba\u015far\u0131 olas\u0131l\u0131\u011f\u0131n\u0131 belirtir.<\/li>\n<li><alpha>: Kritik k\u00fcm\u00fclatif olas\u0131l\u0131\u011f\u0131 belirtir. Genellikle g\u00fcven d\u00fczeyi olarak adland\u0131r\u0131lan bu de\u011fer, i\u015flevin hesaplama yaparken dikkate alaca\u011f\u0131 k\u00fcm\u00fclatif olas\u0131l\u0131\u011f\u0131d\u0131r.<\/li>\n<\/ul>\n<h2>CRITBINOM\/KR\u0130T\u0130KB\u0130NOM \u0130\u015flevinin Pratik Kullan\u0131mlar\u0131<\/h2>\n<p>Bu i\u015flev, \u00e7e\u015fitli alanlarda faydal\u0131 olabilir; a\u015fa\u011f\u0131da iki \u00f6rnek ve uygulama detaylar\u0131 sunulmu\u015ftur:<\/p>\n<h2>\u0130lk Pratik Kullan\u0131m: Kalite Kontrol<\/h2>\n<p> Bir \u00fcretim hatt\u0131nda, her bir \u00fcnite \u00fczerinde ger\u00e7ekle\u015ftirilen kalite kontrol testlerinin sonucuna dayanarak kusurlu \u00fcr\u00fcn oran\u0131n\u0131 belirlemek i\u00e7in <code>CRITBINOM<\/code> kullan\u0131labilir. Diyelim ki, 100 \u00fcnite \u00fcretiliyor ve her birimde kusur bulma olas\u0131l\u0131\u011f\u0131 %5 olarak tahmin ediliyor. G\u00fcven d\u00fczeyi %95 olarak belirlenmi\u015fse, fonksiyonun kullan\u0131m\u0131 \u015fu \u015fekilde olacakt\u0131r: <\/p>\n<pre><code>=CRITBINOM(100, 0.05, 0.95)<\/code><\/pre>\n<p> Bu i\u015flem, belirlenen g\u00fcven d\u00fczeyinde en fazla kusurlu \u00fcr\u00fcn say\u0131s\u0131n\u0131 hesaplar. <\/p>\n<h2>\u0130kinci Pratik Kullan\u0131m: Kampanya Ba\u015far\u0131s\u0131n\u0131n De\u011ferlendirilmesi<\/h2>\n<p> Bir pazarlama kampanyas\u0131nda, \u00f6rne\u011fin bir e-posta kampanyas\u0131nda, belirli bir d\u00f6n\u00fc\u015f\u00fcm oran\u0131n\u0131n (ba\u015far\u0131 oran\u0131n\u0131n) \u00fcst\u00fcndeki sonucu elde etme ihtimali hesaplanmak istenirse, <code>CRITBINOM<\/code> fonksiyonu yine devreye girer. Diyelim ki, 1000 ki\u015fiye e-posta g\u00f6nderildi ve her bir ki\u015finin e-postay\u0131 a\u00e7ma olas\u0131l\u0131\u011f\u0131 %10 olarak hesapland\u0131. E-postalar\u0131n %20&#8217;sinin a\u00e7\u0131lmas\u0131 beklendi\u011finde, kritik ba\u015far\u0131 oran\u0131 \u015f\u00f6yle hesaplan\u0131r: <\/p>\n<pre><code>=CRITBINOM(1000, 0.1, 0.20)<\/code><\/pre>\n<p> Bu form\u00fcl, e-postalar\u0131n en az %20&#8217;sinin a\u00e7\u0131lmas\u0131 i\u00e7in gereken minimum ki\u015fi say\u0131s\u0131n\u0131 verir. <\/p>\n<h2>Yorumlar ve \u00d6neriler<\/h2>\n<p> <code>CRITBINOM<\/code> i\u015flevi, \u00f6zellikle belirsizlik bar\u0131nd\u0131ran durumlarda karar verme s\u00fcrecini desteklemek i\u00e7in m\u00fckemmel bir ara\u00e7t\u0131r. Kalite kontrol, finansal risk analizi, pazar ara\u015ft\u0131rmas\u0131 gibi bir\u00e7ok farkl\u0131 alanda kullan\u0131labilir. \u0130\u015flevin do\u011fru kullan\u0131labilmesi i\u00e7in, deneme say\u0131s\u0131 ve ba\u015far\u0131 olas\u0131l\u0131\u011f\u0131 de\u011ferlerinin do\u011fru belirlenmesi b\u00fcy\u00fck \u00f6nem ta\u015f\u0131r. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>K\u00fcm\u00fclatif binom da\u011f\u0131l\u0131m\u0131n\u0131n bir \u00f6l\u00e7\u00fct de\u011ferinden k\u00fc\u00e7\u00fck veya buna e\u015fit oldu\u011fu en k\u00fc\u00e7\u00fck de\u011feri 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-15342","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 CRITBINOM (KR\u0130T\u0130KB\u0130NOM) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da CRITBINOM (KR\u0130T\u0130KB\u0130NOM) 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\/critbinom\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de CRITBINOM (KR\u0130T\u0130KB\u0130NOM) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da CRITBINOM (KR\u0130T\u0130KB\u0130NOM) 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\/critbinom\/\" \/>\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:24:30+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 CRITBINOM (KR\u0130T\u0130KB\u0130NOM) 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\/critbinom\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/critbinom\/\",\"name\":\"Excel'de CRITBINOM (KR\u0130T\u0130KB\u0130NOM) 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:24:30+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da CRITBINOM (KR\u0130T\u0130KB\u0130NOM) 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\/critbinom\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/critbinom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/critbinom\/#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\":\"KR\u0130T\u0130KB\u0130NOM\"}]},{\"@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 CRITBINOM (KR\u0130T\u0130KB\u0130NOM) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da CRITBINOM (KR\u0130T\u0130KB\u0130NOM) 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\/critbinom\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de CRITBINOM (KR\u0130T\u0130KB\u0130NOM) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da CRITBINOM (KR\u0130T\u0130KB\u0130NOM) 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\/critbinom\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:24:30+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de CRITBINOM (KR\u0130T\u0130KB\u0130NOM) 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\/critbinom\/","url":"https:\/\/functiontranslator.com\/tr\/critbinom\/","name":"Excel'de CRITBINOM (KR\u0130T\u0130KB\u0130NOM) 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:24:30+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da CRITBINOM (KR\u0130T\u0130KB\u0130NOM) 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\/critbinom\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/critbinom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/critbinom\/#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":"KR\u0130T\u0130KB\u0130NOM"}]},{"@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\/15342","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=15342"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15342\/revisions"}],"predecessor-version":[{"id":26610,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15342\/revisions\/26610"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15342"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15342"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15342"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}