Veri analizinde, \u00f6zellikle b\u00fcy\u00fck veri k\u00fcmeleriyle \u00e7al\u0131\u015f\u0131rken, belirli de\u011ferlerin durumunu anlamak amac\u0131yla s\u0131ralamak \u00f6nemlidir. Bu makalede, Microsoft Excel ve Google E-Tablolar’da kullan\u0131lan Bir s\u0131n\u0131ftaki \u00f6\u011frencilerin s\u0131nav sonu\u00e7lar\u0131n\u0131 s\u0131ralamak, \u00f6\u011frenciler aras\u0131nda performans k\u0131yaslamas\u0131 yapmak i\u00e7in faydal\u0131d\u0131r:<\/p>\n Form\u00fcl:<\/strong> Bu form\u00fcl, Ali’nin puan\u0131n\u0131n s\u0131n\u0131f\u0131ndaki di\u011fer puanlarla kar\u015f\u0131la\u015ft\u0131r\u0131lmas\u0131n\u0131 sa\u011flar ve ona bir s\u0131ra numaras\u0131 verir. Ayn\u0131 puan\u0131 alan Ay\u015fe ile e\u015fit s\u0131rada olacakt\u0131r.<\/p>\n Bir \u015firketteki farkl\u0131 sat\u0131\u015f temsilcilerinin performans\u0131n\u0131 de\u011ferlendirmek i\u00e7in sat\u0131\u015f rakamlar\u0131n\u0131n s\u0131ralanmas\u0131 yap\u0131labilir:<\/p>\n Form\u00fcl:<\/strong> Bu form\u00fcl, Ahmet’in sat\u0131\u015flar\u0131n\u0131, di\u011fer temsilcilerinkilerle kar\u015f\u0131la\u015ft\u0131rmak i\u00e7in kullan\u0131labilir. Ahmet ve Elif, e\u015fit sat\u0131\u015f rakamlar\u0131na sahip oldu\u011fu i\u00e7in ayn\u0131 s\u0131ralamay\u0131 al\u0131rlar ve Zeynep en y\u00fcksek sat\u0131\u015fla birinci s\u0131rada yer al\u0131r.<\/p>\n 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-15611","post","type-post","status-publish","format-standard","hentry","category-istatistik"],"acf":[],"yoast_head":"\nRANK.EQ<\/code> i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 derinlemesine inceleyece\u011fiz.<\/p>\n\u0130\u015flevin S\u00f6zdizimi ve Kullan\u0131m\u0131<\/h2>\n
RANK.EQ<\/code> i\u015flevi, belirli bir say\u0131n\u0131n, bir say\u0131lar dizisi i\u00e7indeki s\u0131ras\u0131n\u0131 belirler. Ayn\u0131 de\u011fere sahip \u00f6\u011feler i\u00e7in e\u015fit s\u0131ralama d\u00f6nd\u00fcr\u00fcr ve sonraki s\u0131ralar\u0131 atlar.<\/p>\nRANK.EQ(number, ref, [order])<\/code><\/pre>\n\n
Pratik G\u00f6revler ve \u00c7\u00f6z\u00fcmleri<\/h2>\n
1. S\u0131n\u0131f Ortalamalar\u0131n\u0131n S\u0131ralanmas\u0131<\/h3>\n
\u00d6\u011frenci | Puan -------- | ---- Ali | 90 Veli | 70 Ay\u015fe | 90 Fatma | 85<\/code><\/pre>\n=RANK.EQ(B2, B2:B5, 0)<\/code><\/p>\n2. Sat\u0131\u015f Rakamlar\u0131n\u0131n De\u011ferlendirilmesi<\/h3>\n
Temsilci | Sat\u0131\u015f --------- | ----- Ahmet | 15000 Mehmet | 18000 Elif | 15000 Zeynep | 20000<\/code><\/pre>\n=RANK.EQ(B2, B2:B5)<\/code><\/p>\nYorumlar ve \u0130pucular<\/h2>\n
RANK.EQ<\/code> i\u015flevi, \u00f6zellikle ayn\u0131 de\u011ferlere sahip birden fazla giri\u015f oldu\u011funda, standart s\u0131ralama i\u015flevlerinden farkl\u0131 sonu\u00e7lar \u00fcretebilir. E\u011fer her bir e\u015fit de\u011fer i\u00e7in farkl\u0131 bir s\u0131ralama numaras\u0131 istiyorsan\u0131z, RANK.AVG<\/code> i\u015flevini kullanabilirsiniz. Ayn\u0131 zamanda, veri setinizi \u00f6nceden s\u0131ralaman\u0131za gerek yoktur; i\u015flev, giri\u015f dizisinde verilen d\u00fczeni otomatik olarak uygular.<\/p>\n","protected":false},"excerpt":{"rendered":"