{"id":15592,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/poisson\/"},"modified":"2021-02-25T16:33:49","modified_gmt":"2021-02-25T16:33:49","slug":"poisson","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/poisson\/","title":{"rendered":"POISSON"},"content":{"rendered":"

POISSON i\u015flevi, istatistiki analizler ve olas\u0131l\u0131k hesaplamalar\u0131nda s\u0131k\u00e7a kullan\u0131lan \u00f6nemli bir i\u015flevdir. Hem Microsoft Excel (MS Excel) hem de Google E-Tablolar’da, belirli bir aral\u0131kta belirli bir olay\u0131n ka\u00e7 kez meydana gelece\u011fini tahmin etmeye yarayan bir da\u011f\u0131l\u0131m fonksiyonudur. Bu i\u015flev, \u00f6zellikle olaylar\u0131n belirli bir oranda rastgele ger\u00e7ekle\u015fti\u011fi durumlarda kullan\u0131\u015fl\u0131d\u0131r. <\/p>\n

\u0130\u015flevin S\u00f6zdizimi ve Temel Kullan\u0131m\u0131<\/h2>\n
POISSON.DAGILIM(x, lambda, k\u00fcm\u00fclatif)<\/code><\/pre>\n
    \n
  • x<\/strong>: Olay\u0131n ger\u00e7ekle\u015fme say\u0131s\u0131<\/li>\n
  • lambda<\/strong>: Ortalama olay beklenme say\u0131s\u0131 (ortalama h\u0131z)<\/li>\n
  • k\u00fcm\u00fclatif<\/strong>: Hesaplama t\u00fcr\u00fcn\u00fc belirleyen mant\u0131ksal bir de\u011fer. TRUE ise i\u015flev, k\u00fcm\u00fclatif da\u011f\u0131l\u0131m fonksiyonu de\u011ferini hesaplar; FALSE ise olas\u0131l\u0131k k\u00fctle fonksiyonunu hesaplar.<\/li>\n<\/ul>\n
    K\u00fcm\u00fclatif de\u011feri TRUE<\/code> oldu\u011funda, i\u015flev, X say\u0131s\u0131na kadar olan olaylar i\u00e7in k\u00fcm\u00fclatif olas\u0131l\u0131\u011f\u0131 verir. K\u00fcm\u00fclatif de\u011feri FALSE<\/code> oldu\u011funda ise, tam olarak X say\u0131da olay\u0131n olas\u0131l\u0131\u011f\u0131n\u0131 verir.<\/p>\n
    Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n
    POISSON fonksiyonu; m\u00fc\u015fteri hizmetleri, \u00e7a\u011fr\u0131 merkezi, trafik ak\u0131\u015f\u0131 analizi, biyoloji ve finans gibi bir\u00e7ok alanda kullan\u0131labilir. \u0130\u015fte bu i\u015flevi kullanman\u0131n iki pratik yolu:<\/p>\n
    \u00c7a\u011fr\u0131 Merkezi Gelen Aramalar\u0131n Analizi<\/h3>\n
    Bir \u00e7a\u011fr\u0131 merkezi y\u00f6neticisi, ortalama olarak saatte 10 arama ald\u0131\u011f\u0131n\u0131 biliyor ve bir saat i\u00e7inde tam olarak 15 arama al\u0131nma olas\u0131l\u0131\u011f\u0131n\u0131 \u00f6\u011frenmek istiyor:<\/p>\n
    =POISSON.DAGILIM(15, 10, FALSE)<\/code><\/pre>\n
    Bu form\u00fcl, bir saat i\u00e7inde tam olarak 15 araman\u0131n gelme olas\u0131l\u0131\u011f\u0131n\u0131 hesaplar. POISSON fonksiyonunun FALSE<\/code> kullan\u0131lmas\u0131, bu spesifik say\u0131da olay\u0131n olas\u0131l\u0131\u011f\u0131n\u0131 verir.<\/p>\n
    Biyolojik Deneylerde Olay Say\u0131s\u0131 Tahmini<\/h3>\n
    Bir biyolog, laboratuvar\u0131nda belirli bir bakteri k\u00fclt\u00fcr\u00fcnde ortalama 20 koloni b\u00fcy\u00fcmesini beklemekte ve en \u00e7ok 25 koloni b\u00fcy\u00fcmesi olas\u0131l\u0131\u011f\u0131n\u0131 merak etmektedir:<\/p>\n
    =POISSON.DAGILIM(25, 20, TRUE)<\/code><\/pre>\n
    Bu hesaplama, en fazla 25 koloni b\u00fcy\u00fcme olas\u0131l\u0131\u011f\u0131n\u0131 verecektir. Burada, TRUE<\/code> de\u011feri kullan\u0131larak, 0’dan 25’e kadar olan koloni say\u0131s\u0131 i\u00e7in toplam olas\u0131l\u0131k hesaplanmaktad\u0131r.<\/p>\n
    Her iki \u00f6rnekte de g\u00f6r\u00fcld\u00fc\u011f\u00fc \u00fczere, POISSON i\u015flevi belirli bir olaylar\u0131n belirli bir oranla meydana gelme olas\u0131l\u0131\u011f\u0131n\u0131 anlamak i\u00e7in kullan\u0131\u015fl\u0131d\u0131r. \u0130\u015flevin sa\u011flad\u0131\u011f\u0131 detaylar, planlama ve risk y\u00f6netimi s\u00fcre\u00e7lerinde kritik rol oynayabilir.<\/p>\n
    Genel Yorumlar<\/h2>\n
    POISSON i\u015flevi, \u00f6zellikle az say\u0131da ve ba\u011f\u0131ms\u0131z olaylar\u0131n oldu\u011fu durumlarda \u00e7ok etkilidir. Lambda de\u011feri ne kadar y\u00fcksek olursa, da\u011f\u0131l\u0131m o kadar normal da\u011f\u0131l\u0131ma yakla\u015f\u0131r; bu durum, i\u015flevin daha geni\u015f bir uygulama yelpazesine sahip oldu\u011funu g\u00f6sterir. Ancak, lambda de\u011ferinin d\u00fc\u015f\u00fck oldu\u011fu durumlarda ayr\u0131k olas\u0131l\u0131klar \u00f6nemli hale gelir ve bu da \u00e7e\u015fitli senaryolarda farkl\u0131 stratejilerin uygulanmas\u0131n\u0131 gerektirebilir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Poisson 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-15592","post","type-post","status-publish","format-standard","hentry","category-uyumluluk"],"acf":[],"yoast_head":"\nExcel'de POISSON Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da POISSON 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\/poisson\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de POISSON Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da POISSON 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\/poisson\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:33:49+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 POISSON 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\/poisson\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/poisson\/\",\"name\":\"Excel'de POISSON Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:53+00:00\",\"dateModified\":\"2021-02-25T16:33:49+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da POISSON 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\/poisson\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/poisson\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/poisson\/#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\":\"POISSON\"}]},{\"@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 POISSON Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da POISSON 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\/poisson\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de POISSON Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da POISSON 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\/poisson\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:33:49+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de POISSON 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\/poisson\/","url":"https:\/\/functiontranslator.com\/tr\/poisson\/","name":"Excel'de POISSON Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:53+00:00","dateModified":"2021-02-25T16:33:49+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da POISSON 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\/poisson\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/poisson\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/poisson\/#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":"POISSON"}]},{"@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\/15592","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=15592"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15592\/revisions"}],"predecessor-version":[{"id":26860,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15592\/revisions\/26860"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15592"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15592"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15592"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}