Skip to main content

Table 1 Excel Formulae used in spreadsheet analysis

From: A new spreadsheet method for the analysis of bivariate flow cytometric data

Formula A (average)

{=(IF(D3<4,"x",AVERAGE(IF($A$3:$A$60000=$A2,$B$3:$B$60000))))}

Formula B (cell count)

=COUNTIF($A$3:$A$60000,$A2)

Formula C (standard deviation)

{=IF(B3="x","x",(STDEV(IF($A$3:$A$60000=$A2,$B$3:$B$60000))))}

Formula D (variance)

=IF(B3="x","x",C3^2)

Formula E (99.9% confidence interval)

=IF(B3="x",0,CONFIDENCE(0.001,C3,D3))

Formula F (paired students t-test)

=IF((AND(B3<>"x",N3<>"x")),(ABS(B3-N3))/(SQRT((F3/D3)+(R3/P3))),"x")

Formula G (degrees of freedom)

=IF((AND(B3<>"x",N3<>"x")),((D3+P3)-2),"x")

Formula H (critical t value 99.9%)

=TINV(0.001,T3)

Formula I (Significance at 99.9%)

=IF((AND(B3<>"x",N3<>"x")),(IF((H3>(LOOKUP(I3,$T$3:$T$1002,$V$3:$V$1002))),980,-50)),-50

  1. Formulae used in spreadsheet calculations to analyse flow cytometric data. See methods for further details on the function of each.