=stdev(...) will return the N-1 weighted sample standard deviation.
=stdevp(...) will return the N weighted population standard deviation.
Chat with our AI personalities
You cannot because the standard deviation is not related to the median.
You calculate the standard error using the data.
The answer depends on what functions are built into your calculator. Read the calculator manual.
Your middle point or line for the plot (mean) would be 6.375. Then you would add/subtract 1.47 from your mean. For example, one standard deviation would equal 6.375 + 1.47 and one standard deviation from the left would be 6.375 - 1.47
I believe you are interested in calculating the variance from a set of data related to salaries. Variance = square of the standard deviation, where: s= square root[sum (xi- mean)2/(n-1)] where mean of the set is the sum of all data divided by the number in the sample. X of i is a single data point (single salary). If instead of a sample of data, you have the entire population of size N, substitute N for n-1 in the above equation. You may find more information on the interpretation of variance, by searching wikipedia under variance and standard deviation. I note that an advantage of using the standard deviation rather than variance, is because the standard deviation will be in the same units as the mean.