{"id":15584,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/yuzderank\/"},"modified":"2021-02-25T16:33:29","modified_gmt":"2021-02-25T16:33:29","slug":"percentrank","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/percentrank\/","title":{"rendered":"Y\u00dcZDERANK"},"content":{"rendered":"

Excel ve Google E-Tablolar’da Y\u00fczdesel S\u0131ralama Nas\u0131l Kullan\u0131l\u0131r<\/h1>\n

Veri analizinde, belli bir de\u011ferin topluluktaki konumunu anlamak i\u00e7in \u00e7e\u015fitli i\u015flevler kullan\u0131l\u0131r. Bu i\u015flevlerden biri de y\u00fczdesel s\u0131rada (PERCENTRANK) de\u011ferinin hesaplanmas\u0131d\u0131r. Bu makalede, Excel ve Google E-Tablolar’da y\u00fczdesel s\u0131ralama i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131, \u00f6rneklerle a\u00e7\u0131klanacakt\u0131r.<\/p>\n

Y\u00fczdesel S\u0131ralama \u0130\u015flevi Nedir?<\/h2>\n

Y\u00fczdesel s\u0131ralama i\u015flevi, belirli bir de\u011ferin, veri k\u00fcmesindeki di\u011fer de\u011ferlerle kar\u015f\u0131la\u015ft\u0131r\u0131ld\u0131\u011f\u0131nda nerede oldu\u011funu g\u00f6sterir. Yani, bir de\u011ferin, veri setindeki toplam de\u011ferlerin y\u00fczdesel bir ifadesi olarak s\u0131ralamas\u0131n\u0131 bulmam\u0131z\u0131 sa\u011flar. \u0130\u015flevin genel s\u00f6zdizimi \u015f\u00f6yledir:<\/p>\n

  PERCENTRANK(data, x, [signifikans]) <\/code> <\/pre>\n
    \n
  • data<\/b>: Analiz edilen veri k\u00fcmesi.<\/li>\n
  • x<\/b>: Y\u00fczdesel s\u0131ralamas\u0131 hesaplanacak olan de\u011fer.<\/li>\n
  • signifikans<\/b> (iste\u011fe ba\u011fl\u0131): Y\u00fczdelik de\u011ferin ka\u00e7 ondal\u0131k basama\u011fa kadar hesaplanaca\u011f\u0131n\u0131 belirtir. E\u011fer bu arg\u00fcman verilmezse, Excel varsay\u0131lan olarak 3 ondal\u0131k basamak kullan\u0131r.<\/li>\n<\/ul>\n
    Pratik G\u00f6revler Ve Uygulamalar\u0131<\/h2>\n
    \u00d6\u011frenci Notlar\u0131n\u0131n Y\u00fczdelik S\u0131ralamas\u0131n\u0131 Belirleme<\/h3>\n
    Bir s\u0131n\u0131ftaki \u00f6\u011frencilerin s\u0131nav sonu\u00e7lar\u0131n\u0131 de\u011ferlendirmek istedi\u011finizi d\u00fc\u015f\u00fcn\u00fcn. Toplu bir s\u0131nav sonucunda her \u00f6\u011frencinin performans\u0131n\u0131 di\u011ferlerine g\u00f6re nerede oldu\u011funu y\u00fczdesel olarak belirlemek i\u00e7in y\u00fczdesel s\u0131rada i\u015flevi kullanabiliriz. Diyelim ki s\u0131nav sonu\u00e7lar\u0131 \u015f\u00f6yle:<\/p>\n
      Notlar: 80, 90, 70, 85, 95, 60 <\/code> <\/pre>\n
    \u00d6\u011frencilerden birinin notu olan 85’in y\u00fczdesel s\u0131ras\u0131n\u0131 hesaplamak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullan\u0131r\u0131z:<\/p>\n
      PERCENTRANK(Notlar, 85) <\/code> <\/pre>\n
    Bu form\u00fcl, 85 puan alan \u00f6\u011frencinin s\u0131n\u0131fta \u00fcst %60’l\u0131k dilimde oldu\u011funu g\u00f6sterecektir.<\/p>\n
    Sat\u0131\u015f Performans\u0131n\u0131n De\u011ferlendirilmesi<\/h3>\n
    Bir \u015firkette, farkl\u0131 b\u00f6lgelerdeki sat\u0131\u015f miktarlar\u0131yla ilgili veriler topland\u0131\u011f\u0131n\u0131 ve her b\u00f6lgenin performans\u0131n\u0131 y\u00fczdesel olarak de\u011ferlendirmek istedi\u011finizi varsayal\u0131m. B\u00f6lgeler aras\u0131 sat\u0131\u015flar \u015fu \u015fekilde olsun:<\/p>\n
      Sat\u0131\u015flar: 120, 150, 130, 160, 140 <\/code> <\/pre>\n
    Bu durumda, sat\u0131\u015flar\u0131 150 olan b\u00f6lgenin, toplam sat\u0131\u015flar aras\u0131ndaki y\u00fczdesel s\u0131ralamas\u0131n\u0131 bulmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabiliriz:<\/p>\n
      PERCENTRANK(Sat\u0131\u015flar, 150) <\/code> <\/pre>\n
    Form\u00fcl, 150 sat\u0131\u015f yapan b\u00f6lgenin, s\u0131ralamada \u00fcst %80’lik dilimde oldu\u011funu g\u00f6sterir.<\/p>\n
    Sonu\u00e7 Ve Yorumlar<\/h2>\n
    Y\u00fczdesel s\u0131ralama i\u015flevi, Excel ve Google E-Tablolar’da veri setleri i\u00e7indeki belirli de\u011ferlerin performans\u0131n\u0131 \u00f6l\u00e7mede ve k\u0131yaslamada son derece yararl\u0131d\u0131r. E\u011fitim, sat\u0131\u015f analizi, maa\u015f da\u011f\u0131l\u0131mlar\u0131 ve daha pek \u00e7ok alanda etkin bir \u015fekilde kullan\u0131labilir. Verilen \u00f6rnekler, temel kullan\u0131m\u0131 ve i\u015flevsellik a\u00e7\u0131s\u0131ndan iyi bir ba\u015flang\u0131\u00e7 noktas\u0131 sunmaktad\u0131r. Veri setlerinizle bu i\u015flevi deneyerek, daha bilgi\u00e7sel kararlar alabilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Bir veri k\u00fcmesindeki bir de\u011ferin y\u00fczdelik s\u0131ras\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":[584],"tags":[],"class_list":["post-15584","post","type-post","status-publish","format-standard","hentry","category-uyumluluk"],"acf":[],"yoast_head":"\nExcel'de PERCENTRANK (Y\u00dcZDERANK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da PERCENTRANK (Y\u00dcZDERANK) 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\/percentrank\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de PERCENTRANK (Y\u00dcZDERANK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da PERCENTRANK (Y\u00dcZDERANK) 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\/percentrank\/\" \/>\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:29+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 PERCENTRANK (Y\u00dcZDERANK) 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\/percentrank\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/percentrank\/\",\"name\":\"Excel'de PERCENTRANK (Y\u00dcZDERANK) 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:29+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da PERCENTRANK (Y\u00dcZDERANK) 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\/percentrank\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/percentrank\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/percentrank\/#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\u00dcZDERANK\"}]},{\"@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 PERCENTRANK (Y\u00dcZDERANK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da PERCENTRANK (Y\u00dcZDERANK) 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\/percentrank\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de PERCENTRANK (Y\u00dcZDERANK) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da PERCENTRANK (Y\u00dcZDERANK) 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\/percentrank\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:33:29+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de PERCENTRANK (Y\u00dcZDERANK) 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\/percentrank\/","url":"https:\/\/functiontranslator.com\/tr\/percentrank\/","name":"Excel'de PERCENTRANK (Y\u00dcZDERANK) 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:29+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da PERCENTRANK (Y\u00dcZDERANK) 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\/percentrank\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/percentrank\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/percentrank\/#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\u00dcZDERANK"}]},{"@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\/15584","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=15584"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15584\/revisions"}],"predecessor-version":[{"id":26852,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15584\/revisions\/26852"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15584"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15584"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15584"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}