{"id":15289,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/binom-ters\/"},"modified":"2021-02-25T16:23:10","modified_gmt":"2021-02-25T16:23:10","slug":"binom-inv","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/binom-inv\/","title":{"rendered":"B\u0130NOM.TERS"},"content":{"rendered":"

Binomik Da\u011f\u0131l\u0131m\u0131n Tersi: Excel ve Google E-Tablolar’da Kullan\u0131m\u0131<\/h1>\n

BINOM.INV fonksiyonu, belirlenen parametrelerle binom da\u011f\u0131l\u0131m\u0131 kullanarak, k\u00fcm\u00fclatif da\u011f\u0131l\u0131m fonksiyonunun belirli bir de\u011fere e\u015fit veya ondan k\u00fc\u00e7\u00fck olma olas\u0131l\u0131\u011f\u0131n\u0131 veren deneme say\u0131s\u0131n\u0131 verir. Bu i\u015flev, \u00f6zellikle belirli bir olas\u0131l\u0131k da\u011f\u0131l\u0131m\u0131nda gerekli sonucu elde etmek i\u00e7in ka\u00e7 denemenin gerekti\u011fini anlamak isteyen analistler i\u00e7in son derece kullan\u0131\u015fl\u0131d\u0131r. Excel ve Google E-Tablolar’da kullan\u0131m\u0131 benzerdir. Bu makalede, iki platformda da BINOM.INV fonksiyonunun nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 ayr\u0131nt\u0131l\u0131 olarak a\u00e7\u0131klayaca\u011f\u0131z.<\/p>\n

Genel S\u00f6zdizimi ve \u00d6rnekler<\/h2>\n

BINOM.INV fonksiyonunun s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

  BINOM.INV(toplam_deneme, ba\u015far\u0131_olas\u0131l\u0131\u011f\u0131, alfa)<\/code> <\/pre>\n
    \n
  • toplam_deneme<\/strong>: Denemelerin (testlerin) toplam say\u0131s\u0131d\u0131r.<\/li>\n
  • ba\u015far\u0131_olas\u0131l\u0131\u011f\u0131<\/strong>: Her denemede ba\u015far\u0131 \u015fans\u0131d\u0131r.<\/li>\n
  • alfa<\/strong>: Aranan k\u00fcm\u00fclatif da\u011f\u0131l\u0131m olas\u0131l\u0131\u011f\u0131d\u0131r.<\/li>\n<\/ul>\n
    Bir \u00f6rnek vermek gerekirse, bir zar\u0131 10 kez at\u0131yorsunuz ve en az 60% olas\u0131l\u0131kla en az ka\u00e7 kere 6 gelmesi gerekti\u011fini hesaplamak istiyorsan\u0131z, fonksiyonu \u015fu \u015fekilde kullanabilirsiniz:<\/p>\n
      =BINOM.INV(10, 1\/6, 0.6)<\/code> <\/pre>\n
    Hesaplama yap\u0131l\u0131rken zar\u0131n 6 gelme olas\u0131l\u0131\u011f\u0131 1\/6 olarak al\u0131nm\u0131\u015ft\u0131r. Fonksiyon, bu \u00f6rnekte 4 d\u00f6ner, yani 10 at\u0131\u015f\u0131n en az 4 tanesinde 6 gelmesi 60% olas\u0131l\u0131kla beklenir.<\/p>\n
    Pratik Uygulamalar<\/h2>\n
    Proje Y\u00f6netiminde Kullan\u0131m\u0131<\/h3>\n
    Bir proje y\u00f6neticisi gibi d\u00fc\u015f\u00fcnelim: bir projenin ba\u015far\u0131l\u0131 bir \u015fekilde tamamlanmas\u0131n\u0131n, projenin her bir eleman\u0131n\u0131n ba\u015far\u0131l\u0131 olmas\u0131na ba\u011fl\u0131 oldu\u011funu biliyoruz. E\u011fer projede 15 a\u015fama varsa ve her a\u015fama i\u00e7in ba\u015far\u0131 \u015fans\u0131 %70 ise, projenin %95 olas\u0131l\u0131kla ba\u015far\u0131l\u0131 olmas\u0131 i\u00e7in ka\u00e7 a\u015fama ba\u015far\u0131l\u0131 olmal\u0131?<\/p>\n
      =BINOM.INV(15, 0.7, 0.95)<\/code> <\/pre>\n
    Bu hesaplama, projenin y\u00fczde 95 olas\u0131l\u0131kla ba\u015far\u0131l\u0131 olmas\u0131 i\u00e7in en az 12 a\u015faman\u0131n ba\u015far\u0131l\u0131 olmas\u0131 gerekti\u011fini g\u00f6sterir.<\/p>\n
    Pazarlama Kampanyalar\u0131nda Kullan\u0131m\u0131<\/h3>\n
    Bir pazarlama analisti, yeni bir \u00fcr\u00fcn tan\u0131t\u0131m\u0131 i\u00e7in m\u00fc\u015fteri tepkisini de\u011ferlendirmeye \u00e7al\u0131\u015f\u0131yor. 150 m\u00fc\u015fteri \u00fczerinde yap\u0131lan test sonu\u00e7lar\u0131na g\u00f6re, m\u00fc\u015fterilerin %80’i \u00fcr\u00fcn\u00fc be\u011feniyor. \u015eimdi analist, %90 g\u00fcvenle en az ka\u00e7 m\u00fc\u015fterinin \u00fcr\u00fcn\u00fc be\u011fenece\u011fini anlamak istiyor.<\/p>\n
      =BINOM.INV(150, 0.8, 0.9)<\/code> <\/pre>\n
    Bu fonksiyon, en az 134 m\u00fc\u015fterinin \u00fcr\u00fcn\u00fc be\u011fenmesinin %90 olas\u0131l\u0131kla beklendi\u011fini g\u00f6sterir, bu da kampanyan\u0131n genel ba\u015far\u0131s\u0131n\u0131 \u00f6l\u00e7mede yard\u0131mc\u0131 olur.<\/p>\n
    BINOM.INV fonksiyonu, \u00e7e\u015fitli senaryolarda, \u00f6zellikle risk de\u011ferlendirmesi, projeksiyon yapma ve hedef belirleme gibi durumlarda olduk\u00e7a faydal\u0131d\u0131r. Both Microsoft Excel ve Google E-Tablolar kullanarak, bu t\u00fcr analizleri kolayl\u0131kla ger\u00e7ekle\u015ftirebilir ve gerekli kararlar\u0131 almak i\u00e7in sa\u011flam veri temelleri olu\u015fturabilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"
    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":[582],"tags":[],"class_list":["post-15289","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nExcel'de BINOM.INV (B\u0130NOM.TERS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da BINOM.INV (B\u0130NOM.TERS) 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-inv\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de BINOM.INV (B\u0130NOM.TERS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da BINOM.INV (B\u0130NOM.TERS) 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-inv\/\" \/>\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:10+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 BINOM.INV (B\u0130NOM.TERS) 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-inv\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/binom-inv\/\",\"name\":\"Excel'de BINOM.INV (B\u0130NOM.TERS) 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:10+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da BINOM.INV (B\u0130NOM.TERS) 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-inv\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/binom-inv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/binom-inv\/#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.TERS\"}]},{\"@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.INV (B\u0130NOM.TERS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da BINOM.INV (B\u0130NOM.TERS) 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-inv\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de BINOM.INV (B\u0130NOM.TERS) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da BINOM.INV (B\u0130NOM.TERS) 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-inv\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:23:10+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de BINOM.INV (B\u0130NOM.TERS) 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-inv\/","url":"https:\/\/functiontranslator.com\/tr\/binom-inv\/","name":"Excel'de BINOM.INV (B\u0130NOM.TERS) 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:10+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da BINOM.INV (B\u0130NOM.TERS) 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-inv\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/binom-inv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/binom-inv\/#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.TERS"}]},{"@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\/15289","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=15289"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15289\/revisions"}],"predecessor-version":[{"id":26557,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15289\/revisions\/26557"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15289"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15289"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15289"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}