answersLogoWhite

0

=stdev(...) will return the N-1 weighted sample standard deviation.

=stdevp(...) will return the N weighted population standard deviation.

User Avatar

Wiki User

14y ago

Still curious? Ask our experts.

Chat with our AI personalities

ReneRene
Change my mind. I dare you.
Chat with Rene
RossRoss
Every question is just a happy little opportunity.
Chat with Ross
BlakeBlake
As your older brother, I've been where you are—maybe not exactly, but close enough.
Chat with Blake

Add your answer:

Earn +20 pts
Q: How do you calculate the standard deviation of the mean using Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Continue Learning about Statistics

How do you calculate standard deviation using median?

You cannot because the standard deviation is not related to the median.


What is the standard error of the sampling distribution equal to when you do not know the population standard deviation?

You calculate the standard error using the data.


How do you find standard deviation using a calculator?

The answer depends on what functions are built into your calculator. Read the calculator manual.


Using mean of 6.375 and Standard deviation of 1.47 plot values on normal distribution?

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


How do you calculate salary variance?

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.