Hi Excel experts,
I'm trying to run a linear regression on two columns with integers as values after filtering them for blanks (missing values) and after filtering the rows based on "yes"/"no" values of another column in the table.
When I run the regression, I get the following error:
Regression - LINEST() Function Error
Question:
1. How can I temporarily filter out the entire rows for which there are no values in a cell within that row?
2. How can I deal with this error in order to run the regression?
[TABLE="width: 164"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Q1[/TD]
[TD]Q3[/TD]
[TD]Q4[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]12[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]17[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]18[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]31[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]34[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]38[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]39[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]40[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]41[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]42[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]43[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]44[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]45[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]46[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]48[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]49[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]50[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]51[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]52[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]53[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]54[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]55[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]56[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]57[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]60[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]61[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]62[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]65[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]66[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]67[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]68[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]69[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]70[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]71[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]72[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]74[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]76[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]77[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]78[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]80[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]81[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]82[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]83[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]85[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]86[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]87[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]88[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]89[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]90[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]94[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]95[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]96[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]97[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]98[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]100[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]101[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]102[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]103[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]104[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]105[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]107[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]108[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]110[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]113[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]114[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]115[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]119[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]121[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]123[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]125[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]126[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]127[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]128[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]129[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]130[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]131[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]134[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]135[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]136[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]138[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]139[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]140[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]141[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]142[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]146[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]147[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]148[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]151[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]152[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]153[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]154[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]155[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]156[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]157[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]158[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]159[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]160[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]162[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]163[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]166[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]168[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]170[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]174[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]175[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]176[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]180[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]181[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]182[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]183[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]184[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]185[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]188[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]189[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]191[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]193[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]195[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]202[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]203[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]204[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]205[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]206[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]207[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]208[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]210[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]211[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]213[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]221[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]222[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]225[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]227[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]228[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]229[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]232[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]233[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]235[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]237[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]238[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]239[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]241[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]242[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
</tbody><colgroup><col><col span="3"></colgroup>[/TABLE]
Thank you in advance.
Lee
I'm trying to run a linear regression on two columns with integers as values after filtering them for blanks (missing values) and after filtering the rows based on "yes"/"no" values of another column in the table.
When I run the regression, I get the following error:
Regression - LINEST() Function Error
Question:
1. How can I temporarily filter out the entire rows for which there are no values in a cell within that row?
2. How can I deal with this error in order to run the regression?
[TABLE="width: 164"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Q1[/TD]
[TD]Q3[/TD]
[TD]Q4[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]12[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]17[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]18[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]31[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]34[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]38[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]39[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]40[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]41[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]42[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]43[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]44[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]45[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]46[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]48[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]49[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]50[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]51[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]52[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]53[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]54[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]55[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]56[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]57[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]60[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]61[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]62[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]65[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]66[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]67[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]68[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]69[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]70[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]71[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]72[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]74[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]76[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]77[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]78[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]80[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]81[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]82[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]83[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]85[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]86[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]87[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]88[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]89[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]90[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]94[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]95[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]96[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]97[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]98[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]100[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]101[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]102[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]103[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]104[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]105[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]107[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]108[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]110[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]113[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]114[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]115[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]119[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]121[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]123[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]125[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]126[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]127[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]128[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]129[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]130[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]131[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]134[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]135[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]136[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]138[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]139[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]140[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]141[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]142[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]146[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]147[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]148[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]151[/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]152[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]153[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]154[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]155[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]156[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]157[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]158[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]159[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]160[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]162[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]163[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]166[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]168[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]170[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]174[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]175[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]176[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]180[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]181[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]182[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]183[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]184[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]185[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]188[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]189[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]191[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]193[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]195[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]202[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]203[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]204[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]205[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]206[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]207[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]208[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]210[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]211[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]213[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]221[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]222[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]225[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]227[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]228[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]229[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]232[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]233[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]235[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]237[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]238[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]239[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]241[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD="align: right"]242[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD]Y[/TD]
[/TR]
</tbody><colgroup><col><col span="3"></colgroup>[/TABLE]
Thank you in advance.
Lee
