I am tryingto determine the top and bottom 30 % of students answering a question. Thenumber changes depending on the number of students in each class. The number ofstudents is in C16, I need to determine the answer in d18.

P = [Number of Students who answered correctly / [/COLOR]Number of Students who took the test[/FONT]

D = [P-indexfor High group] – [P-index for Low group]

[TABLE=”class: cms_table_grid, width: 500, align: center”]

[TR]

[TD=”align: center”]A[/TD]

[TD=”align: center”]B[/TD]

[TD=”align: center”]C[/TD]

[TD=”align: center”]D[/TD]

[/TR]

[TR]

[TD=”align: center”]1[/TD]

[TD=”align: center”]Student[/TD]

[TD=”align: center”]Initials[/TD]

[TD=”align: center”]Correct Answer[/TD]

[/TR]

[TR]

[TD=”align: center”]2[/TD]

[TD=”align: center”][/TD]

[TD=”align: center”][/TD]

[TD=”align: center”]B[/TD]

[/TR]

[TR]

[TD=”align: center”]3[/TD]

[TD=”align: center”][/TD]

[TD=”align: center”][/TD]

[TD=”align: center”][/TD]

[/TR]

[TR]

[TD=”align: center”]4[/TD]

[TD=”align: center”]1[/TD]

[TD=”align: center”]AB[/TD]

[TD=”align: center”]A[/TD]

[/TR]

[TR]

[TD=”align: center”]5[/TD]

[TD=”align: center”]2[/TD]

[TD=”align: center”]CG[/TD]

[TD=”align: center”][/TD]

[/TR]

[TR]

[TD=”align: center”]6[/TD]

[TD=”align: center”]3[/TD]

[TD=”align: center”]SG[/TD]

[TD=”align: center”]D[/TD]

[/TR]

[TR]

[TD=”align: center”]7[/TD]

[TD=”align: center”]4[/TD]

[TD=”align: center”]SW[/TD]

[TD=”align: center”][/TD]

[/TR]

[TR]

[TD=”align: center”]8[/TD]

[TD=”align: center”]5[/TD]

[TD=”align: center”]JN[/TD]

[TD=”align: center”][/TD]

[/TR]

[TR]

[TD=”align: center”]9[/TD]

[TD=”align: center”]6[/TD]

[TD=”align: center”]KY[/TD]

[TD=”align: center”]D[/TD]

[/TR]

[TR]

[TD=”align: center”]10[/TD]

[TD=”align: center”]7[/TD]

[TD=”align: center”]TL[/TD]

[TD=”align: center”][/TD]

[/TR]

[TR]

[TD=”align: center”]11[/TD]

[TD=”align: center”]8[/TD]

[TD=”align: center”]EC[/TD]

[TD=”align: center”]C[/TD]

[/TR]

[TR]

[TD=”align: center”]12[/TD]

[TD=”align: center”]9[/TD]

[TD=”align: center”]LM[/TD]

[TD=”align: center”]C[/TD]

[/TR]

[TR]

[TD=”align: center”]13[/TD]

[TD=”align: center”]10[/TD]

[TD=”align: center”]AW[/TD]

[TD=”align: center”]A[/TD]

[/TR]

[TR]

[TD=”align: center”]14[/TD]

[TD=”align: center”]11[/TD]

[TD=”align: center”]TH[/TD]

[TD=”align: center”]C[/TD]

[/TR]

[TR]

[TD=”align: center”]15[/TD]

[TD=”align: center”][/TD]

[TD=”align: center”][/TD]

[TD=”align: center”][/TD]

[/TR]

[TR]

[TD=”align: center”]16[/TD]

[TD=”align: center”]Total[/TD]

[TD=”align: center”]10[/TD]

[TD=”align: center”][/TD]

[/TR]

[TR]

[TD=”align: center”]17[/TD]

[TD=”align: center”]P=[/TD]

[TD=”align: center”][/TD]

[TD=”align: center”][/TD]

[/TR]

[TR]

[TD=”align: center”]18[/TD]

[TD=”align: center”]D=[/TD]

[TD][/TD]

[/TR]

[/TABLE]