{"id":15602,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/dorttebirlik\/"},"modified":"2021-02-25T16:34:11","modified_gmt":"2021-02-25T16:34:11","slug":"quartile","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/quartile\/","title":{"rendered":"D\u00d6RTTEB\u0130RL\u0130K"},"content":{"rendered":"

Microsoft Excel ve Google E-Tablolar, veri analizi ve i\u015flem s\u00fcre\u00e7lerinizde s\u0131k\u00e7a yararlanabilece\u011finiz iki \u00f6nemli ara\u00e7t\u0131r. \u0130statistiksel analizler yaparken veri setinizin da\u011f\u0131l\u0131m\u0131n\u0131 de\u011ferlendirmek i\u00e7in kullanabilece\u011finiz fonksiyonlardan biri de D\u00d6RTTEB\u0130RL\u0130K (QUARTILE) fonksiyonudur. Bu yaz\u0131da, QUARTILE fonksiyonunun s\u00f6zdizimi, kullan\u0131m\u0131 ve ger\u00e7ek ya\u015fam \u00f6rnekleri ile nas\u0131l pratikte kullan\u0131labilece\u011fi \u00fczerine detayl\u0131 bilgiler sunaca\u011f\u0131m.<\/p>\n

QUARTILE Fonksiyonunun S\u00f6zdizimi<\/h2>\n

QUARTILE fonksiyonu, bir veri serisinin d\u00f6rttebirliklerini (\u00e7eyrek de\u011ferleri) hesaplamak i\u00e7in kullan\u0131l\u0131r. Excel ve Google E-Tablolar’da bu fonksiyonun kullan\u0131m\u0131 temelde benzerdir.<\/p>\n

  QUARTILE(array, quart) <\/code> <\/pre>\n
Bu fonksiyonda ‘array’ veri serisini, ‘quart’ ise istenen \u00e7eyreklik de\u011ferini ifade eder. ‘quart’ parametresi i\u00e7in ge\u00e7erli de\u011ferler: <\/p>\n
    \n
  • 0<\/code>: Minimum de\u011fer<\/li>\n
  • 1<\/code>: Birinci d\u00f6rttebirlik (25. persentil)<\/li>\n
  • 2<\/code>: Medyan ya da ikinci d\u00f6rttebirlik (50. persentil)<\/li>\n
  • 3<\/code>: \u00dc\u00e7\u00fcnc\u00fc d\u00f6rttebirlik (75. persentil)<\/li>\n
  • 4<\/code>: Maksimum de\u011fer<\/li>\n<\/ul>\n
    Pratikte QUARTILE Kullan\u0131m\u0131<\/h2>\n
    \u0130\u015fte QUARTILE fonksiyonunun kullan\u0131labilece\u011fi iki pratik \u00f6rnek:<\/p>\n
    Birinci Uygulama: S\u0131nav Sonu\u00e7lar\u0131n\u0131n De\u011ferlendirilmesi<\/h2>\n
    Bir \u00f6\u011fretmen, s\u0131n\u0131f\u0131ndaki \u00f6\u011frencilerin matematik s\u0131nav sonu\u00e7lar\u0131n\u0131 analiz ederek, performans da\u011f\u0131l\u0131m\u0131n\u0131 g\u00f6rmek istiyor.<\/p>\n
      =QUARTILE(A2:A101, 1) <\/code> <\/pre>\n
    Bu form\u00fcl, A2:A101 h\u00fccreleri aras\u0131ndaki s\u0131nav puanlar\u0131na uyguland\u0131\u011f\u0131nda, t\u00fcm \u00f6\u011frencilerin %25’inin ald\u0131\u011f\u0131 puan\u0131 (birinci \u00e7eyrek) verir. \u00d6\u011fretmen bu bilgiyle, s\u0131n\u0131f\u0131n alt %25’lik dilimindeki \u00f6\u011frencilerin hangi d\u00fczeyde oldu\u011funu anlayabilir ve onlara y\u00f6nelik ek destek planlar\u0131 yapabilir.<\/p>\n
    \u0130kinci Uygulama: Sat\u0131\u015f Verilerinin Analizi<\/h2>\n
    Bir \u015firket, farkl\u0131 b\u00f6l\u00fcmlerdeki \u00fcr\u00fcn sat\u0131\u015flar\u0131n\u0131 \u00e7eyreklik bazda analiz ederek, hangi \u00fcr\u00fcnlerin alt ve \u00fcst %25 diliminde oldu\u011funu g\u00f6rmek istiyor.<\/p>\n
      =QUARTILE(B2:B100, 3) <\/code> <\/pre>\n
    Bu \u00f6rnekte B2:B100 aras\u0131 h\u00fccrelerdeki sat\u0131\u015f rakamlar\u0131 incelendi\u011finde, \u00fc\u00e7\u00fcnc\u00fc d\u00f6rttebirlik de\u011feri (75. persentil) hesaplan\u0131r. Bu, t\u00fcm sat\u0131\u015flar\u0131n en y\u00fcksek %25’lik dilimindeki ba\u015flang\u0131\u00e7 noktas\u0131n\u0131 belirler. Bu bilgi, firman\u0131n en iyi performans g\u00f6steren \u00fcr\u00fcnlerini belirlemesine ve bu \u00fcr\u00fcnler \u00fczerine yo\u011funla\u015farak sat\u0131\u015f stratejilerini \u015fekillendirmesine olanak tan\u0131r.<\/p>\n
    Her iki senaryoda da, QUARTILE fonksiyonu farkl\u0131 veri setlerinin istatistiksel \u00f6zelliklerini h\u0131zl\u0131 ve etkili bir \u015fekilde anlamam\u0131za olanak tan\u0131r. Bu, daha bilin\u00e7li kararlar vermek ve kaynaklar\u0131 daha etkin kullanmak i\u00e7in kritik bir rol oynamaktad\u0131r.<\/p>\n
    Excel ve Google E-Tablolar’da QUARTILE gibi fonksiyonlar\u0131 kullanarak, veri g\u00f6rselle\u015ftirme ve analiz yeteneklerinizi geli\u015ftirebilir, karma\u015f\u0131k veri setlerinden anlaml\u0131 bilgiler \u00e7\u0131karmak i\u00e7in gereken ara\u00e7lara sahip olabilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Veri k\u00fcmesinin d\u00f6rtte birini 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-15602","post","type-post","status-publish","format-standard","hentry","category-uyumluluk"],"acf":[],"yoast_head":"\nExcel'de QUARTILE (D\u00d6RTTEB\u0130RL\u0130K) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da QUARTILE (D\u00d6RTTEB\u0130RL\u0130K) 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\/quartile\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de QUARTILE (D\u00d6RTTEB\u0130RL\u0130K) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da QUARTILE (D\u00d6RTTEB\u0130RL\u0130K) 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\/quartile\/\" \/>\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:34:11+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 QUARTILE (D\u00d6RTTEB\u0130RL\u0130K) 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\/quartile\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/quartile\/\",\"name\":\"Excel'de QUARTILE (D\u00d6RTTEB\u0130RL\u0130K) 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:34:11+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da QUARTILE (D\u00d6RTTEB\u0130RL\u0130K) 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\/quartile\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/quartile\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/quartile\/#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\":\"D\u00d6RTTEB\u0130RL\u0130K\"}]},{\"@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 QUARTILE (D\u00d6RTTEB\u0130RL\u0130K) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da QUARTILE (D\u00d6RTTEB\u0130RL\u0130K) 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\/quartile\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de QUARTILE (D\u00d6RTTEB\u0130RL\u0130K) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da QUARTILE (D\u00d6RTTEB\u0130RL\u0130K) 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\/quartile\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:34:11+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de QUARTILE (D\u00d6RTTEB\u0130RL\u0130K) 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\/quartile\/","url":"https:\/\/functiontranslator.com\/tr\/quartile\/","name":"Excel'de QUARTILE (D\u00d6RTTEB\u0130RL\u0130K) 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:34:11+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da QUARTILE (D\u00d6RTTEB\u0130RL\u0130K) 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\/quartile\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/quartile\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/quartile\/#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":"D\u00d6RTTEB\u0130RL\u0130K"}]},{"@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\/15602","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=15602"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15602\/revisions"}],"predecessor-version":[{"id":26870,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15602\/revisions\/26870"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15602"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15602"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15602"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}