I searched the standard error formula in Excel Help and found this:
I tried the formula using this data set:
and the result is 1.65831. This is wrong, because the standard error should be 0.70711.
I know that the standard error is equal to the sample standard deviation over the square root of the size of the sample. If I use this formula, the result is 0.70711.
Can anyone help with the formula in Excel Help? Thanks in advance.