Google Sheets: Mean Confidence Interval : Manual Calculation
Here is a step-by-step procedure on how to get the 95% confidence interval (or any interval) of the sample mean in Google Sheets. This video includes the formulas for manual calculations. No Google Sheets extensions are needed.
The t-distribution is used since the population standard deviation is not known. The data here are for illustration purposes only and are manually created.