{"id":15519,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/lognorm-dag\/"},"modified":"2021-02-25T16:31:04","modified_gmt":"2021-02-25T16:31:04","slug":"lognorm-dist","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/lognorm-dist\/","title":{"rendered":"LOGNORM.DA\u011e"},"content":{"rendered":"

LOGNORM.DIST (Microsoft Excel’de) ve LOGNORM.DA\u011e (Google Sheets’te T\u00fcrk\u00e7e versiyon) i\u015flevleri, log-normal da\u011f\u0131l\u0131m\u0131n k\u00fcm\u00fclatif da\u011f\u0131l\u0131m fonksiyonunu (CDF) veya olas\u0131l\u0131k yo\u011funluk fonksiyonunu (PDF) hesaplamak i\u00e7in kullan\u0131l\u0131r. Log-normal da\u011f\u0131l\u0131m, bir de\u011fi\u015fkenin logaritmas\u0131n\u0131n normal da\u011f\u0131l\u0131m g\u00f6sterdi\u011fi bir s\u00fcrekli olas\u0131l\u0131k da\u011f\u0131l\u0131m\u0131d\u0131r. Bu i\u015flev, \u00f6zellikle finans ve m\u00fchendislik alanlar\u0131nda de\u011fi\u015fkenlerin \u00e7arp\u0131m\u0131na dayanan modellerde veya s\u00fcre\u00e7lerde s\u0131k\u00e7a tercih edilir.<\/p>\n

\u0130\u015flevin S\u00f6zdizimi<\/h2>\n

Excel ve Google Sheets i\u00e7in LOGNORM.DIST ve LOGNORM.DA\u011e i\u015flevlerinin s\u00f6zdizimi \u015f\u00f6yledir:<\/p>\n

  =LOGNORM.DIST(x, ort, std_sapma, k\u00fcm\u00fclatif) =LOGNORM.DA\u011e(x, ort, std_sapma, k\u00fcm\u00fclatif) <\/code> <\/pre>\n
    \n
  • x<\/b>: \u0130\u015flevin hesaplanmas\u0131nda kullan\u0131lan de\u011fer.<\/li>\n
  • ort<\/b>: Logaritman\u0131n ortalamas\u0131 (logaritmik \u00f6l\u00e7ekte).<\/li>\n
  • std_sapma<\/b>: Logaritman\u0131n standart sapmas\u0131 (logaritmik \u00f6l\u00e7ekte).<\/li>\n
  • k\u00fcm\u00fclatif<\/b>: \u0130\u015flevin k\u00fcm\u00fclatif da\u011f\u0131l\u0131m fonksiyonu (CDF) veya olas\u0131l\u0131k yo\u011funluk fonksiyonu (PDF) olarak hesaplan\u0131p hesaplanmayaca\u011f\u0131n\u0131 belirler. DO\u011eRU ise CDF, YANLI\u015e ise PDF hesaplan\u0131r.<\/li>\n<\/ul>\n
    \u00d6rnek Kullan\u0131mlar<\/h2>\n
    A\u015fa\u011f\u0131da LOGNORM.DIST ve LOGNORM.DA\u011e i\u015flevlerinin pratik senaryolarda nas\u0131l kullan\u0131ld\u0131\u011f\u0131n\u0131 inceleyece\u011fiz.<\/p>\n
    Yat\u0131r\u0131m Getirilerinin Analizi<\/h2>\n
    Kabul edelim ki, bir yat\u0131r\u0131m\u0131n gelecekteki de\u011feri log-normal da\u011f\u0131l\u0131mda. Ba\u015flang\u0131\u00e7 de\u011feri 1000 birim olan bu yat\u0131r\u0131mda, ortalama y\u0131ll\u0131k getiri %5 (logaritmik \u00f6l\u00e7ekte 0.05) ve y\u0131ll\u0131k standart sapma %10 (logaritmik \u00f6l\u00e7ekte 0.1) olarak varsay\u0131lmaktad\u0131r. 1 y\u0131l sonunda yat\u0131r\u0131m\u0131n 1100 birimi a\u015fma olas\u0131l\u0131\u011f\u0131n\u0131 hesaplamak istiyoruz.<\/p>\n
      =1 - LOGNORM.DIST(1100, 0.05, 0.1, TRUE) <\/code> <\/pre>\n
    Bu form\u00fcl, yat\u0131r\u0131m\u0131n bir y\u0131l sonra 1100 birimi ge\u00e7me olas\u0131l\u0131\u011f\u0131n\u0131 hesaplar. LOGNORM.DIST ile k\u00fcm\u00fclatif da\u011f\u0131l\u0131m fonksiyonu elde edilir ve 1100 birimin alt\u0131ndaki olas\u0131l\u0131k 1’den \u00e7\u0131kar\u0131larak hesaplan\u0131r.<\/p>\n
    \u00dcretim S\u00fcre\u00e7lerinde Hata Oranlar\u0131n\u0131n Tahmin Edilmesi<\/h2>\n
    Bir \u00fcretim s\u00fcrecinde kullan\u0131lan par\u00e7alar\u0131n boyutlar\u0131n\u0131n log-normal da\u011f\u0131l\u0131mda oldu\u011fu belirlenmi\u015f olsun. Burada ortalama \u00f6l\u00e7\u00fcm 5 cm ve standart sapma 0.1 cm (her ikisi de logaritmik \u00f6l\u00e7ekte). Bu par\u00e7alar\u0131n boyutlar\u0131n\u0131n, 5.2 cm’den az olma olas\u0131l\u0131\u011f\u0131n\u0131 hesaplamak istiyoruz.<\/p>\n
      =LOGNORM.DIST(5.2, 5, 0.1, TRUE) <\/code> <\/pre>\n
    Bu form\u00fcl, par\u00e7alar\u0131n 5.2 cm’den k\u0131sa olma ihtimalini hesaplar ve b\u00f6ylece \u00fcretim s\u00fcrecinin daha iyi bir teorik ve pratik analizi sa\u011flan\u0131r.<\/p>\n
    Genel olarak, LOGNORM.DIST ve LOGNORM.DA\u011e i\u015flevleri, belirli bir de\u011ferin alt\u0131nda veya \u00fcst\u00fcnde olma olas\u0131l\u0131\u011f\u0131n\u0131 de\u011ferlendirme imkan\u0131 sunar. Bu i\u015flevler, maliyet ve s\u00fcre analizleri gibi kritik metriklerin de\u011ferlendirilmesi gereken finansal analizlerden, \u00fcretim s\u00fcre\u00e7lerinin optimizasyonuna kadar \u00e7ok \u00e7e\u015fitli alanlarda kullan\u0131labilir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Logaritmik normal k\u00fcm\u00fclatif 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-15519","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nExcel'de LOGNORM.DIST (LOGNORM.DA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da LOGNORM.DIST (LOGNORM.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\/lognorm-dist\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de LOGNORM.DIST (LOGNORM.DA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da LOGNORM.DIST (LOGNORM.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\/lognorm-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:31:04+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 LOGNORM.DIST (LOGNORM.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\/lognorm-dist\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/lognorm-dist\/\",\"name\":\"Excel'de LOGNORM.DIST (LOGNORM.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:31:04+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da LOGNORM.DIST (LOGNORM.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\/lognorm-dist\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/lognorm-dist\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/lognorm-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\":\"LOGNORM.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 LOGNORM.DIST (LOGNORM.DA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da LOGNORM.DIST (LOGNORM.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\/lognorm-dist\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de LOGNORM.DIST (LOGNORM.DA\u011e) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da LOGNORM.DIST (LOGNORM.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\/lognorm-dist\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:31:04+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de LOGNORM.DIST (LOGNORM.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\/lognorm-dist\/","url":"https:\/\/functiontranslator.com\/tr\/lognorm-dist\/","name":"Excel'de LOGNORM.DIST (LOGNORM.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:31:04+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da LOGNORM.DIST (LOGNORM.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\/lognorm-dist\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/lognorm-dist\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/lognorm-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":"LOGNORM.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\/15519","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=15519"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15519\/revisions"}],"predecessor-version":[{"id":26787,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15519\/revisions\/26787"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15519"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15519"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15519"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}