Enter the observation data in Excel one observation in each cell. Eventually we divide the sum by number of rows to calculate the mean in excel. Here first SUM function adds all the non numeric value in the given range.
Now we need to start by tricking Excel into calculating the one-sample t-test for us.
AVERAGE B2B7The average goes to any empty cell say B8. Here first SUM function adds all the non numeric value in the given range. We use the following formula to calculate a confidence interval for a difference in population means. The standard error SE or standard error of the mean SEM is a value that corresponds to the standard deviation of a sampling distribution relative to the mean value.