{"id":15549,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/negbinom-dag\/"},"modified":"2021-02-25T16:32:33","modified_gmt":"2021-02-25T16:32:33","slug":"negbinom-dist","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/negbinom-dist\/","title":{"rendered":"NEGB\u0130NOM.DA\u011e"},"content":{"rendered":"

Bu rehberde, hem Microsoft Excel hem de Google E-Tablolar’da kullan\u0131labilen istatistiksel bir i\u015flev olan NEGBINOM.DIST (T\u00fcrk\u00e7e Excel’de NEGB\u0130NOM.DA\u011e) \u00fczerinde duraca\u011f\u0131z. Bu i\u015flev, olas\u0131l\u0131k teorisinde ve istatistikte yer alan negatif binom da\u011f\u0131l\u0131m\u0131n\u0131n bir par\u00e7as\u0131d\u0131r ve belirli say\u0131da ba\u015far\u0131s\u0131zl\u0131ktan sonra ger\u00e7ekle\u015fen ilk ba\u015far\u0131 say\u0131s\u0131n\u0131n olas\u0131l\u0131\u011f\u0131n\u0131 hesaplamak i\u00e7in kullan\u0131l\u0131r.<\/p>\n

Kapsaml\u0131 S\u00f6zdizimi A\u00e7\u0131klamas\u0131 ve \u00d6rnekler<\/h2>\n

Excel ve Google E-Tablolar’daki NEGBINOM.DIST i\u015flevi, a\u015fa\u011f\u0131daki s\u00f6zdizimine sahiptir:<\/p>\n

NEGBINOM.DIST(ba\u015far\u0131s\u0131zl\u0131k_say\u0131s\u0131, ba\u015far\u0131_say\u0131s\u0131, ba\u015far\u0131_olas\u0131l\u0131\u011f\u0131, k\u00fcm\u00fclatif)<\/code><\/pre>\n
    \n
  • ba\u015far\u0131s\u0131zl\u0131k_say\u0131s\u0131<\/code>: \u0130lgili s\u00fcre\u00e7te elde edilmesi gereken ba\u015far\u0131s\u0131zl\u0131k say\u0131s\u0131. Bu say\u0131 s\u0131f\u0131r veya daha b\u00fcy\u00fck bir tam say\u0131 olmal\u0131d\u0131r.<\/li>\n
  • ba\u015far\u0131_say\u0131s\u0131<\/code>: Elde edilmesi gereken ba\u015far\u0131 say\u0131s\u0131. Bu da s\u0131f\u0131rdan b\u00fcy\u00fck bir tam say\u0131 olmal\u0131d\u0131r.<\/li>\n
  • ba\u015far\u0131_olas\u0131l\u0131\u011f\u0131<\/code>: Her denemede ba\u015far\u0131 elde etme olas\u0131l\u0131\u011f\u0131. Bu de\u011fer 0 ile 1 aras\u0131nda bir say\u0131d\u0131r (dahil).<\/li>\n
  • k\u00fcm\u00fclatif<\/code>: Bu, i\u015flevin form\u00fcn\u00fcn k\u00fcm\u00fclatif (DA\u011eILIM) veya olas\u0131l\u0131k k\u00fctle fonksiyonunu (YANLI\u015e) hesaplay\u0131p hesaplamayaca\u011f\u0131n\u0131 belirler. TRUE ya da 1 de\u011feri, i\u015flevin k\u00fcm\u00fclatif da\u011f\u0131l\u0131m fonksiyonunu; FALSE ya da 0 de\u011feri, olas\u0131l\u0131k k\u00fctle fonksiyonunu hesaplar.<\/li>\n<\/ul>\n
    \u00d6rnek: Bir basketbol oyuncusunun her at\u0131\u015f\u0131 0.5 olas\u0131l\u0131kla isabet ettirdi\u011fini d\u00fc\u015f\u00fcnelim. Bu oyuncunun ilk ba\u015far\u0131s\u0131n\u0131 elde etmeden \u00f6nce 3 ba\u015far\u0131s\u0131z at\u0131\u015f yapma olas\u0131l\u0131\u011f\u0131n\u0131 hesaplamaya \u00e7al\u0131\u015fal\u0131m.<\/p>\n
    =NEGBINOM.DIST(3, 1, 0.5, FALSE)<\/code><\/pre>\n
    Bu form\u00fcl ile hesaplanan de\u011fer, oyuncunun ilk ba\u015far\u0131y\u0131 elde etmeden \u00f6nce \u00fc\u00e7 kez ba\u015far\u0131s\u0131z olma olas\u0131l\u0131\u011f\u0131n\u0131 verir.<\/p>\n
    Pratik Uygulamalar<\/h2>\n
    Proje Y\u00f6netimi<\/h3>\n
    Proje y\u00f6netiminde, belirli bir hedefe ula\u015fmadan \u00f6nce ortaya \u00e7\u0131kabilecek hatalar\u0131n veya gecikmelerin analiz edilmesi i\u00e7in negatif binom da\u011f\u0131l\u0131m\u0131 kullan\u0131labilir. \u00d6rne\u011fin, bir yaz\u0131l\u0131m geli\u015ftirme projesinde, hedeflenen \u00e7\u0131kt\u0131y\u0131 elde etmeden \u00f6nce meydana gelebilecek hata say\u0131s\u0131n\u0131n tahmin edilmesi gerekebilir.<\/p>\n
    =NEGBINOM.DIST(5, 1, 0.2, TRUE)<\/code><\/pre>\n
    Bu form\u00fcl, be\u015f hata meydana gelmeden projenin ba\u015far\u0131yla tamamlanma olas\u0131l\u0131\u011f\u0131n\u0131 k\u00fcm\u00fclatif olarak hesaplar.<\/p>\n
    Pazarlama Kampanyalar\u0131<\/h3>\n
    Bir pazarlama kampanyas\u0131ndaki ba\u015far\u0131l\u0131 sat\u0131\u015f say\u0131s\u0131n\u0131 tahmin etmek ad\u0131na da bu i\u015flev kullan\u0131labilir. Diyelim ki, bir kampanyan\u0131n ba\u015far\u0131l\u0131 olup olmayaca\u011f\u0131n\u0131 anlamak i\u00e7in belirli say\u0131da sat\u0131\u015f yap\u0131lmas\u0131 gerekiyor. NEGBINOM.DIST i\u015flevi, ba\u015far\u0131l\u0131 sat\u0131\u015flar\u0131n ger\u00e7ekle\u015fme olas\u0131l\u0131\u011f\u0131n\u0131 hesaplamaya yard\u0131mc\u0131 olabilir.<\/p>\n
    =NEGBINOM.DIST(10, 3, 0.7, FALSE)<\/code><\/pre>\n
    Bu \u00f6rnekte, \u00fc\u00e7\u00fcnc\u00fc ba\u015far\u0131l\u0131 sat\u0131\u015f ger\u00e7ekle\u015fmeden \u00f6nce on kez ba\u015far\u0131s\u0131z sat\u0131\u015f yapma olas\u0131l\u0131\u011f\u0131n\u0131 hesaplar\u0131z.<\/p>\n
    Bu \u00f6rnekler, NEGBINOM.DIST i\u015flevinin hem Excel hem de Google E-Tablolar’da nas\u0131l kullan\u0131labilece\u011fini g\u00f6stermektedir. \u0130\u015flevin kapsam\u0131 ve uygulama alanlar\u0131 olduk\u00e7a geni\u015ftir ve yukar\u0131da bahsedilenler sadece baz\u0131 basit kullan\u0131m senaryolar\u0131n\u0131 i\u00e7ermektedir.”\/><\/p>\n","protected":false},"excerpt":{"rendered":"
    Negatif binom da\u011f\u0131l\u0131m\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-15549","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nExcel'de NEGBINOM.DIST (NEGB\u0130NOM.DA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da NEGBINOM.DIST (NEGB\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\/negbinom-dist\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de NEGBINOM.DIST (NEGB\u0130NOM.DA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da NEGBINOM.DIST (NEGB\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\/negbinom-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:33+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 NEGBINOM.DIST (NEGB\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=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/negbinom-dist\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/negbinom-dist\/\",\"name\":\"Excel'de NEGBINOM.DIST (NEGB\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:32:33+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da NEGBINOM.DIST (NEGB\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\/negbinom-dist\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/negbinom-dist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/negbinom-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\":\"NEGB\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 NEGBINOM.DIST (NEGB\u0130NOM.DA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da NEGBINOM.DIST (NEGB\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\/negbinom-dist\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de NEGBINOM.DIST (NEGB\u0130NOM.DA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da NEGBINOM.DIST (NEGB\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\/negbinom-dist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:32:33+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de NEGBINOM.DIST (NEGB\u0130NOM.DA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/negbinom-dist\/","url":"https:\/\/functiontranslator.com\/tr\/negbinom-dist\/","name":"Excel'de NEGBINOM.DIST (NEGB\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:32:33+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da NEGBINOM.DIST (NEGB\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\/negbinom-dist\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/negbinom-dist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/negbinom-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":"NEGB\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\/15549","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=15549"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15549\/revisions"}],"predecessor-version":[{"id":26817,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15549\/revisions\/26817"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15549"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15549"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15549"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}