Your privacy, your choice

We use essential cookies to make sure the site can function. We also use optional cookies for advertising, personalisation of content, usage analysis, and social media.

By accepting optional cookies, you consent to the processing of your personal data - including transfers to third parties. Some third parties are outside of the European Economic Area, with varying standards of data protection.

See our privacy policy for more information on the use of your personal data.

for further information and to change your choices.
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.
Back to article page

BMC Molecular and Cell Biology

ISSN: 2661-8850

Contact us