calculate the average percentage of marks<\/strong>.<\/p>\n\n\n\nCalculate the Average Percentage of Marks<\/h2>\n\n\n\n For our example, we will suppose that we had four groups of students<\/strong>, each group containing 15 students<\/strong>, and their marks from the exam<\/strong>, ranging from 1% to 100%<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nWe now need to calculate the average of our percentages for every group, and we will do so by inserting the AVERAGE formula<\/strong> at the bottom of our table:<\/p>\n\n\n\n <\/figure>\n\n\n\nNow we need to calculate the averages of our four groups<\/strong>. We need to consider that every group has a different number of students (for example, we have 15 students in group A, but only 11 students in group C).<\/p>\n\n\n\nTo encapsulate this, we need to use the COUNT formula<\/strong>. We will place it beneath the averages:<\/p>\n\n\n\n <\/figure>\n\n\n\nTo calculate the average percentage of all marks, we will use the SUMPRODUCT formula<\/strong>, including averages and counts of records<\/strong>. Our formula will be as follows:<\/p>\n\n\n\n=SUMPRODUCT(B17:E17,B18:E18)\/SUM(B18:E18)<\/code><\/pre>\n\n\n\nThis is what the formula looks like in the sheet:<\/p>\n\n\n\n <\/figure>\n\n\n\nAnd our result will be 49.40%<\/strong>.<\/p>\n\n\n\nTo verify this result we calculate results for every group (multiplying AVERAGE and COUNTA for every group)<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nThen we sum all these numbers and divide them by the sum of the total students<\/strong>. We will get the same number:<\/p>\n\n\n\n <\/figure>\n","protected":false},"excerpt":{"rendered":"Excel is a perfect tool for all mathematical operations and visual presentation of data. It can be used to combine the two, as…<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[170],"yoast_head":"\n
Calculate the Average Percentage of Marks in Excel<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n