{"id":15400,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/ustel-dag\/"},"modified":"2021-02-25T16:26:41","modified_gmt":"2021-02-25T16:26:41","slug":"expon-dist","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/expon-dist\/","title":{"rendered":"\u00dcSTEL.DA\u011e"},"content":{"rendered":"

Microsoft Excel ve Google Sheets\u2019te yer alan \u00fcstel da\u011f\u0131l\u0131m fonksiyonu, s\u00fcre\u00e7ler aras\u0131ndaki zaman aral\u0131klar\u0131n\u0131 modellemek amac\u0131yla kullan\u0131lan s\u00fcrekli olas\u0131l\u0131k da\u011f\u0131l\u0131mlar\u0131n\u0131 ifade eden bir fonksiyondur. Bu fonksiyon, belirli bir s\u00fcre zarf\u0131nda meydana gelen olaylar\u0131n frekans\u0131n\u0131 de\u011ferlendirmek i\u00e7in kullan\u0131l\u0131r.<\/p>\n

\u00dcstel Da\u011f\u0131l\u0131m Fonksiyonunun S\u00f6zdizimi<\/h2>\n

Excel ve Google Sheets\u2019te bu fonksiyonun s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

=\u00dcSTEL.DA\u011e(x, lambda, k\u00fcm\u00fclatif)<\/code><\/pre>\n
Bu parametreler \u015fu \u015fekilde tan\u0131mlan\u0131r:<\/p>\n
    \n
  • x<\/strong>: Olaylar\u0131n ger\u00e7ekle\u015fme s\u00fcresi veya beklenen zaman aral\u0131\u011f\u0131d\u0131r ve x de\u011feri 0 veya daha b\u00fcy\u00fck olmal\u0131d\u0131r.<\/li>\n
  • lambda<\/strong>: Birim zaman ba\u015f\u0131na d\u00fc\u015fen ortalama olay say\u0131s\u0131n\u0131 belirten orand\u0131r ve lambda de\u011feri s\u0131f\u0131rdan b\u00fcy\u00fck olmal\u0131d\u0131r.<\/li>\n
  • k\u00fcm\u00fclatif<\/strong>: Fonksiyonun k\u00fcm\u00fclatif da\u011f\u0131l\u0131m fonksiyonunu (DO\u011eRU) veya olas\u0131l\u0131k yo\u011funluk fonksiyonunu (YANLI\u015e) hesaplay\u0131p hesaplamayaca\u011f\u0131n\u0131 belirten mant\u0131ksal bir de\u011ferdir.<\/li>\n<\/ul>\n
    Pratik Uygulamalar<\/h2>\n
    \u00dcstel da\u011f\u0131l\u0131m fonksiyonu, a\u015fa\u011f\u0131daki gibi farkl\u0131 senaryolarda kullan\u0131labilir:<\/p>\n
      \n
    1. Telekom\u00fcnikasyon<\/strong>: Bir \u00e7a\u011fr\u0131 merkezindeki aramalar aras\u0131ndaki s\u00fcrelerin modellenmesi.<\/li>\n
    2. Teknik Servis<\/strong>: Bir \u00fcr\u00fcn\u00fcn ar\u0131zalanma s\u00fcresinin tahmin edilmesi.<\/li>\n<\/ol>\n
      Detayl\u0131 \u00c7\u00f6z\u00fcm \u00d6rnekleri<\/h2>\n
      \u00d6rnek 1: Bir \u00e7a\u011fr\u0131 merkezi dakikada ortalama 3 arama almaktad\u0131r. Bir sonraki araman\u0131n 2 dakika i\u00e7inde gelme olas\u0131l\u0131\u011f\u0131n\u0131 hesaplayal\u0131m.<\/p>\n
      =\u00dcSTEL.DA\u011e(2, 3, DO\u011eRU)<\/code><\/pre>\n
      Bu \u00f6rnekte, “lambda” de\u011feri dakika ba\u015f\u0131na 3 arama oldu\u011fu i\u00e7in, 2 dakikal\u0131k s\u00fcre boyunca bu oranla hesaplama yap\u0131l\u0131r. “DO\u011eRU” se\u00e7ene\u011fi kullan\u0131larak k\u00fcm\u00fclatif da\u011f\u0131l\u0131m fonksiyonu se\u00e7ilmi\u015ftir, ki bu da 0’dan 2 dakikaya kadar olan s\u00fcrede en az bir arama yap\u0131lma olas\u0131l\u0131\u011f\u0131n\u0131 verir.<\/p>\n
      \u00d6rnek 2: Bilinen bir bilgisayar\u0131n ortalama 5 y\u0131l boyunca ar\u0131zas\u0131z \u00e7al\u0131\u015ft\u0131\u011f\u0131 d\u00fc\u015f\u00fcn\u00fcld\u00fc\u011f\u00fcnde, 3 y\u0131l i\u00e7inde ar\u0131zalanma olas\u0131l\u0131\u011f\u0131n\u0131 hesaplayal\u0131m.<\/p>\n
      =\u00dcSTEL.DA\u011e(3, 1\/5, DO\u011eRU)<\/code><\/pre>\n
      Burada “lambda” de\u011feri, ortalama ar\u0131za s\u00fcresinin 5 y\u0131l oldu\u011funu g\u00f6stermek i\u00e7in 1\/5 olarak belirlenmi\u015ftir. Bu, y\u0131ll\u0131k 0.2 ar\u0131za oran\u0131na tekab\u00fcl eder. Burada da k\u00fcm\u00fclatif da\u011f\u0131l\u0131m kullan\u0131larak 3 y\u0131l i\u00e7inde ar\u0131zalanma olas\u0131l\u0131\u011f\u0131 hesaplanm\u0131\u015ft\u0131r.<\/p>\n
      \u0130statistiki Modelleme<\/h2>\n
      \u00dcstel da\u011f\u0131l\u0131m, bilim ve m\u00fchendislik dallar\u0131nda zamanla ilgili s\u00fcre\u00e7lerin modellenmesinde yayg\u0131n olarak kullan\u0131l\u0131r. \u00d6zellikle sistem performans\u0131n\u0131n ve ar\u0131za s\u00fcrelerinin tahmin edilmesinde b\u00fcy\u00fck \u00f6nem ta\u015f\u0131r. Excel ve Google Sheets\u2019te bu fonksiyonun do\u011fru parametrelerle kullan\u0131lmas\u0131, veri analizi ve modelleme konusunda do\u011frulu\u011fu art\u0131rabilir.<\/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":[582],"tags":[],"class_list":["post-15400","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nExcel'de EXPON.DIST (\u00dcSTEL.DA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da EXPON.DIST (\u00dcSTEL.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\/expon-dist\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de EXPON.DIST (\u00dcSTEL.DA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da EXPON.DIST (\u00dcSTEL.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\/expon-dist\/\" \/>\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:41+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 EXPON.DIST (\u00dcSTEL.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=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/expon-dist\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/expon-dist\/\",\"name\":\"Excel'de EXPON.DIST (\u00dcSTEL.DA\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:41+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da EXPON.DIST (\u00dcSTEL.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\/expon-dist\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/expon-dist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/expon-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\":\"\u00dcSTEL.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 EXPON.DIST (\u00dcSTEL.DA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da EXPON.DIST (\u00dcSTEL.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\/expon-dist\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de EXPON.DIST (\u00dcSTEL.DA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da EXPON.DIST (\u00dcSTEL.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\/expon-dist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:26:41+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de EXPON.DIST (\u00dcSTEL.DA\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\/expon-dist\/","url":"https:\/\/functiontranslator.com\/tr\/expon-dist\/","name":"Excel'de EXPON.DIST (\u00dcSTEL.DA\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:41+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da EXPON.DIST (\u00dcSTEL.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\/expon-dist\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/expon-dist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/expon-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":"\u00dcSTEL.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\/15400","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=15400"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15400\/revisions"}],"predecessor-version":[{"id":26668,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15400\/revisions\/26668"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15400"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15400"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}