{"id":15401,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/usteldag\/"},"modified":"2021-02-25T16:26:43","modified_gmt":"2021-02-25T16:26:43","slug":"expondist","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/expondist\/","title":{"rendered":"\u00dcSTELDA\u011e"},"content":{"rendered":"

\u00dcstel Da\u011f\u0131l\u0131m Fonksiyonunun Genel Bak\u0131\u015f\u0131<\/h2>\n

\u00dcstel da\u011f\u0131l\u0131m fonksiyonu, istatistik ve olas\u0131l\u0131k teorisinde s\u0131kl\u0131kla kar\u015f\u0131la\u015f\u0131lan bir fonksiyondur ve s\u00fcrekli olas\u0131l\u0131k da\u011f\u0131l\u0131mlar\u0131n\u0131 modellemek i\u00e7in kullan\u0131l\u0131r. Microsoft Excel ve Google E-Tablolar’da bu fonksiyon, EXPONDIST<\/code> (Microsoft Excel) veya EXPON.DIST<\/code> (Google E-Tablolar ve yeni Excel s\u00fcr\u00fcmleri) olarak ge\u00e7er. Bu fonksiyon, belirli bir s\u00fcre i\u00e7erisinde bir olay\u0131n meydana gelme olas\u0131l\u0131\u011f\u0131n\u0131 hesaplamak i\u00e7in kullan\u0131l\u0131r.<\/p>\n

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

EXPONDIST<\/code> fonksiyonunun temel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

 EXPONDIST(x, lambda, cumulative) <\/code> <\/pre>\n
    \n
  • x<\/strong>: Olay\u0131n ger\u00e7ekle\u015fme s\u00fcresi veya s\u00fcrecinin de\u011feri. Bu de\u011fer 0 veya daha b\u00fcy\u00fck olmal\u0131d\u0131r.<\/li>\n
  • lambda<\/strong>: Oran parametresi, yani birim zaman ba\u015f\u0131na olay say\u0131s\u0131. Lambda de\u011feri pozitif olmal\u0131d\u0131r.<\/li>\n
  • cumulative<\/strong>: Da\u011f\u0131l\u0131m\u0131n k\u00fcm\u00fclatif (toplam) olup olmad\u0131\u011f\u0131n\u0131 belirten mant\u0131ksal bir de\u011fer. TRUE ise k\u00fcm\u00fclatif da\u011f\u0131l\u0131m fonksiyonu, FALSE ise olas\u0131l\u0131k yo\u011funluk fonksiyonu hesaplan\u0131r.<\/li>\n<\/ul>\n
    Pratik Uygulama Senaryolar\u0131<\/h2>\n
    EXPONDIST fonksiyonu, \u00f6zellikle sistem performans\u0131 analizi ve s\u00fcre\u00e7 optimizasyonu gibi alanlarda kullan\u0131labilir. \u0130ki farkl\u0131 senaryoda bu fonksiyonun nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6relim:<\/p>\n
    Bir \u00c7a\u011fr\u0131 Merkezi i\u00e7in Bekleme S\u00fcresi Analizi<\/h3>\n
    Bir \u00e7a\u011fr\u0131 merkezinde m\u00fc\u015fterinin bir sonraki \u00e7a\u011fr\u0131y\u0131 almas\u0131n\u0131 bekledi\u011fi s\u00fcre s\u00fcrekli olarak izlenir. E\u011fer \u00e7a\u011fr\u0131lar, ortalama 5 dakikada bir gelirse, m\u00fc\u015fterilerin bekleme s\u00fcresi \u00fcstel da\u011f\u0131l\u0131mla modelleyebilir. Burada lambda (ortalama \u00e7a\u011fr\u0131 oran\u0131) = 1\/5 = 0.2 olur.<\/p>\n
    Bir m\u00fc\u015fterinin en az 3 dakika beklemesi gerekti\u011fi olas\u0131l\u0131\u011f\u0131:<\/p>\n
      =1 - EXPONDIST(3, 0.2, TRUE) <\/code> <\/pre>\n
    Bu hesaplama, m\u00fc\u015fterinin en az 3 dakika bekleyece\u011fi olas\u0131l\u0131\u011f\u0131 verir.<\/p>\n
    \u00dcr\u00fcn\u00fcn Bozulma S\u00fcresi Tahmini<\/h3>\n
    Bir elektronik \u00fcr\u00fcn\u00fcn ortalama 1000 saat sonra bozuldu\u011funu varsayal\u0131m. Lambda de\u011feri, bu durumda 1\/1000 = 0.001 olarak hesaplan\u0131r. \u00dcr\u00fcn\u00fcn 500 saat i\u00e7erisinde bozulma olas\u0131l\u0131\u011f\u0131n\u0131 hesaplamak isteyelim.<\/p>\n
      =EXPONDIST(500, 0.001, TRUE) <\/code> <\/pre>\n
    Bu hesaplama, \u00fcr\u00fcn\u00fcn 500 saat i\u00e7inde bozulma ihtimalini verir ve dayan\u0131kl\u0131l\u0131k analizlerinde kullan\u0131labilir.<\/p>\n
    Sonu\u00e7lar ve Yorumlar<\/h2>\n
    EXPONDIST<\/code> fonksiyonu, \u00fcstel da\u011f\u0131l\u0131m\u0131 kullanarak \u00e7e\u015fitli ger\u00e7ek d\u00fcnya durumlar\u0131nda olas\u0131l\u0131klar\u0131 hesaplaman\u0131n yan\u0131 s\u0131ra, risk analizi ve s\u00fcre\u00e7 iyile\u015ftirme \u00e7al\u0131\u015fmalar\u0131nda da etkili bir ara\u00e7t\u0131r. Fonksiyon, verilen ‘lambda’ de\u011ferine g\u00f6re olaylar\u0131n ne s\u0131kl\u0131kla ger\u00e7ekle\u015fece\u011fini modelleyebilir ve yukar\u0131da belirtilen \u00f6rnekler, fonksiyonun uygulanabilirli\u011fini ve faydas\u0131n\u0131 g\u00f6stermektedir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    \u00dcstel da\u011f\u0131l\u0131m\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-15401","post","type-post","status-publish","format-standard","hentry","category-uyumluluk"],"acf":[],"yoast_head":"\nExcel'de EXPONDIST (\u00dcSTELDA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da EXPONDIST (\u00dcSTELDA\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\/expondist\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de EXPONDIST (\u00dcSTELDA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da EXPONDIST (\u00dcSTELDA\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\/expondist\/\" \/>\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:26:43+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 EXPONDIST (\u00dcSTELDA\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\/expondist\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/expondist\/\",\"name\":\"Excel'de EXPONDIST (\u00dcSTELDA\u011e) 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:26:43+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da EXPONDIST (\u00dcSTELDA\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\/expondist\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/expondist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/expondist\/#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\":\"\u00dcSTELDA\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 EXPONDIST (\u00dcSTELDA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da EXPONDIST (\u00dcSTELDA\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\/expondist\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de EXPONDIST (\u00dcSTELDA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da EXPONDIST (\u00dcSTELDA\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\/expondist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:26:43+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de EXPONDIST (\u00dcSTELDA\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\/expondist\/","url":"https:\/\/functiontranslator.com\/tr\/expondist\/","name":"Excel'de EXPONDIST (\u00dcSTELDA\u011e) 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:26:43+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da EXPONDIST (\u00dcSTELDA\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\/expondist\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/expondist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/expondist\/#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":"\u00dcSTELDA\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\/15401","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=15401"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15401\/revisions"}],"predecessor-version":[{"id":26669,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15401\/revisions\/26669"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15401"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}