学生成绩统计表Excel(含图含公式)

姓名学号性别语文数学英语体育总分平均分最高分最低分名次英语比例成绩情况学生A学生B学生C学生D学生E学生F学生G学生H学生I学生J学生K学生L学生M学生N学生O学生P学生Q学生R1234567101112131415161718女男女女男女男女男女男男男男男女男女92888397919081708379927669858597919093879190998092809169708684797390998086788570698388807483775971726670698390988176628465786074715769817636135134834634032932331431330929929529529329334634032990.2587.7587.0086.5085.0082.2580.7578.5078.2577.2574.7573.7573.7573.2573.2586.5085.0082.259391979990928491839286848585979990867883706976627065696059695766706976125610141718212226262728296101423.8%22.2%24.4%20.2%20.3%25.2%27.2%25.5%23.6%26.9%25.8%20.0%24.1%24.6%22.5%20.2%20.3%25.2%优良良良良良良中中中中中中中中良良良学生S学生T学生U学生V学生W学生X学生Y学生Z学生ZQ学生WZ学生EZ学生RZ192021222324252627282930女男女男女男女男男男女女817083798883657368635280916993879174991031071118880748384788583991061131206284657098847162534432331431330935635134830634233933633380.7578.5078.2577.25.0087.7587.0076.5085.5084.7584.0083.2592849183939184991061131206270656984788365716253441718212222524911131327.2%25.5%23.6%26.9%23.6%22.2%24.4%27.1%28.9%31.3%33.6%36.0%良中中中良良良中良良良良最高分最低分平均值97581116912059984436129390.257380.151208384####################320.60语文成绩统计表

语文成绩<50人数（n)50—5960—6970—7980—620.69%1157.%≥90842.11%014百分比(n/N)0.00%3.33%13.79%语文成绩分数段人数121086语文成绩分数段人数420<5050—5960—6970—7980—≥90