90% 110 111 Because 5 is not one of the values in the range, the percentile was calculated by interpolating between values. 112 113 The grading of the Workbooks uses the PERCENTRANK function. + 114 Suppose there are 10 students in the class who achieve the scores presented in the gray shaded boxes (Column C) 115 We have again used the RAND function to generate random grades. 116 Write formula in the green boxes that calculates the percentile ranking of each student. 117 Use the '$' to be able to copy the formula down. 118 119 Student Score Percentile 1 70 51 2 3 4 120 121 122 123 124 125 4 33 5 61 6 33 7 7 126 127 8 87 128 9 65 129 10 3 130 131 PERCENTILE Function 132 The PERCENTILE function returns the kth percentile of values in a range (array) of values. 133 in the box immediately below the formula 'PERCENTILE(H134:135,50%)' identifies the value 2.5 as the 50th percentile of the rang 2.5 135 the CA APARIT I hate that matter than the SFAM Cash Flow Statement FSA Cash Flow Statement EXCEL Complex Functions 134 90% 110 111 Because 5 is not one of the values in the range, the percentile was calculated by interpolating between values. 112 113 The grading of the Workbooks uses the PERCENTRANK function. + 114 Suppose there are 10 students in the class who achieve the scores presented in the gray shaded boxes (Column C) 115 We have again used the RAND function to generate random grades. 116 Write formula in the green boxes that calculates the percentile ranking of each student. 117 Use the '$' to be able to copy the formula down. 118 119 Student Score Percentile 1 70 51 2 3 4 120 121 122 123 124 125 4 33 5 61 6 33 7 7 126 127 8 87 128 9 65 129 10 3 130 131 PERCENTILE Function 132 The PERCENTILE function returns the kth percentile of values in a range (array) of values. 133 in the box immediately below the formula 'PERCENTILE(H134:135,50%)' identifies the value 2.5 as the 50th percentile of the rang 2.5 135 the CA APARIT I hate that matter than the SFAM Cash Flow Statement FSA Cash Flow Statement EXCEL Complex Functions 134
