{"id":15581,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/yuzdebirlik\/"},"modified":"2021-02-25T16:33:24","modified_gmt":"2021-02-25T16:33:24","slug":"percentile","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/percentile\/","title":{"rendered":"Y\u00dcZDEB\u0130RL\u0130K"},"content":{"rendered":"

Y\u00fczdebirlik Fonksiyonu Kullan\u0131m Rehberi<\/h1>\n

Verilerin y\u00fczdelik dilimlerini hesaplamak, veri analizinde yayg\u0131n olarak kullan\u0131lan bir y\u00f6ntemdir. Bu rehberde, Microsoft Excel ve Google E-Tablolar’da PERCENTILE<\/strong> fonksiyonunun nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6rneklerle ele alaca\u011f\u0131z.<\/p>\n

Nas\u0131l \u00c7al\u0131\u015f\u0131r?<\/h2>\n

PERCENTILE<\/code> fonksiyonu bir veri setinin belirli bir y\u00fczdeli\u011findeki de\u011feri bulmaya yarar. Yani, bir dizi say\u0131sal veri i\u00e7inde belirli bir y\u00fczdeye kar\u015f\u0131l\u0131k gelen de\u011feri hesaplar.<\/p>\n

S\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n

 PERCENTILE(data, k)<\/code> <\/pre>\n
    \n
  • data<\/strong>: Analizi yap\u0131lan say\u0131sal veri dizisi.<\/li>\n
  • k<\/strong>: Hesaplanacak y\u00fczdebirlik de\u011feri, 0 ile 1 aras\u0131nda bir say\u0131 (\u00f6rn. 0,3 ise veri setinin %30’luk dilimi).<\/li>\n<\/ul>\n
    Pratik Uygulamalar<\/h2>\n
    Y\u00fczdebirlik fonksiyonunu, i\u015f d\u00fcnyas\u0131nda ve akademik ara\u015ft\u0131rmalarda kullanabilirsiniz. \u0130ki pratik uygulamayla \u00f6rnekleri inceleyelim:<\/p>\n
    Maa\u015f Analizi<\/h3>\n
    Bir \u015firketteki \u00e7al\u0131\u015fanlar\u0131n maa\u015flar\u0131n\u0131n da\u011f\u0131l\u0131m\u0131n\u0131 analiz etmek i\u00e7in PERCENTILE<\/code> fonksiyonu kullan\u0131l\u0131r. Diyelim ki \u00e7al\u0131\u015fanlar\u0131n maa\u015flar\u0131n\u0131 i\u00e7eren bir liste var ve bu liste i\u00e7indeki %75’lik dilimi, yani maa\u015flar\u0131n %75’inin alt\u0131nda kald\u0131\u011f\u0131 de\u011feri bulmak istiyoruz. Bu, \u015firketin maa\u015f skalas\u0131n\u0131 de\u011ferlendirmek i\u00e7in faydal\u0131d\u0131r.<\/p>\n
     =PERCENTILE(A2:A100, 0.75)<\/code> <\/pre>\n
    Bu form\u00fcl, A2:A100 aral\u0131\u011f\u0131nda bulunan maa\u015flar\u0131n %75’lik dilimdeki de\u011ferini verir. Yani, burada \u00e7\u0131kan sonu\u00e7, \u00e7al\u0131\u015fanlar\u0131n %75’inin ald\u0131\u011f\u0131 maa\u015ftan az veya e\u015fit oldu\u011fu anlam\u0131na gelir.<\/p>\n
    Test Sonu\u00e7lar\u0131n\u0131n De\u011ferlendirilmesi<\/h3>\n
    Bir okulun s\u0131nav sonu\u00e7lar\u0131 \u00fczerinden \u00f6\u011frencilerin performans\u0131n\u0131 y\u00fczdelik dilimlere g\u00f6re de\u011ferlendirmek isteyebilirsiniz. \u00d6rne\u011fin, bir s\u0131nav\u0131n %10’luk dilimini hesaplayarak, en d\u00fc\u015f\u00fck y\u00fczde 10’luk performans g\u00f6steren \u00f6\u011frencileri tespit edebilirsiniz.<\/p>\n
     =PERCENTILE(B2:B300, 0.1)<\/code> <\/pre>\n
    Bu form\u00fcl, B2:B300 aral\u0131\u011f\u0131nda bulunan s\u0131nav sonu\u00e7lar\u0131n\u0131n %10’luk dilimdeki de\u011ferini hesaplar. Elde edilen sonu\u00e7, t\u00fcm \u00f6\u011frencilerin %10’unun ald\u0131\u011f\u0131 puandan d\u00fc\u015f\u00fck veya e\u015fit puanlar\u0131 ifade eder.<\/p>\n
    \u00d6zet<\/h2>\n
    PERCENTILE<\/code> fonksiyonu, veri setlerindeki belirli bir y\u00fczdelik dilimdeki de\u011feri kolayca bulman\u0131za olanak tan\u0131r. Bu fonksiyon, maa\u015f analizleri, s\u0131nav sonu\u00e7lar\u0131n\u0131n de\u011ferlendirilmesi gibi \u00e7e\u015fitli alanlarda kullan\u0131l\u0131r. Fonksiyonun do\u011fru kullan\u0131m\u0131, etkili ve isabetli analizler yapman\u0131za yard\u0131mc\u0131 olur.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Bir aral\u0131k i\u00e7erisinde bulunan de\u011ferlerin k s\u0131ras\u0131ndaki y\u00fczdebirli\u011fini 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-15581","post","type-post","status-publish","format-standard","hentry","category-uyumluluk"],"acf":[],"yoast_head":"\nExcel'de PERCENTILE (Y\u00dcZDEB\u0130RL\u0130K) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da PERCENTILE (Y\u00dcZDEB\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\/percentile\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de PERCENTILE (Y\u00dcZDEB\u0130RL\u0130K) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da PERCENTILE (Y\u00dcZDEB\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\/percentile\/\" \/>\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:33:24+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 PERCENTILE (Y\u00dcZDEB\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\/percentile\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/percentile\/\",\"name\":\"Excel'de PERCENTILE (Y\u00dcZDEB\u0130RL\u0130K) 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:33:24+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da PERCENTILE (Y\u00dcZDEB\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\/percentile\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/percentile\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/percentile\/#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\":\"Y\u00dcZDEB\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 PERCENTILE (Y\u00dcZDEB\u0130RL\u0130K) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da PERCENTILE (Y\u00dcZDEB\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\/percentile\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de PERCENTILE (Y\u00dcZDEB\u0130RL\u0130K) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da PERCENTILE (Y\u00dcZDEB\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\/percentile\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:33:24+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de PERCENTILE (Y\u00dcZDEB\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\/percentile\/","url":"https:\/\/functiontranslator.com\/tr\/percentile\/","name":"Excel'de PERCENTILE (Y\u00dcZDEB\u0130RL\u0130K) 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:33:24+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da PERCENTILE (Y\u00dcZDEB\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\/percentile\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/percentile\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/percentile\/#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":"Y\u00dcZDEB\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\/15581","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=15581"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15581\/revisions"}],"predecessor-version":[{"id":26849,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15581\/revisions\/26849"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15581"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15581"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15581"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}