Funkce Skladba funkce P\u0159\u00edklady pou\u017eit\u00ed:<\/p>\n Tento p\u0159\u00edklad z\u00edsk\u00e1 po\u0159ad\u00ed \u010d\u00edsla 10 v rozsahu bun\u011bk od A1 do A10 s pou\u017eit\u00edm sestupn\u00e9ho \u0159azen\u00ed.<\/p>\n Pod\u00edvejme se na n\u011bkolik praktick\u00fdch aplikac\u00ed funkce U\u010ditel pot\u0159ebuje se\u0159adit studenty podle sk\u00f3re z testu a stanovit pr\u016fm\u011brn\u00e9 po\u0159ad\u00ed pro studenty s identick\u00fdmi v\u00fdsledky.<\/p>\n Ve vzorci Mana\u017eer m\u016f\u017ee cht\u00edt analyzovat prodejn\u00ed v\u00fdkony sv\u00e9ho t\u00fdmu a za\u0159adit prodejce do kvartil\u016f podle jejich v\u00fdsledk\u016f.<\/p>\n V tomto p\u0159\u00edpad\u011b Vr\u00e1t\u00ed po\u0159ad\u00ed \u010d\u00edsla v\u00a0seznamu \u010d\u00edsel<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[287],"tags":[],"class_list":["post-5772","post","type-post","status-publish","format-standard","hentry","category-statisticke"],"acf":[],"yoast_head":"\nRANK.AVG<\/code> je n\u00e1strojem v Excelu a Google Sheets, kter\u00fd umo\u017e\u0148uje vypo\u010d\u00edtat pr\u016fm\u011brn\u00e9 po\u0159ad\u00ed zvolen\u00e9ho \u010d\u00edsla v r\u00e1mci seznamu \u010d\u00edsel. Tato funkce je kl\u00ed\u010dov\u00e1 pro statistick\u00e9 anal\u00fdzy, nebo\u0165 poskytuje porovn\u00e1n\u00ed hodnot vzhledem k ostatn\u00edm dat\u016fm v souboru.<\/p>\nDetailn\u00ed popis syntaxe<\/h2>\n
RANK.AVG<\/code> v aplikac\u00edch Microsoft Excel a Google Sheets je definov\u00e1na n\u00e1sledovn\u011b:<\/p>\nRANK.AVG(number, ref, [order])<\/code><\/pre>\n\n
=RANK.AVG(10, A1:A10, 0)<\/code><\/pre>\nPou\u017eit\u00ed ve skute\u010dn\u00fdch \u00faloh\u00e1ch<\/h2>\n
RANK.AVG<\/code>.<\/p>\nAnal\u00fdza testov\u00fdch v\u00fdsledk\u016f<\/h2>\n
=RANK.AVG(B2, $B$2:$B$21, 0)<\/code><\/pre>\nB2<\/code> p\u0159edstavuje sk\u00f3re prvn\u00edho studenta a rozsah $B$2:$B$21<\/code> obsahuje v\u00fdsledky v\u0161ech student\u016f. Sestupn\u00e9 \u0159azen\u00ed je specifikov\u00e1no parametrem 0. V\u00fdsledn\u00e9 po\u0159ad\u00ed lze pak snadno p\u0159i\u0159adit ka\u017ed\u00e9mu studentovi ve vlastn\u00edm sloupci, co\u017e usnad\u0148uje srovn\u00e1n\u00ed jejich v\u00fdkon\u016f.<\/p>\nHodnocen\u00ed prodejn\u00edch v\u00fdkon\u016f<\/h2>\n
=RANK.AVG(C2, $C$2:$C$15, 1)<\/code><\/pre>\nC2<\/code> reprezentuje prodejn\u00ed v\u00fdkon prvn\u00edho zam\u011bstnance a $C$2:$C$15<\/code> je celkov\u00fd rozsah prodejn\u00edch v\u00fdsledk\u016f t\u00fdmu. Pou\u017eit\u00edm parametru 1 se hodnoty \u0159ad\u00ed vzestupn\u011b, umo\u017e\u0148uj\u00edc\u00ed rychle ur\u010dit, jak jednotliv\u00ed prodejci stoj\u00ed v porovn\u00e1n\u00ed s kolegy, identifikovat nejlep\u0161\u00ed v\u00fdkony, ale i ty, kte\u0159\u00ed mo\u017en\u00e1 pot\u0159ebuj\u00ed v\u00edce podpory.<\/p>\n","protected":false},"excerpt":{"rendered":"