Enter your technical replicates (mean, SD, n) to compute the pooled biological replicate. Tab between fields, paste from Excel/Prism, then copy the result back into Prism.
| # | Label | Mean | SD | n |
|---|
SS_within = Σ (nᵢ−1)·SDᵢ² ·
SS_between = Σ nᵢ·(x̄ᵢ − x̄)² ·
SD_combined = √((SS_within + SS_between) / (N−1))Enter on n to add a row. Paste a block from Excel/Prism into any cell to bulk-fill.