Microsoft Excel ve Google Tablolar’da bulunan RANK.AVG (Excel’de) veya RANK.ORT (Google Tablolar’da) fonksiyonu, bir liste i\u00e7indeki bir say\u0131n\u0131n s\u0131ralamas\u0131n\u0131 verirken, e\u015fit de\u011ferlerle kar\u015f\u0131la\u015f\u0131ld\u0131\u011f\u0131nda ortalama bir s\u0131ralama d\u00f6nd\u00fcr\u00fcr. Bu yaz\u0131da, bu fonksiyonun nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131, kullan\u0131m \u00f6rneklerini ve kar\u015f\u0131la\u015f\u0131labilecek iki pratik uygulamay\u0131 ad\u0131m ad\u0131m inceleyece\u011fiz.<\/p>\n
\u00d6rnek kullan\u0131m:<\/p>\n Bu form\u00fcl, A1:A10 h\u00fccre aral\u0131\u011f\u0131ndaki say\u0131lar aras\u0131nda 10 say\u0131s\u0131n\u0131n s\u0131ralamas\u0131n\u0131, azalan d\u00fczende hesaplar ve e\u011fer 10 say\u0131s\u0131 birden fazla kez ge\u00e7iyorsa ortalama bir s\u0131ralama de\u011feri d\u00f6nd\u00fcr\u00fcr.<\/p>\n Bir sat\u0131\u015f ekibi \u00fcyelerinin belli bir d\u00f6nemdeki performans\u0131n\u0131 s\u0131ralamak i\u00e7in RANK.AVG fonksiyonunu kullanabiliriz. Bu \u00f6rnekte, her bir sat\u0131\u015f g\u00f6revlisinin sat\u0131\u015f rakamlar\u0131 belirli bir aral\u0131kta (B1:B10) listelenmi\u015f olsun ve biz bu rakamlar\u0131 azalan s\u0131rada de\u011ferlendirmek istiyoruz.<\/p>\n Bu form\u00fcl, B1’deki sat\u0131\u015f miktar\u0131n\u0131 B s\u00fctunu aral\u0131\u011f\u0131nda kar\u015f\u0131la\u015ft\u0131r\u0131r ve bu de\u011ferin s\u0131ralamas\u0131n\u0131 C1’e yazar. Bu form\u00fcl C2’den C10’a kadar kopyalan\u0131r.<\/p>\n \u00d6\u011frencilerin bir s\u0131navdan ald\u0131klar\u0131 puanlar\u0131 s\u0131ralamak i\u00e7in de RANK.AVG kullan\u0131labilir. E\u011fer birden fazla \u00f6\u011frenci ayn\u0131 puan\u0131 ald\u0131ysa, ortalama bir s\u0131ralama elde etmek adil olacakt\u0131r.<\/p>\n Bu form\u00fcl, \u00f6\u011frencinin s\u0131nav puan\u0131n\u0131 artan d\u00fczenle s\u0131ralay\u0131p her \u00f6\u011frenci i\u00e7in puanlar\u0131na g\u00f6re s\u0131ralama yapar ve ortalamay\u0131 alarak daha adil bir s\u0131ralama sunar. Her \u00f6\u011frenci i\u00e7in ayn\u0131 i\u015flem tekrarlanarak s\u0131ralamalar C s\u00fctununa yazd\u0131r\u0131labilir.<\/p>\n Her iki \u00f6rnekte de, RANK.AVG fonksiyonu sayesinde birden fazla tekrar eden de\u011ferlerde ortaya \u00e7\u0131kan s\u0131ralama sorunlar\u0131 adaletli bir \u015fekilde \u00e7\u00f6z\u00fclebilir ve hem ger\u00e7ek d\u00fcnya verilerinde hem de akademik de\u011ferlendirmelerde faydal\u0131 olur.<\/p>\n","protected":false},"excerpt":{"rendered":" Say\u0131lar listesinde bir say\u0131n\u0131n s\u0131radaki yerini 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-15610","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nRANK.AVG<\/code> fonksiyonunun temel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\nRANK.AVG(number, ref, [order])<\/code><\/pre>\n\n
=RANK.AVG(10, A1:A10)<\/code><\/pre>\n1. Pratik Uygulama: Sat\u0131\u015f Performans\u0131n\u0131n S\u0131ralanmas\u0131<\/h2>\n
A s\u00fctunu - Sat\u0131\u015f G\u00f6revlileri B s\u00fctunu - Sat\u0131\u015f Rakamlar\u0131 C S\u00fctunu - S\u0131ralama C1 h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl girilir: =RANK.AVG(B1, $B$1:$B$10)<\/code><\/pre>\n2. Pratik Uygulama: Akademik Ba\u015far\u0131 S\u0131ralamas\u0131<\/h2>\n
A s\u00fctunu - \u00d6\u011frenci \u0130simleri B s\u00fctunu - S\u0131nav Puanlar\u0131 C S\u00fctunu - S\u0131ralama C1 h\u00fccresi i\u00e7in form\u00fcl: =RANK.AVG(B1, $B$1:$B$50, 1)<\/code><\/pre>\n