{"id":15687,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/egilim\/"},"modified":"2021-02-25T16:38:04","modified_gmt":"2021-02-25T16:38:04","slug":"trend","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/trend\/","title":{"rendered":"E\u011e\u0130L\u0130M"},"content":{"rendered":"

Excel ve Google E-Tablolar g\u00fcnl\u00fck i\u015flerimizde kulland\u0131\u011f\u0131m\u0131z, veri analizi ve i\u015flenmesi konusunda olduk\u00e7a g\u00fc\u00e7l\u00fc ara\u00e7lard\u0131r. Bu makalede, hem MS Excel hem de Google E-Tablolar’da kullan\u0131lan TREND (E\u011e\u0130L\u0130M) fonksiyonunun nas\u0131l kullan\u0131ld\u0131\u011f\u0131n\u0131, bu fonksiyonun potansiyel kullan\u0131m alanlar\u0131n\u0131 ve bu i\u015flevin yaratabilece\u011fi sonu\u00e7lar\u0131 ele alaca\u011f\u0131z.<\/p>\n

E\u011filim Fonksiyonunun Kullan\u0131m\u0131<\/h2>\n

TREND fonksiyonu, bilinen y de\u011ferleri ve ba\u011f\u0131ms\u0131z x de\u011ferleri aras\u0131ndaki ili\u015fkiyi kullanarak yeni y de\u011ferlerini tahmin etmeye yarar. Bu fonksiyon, \u00f6zellikle istatistiksel analiz ve veri tahmininde kullan\u0131l\u0131r. S\u00f6zdizimine gelirsek, Excel ve Google E-Tablolar’da genel yap\u0131s\u0131 \u015f\u00f6yledir: <\/p>\n

TREND(known_y's, [known_x's], [new_x's], [const])<\/code><\/pre>\n
    \n
  • known_y's<\/code>: Ba\u011f\u0131ml\u0131 y de\u011fi\u015fkenlerinin dizi ya da h\u00fccre aral\u0131\u011f\u0131.<\/li>\n
  • [known_x's]<\/code>: Opsiyonel, ba\u011f\u0131ms\u0131z x de\u011fi\u015fkenlerinin dizi ya da h\u00fccre aral\u0131\u011f\u0131. E\u011fer belirtilmezse, varsay\u0131lan olarak 1, 2, 3… olarak kabul edilir.<\/li>\n
  • [new_x's]<\/code>: Opsiyonel, y de\u011ferlerinin tahmin edilece\u011fi yeni x de\u011ferleri. E\u011fer belirtilmezse, known_x’s kullan\u0131l\u0131r.<\/li>\n
  • [const]<\/code>: Opsiyonel, TRUE veya FALSE. E\u011fim \u00e7izgisinin y ekseninden ge\u00e7ip ge\u00e7meyece\u011fini belirleyen bir de\u011ferdir (varsay\u0131lan de\u011fer TRUE).<\/li>\n<\/ul>\n
    Pratik \u00d6rnekler<\/h2>\n
    \u0130\u015fte TREND fonksiyonunun Excel ve Google E-Tablolar\u2019da pratikte nas\u0131l kullan\u0131laca\u011f\u0131na dair iki \u00f6rnekle birlikte baz\u0131 a\u00e7\u0131klamalar:<\/p>\n
    Anahtar Sat\u0131\u015f D\u00f6nemlerinde Tahmini Sat\u0131\u015f Hesaplama<\/h3>\n
     Firma olarak ge\u00e7mi\u015fteki sat\u0131\u015f verileriniz var ve \u00f6n\u00fcm\u00fczdeki ay i\u00e7in sat\u0131\u015f tahmini yapman\u0131z gerekiyor. \u00c7al\u0131\u015fma alan\u0131n\u0131za \u015funlar\u0131 yerle\u015ftirin: <\/p>\n
    known_y’s:<\/b> A1:A12 (Son 12 ay\u0131n sat\u0131\u015f verileri)<\/p>\n
    new_x’s:<\/b> 13 (Gelecek ay)<\/p>\n
    Kodunuz \u015fu \u015fekilde olacak:<\/p>\n
    =TREND(A1:A12,,13)<\/code><\/pre>\n
    Bu form\u00fcl, ge\u00e7mi\u015f 12 ay\u0131n verilerine dayanarak gelecek ay i\u00e7in bir sat\u0131\u015f tahmini yapacakt\u0131r.<\/p>\n
    Ak\u0131ll\u0131 Telefonlarda Pil \u00d6mr\u00fcn\u00fcn Tahmin Edilmesi<\/h3>\n
     Farkl\u0131 markalardan ak\u0131ll\u0131 telefonlar test ediliyor ve pil \u00f6mr\u00fc ile ilgili veriler toplan\u0131yor. Deneklerden toplanan veriler aras\u0131nda cihaz kullan\u0131m s\u00fcresi (saat olarak) ve g\u00fcn sonunda kalan pil y\u00fczdesi bulunuyor. Bu verilere g\u00f6re yeni bir cihaz\u0131n tahmini pil \u00f6mr\u00fc hesaplanacak. <\/p>\n
    known_y’s:<\/b> B1:B10 (G\u00fcn sonunda kalan pil y\u00fczdesi)<\/p>\n
    known_x’s:<\/b> A1:A10 (Cihaz kullan\u0131m s\u00fcresi)<\/p>\n
    new_x’s:<\/b> 11 (Yeni cihaz i\u00e7in tahmin edilecek kullan\u0131m s\u00fcresi)<\/p>\n
    =TREND(B1:B10, A1:A10, 11)<\/code><\/pre>\n
    Bu hesaplama, s\u00f6z konusu kullan\u0131m s\u00fcresinde yeni cihaz\u0131n g\u00fcn sonunda ne kadar pil y\u00fczdesi kalaca\u011f\u0131n\u0131 tahmin etmeye yarayacakt\u0131r.<\/p>\n
    Excel ve Google E-Tablolar, TREND fonksiyonu sayesinde, i\u015f ve ara\u015ft\u0131rma d\u00fcnyas\u0131nda \u00e7ok \u00e7e\u015fitli senaryolarda de\u011ferli tahminler sunabilmektedir. Bu fonksiyon, basit kullan\u0131m\u0131 ve sa\u011flad\u0131\u011f\u0131 g\u00fc\u00e7l\u00fc i\u015flevsellik ile analiz i\u015flemlerinizde b\u00fcy\u00fck bir yard\u0131mc\u0131 olacakt\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Do\u011frusal bir e\u011filim boyunca de\u011fer 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-15687","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nExcel'de TREND (E\u011e\u0130L\u0130M) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da TREND (E\u011e\u0130L\u0130M) 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\/trend\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de TREND (E\u011e\u0130L\u0130M) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da TREND (E\u011e\u0130L\u0130M) 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\/trend\/\" \/>\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:38: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 TREND (E\u011e\u0130L\u0130M) 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\/trend\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/trend\/\",\"name\":\"Excel'de TREND (E\u011e\u0130L\u0130M) 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:38:04+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da TREND (E\u011e\u0130L\u0130M) 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\/trend\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/trend\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/trend\/#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\":\"E\u011e\u0130L\u0130M\"}]},{\"@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 TREND (E\u011e\u0130L\u0130M) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da TREND (E\u011e\u0130L\u0130M) 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\/trend\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de TREND (E\u011e\u0130L\u0130M) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da TREND (E\u011e\u0130L\u0130M) 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\/trend\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:38:04+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de TREND (E\u011e\u0130L\u0130M) 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\/trend\/","url":"https:\/\/functiontranslator.com\/tr\/trend\/","name":"Excel'de TREND (E\u011e\u0130L\u0130M) 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:38:04+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da TREND (E\u011e\u0130L\u0130M) 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\/trend\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/trend\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/trend\/#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":"E\u011e\u0130L\u0130M"}]},{"@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\/15687","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=15687"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15687\/revisions"}],"predecessor-version":[{"id":26955,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15687\/revisions\/26955"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15687"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15687"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15687"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}