{"id":15517,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/lot\/"},"modified":"2021-02-25T16:30:59","modified_gmt":"2021-02-25T16:30:59","slug":"logest","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/logest\/","title":{"rendered":"LOT"},"content":{"rendered":"<h2>Nedir Bu \u0130\u015flev ve Nas\u0131l Kullan\u0131l\u0131r?<\/h2>\n<p><code>LOGEST<\/code> i\u015flevi, bir veya daha fazla ba\u011f\u0131ms\u0131z de\u011fi\u015fken dizisiyle en uygun \u00fcssel (logaritmik) regresyonu hesaplamak i\u00e7in kullan\u0131l\u0131r. Excel ve Google E-Tablolar&#8217;da, \u00f6zellikle finansal veriler \u00fczerinde trend analizleri yaparken bu i\u015flevden faydalanabilirsiniz. Birden fazla ba\u011f\u0131ms\u0131z de\u011fi\u015fken desteklenir, b\u00f6ylece \u00e7oklu regresyon analizleri de m\u00fcmk\u00fcnd\u00fcr.<\/p>\n<h2>\u0130\u015flevin S\u00f6zdizimi ve Parametreleri<\/h2>\n<pre> <code> LOGEST(known_y's, [known_x's], [const], [stats]) <\/code> <\/pre>\n<ul>\n<li><strong>known_y&#8217;s<\/strong>: Ba\u011f\u0131ml\u0131 de\u011fi\u015fken y&#8217;nin bilinen de\u011ferlerini i\u00e7eren dizi veya aral\u0131k.<\/li>\n<li><strong>[known_x&#8217;s]<\/strong>: \u0130ste\u011fe ba\u011fl\u0131. Ba\u011f\u0131ms\u0131z de\u011fi\u015fken x&#8217;in bilinen de\u011ferlerini i\u00e7eren dizi veya aral\u0131k. Belirtilmezse, y de\u011ferlerinin s\u0131ra numaralar\u0131 kullan\u0131l\u0131r.<\/li>\n<li><strong>[const]<\/strong>: \u0130ste\u011fe ba\u011fl\u0131. TRUE (varsay\u0131lan) ise, b sabiti hesaplamaya dahil edilir. FALSE ise, b = 1 olarak kabul edilir.<\/li>\n<li><strong>[stats]<\/strong>: \u0130ste\u011fe ba\u011fl\u0131. TRUE ise, i\u015flev ek regresyon istatistikleri d\u00f6nd\u00fcr\u00fcr; FALSE (varsay\u0131lan) ise yaln\u0131zca LOGEST sonu\u00e7lar\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/li>\n<\/ul>\n<h2>Pratik G\u00f6rev 1: Pazar B\u00fcy\u00fcme Oran\u0131n\u0131 Tahmin Etmek<\/h2>\n<p>\u015eirketiniz son 5 y\u0131l i\u00e7inde y\u0131ll\u0131k sat\u0131\u015f verilerine sahip ve gelecek y\u0131l i\u00e7in b\u00fcy\u00fcme oran\u0131n\u0131 tahmin etmek istiyorsunuz. Y\u0131llara g\u00f6re sat\u0131\u015flar\u0131n\u0131z \u015f\u00f6yle:<\/p>\n<ul>\n<li>Y\u0131l 1: 100<\/li>\n<li>Y\u0131l 2: 150<\/li>\n<li>Y\u0131l 3: 225<\/li>\n<li>Y\u0131l 4: 338<\/li>\n<li>Y\u0131l 5: 507<\/li>\n<\/ul>\n<p>Excel veya Google E-Tablolar&#8217;da a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanarak gelecekteki b\u00fcy\u00fcme oran\u0131n\u0131 tahmin edebilirsiniz:<\/p>\n<pre> <code> =LOGEST(A2:A6) <\/code> <\/pre>\n<p>\u0130\u015flev, belirtilen y\u0131llar aras\u0131ndaki b\u00fcy\u00fcme oran\u0131n\u0131 y\u00fczde olarak verecektir. Daha sonra bu oran\u0131 kullanarak gelecek y\u0131llar\u0131n tahminlerini yapabilirsiniz.<\/p>\n<h2>Pratik G\u00f6rev 2: \u00c7oklu De\u011fi\u015fkenli Veri Setiyle \u00c7al\u0131\u015fmak<\/h2>\n<p>\u00c7e\u015fitli pazarlama kanallar\u0131ndan elde edilen veriler \u00fczerinde bir model olu\u015fturmak istiyorsunuz. Her bir pazarlama kanal\u0131ndan gelen m\u00fc\u015fteri say\u0131s\u0131 ile toplam sat\u0131\u015flar aras\u0131ndaki ili\u015fkiyi analiz etmek i\u00e7in \u00e7oklu logaritmik regresyon modeli kullanabilirsiniz. \u00d6rne\u011fin:<\/p>\n<ul>\n<li>Kanal 1&#8217;den gelen m\u00fc\u015fteri say\u0131s\u0131<\/li>\n<li>Kanal 2&#8217;den gelen m\u00fc\u015fteri say\u0131s\u0131<\/li>\n<li>Kanal 3&#8217;den gelen m\u00fc\u015fteri say\u0131s\u0131<\/li>\n<\/ul>\n<p>Bu verileri kullanarak, a\u015fa\u011f\u0131daki form\u00fcl ile bir model olu\u015fturabilirsiniz:<\/p>\n<pre> <code> =LOGEST(B2:B6, A2:C6, TRUE, TRUE) <\/code> <\/pre>\n<p>Bu form\u00fcl, her kanal\u0131n sat\u0131\u015flara etkisini de\u011ferlendirir ve size detayl\u0131 istatistikler sa\u011flar. Analizden elde edilen sonu\u00e7lar, pazarlama b\u00fct\u00e7esinin daha etkin bir \u015fekilde ayr\u0131lmas\u0131na yard\u0131mc\u0131 olabilir.<\/p>\n<p>Bu bilgiler, LOGEST i\u015flevinin g\u00fc\u00e7l\u00fc ve esnek do\u011fas\u0131 hakk\u0131nda sadece bir giri\u015f niteli\u011findedir ve ger\u00e7ek d\u00fcnya senaryolar\u0131nda kesinlikle de\u011ferli olabilir. Excel ve Google E-Tablolar&#8217;da \u00f6\u011frenmenin ve ke\u015ffetmenin devam etti\u011fini unutmay\u0131n!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00dcstel bir e\u011filimin parametrelerini 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-15517","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de LOGEST (LOT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da LOGEST (LOT) 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\/logest\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de LOGEST (LOT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da LOGEST (LOT) 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\/logest\/\" \/>\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:30:59+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel&#039;de LOGEST (LOT) 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\/logest\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/logest\/\",\"name\":\"Excel'de LOGEST (LOT) 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:30:59+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da LOGEST (LOT) 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\/logest\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/logest\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/logest\/#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\":\"LOT\"}]},{\"@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 LOGEST (LOT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da LOGEST (LOT) 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\/logest\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de LOGEST (LOT) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da LOGEST (LOT) 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\/logest\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:30:59+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de LOGEST (LOT) 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\/logest\/","url":"https:\/\/functiontranslator.com\/tr\/logest\/","name":"Excel'de LOGEST (LOT) 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:30:59+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da LOGEST (LOT) 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\/logest\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/logest\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/logest\/#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":"LOT"}]},{"@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\/15517","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=15517"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15517\/revisions"}],"predecessor-version":[{"id":26785,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15517\/revisions\/26785"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15517"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15517"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15517"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}