1 3 5 The figure below shows an MS Excel table that holds marks obtained in two tests group of 15 students. Answer the following questions based on this figure. ? ? D TEST 1 TEST 2 AGGREGATE VERDICT...

1 3 5 The figure below shows an MS Excel table that holds marks obtained in two tests group of 15 students. Answer the following questions based on this figure. ? ? D TEST 1 TEST 2 AGGREGATE VERDICT 2 57 38 46 PASS 50 34 40 FAIL 4 36 69 56 PASS 47 83 69 PASS 6 97 66 78 PASS 92 88 90 PASS 97 90 93 PASS 9 4 29 FAIL 10 6 52 34 FAIL 11 81 70 74 PASS 12 24 90 64 FAIL 37 6 18 FAIL 14 96 88 91 PASS 15 70 44 54 PASS 16 52 11 27 FAIL 7 8 46 13 a) Test 1 is welghted 40% and Test 2 is weighted 60% to calculate the aggregate mark for each student. What formula should you type in C2 to calculate the aggregate mark? b) In order to get PASS' grade from this course, both Test 1 and Test 2 marks have to be greater than 35 and aggregate mark has to be greater than 40. What formula should you type in D2? >35) > 35) • > 40)."PASS" c) What formula should you type in a single cell if you want to find the number of all passing students ? d) What formula should you type in a single cell if you want to calculate the arithmetic mean of aggregate grades? .) What formula should you type in a single cell if you want to calculate the median of aggregate grades? ) What formula should you type in a single cell if you want to calculate the variance of aggregate grades? 9) What formula should you type in a single cell you want to calculate the standard deviation of aggregate grades? h) What formula should you type in a single cell ll you want to calculate the first quartile of aggregate grades? =QUARTILE