Select the cell where you want the 95% confidence interval to appear and type “95% CI” next to it. You can calculate this in Excel by typing “=2*(D21).” D21 is.