Question: how to calculate standard error of mean in excel 2007?
Answer: The standard error of the mean may be calculated by dividing the standard deviation by the square root of the number of values in the dataset. There is no direct function in MS Excel to get it automatically. Therefore, you must refer to its definition and type =STDEV(...)/SQRT(COUNT(...)) . )/SQRT(COUNT(A1:A100)) .