Hi,
I've never created a pivot table before, so I'm not sure whether this is the route to go. Please let me know if I'm barking up the wrong tree.
Suppose I have 149 members in a marble club. You're given the details of each member at the bottom (it's long, so I figured I'd put it at the bottom).
How would you propose building the following distribution chart?
[TABLE="class: grid, width: 441"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD="align: center"][/TD]
[TD="colspan: 2, align: center"]Males[/TD]
[TD="colspan: 2, align: center"]Females
[/TD]
[/TR]
[TR]
[TD="align: center"]Age
[/TD]
[TD="align: center"]Number[/TD]
[TD="align: center"]Average number of marbles[/TD]
[TD="align: center"]Number[/TD]
[TD="align: center"]Average number of marbles[/TD]
[/TR]
[TR]
[TD="align: center"]Under 10
[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]527[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]605[/TD]
[/TR]
[TR]
[TD="align: center"]10-14[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]413[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]319[/TD]
[/TR]
[TR]
[TD="align: center"]15-19[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]677[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]470[/TD]
[/TR]
[TR]
[TD="align: center"]20-24[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]647[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]422[/TD]
[/TR]
[TR]
[TD="align: center"]25-29
[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]446[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]412[/TD]
[/TR]
[TR]
[TD="align: center"]30-34
[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]535[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]352[/TD]
[/TR]
[TR]
[TD="align: center"]35-39[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]493[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]429[/TD]
[/TR]
[TR]
[TD="align: center"]40-44[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]317[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]419[/TD]
[/TR]
[TR]
[TD="align: center"]45-49[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]649[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]705[/TD]
[/TR]
[TR]
[TD="align: center"]50-54[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]693[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]400[/TD]
[/TR]
[TR]
[TD="align: center"]55-59[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]520[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]439[/TD]
[/TR]
[TR]
[TD="align: center"]60 and over[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]609[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]697
[/TD]
[/TR]
[TR]
[TD="align: center"]Total
[/TD]
[TD="align: center"]77[/TD]
[TD="align: center"]6526[/TD]
[TD="align: center"]72[/TD]
[TD="align: center"]5669
[/TD]
[/TR]
</tbody>[/TABLE]
I think the distribution table is pretty straight forward, but, to be perfectly clear, the averages are for the specific sex and specific age range. Is this a pivot table task? Or does this task just require brute force and perhaps some clever Excel formulas? To create the distribution above, I used the countifs and sumifs functions, which sped it up, but I imagine pivot tables should be able to do this.
Hopefully this is obvious, but I have no interest in marbles. I need to do a distribution of salaries, ages and group divisions for a client report, but I figured the above example is sufficiently analogous for me adapt it to the table I'm putting in the report.
Anyway, the data set's below. Have at it.
Thanks for considering this.
Peter
[TABLE="class: grid, width: 155"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Member ID[/TD]
[TD]Age[/TD]
[TD]Sex[/TD]
[TD]Marbles[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD="align: right"]61[/TD]
[TD]M[/TD]
[TD="align: right"]824[/TD]
[/TR]
[TR]
[TD]AB[/TD]
[TD="align: right"]41[/TD]
[TD]F[/TD]
[TD="align: right"]239[/TD]
[/TR]
[TR]
[TD]AC[/TD]
[TD="align: right"]63[/TD]
[TD]M[/TD]
[TD="align: right"]76[/TD]
[/TR]
[TR]
[TD]AD[/TD]
[TD="align: right"]21[/TD]
[TD]M[/TD]
[TD="align: right"]831
[/TD]
[/TR]
[TR]
[TD]AE[/TD]
[TD="align: right"]34[/TD]
[TD]F[/TD]
[TD="align: right"]213[/TD]
[/TR]
[TR]
[TD]AF[/TD]
[TD="align: right"]47[/TD]
[TD]F[/TD]
[TD="align: right"]837[/TD]
[/TR]
[TR]
[TD]AG[/TD]
[TD="align: right"]21[/TD]
[TD]F[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]AH[/TD]
[TD="align: right"]31[/TD]
[TD]F[/TD]
[TD="align: right"]151[/TD]
[/TR]
[TR]
[TD]AI[/TD]
[TD="align: right"]35[/TD]
[TD]F[/TD]
[TD="align: right"]170
[/TD]
[/TR]
[TR]
[TD]AJ[/TD]
[TD="align: right"]36[/TD]
[TD]F[/TD]
[TD="align: right"]332[/TD]
[/TR]
[TR]
[TD]AK[/TD]
[TD="align: right"]19[/TD]
[TD]M[/TD]
[TD="align: right"]825[/TD]
[/TR]
[TR]
[TD]AL[/TD]
[TD="align: right"]26[/TD]
[TD]F[/TD]
[TD="align: right"]76[/TD]
[/TR]
[TR]
[TD]AM[/TD]
[TD="align: right"]44[/TD]
[TD]F[/TD]
[TD="align: right"]789[/TD]
[/TR]
[TR]
[TD]AN[/TD]
[TD="align: right"]6[/TD]
[TD]M[/TD]
[TD="align: right"]274[/TD]
[/TR]
[TR]
[TD]AO[/TD]
[TD="align: right"]33[/TD]
[TD]M[/TD]
[TD="align: right"]859[/TD]
[/TR]
[TR]
[TD]AP[/TD]
[TD="align: right"]40[/TD]
[TD]F[/TD]
[TD="align: right"]455[/TD]
[/TR]
[TR]
[TD]AQ[/TD]
[TD="align: right"]49[/TD]
[TD]F[/TD]
[TD="align: right"]588[/TD]
[/TR]
[TR]
[TD]AR[/TD]
[TD="align: right"]29[/TD]
[TD]M[/TD]
[TD="align: right"]921[/TD]
[/TR]
[TR]
[TD]AS[/TD]
[TD="align: right"]20[/TD]
[TD]M[/TD]
[TD="align: right"]474[/TD]
[/TR]
[TR]
[TD]AT[/TD]
[TD="align: right"]16[/TD]
[TD]M[/TD]
[TD="align: right"]329[/TD]
[/TR]
[TR]
[TD]AU[/TD]
[TD="align: right"]37[/TD]
[TD]M[/TD]
[TD="align: right"]204[/TD]
[/TR]
[TR]
[TD]AV[/TD]
[TD="align: right"]55[/TD]
[TD]M[/TD]
[TD="align: right"]285[/TD]
[/TR]
[TR]
[TD]AW[/TD]
[TD="align: right"]36[/TD]
[TD]M[/TD]
[TD="align: right"]852[/TD]
[/TR]
[TR]
[TD]AX[/TD]
[TD="align: right"]17[/TD]
[TD]F[/TD]
[TD="align: right"]871[/TD]
[/TR]
[TR]
[TD]AY[/TD]
[TD="align: right"]30[/TD]
[TD]F[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]AZ[/TD]
[TD="align: right"]55[/TD]
[TD]M[/TD]
[TD="align: right"]394[/TD]
[/TR]
[TR]
[TD]BA[/TD]
[TD="align: right"]6[/TD]
[TD]M[/TD]
[TD="align: right"]636[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD="align: right"]11[/TD]
[TD]F[/TD]
[TD="align: right"]766[/TD]
[/TR]
[TR]
[TD]BC[/TD]
[TD="align: right"]29[/TD]
[TD]M[/TD]
[TD="align: right"]177[/TD]
[/TR]
[TR]
[TD]BD[/TD]
[TD="align: right"]15[/TD]
[TD]M[/TD]
[TD="align: right"]693[/TD]
[/TR]
[TR]
[TD]BE[/TD]
[TD="align: right"]13[/TD]
[TD]M[/TD]
[TD="align: right"]373[/TD]
[/TR]
[TR]
[TD]BF[/TD]
[TD="align: right"]17[/TD]
[TD]F[/TD]
[TD="align: right"]366[/TD]
[/TR]
[TR]
[TD]BG[/TD]
[TD="align: right"]5[/TD]
[TD]M[/TD]
[TD="align: right"]613[/TD]
[/TR]
[TR]
[TD]BH[/TD]
[TD="align: right"]60[/TD]
[TD]M[/TD]
[TD="align: right"]848[/TD]
[/TR]
[TR]
[TD]BI[/TD]
[TD="align: right"]17[/TD]
[TD]F[/TD]
[TD="align: right"]375[/TD]
[/TR]
[TR]
[TD]BJ[/TD]
[TD="align: right"]46[/TD]
[TD]M[/TD]
[TD="align: right"]917[/TD]
[/TR]
[TR]
[TD]BK[/TD]
[TD="align: right"]55[/TD]
[TD]F[/TD]
[TD="align: right"]866[/TD]
[/TR]
[TR]
[TD]BL[/TD]
[TD="align: right"]12[/TD]
[TD]M[/TD]
[TD="align: right"]849[/TD]
[/TR]
[TR]
[TD]BM[/TD]
[TD="align: right"]36[/TD]
[TD]M[/TD]
[TD="align: right"]191[/TD]
[/TR]
[TR]
[TD]BN[/TD]
[TD="align: right"]14[/TD]
[TD]M[/TD]
[TD="align: right"]948[/TD]
[/TR]
[TR]
[TD]BO[/TD]
[TD="align: right"]26[/TD]
[TD]F[/TD]
[TD="align: right"]707[/TD]
[/TR]
[TR]
[TD]BP[/TD]
[TD="align: right"]47[/TD]
[TD]F[/TD]
[TD="align: right"]282[/TD]
[/TR]
[TR]
[TD]BQ[/TD]
[TD="align: right"]20[/TD]
[TD]F[/TD]
[TD="align: right"]204[/TD]
[/TR]
[TR]
[TD]BR[/TD]
[TD="align: right"]54[/TD]
[TD]M[/TD]
[TD="align: right"]754[/TD]
[/TR]
[TR]
[TD]BS[/TD]
[TD="align: right"]9[/TD]
[TD]F[/TD]
[TD="align: right"]939[/TD]
[/TR]
[TR]
[TD]BT[/TD]
[TD="align: right"]20[/TD]
[TD]M[/TD]
[TD="align: right"]576[/TD]
[/TR]
[TR]
[TD]BU[/TD]
[TD="align: right"]62[/TD]
[TD]F[/TD]
[TD="align: right"]301[/TD]
[/TR]
[TR]
[TD]BV[/TD]
[TD="align: right"]36[/TD]
[TD]M[/TD]
[TD="align: right"]977[/TD]
[/TR]
[TR]
[TD]BW[/TD]
[TD="align: right"]36[/TD]
[TD]M[/TD]
[TD="align: right"]323[/TD]
[/TR]
[TR]
[TD]BX[/TD]
[TD="align: right"]36[/TD]
[TD]F[/TD]
[TD="align: right"]744[/TD]
[/TR]
[TR]
[TD]BY[/TD]
[TD="align: right"]37[/TD]
[TD]F[/TD]
[TD="align: right"]340[/TD]
[/TR]
[TR]
[TD]BZ[/TD]
[TD="align: right"]37[/TD]
[TD]F[/TD]
[TD="align: right"]196[/TD]
[/TR]
[TR]
[TD]CA[/TD]
[TD="align: right"]34[/TD]
[TD]F[/TD]
[TD="align: right"]786[/TD]
[/TR]
[TR]
[TD]CB[/TD]
[TD="align: right"]55[/TD]
[TD]M[/TD]
[TD="align: right"]837[/TD]
[/TR]
[TR]
[TD]CC[/TD]
[TD="align: right"]53[/TD]
[TD]F[/TD]
[TD="align: right"]138[/TD]
[/TR]
[TR]
[TD]CD[/TD]
[TD="align: right"]24[/TD]
[TD]F[/TD]
[TD="align: right"]408[/TD]
[/TR]
[TR]
[TD]CE[/TD]
[TD="align: right"]44[/TD]
[TD]M[/TD]
[TD="align: right"]161[/TD]
[/TR]
[TR]
[TD]CF[/TD]
[TD="align: right"]48[/TD]
[TD]F[/TD]
[TD="align: right"]833[/TD]
[/TR]
[TR]
[TD]CG[/TD]
[TD="align: right"]43[/TD]
[TD]F[/TD]
[TD="align: right"]637[/TD]
[/TR]
[TR]
[TD]CH[/TD]
[TD="align: right"]62[/TD]
[TD]F[/TD]
[TD="align: right"]859[/TD]
[/TR]
[TR]
[TD]CI[/TD]
[TD="align: right"]25[/TD]
[TD]F[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]CJ[/TD]
[TD="align: right"]63[/TD]
[TD]F[/TD]
[TD="align: right"]949[/TD]
[/TR]
[TR]
[TD]CK[/TD]
[TD="align: right"]46[/TD]
[TD]M[/TD]
[TD="align: right"]876[/TD]
[/TR]
[TR]
[TD]CL[/TD]
[TD="align: right"]23[/TD]
[TD]M[/TD]
[TD="align: right"]477[/TD]
[/TR]
[TR]
[TD]CM[/TD]
[TD="align: right"]19[/TD]
[TD]F[/TD]
[TD="align: right"]770[/TD]
[/TR]
[TR]
[TD]CN[/TD]
[TD="align: right"]63[/TD]
[TD]M[/TD]
[TD="align: right"]513[/TD]
[/TR]
[TR]
[TD]CO[/TD]
[TD="align: right"]30[/TD]
[TD]M[/TD]
[TD="align: right"]268[/TD]
[/TR]
[TR]
[TD]CP[/TD]
[TD="align: right"]7[/TD]
[TD]F[/TD]
[TD="align: right"]613[/TD]
[/TR]
[TR]
[TD]CQ[/TD]
[TD="align: right"]17[/TD]
[TD]M[/TD]
[TD="align: right"]859[/TD]
[/TR]
[TR]
[TD]CR[/TD]
[TD="align: right"]65[/TD]
[TD]M[/TD]
[TD="align: right"]909[/TD]
[/TR]
[TR]
[TD]CS[/TD]
[TD="align: right"]19[/TD]
[TD]F[/TD]
[TD="align: right"]171[/TD]
[/TR]
[TR]
[TD]CT[/TD]
[TD="align: right"]52[/TD]
[TD]F[/TD]
[TD="align: right"]606[/TD]
[/TR]
[TR]
[TD]CU[/TD]
[TD="align: right"]42[/TD]
[TD]M[/TD]
[TD="align: right"]87[/TD]
[/TR]
[TR]
[TD]CV[/TD]
[TD="align: right"]55[/TD]
[TD]M[/TD]
[TD="align: right"]140[/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD="align: right"]21[/TD]
[TD]F[/TD]
[TD="align: right"]97[/TD]
[/TR]
[TR]
[TD]CX[/TD]
[TD="align: right"]60[/TD]
[TD]M[/TD]
[TD="align: right"]371[/TD]
[/TR]
[TR]
[TD]CY[/TD]
[TD="align: right"]64[/TD]
[TD]F[/TD]
[TD="align: right"]911[/TD]
[/TR]
[TR]
[TD]CZ[/TD]
[TD="align: right"]40[/TD]
[TD]M[/TD]
[TD="align: right"]228[/TD]
[/TR]
[TR]
[TD]DA[/TD]
[TD="align: right"]13[/TD]
[TD]F[/TD]
[TD="align: right"]229[/TD]
[/TR]
[TR]
[TD]DB[/TD]
[TD="align: right"]31[/TD]
[TD]M[/TD]
[TD="align: right"]14[/TD]
[/TR]
[TR]
[TD]DC[/TD]
[TD="align: right"]44[/TD]
[TD]F[/TD]
[TD="align: right"]564[/TD]
[/TR]
[TR]
[TD]DD[/TD]
[TD="align: right"]22[/TD]
[TD]M[/TD]
[TD="align: right"]444[/TD]
[/TR]
[TR]
[TD]DE[/TD]
[TD="align: right"]21[/TD]
[TD]M[/TD]
[TD="align: right"]661[/TD]
[/TR]
[TR]
[TD]DF[/TD]
[TD="align: right"]51[/TD]
[TD]M[/TD]
[TD="align: right"]804[/TD]
[/TR]
[TR]
[TD]DG[/TD]
[TD="align: right"]26[/TD]
[TD]M[/TD]
[TD="align: right"]422[/TD]
[/TR]
[TR]
[TD]DH[/TD]
[TD="align: right"]49[/TD]
[TD]M[/TD]
[TD="align: right"]880[/TD]
[/TR]
[TR]
[TD]DI[/TD]
[TD="align: right"]38[/TD]
[TD]M[/TD]
[TD="align: right"]340[/TD]
[/TR]
[TR]
[TD]DJ[/TD]
[TD="align: right"]22[/TD]
[TD]M[/TD]
[TD="align: right"]853[/TD]
[/TR]
[TR]
[TD]DK[/TD]
[TD="align: right"]50[/TD]
[TD]M[/TD]
[TD="align: right"]514[/TD]
[/TR]
[TR]
[TD]DL[/TD]
[TD="align: right"]62[/TD]
[TD]F[/TD]
[TD="align: right"]588[/TD]
[/TR]
[TR]
[TD]DM[/TD]
[TD="align: right"]14[/TD]
[TD]F[/TD]
[TD="align: right"]293[/TD]
[/TR]
[TR]
[TD]DN[/TD]
[TD="align: right"]34[/TD]
[TD]M[/TD]
[TD="align: right"]127[/TD]
[/TR]
[TR]
[TD]DO[/TD]
[TD="align: right"]20[/TD]
[TD]F[/TD]
[TD="align: right"]364[/TD]
[/TR]
[TR]
[TD]DP[/TD]
[TD="align: right"]44[/TD]
[TD]M[/TD]
[TD="align: right"]217[/TD]
[/TR]
[TR]
[TD]DQ[/TD]
[TD="align: right"]40[/TD]
[TD]F[/TD]
[TD="align: right"]133[/TD]
[/TR]
[TR]
[TD]DR[/TD]
[TD="align: right"]23[/TD]
[TD]F[/TD]
[TD="align: right"]720[/TD]
[/TR]
[TR]
[TD]DS[/TD]
[TD="align: right"]13[/TD]
[TD]M[/TD]
[TD="align: right"]104[/TD]
[/TR]
[TR]
[TD]DT[/TD]
[TD="align: right"]30[/TD]
[TD]F[/TD]
[TD="align: right"]709[/TD]
[/TR]
[TR]
[TD]DU[/TD]
[TD="align: right"]36[/TD]
[TD]M[/TD]
[TD="align: right"]977[/TD]
[/TR]
[TR]
[TD]DV[/TD]
[TD="align: right"]43[/TD]
[TD]F[/TD]
[TD="align: right"]972[/TD]
[/TR]
[TR]
[TD]DW[/TD]
[TD="align: right"]15[/TD]
[TD]F[/TD]
[TD="align: right"]265[/TD]
[/TR]
[TR]
[TD]DX[/TD]
[TD="align: right"]53[/TD]
[TD]M[/TD]
[TD="align: right"]909[/TD]
[/TR]
[TR]
[TD]DY[/TD]
[TD="align: right"]52[/TD]
[TD]F[/TD]
[TD="align: right"]457[/TD]
[/TR]
[TR]
[TD]DZ[/TD]
[TD="align: right"]44[/TD]
[TD]M[/TD]
[TD="align: right"]273[/TD]
[/TR]
[TR]
[TD]EA[/TD]
[TD="align: right"]8[/TD]
[TD]F[/TD]
[TD="align: right"]160[/TD]
[/TR]
[TR]
[TD]EB[/TD]
[TD="align: right"]12[/TD]
[TD]M[/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD]EC[/TD]
[TD="align: right"]47[/TD]
[TD]F[/TD]
[TD="align: right"]986[/TD]
[/TR]
[TR]
[TD]ED[/TD]
[TD="align: right"]33[/TD]
[TD]M[/TD]
[TD="align: right"]918[/TD]
[/TR]
[TR]
[TD]EE[/TD]
[TD="align: right"]30[/TD]
[TD]F[/TD]
[TD="align: right"]251[/TD]
[/TR]
[TR]
[TD]EF[/TD]
[TD="align: right"]55[/TD]
[TD]M[/TD]
[TD="align: right"]944[/TD]
[/TR]
[TR]
[TD]EG[/TD]
[TD="align: right"]61[/TD]
[TD]M[/TD]
[TD="align: right"]272[/TD]
[/TR]
[TR]
[TD]EH[/TD]
[TD="align: right"]48[/TD]
[TD]M[/TD]
[TD="align: right"]778[/TD]
[/TR]
[TR]
[TD]EI[/TD]
[TD="align: right"]6[/TD]
[TD]M[/TD]
[TD="align: right"]458[/TD]
[/TR]
[TR]
[TD]EJ[/TD]
[TD="align: right"]10[/TD]
[TD]M[/TD]
[TD="align: right"]511[/TD]
[/TR]
[TR]
[TD]EK[/TD]
[TD="align: right"]38[/TD]
[TD]M[/TD]
[TD="align: right"]77[/TD]
[/TR]
[TR]
[TD]EL[/TD]
[TD="align: right"]6[/TD]
[TD]M[/TD]
[TD="align: right"]655[/TD]
[/TR]
[TR]
[TD]EM[/TD]
[TD="align: right"]65[/TD]
[TD]F[/TD]
[TD="align: right"]795[/TD]
[/TR]
[TR]
[TD]EN[/TD]
[TD="align: right"]32[/TD]
[TD]M[/TD]
[TD="align: right"]604[/TD]
[/TR]
[TR]
[TD]EO[/TD]
[TD="align: right"]22[/TD]
[TD]F[/TD]
[TD="align: right"]260[/TD]
[/TR]
[TR]
[TD]EP[/TD]
[TD="align: right"]29[/TD]
[TD]M[/TD]
[TD="align: right"]146[/TD]
[/TR]
[TR]
[TD]EQ[/TD]
[TD="align: right"]12[/TD]
[TD]F[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]ER[/TD]
[TD="align: right"]40[/TD]
[TD]F[/TD]
[TD="align: right"]219[/TD]
[/TR]
[TR]
[TD]ES[/TD]
[TD="align: right"]55[/TD]
[TD]F[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]ET[/TD]
[TD="align: right"]24[/TD]
[TD]M[/TD]
[TD="align: right"]688[/TD]
[/TR]
[TR]
[TD]EU[/TD]
[TD="align: right"]10[/TD]
[TD]F[/TD]
[TD="align: right"]302[/TD]
[/TR]
[TR]
[TD]EV[/TD]
[TD="align: right"]64[/TD]
[TD]F[/TD]
[TD="align: right"]857[/TD]
[/TR]
[TR]
[TD]EW[/TD]
[TD="align: right"]44[/TD]
[TD]F[/TD]
[TD="align: right"]51[/TD]
[/TR]
[TR]
[TD]EX[/TD]
[TD="align: right"]49[/TD]
[TD]M[/TD]
[TD="align: right"]54[/TD]
[/TR]
[TR]
[TD]EY[/TD]
[TD="align: right"]24[/TD]
[TD]F[/TD]
[TD="align: right"]989[/TD]
[/TR]
[TR]
[TD]EZ[/TD]
[TD="align: right"]64[/TD]
[TD]M[/TD]
[TD="align: right"]994[/TD]
[/TR]
[TR]
[TD]FA[/TD]
[TD="align: right"]5[/TD]
[TD]F[/TD]
[TD="align: right"]741[/TD]
[/TR]
[TR]
[TD]FB[/TD]
[TD="align: right"]5[/TD]
[TD]F[/TD]
[TD="align: right"]220[/TD]
[/TR]
[TR]
[TD]FC[/TD]
[TD="align: right"]7[/TD]
[TD]F[/TD]
[TD="align: right"]954[/TD]
[/TR]
[TR]
[TD]FD[/TD]
[TD="align: right"]54[/TD]
[TD]M[/TD]
[TD="align: right"]520[/TD]
[/TR]
[TR]
[TD]FE[/TD]
[TD="align: right"]62[/TD]
[TD]F[/TD]
[TD="align: right"]104[/TD]
[/TR]
[TR]
[TD]FF[/TD]
[TD="align: right"]24[/TD]
[TD]M[/TD]
[TD="align: right"]818[/TD]
[/TR]
[TR]
[TD]FG[/TD]
[TD="align: right"]60[/TD]
[TD]F[/TD]
[TD="align: right"]908[/TD]
[/TR]
[TR]
[TD]FH[/TD]
[TD="align: right"]23[/TD]
[TD]F[/TD]
[TD="align: right"]658[/TD]
[/TR]
[TR]
[TD]FI[/TD]
[TD="align: right"]21[/TD]
[TD]F[/TD]
[TD="align: right"]519[/TD]
[/TR]
[TR]
[TD]FJ[/TD]
[TD="align: right"]46[/TD]
[TD]M[/TD]
[TD="align: right"]391[/TD]
[/TR]
[TR]
[TD]FK[/TD]
[TD="align: right"]29[/TD]
[TD]M[/TD]
[TD="align: right"]565[/TD]
[/TR]
[TR]
[TD]FL[/TD]
[TD="align: right"]64[/TD]
[TD]M[/TD]
[TD="align: right"]671[/TD]
[/TR]
[TR]
[TD]FM[/TD]
[TD="align: right"]52[/TD]
[TD]M[/TD]
[TD="align: right"]656[/TD]
[/TR]
[TR]
[TD]FN[/TD]
[TD="align: right"]41[/TD]
[TD]M[/TD]
[TD="align: right"]937[/TD]
[/TR]
[TR]
[TD]FO[/TD]
[TD="align: right"]41[/TD]
[TD]F[/TD]
[TD="align: right"]127[/TD]
[/TR]
[TR]
[TD]FP[/TD]
[TD="align: right"]26[/TD]
[TD]F[/TD]
[TD="align: right"]864[/TD]
[/TR]
[TR]
[TD]FQ[/TD]
[TD="align: right"]10[/TD]
[TD]M[/TD]
[TD="align: right"]88[/TD]
[/TR]
[TR]
[TD]FR[/TD]
[TD="align: right"]30[/TD]
[TD]M[/TD]
[TD="align: right"]958[/TD]
[/TR]
[TR]
[TD]FS[/TD]
[TD="align: right"]38[/TD]
[TD]F[/TD]
[TD="align: right"]789[/TD]
[/TR]
</tbody>[/TABLE]
I've never created a pivot table before, so I'm not sure whether this is the route to go. Please let me know if I'm barking up the wrong tree.
Suppose I have 149 members in a marble club. You're given the details of each member at the bottom (it's long, so I figured I'd put it at the bottom).
How would you propose building the following distribution chart?
[TABLE="class: grid, width: 441"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD="align: center"][/TD]
[TD="colspan: 2, align: center"]Males[/TD]
[TD="colspan: 2, align: center"]Females
[/TD]
[/TR]
[TR]
[TD="align: center"]Age
[/TD]
[TD="align: center"]Number[/TD]
[TD="align: center"]Average number of marbles[/TD]
[TD="align: center"]Number[/TD]
[TD="align: center"]Average number of marbles[/TD]
[/TR]
[TR]
[TD="align: center"]Under 10
[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]527[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]605[/TD]
[/TR]
[TR]
[TD="align: center"]10-14[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]413[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]319[/TD]
[/TR]
[TR]
[TD="align: center"]15-19[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]677[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]470[/TD]
[/TR]
[TR]
[TD="align: center"]20-24[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]647[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]422[/TD]
[/TR]
[TR]
[TD="align: center"]25-29
[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]446[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]412[/TD]
[/TR]
[TR]
[TD="align: center"]30-34
[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]535[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]352[/TD]
[/TR]
[TR]
[TD="align: center"]35-39[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]493[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]429[/TD]
[/TR]
[TR]
[TD="align: center"]40-44[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]317[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]419[/TD]
[/TR]
[TR]
[TD="align: center"]45-49[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]649[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]705[/TD]
[/TR]
[TR]
[TD="align: center"]50-54[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]693[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]400[/TD]
[/TR]
[TR]
[TD="align: center"]55-59[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]520[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]439[/TD]
[/TR]
[TR]
[TD="align: center"]60 and over[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]609[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]697
[/TD]
[/TR]
[TR]
[TD="align: center"]Total
[/TD]
[TD="align: center"]77[/TD]
[TD="align: center"]6526[/TD]
[TD="align: center"]72[/TD]
[TD="align: center"]5669
[/TD]
[/TR]
</tbody>[/TABLE]
I think the distribution table is pretty straight forward, but, to be perfectly clear, the averages are for the specific sex and specific age range. Is this a pivot table task? Or does this task just require brute force and perhaps some clever Excel formulas? To create the distribution above, I used the countifs and sumifs functions, which sped it up, but I imagine pivot tables should be able to do this.
Hopefully this is obvious, but I have no interest in marbles. I need to do a distribution of salaries, ages and group divisions for a client report, but I figured the above example is sufficiently analogous for me adapt it to the table I'm putting in the report.
Anyway, the data set's below. Have at it.
Thanks for considering this.
Peter
[TABLE="class: grid, width: 155"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Member ID[/TD]
[TD]Age[/TD]
[TD]Sex[/TD]
[TD]Marbles[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD="align: right"]61[/TD]
[TD]M[/TD]
[TD="align: right"]824[/TD]
[/TR]
[TR]
[TD]AB[/TD]
[TD="align: right"]41[/TD]
[TD]F[/TD]
[TD="align: right"]239[/TD]
[/TR]
[TR]
[TD]AC[/TD]
[TD="align: right"]63[/TD]
[TD]M[/TD]
[TD="align: right"]76[/TD]
[/TR]
[TR]
[TD]AD[/TD]
[TD="align: right"]21[/TD]
[TD]M[/TD]
[TD="align: right"]831
[/TD]
[/TR]
[TR]
[TD]AE[/TD]
[TD="align: right"]34[/TD]
[TD]F[/TD]
[TD="align: right"]213[/TD]
[/TR]
[TR]
[TD]AF[/TD]
[TD="align: right"]47[/TD]
[TD]F[/TD]
[TD="align: right"]837[/TD]
[/TR]
[TR]
[TD]AG[/TD]
[TD="align: right"]21[/TD]
[TD]F[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]AH[/TD]
[TD="align: right"]31[/TD]
[TD]F[/TD]
[TD="align: right"]151[/TD]
[/TR]
[TR]
[TD]AI[/TD]
[TD="align: right"]35[/TD]
[TD]F[/TD]
[TD="align: right"]170
[/TD]
[/TR]
[TR]
[TD]AJ[/TD]
[TD="align: right"]36[/TD]
[TD]F[/TD]
[TD="align: right"]332[/TD]
[/TR]
[TR]
[TD]AK[/TD]
[TD="align: right"]19[/TD]
[TD]M[/TD]
[TD="align: right"]825[/TD]
[/TR]
[TR]
[TD]AL[/TD]
[TD="align: right"]26[/TD]
[TD]F[/TD]
[TD="align: right"]76[/TD]
[/TR]
[TR]
[TD]AM[/TD]
[TD="align: right"]44[/TD]
[TD]F[/TD]
[TD="align: right"]789[/TD]
[/TR]
[TR]
[TD]AN[/TD]
[TD="align: right"]6[/TD]
[TD]M[/TD]
[TD="align: right"]274[/TD]
[/TR]
[TR]
[TD]AO[/TD]
[TD="align: right"]33[/TD]
[TD]M[/TD]
[TD="align: right"]859[/TD]
[/TR]
[TR]
[TD]AP[/TD]
[TD="align: right"]40[/TD]
[TD]F[/TD]
[TD="align: right"]455[/TD]
[/TR]
[TR]
[TD]AQ[/TD]
[TD="align: right"]49[/TD]
[TD]F[/TD]
[TD="align: right"]588[/TD]
[/TR]
[TR]
[TD]AR[/TD]
[TD="align: right"]29[/TD]
[TD]M[/TD]
[TD="align: right"]921[/TD]
[/TR]
[TR]
[TD]AS[/TD]
[TD="align: right"]20[/TD]
[TD]M[/TD]
[TD="align: right"]474[/TD]
[/TR]
[TR]
[TD]AT[/TD]
[TD="align: right"]16[/TD]
[TD]M[/TD]
[TD="align: right"]329[/TD]
[/TR]
[TR]
[TD]AU[/TD]
[TD="align: right"]37[/TD]
[TD]M[/TD]
[TD="align: right"]204[/TD]
[/TR]
[TR]
[TD]AV[/TD]
[TD="align: right"]55[/TD]
[TD]M[/TD]
[TD="align: right"]285[/TD]
[/TR]
[TR]
[TD]AW[/TD]
[TD="align: right"]36[/TD]
[TD]M[/TD]
[TD="align: right"]852[/TD]
[/TR]
[TR]
[TD]AX[/TD]
[TD="align: right"]17[/TD]
[TD]F[/TD]
[TD="align: right"]871[/TD]
[/TR]
[TR]
[TD]AY[/TD]
[TD="align: right"]30[/TD]
[TD]F[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]AZ[/TD]
[TD="align: right"]55[/TD]
[TD]M[/TD]
[TD="align: right"]394[/TD]
[/TR]
[TR]
[TD]BA[/TD]
[TD="align: right"]6[/TD]
[TD]M[/TD]
[TD="align: right"]636[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD="align: right"]11[/TD]
[TD]F[/TD]
[TD="align: right"]766[/TD]
[/TR]
[TR]
[TD]BC[/TD]
[TD="align: right"]29[/TD]
[TD]M[/TD]
[TD="align: right"]177[/TD]
[/TR]
[TR]
[TD]BD[/TD]
[TD="align: right"]15[/TD]
[TD]M[/TD]
[TD="align: right"]693[/TD]
[/TR]
[TR]
[TD]BE[/TD]
[TD="align: right"]13[/TD]
[TD]M[/TD]
[TD="align: right"]373[/TD]
[/TR]
[TR]
[TD]BF[/TD]
[TD="align: right"]17[/TD]
[TD]F[/TD]
[TD="align: right"]366[/TD]
[/TR]
[TR]
[TD]BG[/TD]
[TD="align: right"]5[/TD]
[TD]M[/TD]
[TD="align: right"]613[/TD]
[/TR]
[TR]
[TD]BH[/TD]
[TD="align: right"]60[/TD]
[TD]M[/TD]
[TD="align: right"]848[/TD]
[/TR]
[TR]
[TD]BI[/TD]
[TD="align: right"]17[/TD]
[TD]F[/TD]
[TD="align: right"]375[/TD]
[/TR]
[TR]
[TD]BJ[/TD]
[TD="align: right"]46[/TD]
[TD]M[/TD]
[TD="align: right"]917[/TD]
[/TR]
[TR]
[TD]BK[/TD]
[TD="align: right"]55[/TD]
[TD]F[/TD]
[TD="align: right"]866[/TD]
[/TR]
[TR]
[TD]BL[/TD]
[TD="align: right"]12[/TD]
[TD]M[/TD]
[TD="align: right"]849[/TD]
[/TR]
[TR]
[TD]BM[/TD]
[TD="align: right"]36[/TD]
[TD]M[/TD]
[TD="align: right"]191[/TD]
[/TR]
[TR]
[TD]BN[/TD]
[TD="align: right"]14[/TD]
[TD]M[/TD]
[TD="align: right"]948[/TD]
[/TR]
[TR]
[TD]BO[/TD]
[TD="align: right"]26[/TD]
[TD]F[/TD]
[TD="align: right"]707[/TD]
[/TR]
[TR]
[TD]BP[/TD]
[TD="align: right"]47[/TD]
[TD]F[/TD]
[TD="align: right"]282[/TD]
[/TR]
[TR]
[TD]BQ[/TD]
[TD="align: right"]20[/TD]
[TD]F[/TD]
[TD="align: right"]204[/TD]
[/TR]
[TR]
[TD]BR[/TD]
[TD="align: right"]54[/TD]
[TD]M[/TD]
[TD="align: right"]754[/TD]
[/TR]
[TR]
[TD]BS[/TD]
[TD="align: right"]9[/TD]
[TD]F[/TD]
[TD="align: right"]939[/TD]
[/TR]
[TR]
[TD]BT[/TD]
[TD="align: right"]20[/TD]
[TD]M[/TD]
[TD="align: right"]576[/TD]
[/TR]
[TR]
[TD]BU[/TD]
[TD="align: right"]62[/TD]
[TD]F[/TD]
[TD="align: right"]301[/TD]
[/TR]
[TR]
[TD]BV[/TD]
[TD="align: right"]36[/TD]
[TD]M[/TD]
[TD="align: right"]977[/TD]
[/TR]
[TR]
[TD]BW[/TD]
[TD="align: right"]36[/TD]
[TD]M[/TD]
[TD="align: right"]323[/TD]
[/TR]
[TR]
[TD]BX[/TD]
[TD="align: right"]36[/TD]
[TD]F[/TD]
[TD="align: right"]744[/TD]
[/TR]
[TR]
[TD]BY[/TD]
[TD="align: right"]37[/TD]
[TD]F[/TD]
[TD="align: right"]340[/TD]
[/TR]
[TR]
[TD]BZ[/TD]
[TD="align: right"]37[/TD]
[TD]F[/TD]
[TD="align: right"]196[/TD]
[/TR]
[TR]
[TD]CA[/TD]
[TD="align: right"]34[/TD]
[TD]F[/TD]
[TD="align: right"]786[/TD]
[/TR]
[TR]
[TD]CB[/TD]
[TD="align: right"]55[/TD]
[TD]M[/TD]
[TD="align: right"]837[/TD]
[/TR]
[TR]
[TD]CC[/TD]
[TD="align: right"]53[/TD]
[TD]F[/TD]
[TD="align: right"]138[/TD]
[/TR]
[TR]
[TD]CD[/TD]
[TD="align: right"]24[/TD]
[TD]F[/TD]
[TD="align: right"]408[/TD]
[/TR]
[TR]
[TD]CE[/TD]
[TD="align: right"]44[/TD]
[TD]M[/TD]
[TD="align: right"]161[/TD]
[/TR]
[TR]
[TD]CF[/TD]
[TD="align: right"]48[/TD]
[TD]F[/TD]
[TD="align: right"]833[/TD]
[/TR]
[TR]
[TD]CG[/TD]
[TD="align: right"]43[/TD]
[TD]F[/TD]
[TD="align: right"]637[/TD]
[/TR]
[TR]
[TD]CH[/TD]
[TD="align: right"]62[/TD]
[TD]F[/TD]
[TD="align: right"]859[/TD]
[/TR]
[TR]
[TD]CI[/TD]
[TD="align: right"]25[/TD]
[TD]F[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]CJ[/TD]
[TD="align: right"]63[/TD]
[TD]F[/TD]
[TD="align: right"]949[/TD]
[/TR]
[TR]
[TD]CK[/TD]
[TD="align: right"]46[/TD]
[TD]M[/TD]
[TD="align: right"]876[/TD]
[/TR]
[TR]
[TD]CL[/TD]
[TD="align: right"]23[/TD]
[TD]M[/TD]
[TD="align: right"]477[/TD]
[/TR]
[TR]
[TD]CM[/TD]
[TD="align: right"]19[/TD]
[TD]F[/TD]
[TD="align: right"]770[/TD]
[/TR]
[TR]
[TD]CN[/TD]
[TD="align: right"]63[/TD]
[TD]M[/TD]
[TD="align: right"]513[/TD]
[/TR]
[TR]
[TD]CO[/TD]
[TD="align: right"]30[/TD]
[TD]M[/TD]
[TD="align: right"]268[/TD]
[/TR]
[TR]
[TD]CP[/TD]
[TD="align: right"]7[/TD]
[TD]F[/TD]
[TD="align: right"]613[/TD]
[/TR]
[TR]
[TD]CQ[/TD]
[TD="align: right"]17[/TD]
[TD]M[/TD]
[TD="align: right"]859[/TD]
[/TR]
[TR]
[TD]CR[/TD]
[TD="align: right"]65[/TD]
[TD]M[/TD]
[TD="align: right"]909[/TD]
[/TR]
[TR]
[TD]CS[/TD]
[TD="align: right"]19[/TD]
[TD]F[/TD]
[TD="align: right"]171[/TD]
[/TR]
[TR]
[TD]CT[/TD]
[TD="align: right"]52[/TD]
[TD]F[/TD]
[TD="align: right"]606[/TD]
[/TR]
[TR]
[TD]CU[/TD]
[TD="align: right"]42[/TD]
[TD]M[/TD]
[TD="align: right"]87[/TD]
[/TR]
[TR]
[TD]CV[/TD]
[TD="align: right"]55[/TD]
[TD]M[/TD]
[TD="align: right"]140[/TD]
[/TR]
[TR]
[TD]CW[/TD]
[TD="align: right"]21[/TD]
[TD]F[/TD]
[TD="align: right"]97[/TD]
[/TR]
[TR]
[TD]CX[/TD]
[TD="align: right"]60[/TD]
[TD]M[/TD]
[TD="align: right"]371[/TD]
[/TR]
[TR]
[TD]CY[/TD]
[TD="align: right"]64[/TD]
[TD]F[/TD]
[TD="align: right"]911[/TD]
[/TR]
[TR]
[TD]CZ[/TD]
[TD="align: right"]40[/TD]
[TD]M[/TD]
[TD="align: right"]228[/TD]
[/TR]
[TR]
[TD]DA[/TD]
[TD="align: right"]13[/TD]
[TD]F[/TD]
[TD="align: right"]229[/TD]
[/TR]
[TR]
[TD]DB[/TD]
[TD="align: right"]31[/TD]
[TD]M[/TD]
[TD="align: right"]14[/TD]
[/TR]
[TR]
[TD]DC[/TD]
[TD="align: right"]44[/TD]
[TD]F[/TD]
[TD="align: right"]564[/TD]
[/TR]
[TR]
[TD]DD[/TD]
[TD="align: right"]22[/TD]
[TD]M[/TD]
[TD="align: right"]444[/TD]
[/TR]
[TR]
[TD]DE[/TD]
[TD="align: right"]21[/TD]
[TD]M[/TD]
[TD="align: right"]661[/TD]
[/TR]
[TR]
[TD]DF[/TD]
[TD="align: right"]51[/TD]
[TD]M[/TD]
[TD="align: right"]804[/TD]
[/TR]
[TR]
[TD]DG[/TD]
[TD="align: right"]26[/TD]
[TD]M[/TD]
[TD="align: right"]422[/TD]
[/TR]
[TR]
[TD]DH[/TD]
[TD="align: right"]49[/TD]
[TD]M[/TD]
[TD="align: right"]880[/TD]
[/TR]
[TR]
[TD]DI[/TD]
[TD="align: right"]38[/TD]
[TD]M[/TD]
[TD="align: right"]340[/TD]
[/TR]
[TR]
[TD]DJ[/TD]
[TD="align: right"]22[/TD]
[TD]M[/TD]
[TD="align: right"]853[/TD]
[/TR]
[TR]
[TD]DK[/TD]
[TD="align: right"]50[/TD]
[TD]M[/TD]
[TD="align: right"]514[/TD]
[/TR]
[TR]
[TD]DL[/TD]
[TD="align: right"]62[/TD]
[TD]F[/TD]
[TD="align: right"]588[/TD]
[/TR]
[TR]
[TD]DM[/TD]
[TD="align: right"]14[/TD]
[TD]F[/TD]
[TD="align: right"]293[/TD]
[/TR]
[TR]
[TD]DN[/TD]
[TD="align: right"]34[/TD]
[TD]M[/TD]
[TD="align: right"]127[/TD]
[/TR]
[TR]
[TD]DO[/TD]
[TD="align: right"]20[/TD]
[TD]F[/TD]
[TD="align: right"]364[/TD]
[/TR]
[TR]
[TD]DP[/TD]
[TD="align: right"]44[/TD]
[TD]M[/TD]
[TD="align: right"]217[/TD]
[/TR]
[TR]
[TD]DQ[/TD]
[TD="align: right"]40[/TD]
[TD]F[/TD]
[TD="align: right"]133[/TD]
[/TR]
[TR]
[TD]DR[/TD]
[TD="align: right"]23[/TD]
[TD]F[/TD]
[TD="align: right"]720[/TD]
[/TR]
[TR]
[TD]DS[/TD]
[TD="align: right"]13[/TD]
[TD]M[/TD]
[TD="align: right"]104[/TD]
[/TR]
[TR]
[TD]DT[/TD]
[TD="align: right"]30[/TD]
[TD]F[/TD]
[TD="align: right"]709[/TD]
[/TR]
[TR]
[TD]DU[/TD]
[TD="align: right"]36[/TD]
[TD]M[/TD]
[TD="align: right"]977[/TD]
[/TR]
[TR]
[TD]DV[/TD]
[TD="align: right"]43[/TD]
[TD]F[/TD]
[TD="align: right"]972[/TD]
[/TR]
[TR]
[TD]DW[/TD]
[TD="align: right"]15[/TD]
[TD]F[/TD]
[TD="align: right"]265[/TD]
[/TR]
[TR]
[TD]DX[/TD]
[TD="align: right"]53[/TD]
[TD]M[/TD]
[TD="align: right"]909[/TD]
[/TR]
[TR]
[TD]DY[/TD]
[TD="align: right"]52[/TD]
[TD]F[/TD]
[TD="align: right"]457[/TD]
[/TR]
[TR]
[TD]DZ[/TD]
[TD="align: right"]44[/TD]
[TD]M[/TD]
[TD="align: right"]273[/TD]
[/TR]
[TR]
[TD]EA[/TD]
[TD="align: right"]8[/TD]
[TD]F[/TD]
[TD="align: right"]160[/TD]
[/TR]
[TR]
[TD]EB[/TD]
[TD="align: right"]12[/TD]
[TD]M[/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD]EC[/TD]
[TD="align: right"]47[/TD]
[TD]F[/TD]
[TD="align: right"]986[/TD]
[/TR]
[TR]
[TD]ED[/TD]
[TD="align: right"]33[/TD]
[TD]M[/TD]
[TD="align: right"]918[/TD]
[/TR]
[TR]
[TD]EE[/TD]
[TD="align: right"]30[/TD]
[TD]F[/TD]
[TD="align: right"]251[/TD]
[/TR]
[TR]
[TD]EF[/TD]
[TD="align: right"]55[/TD]
[TD]M[/TD]
[TD="align: right"]944[/TD]
[/TR]
[TR]
[TD]EG[/TD]
[TD="align: right"]61[/TD]
[TD]M[/TD]
[TD="align: right"]272[/TD]
[/TR]
[TR]
[TD]EH[/TD]
[TD="align: right"]48[/TD]
[TD]M[/TD]
[TD="align: right"]778[/TD]
[/TR]
[TR]
[TD]EI[/TD]
[TD="align: right"]6[/TD]
[TD]M[/TD]
[TD="align: right"]458[/TD]
[/TR]
[TR]
[TD]EJ[/TD]
[TD="align: right"]10[/TD]
[TD]M[/TD]
[TD="align: right"]511[/TD]
[/TR]
[TR]
[TD]EK[/TD]
[TD="align: right"]38[/TD]
[TD]M[/TD]
[TD="align: right"]77[/TD]
[/TR]
[TR]
[TD]EL[/TD]
[TD="align: right"]6[/TD]
[TD]M[/TD]
[TD="align: right"]655[/TD]
[/TR]
[TR]
[TD]EM[/TD]
[TD="align: right"]65[/TD]
[TD]F[/TD]
[TD="align: right"]795[/TD]
[/TR]
[TR]
[TD]EN[/TD]
[TD="align: right"]32[/TD]
[TD]M[/TD]
[TD="align: right"]604[/TD]
[/TR]
[TR]
[TD]EO[/TD]
[TD="align: right"]22[/TD]
[TD]F[/TD]
[TD="align: right"]260[/TD]
[/TR]
[TR]
[TD]EP[/TD]
[TD="align: right"]29[/TD]
[TD]M[/TD]
[TD="align: right"]146[/TD]
[/TR]
[TR]
[TD]EQ[/TD]
[TD="align: right"]12[/TD]
[TD]F[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]ER[/TD]
[TD="align: right"]40[/TD]
[TD]F[/TD]
[TD="align: right"]219[/TD]
[/TR]
[TR]
[TD]ES[/TD]
[TD="align: right"]55[/TD]
[TD]F[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]ET[/TD]
[TD="align: right"]24[/TD]
[TD]M[/TD]
[TD="align: right"]688[/TD]
[/TR]
[TR]
[TD]EU[/TD]
[TD="align: right"]10[/TD]
[TD]F[/TD]
[TD="align: right"]302[/TD]
[/TR]
[TR]
[TD]EV[/TD]
[TD="align: right"]64[/TD]
[TD]F[/TD]
[TD="align: right"]857[/TD]
[/TR]
[TR]
[TD]EW[/TD]
[TD="align: right"]44[/TD]
[TD]F[/TD]
[TD="align: right"]51[/TD]
[/TR]
[TR]
[TD]EX[/TD]
[TD="align: right"]49[/TD]
[TD]M[/TD]
[TD="align: right"]54[/TD]
[/TR]
[TR]
[TD]EY[/TD]
[TD="align: right"]24[/TD]
[TD]F[/TD]
[TD="align: right"]989[/TD]
[/TR]
[TR]
[TD]EZ[/TD]
[TD="align: right"]64[/TD]
[TD]M[/TD]
[TD="align: right"]994[/TD]
[/TR]
[TR]
[TD]FA[/TD]
[TD="align: right"]5[/TD]
[TD]F[/TD]
[TD="align: right"]741[/TD]
[/TR]
[TR]
[TD]FB[/TD]
[TD="align: right"]5[/TD]
[TD]F[/TD]
[TD="align: right"]220[/TD]
[/TR]
[TR]
[TD]FC[/TD]
[TD="align: right"]7[/TD]
[TD]F[/TD]
[TD="align: right"]954[/TD]
[/TR]
[TR]
[TD]FD[/TD]
[TD="align: right"]54[/TD]
[TD]M[/TD]
[TD="align: right"]520[/TD]
[/TR]
[TR]
[TD]FE[/TD]
[TD="align: right"]62[/TD]
[TD]F[/TD]
[TD="align: right"]104[/TD]
[/TR]
[TR]
[TD]FF[/TD]
[TD="align: right"]24[/TD]
[TD]M[/TD]
[TD="align: right"]818[/TD]
[/TR]
[TR]
[TD]FG[/TD]
[TD="align: right"]60[/TD]
[TD]F[/TD]
[TD="align: right"]908[/TD]
[/TR]
[TR]
[TD]FH[/TD]
[TD="align: right"]23[/TD]
[TD]F[/TD]
[TD="align: right"]658[/TD]
[/TR]
[TR]
[TD]FI[/TD]
[TD="align: right"]21[/TD]
[TD]F[/TD]
[TD="align: right"]519[/TD]
[/TR]
[TR]
[TD]FJ[/TD]
[TD="align: right"]46[/TD]
[TD]M[/TD]
[TD="align: right"]391[/TD]
[/TR]
[TR]
[TD]FK[/TD]
[TD="align: right"]29[/TD]
[TD]M[/TD]
[TD="align: right"]565[/TD]
[/TR]
[TR]
[TD]FL[/TD]
[TD="align: right"]64[/TD]
[TD]M[/TD]
[TD="align: right"]671[/TD]
[/TR]
[TR]
[TD]FM[/TD]
[TD="align: right"]52[/TD]
[TD]M[/TD]
[TD="align: right"]656[/TD]
[/TR]
[TR]
[TD]FN[/TD]
[TD="align: right"]41[/TD]
[TD]M[/TD]
[TD="align: right"]937[/TD]
[/TR]
[TR]
[TD]FO[/TD]
[TD="align: right"]41[/TD]
[TD]F[/TD]
[TD="align: right"]127[/TD]
[/TR]
[TR]
[TD]FP[/TD]
[TD="align: right"]26[/TD]
[TD]F[/TD]
[TD="align: right"]864[/TD]
[/TR]
[TR]
[TD]FQ[/TD]
[TD="align: right"]10[/TD]
[TD]M[/TD]
[TD="align: right"]88[/TD]
[/TR]
[TR]
[TD]FR[/TD]
[TD="align: right"]30[/TD]
[TD]M[/TD]
[TD="align: right"]958[/TD]
[/TR]
[TR]
[TD]FS[/TD]
[TD="align: right"]38[/TD]
[TD]F[/TD]
[TD="align: right"]789[/TD]
[/TR]
</tbody>[/TABLE]
