Y\u00fczdelik dilim<\/strong> bize bir veri setindeki g\u00f6zlemlerin y\u00fczde ka\u00e7\u0131n\u0131n belirli bir de\u011ferin alt\u0131na d\u00fc\u015ft\u00fc\u011f\u00fcn\u00fc s\u00f6yler.<\/span><\/p>\n Cevaplamaya \u00e7al\u0131\u015ft\u0131\u011f\u0131m\u0131z sorunun t\u00fcr\u00fcne ba\u011fl\u0131 olarak s\u0131kl\u0131kla z puanlar\u0131 ve y\u00fczdelikler aras\u0131nda d\u00f6n\u00fc\u015f\u00fcm yapmak isteriz. Neyse ki Excel, ikisi aras\u0131nda d\u00f6n\u00fc\u015ft\u00fcrmeyi kolayla\u015ft\u0131ran iki yerle\u015fik i\u015fleve sahiptir.<\/span><\/p>\n az puan\u0131n\u0131 y\u00fczdelik dilime d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in a\u015fa\u011f\u0131daki yerle\u015fik Excel i\u015flevini kullanabiliriz:<\/span><\/p>\n =NORM.S.DA\u011e(z, k\u00fcm\u00fclatif)<\/strong><\/span><\/p>\n Alt\u0131n:<\/span><\/p>\n \u00d6rne\u011fin, 1,78’lik z-puan\u0131n\u0131 y\u00fczdelik dilime nas\u0131l d\u00f6n\u00fc\u015ft\u00fcrece\u011finiz a\u015fa\u011f\u0131da a\u00e7\u0131klanm\u0131\u015ft\u0131r:<\/span> <\/p>\n 1,78’lik bir z-puan\u0131n\u0131n yakla\u015f\u0131k 96,2’lik<\/strong> bir y\u00fczdeli\u011fe kar\u015f\u0131l\u0131k geldi\u011fi ortaya \u00e7\u0131kt\u0131. D\u00fcz \u0130ngilizcede bu, z-puan\u0131 1,78 olan bir veri de\u011ferinin, veri k\u00fcmesindeki di\u011fer t\u00fcm veri de\u011ferlerinin yakla\u015f\u0131k %96,2’sinden daha b\u00fcy\u00fck oldu\u011fu anlam\u0131na gelir.<\/span><\/p>\n Y\u00fczdelik de\u011feri az puana d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in a\u015fa\u011f\u0131daki yerle\u015fik Excel i\u015flevini kullanabiliriz:<\/span><\/p>\n =NORM.S.TERS(olas\u0131l\u0131k)<\/strong><\/span><\/p>\n Alt\u0131n:<\/span><\/p>\n \u00d6rne\u011fin, 0,85’lik y\u00fczdelik dilimin z puan\u0131na nas\u0131l d\u00f6n\u00fc\u015ft\u00fcr\u00fclece\u011fi a\u015fa\u011f\u0131da a\u00e7\u0131klanm\u0131\u015ft\u0131r:<\/span> <\/p>\n 0,85’lik bir y\u00fczdelik dilimin yakla\u015f\u0131k 1,036’l\u0131k<\/strong> bir z puan\u0131na kar\u015f\u0131l\u0131k geldi\u011fi ortaya \u00e7\u0131kt\u0131. D\u00fcz \u0130ngilizce’de bu, bir veri k\u00fcmesindeki 85. y\u00fczdelik dilimdeki bir veri de\u011ferinin 1,036 z puan\u0131na sahip oldu\u011fu anlam\u0131na gelir.<\/span><\/p>\n Z puanlar\u0131 negatif sonsuzluk ile sonsuz aras\u0131nda herhangi bir de\u011feri alabilir. Ancak y\u00fczdelikler yaln\u0131zca 0 ile 100 aras\u0131ndaki de\u011ferleri alabilir.<\/span><\/p>\n 0’l\u0131k bir z-puan\u0131 tam olarak 0,50’lik bir y\u00fczdeli\u011fe kar\u015f\u0131l\u0131k gelir. Dolay\u0131s\u0131yla, 0’dan b\u00fcy\u00fck herhangi bir z puan\u0131, 0,50’den b\u00fcy\u00fck bir y\u00fczdeli\u011fe kar\u015f\u0131l\u0131k gelir ve 0’dan k\u00fc\u00e7\u00fck herhangi bir z puan\u0131, 0,50’den k\u00fc\u00e7\u00fck bir y\u00fczdeli\u011fe kar\u015f\u0131l\u0131k gelir.<\/span><\/p>\n Cevaplamaya \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131z sorunun t\u00fcr\u00fcne ba\u011fl\u0131 olarak z-puan\u0131n\u0131 veya y\u00fczdelik dilimini bilmek daha yararl\u0131 olabilir.<\/span><\/p>\n \u00d6rne\u011fin Jessica’n\u0131n belirli bir s\u0131navdan %90 ald\u0131\u011f\u0131n\u0131 varsayal\u0131m. Bu y\u00fcksek bir puan gibi g\u00f6r\u00fcnebilir ama ya s\u0131nav ger\u00e7ekten kolay olsayd\u0131 ve t\u00fcm s\u0131n\u0131f\u0131 iyi not alsayd\u0131? Notunun s\u0131n\u0131ftaki di\u011fer notlarla kar\u015f\u0131la\u015ft\u0131r\u0131ld\u0131\u011f\u0131nda ne kadar iyi oldu\u011funu belirlemek i\u00e7in hem z-puan\u0131n\u0131 hem de s\u0131nav notunun y\u00fczdelik dilimini hesaplayabiliriz.<\/span><\/p>\n S\u0131nav puan\u0131 z-puan\u0131<\/strong> 1,23’e tekab\u00fcl ediyorsa bu, s\u0131nav puan\u0131n\u0131n ortalama s\u0131nav puan\u0131n\u0131n 1,23 standart sapma \u00fczerinde oldu\u011fu anlam\u0131na gelir. Bu z-puan\u0131 ayn\u0131 zamanda yakla\u015f\u0131k 0,89’luk bir y\u00fczdelik dilime<\/strong> kar\u015f\u0131l\u0131k geliyor, bu da onun s\u0131n\u0131f arkada\u015flar\u0131n\u0131n %89’undan daha y\u00fcksek puan ald\u0131\u011f\u0131 anlam\u0131na geliyor. Z-puan\u0131 ve y\u00fczdelik dilimin bize onun s\u0131nav puan\u0131 hakk\u0131nda nas\u0131l yararl\u0131 bilgiler sa\u011flad\u0131\u011f\u0131na dikkat edin.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":" Z-puan\u0131 bize belirli bir de\u011ferin veri k\u00fcmesinin ortalamas\u0131ndan ka\u00e7 standart sapma oldu\u011funu s\u00f6yler. Y\u00fczdelik dilim bize bir veri setindeki g\u00f6zlemlerin y\u00fczde ka\u00e7\u0131n\u0131n belirli bir de\u011ferin alt\u0131na d\u00fc\u015ft\u00fc\u011f\u00fcn\u00fc s\u00f6yler. Cevaplamaya \u00e7al\u0131\u015ft\u0131\u011f\u0131m\u0131z sorunun t\u00fcr\u00fcne ba\u011fl\u0131 olarak s\u0131kl\u0131kla z puanlar\u0131 ve y\u00fczdelikler aras\u0131nda d\u00f6n\u00fc\u015f\u00fcm yapmak isteriz. Neyse ki Excel, ikisi aras\u0131nda d\u00f6n\u00fc\u015ft\u00fcrmeyi kolayla\u015ft\u0131ran iki yerle\u015fik i\u015fleve sahiptir. Excel’de […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-656","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n Excel’de Z Puanlar\u0131n\u0131 Y\u00fczdelik De\u011ferlere D\u00f6n\u00fc\u015ft\u00fcrme<\/strong><\/span><\/h3>\n
\n
![\"Excel'de](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/zscorepercentileexcel1-1.png\")
<\/p>\n Excel’de Y\u00fczdelik De\u011ferleri Z Puanlar\u0131na D\u00f6n\u00fc\u015ft\u00fcrme<\/strong><\/span><\/h3>\n
\n
![\"Excel'de](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/zscorepercentileexcel2.png\")
<\/p>\n Y\u00fczdelikler ile Z puanlar\u0131 aras\u0131ndaki ili\u015fki<\/strong><\/span><\/h3>\n