{"id":15550,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/negbinomdag\/"},"modified":"2021-02-25T16:32:35","modified_gmt":"2021-02-25T16:32:35","slug":"negbinomdist","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/negbinomdist\/","title":{"rendered":"NEGB\u0130NOMDA\u011e"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, istatistiksel analizler yapmak i\u00e7in kullan\u0131lan g\u00fc\u00e7l\u00fc ara\u00e7lard\u0131r ve pek \u00e7ok yararl\u0131 fonksiyon i\u00e7erirler. Bu ara\u00e7larda bulunan NEGBINOMDIST<\/strong> veya T\u00fcrk\u00e7ede NEGB\u0130NOMDA\u011e<\/strong> fonksiyonu, olas\u0131l\u0131klar\u0131 hesaplamak i\u00e7in negatif binom da\u011f\u0131l\u0131m\u0131ndan yararlan\u0131r. Bu fonksiyon, belirlenen ba\u015far\u0131 say\u0131s\u0131na ula\u015f\u0131lana kadar ger\u00e7ekle\u015fen ba\u015far\u0131s\u0131z deneme say\u0131s\u0131n\u0131n olas\u0131l\u0131\u011f\u0131n\u0131 belirlemek i\u00e7in \u00f6zellikle kullan\u0131\u015fl\u0131d\u0131r.<\/p>\n

Fonksiyonun S\u00f6zdizimi ve \u00d6rnekleri<\/h2>\n

NEGB\u0130NOMDA\u011e fonksiyonunun genel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

=NEGBINOMDIST(r, ba\u015far\u0131_say\u0131s\u0131, ba\u015far\u0131_olas\u0131l\u0131\u011f\u0131, k\u00fcm\u00fclatif)<\/code><\/pre>\n
    \n
  • r<\/strong>: Ba\u015far\u0131s\u0131z deneme say\u0131s\u0131 (s\u0131f\u0131r veya daha b\u00fcy\u00fck bir tamsay\u0131).<\/li>\n
  • ba\u015far\u0131_say\u0131s\u0131<\/strong>: Ba\u015far\u0131ya ula\u015fmak i\u00e7in ge\u00e7ilmesi gereken minimal ba\u015far\u0131l\u0131 deneme say\u0131s\u0131 (pozitif tamsay\u0131).<\/li>\n
  • ba\u015far\u0131_olas\u0131l\u0131\u011f\u0131<\/strong>: Her denemede ba\u015far\u0131 elde etme olas\u0131l\u0131\u011f\u0131 (0 ile 1 aras\u0131nda bir de\u011fer).<\/li>\n
  • k\u00fcm\u00fclatif<\/strong>: Bu de\u011fer TRUE ise fonksiyon, k\u00fcm\u00fclatif da\u011f\u0131l\u0131m fonksiyonunu; FALSE ise olas\u0131l\u0131k k\u00fctle fonksiyonunu hesaplar.<\/li>\n<\/ul>\n
    \u0130\u015fte baz\u0131 \u00f6rnekler:<\/p>\n
    =NEGBINOMDIST(3, 2, 0.8, FALSE)  =NEGBINOMDIST(5, 3, 0.5, TRUE)  <\/code><\/pre>\n
    Uygulama Senaryolar\u0131<\/h2>\n
    Bu fonksiyonun kullan\u0131m\u0131na dair uygulama senaryolar\u0131 verelim:<\/p>\n
    1. Pazarlama Kampanyas\u0131n\u0131n Etkinli\u011finin De\u011ferlendirilmesi<\/h2>\n
    Bir pazarlama ekibi, yeni bir \u00fcr\u00fcn\u00fcn lansman\u0131nda belirli bir sat\u0131\u015f hedefine ula\u015f\u0131lmas\u0131 i\u00e7in NEGB\u0130NOMDA\u011e fonksiyonundan yararlanabilir. Bu fonksiyon, ilk ba\u015far\u0131ya ula\u015fana kadar ka\u00e7 potansiyel m\u00fc\u015fteriyle ileti\u015fim kurulmas\u0131 gerekti\u011fini belirlemelerine yard\u0131mc\u0131 olabilir.<\/p>\n
    \u00d6rnek Problem:<\/p>\n
    \u015eirket, \u00fcr\u00fcn reklamlar\u0131na t\u0131klanma oran\u0131n\u0131n %10 oldu\u011funu belirlemi\u015ftir. 3 ba\u015far\u0131l\u0131 sat\u0131\u015f yapabilmek i\u00e7in gerekli minimum t\u00fcketici say\u0131s\u0131n\u0131 hesaplay\u0131n.<\/code><\/pre>\n
    \u00c7\u00f6z\u00fcm:<\/p>\n
      \n
    • Kullan\u0131lacak form\u00fcl: =NEGBINOMDIST(r, 3, 0.10, TRUE)<\/code><\/li>\n
    • Farkl\u0131 ‘r’ de\u011ferleri i\u00e7in bu form\u00fcl\u00fc test ederek, %50 olas\u0131l\u0131k s\u0131n\u0131r\u0131n\u0131 ge\u00e7ti\u011fi noktay\u0131 bulun.<\/li>\n<\/ul>\n
      2. Ar-Ge Projesinde Beklenen Deneme Say\u0131s\u0131n\u0131n Hesaplanmas\u0131<\/h2>\n
      Ar-Ge departman\u0131, ba\u015far\u0131l\u0131 sonu\u00e7lar elde edene kadar deneysel \u00e7al\u0131\u015fmalar y\u00fcr\u00fct\u00fcr. Beklenen ba\u015far\u0131s\u0131zl\u0131k say\u0131s\u0131n\u0131 tahmin etmek i\u00e7in NEGB\u0130NOMDA\u011e fonksiyonu yararl\u0131 olabilir.<\/p>\n
      \u00d6rnek Problem:<\/p>\n
      %20 ba\u015far\u0131 \u015fans\u0131 olan bir dizi deneyde, 2 ba\u015far\u0131l\u0131 sonu\u00e7 al\u0131nana kadar gereken deneme say\u0131s\u0131n\u0131 hesaplay\u0131n.<\/code><\/pre>\n
      \u00c7\u00f6z\u00fcm:<\/p>\n
        \n
      • Y\u00f6ntem: =NEGBINOMDIST(r, 2, 0.20, TRUE)<\/code> form\u00fcl\u00fcn\u00fc kullanarak uygun k\u00fcm\u00fclatif de\u011fere ula\u015f\u0131ncaya dek ‘r’ de\u011ferini art\u0131r\u0131n.<\/li>\n<\/ul>\n
        Yukar\u0131da verilen \u00f6rnekler, NEGB\u0130NOMDA\u011e fonksiyonunun hem teoride hem de pratikte nas\u0131l kullan\u0131labilece\u011fine dair fikir sa\u011flamaktad\u0131r. Bu fonksiyon, belirsizlik bar\u0131nd\u0131ran durumlar i\u00e7in \u00f6nemli kararlar al\u0131rken farkl\u0131 end\u00fcstri sekt\u00f6rlerinde b\u00fcy\u00fck \u00f6neme sahiptir.<\/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":[584],"tags":[],"class_list":["post-15550","post","type-post","status-publish","format-standard","hentry","category-uyumluluk"],"acf":[],"yoast_head":"\nExcel'de NEGBINOMDIST (NEGB\u0130NOMDA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da NEGBINOMDIST (NEGB\u0130NOMDA\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\/negbinomdist\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de NEGBINOMDIST (NEGB\u0130NOMDA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da NEGBINOMDIST (NEGB\u0130NOMDA\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\/negbinomdist\/\" \/>\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:35+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 NEGBINOMDIST (NEGB\u0130NOMDA\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\/negbinomdist\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/negbinomdist\/\",\"name\":\"Excel'de NEGBINOMDIST (NEGB\u0130NOMDA\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:35+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da NEGBINOMDIST (NEGB\u0130NOMDA\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\/negbinomdist\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/negbinomdist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/negbinomdist\/#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\":\"NEGB\u0130NOMDA\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 NEGBINOMDIST (NEGB\u0130NOMDA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da NEGBINOMDIST (NEGB\u0130NOMDA\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\/negbinomdist\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de NEGBINOMDIST (NEGB\u0130NOMDA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da NEGBINOMDIST (NEGB\u0130NOMDA\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\/negbinomdist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:32:35+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de NEGBINOMDIST (NEGB\u0130NOMDA\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\/negbinomdist\/","url":"https:\/\/functiontranslator.com\/tr\/negbinomdist\/","name":"Excel'de NEGBINOMDIST (NEGB\u0130NOMDA\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:35+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da NEGBINOMDIST (NEGB\u0130NOMDA\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\/negbinomdist\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/negbinomdist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/negbinomdist\/#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":"NEGB\u0130NOMDA\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\/15550","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=15550"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15550\/revisions"}],"predecessor-version":[{"id":26818,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15550\/revisions\/26818"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15550"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15550"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15550"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}