answersLogoWhite

0


Best Answer

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

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

User Avatar

Wiki User

13y ago
This answer is:
User Avatar

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.

Related questions

How do you calculate standard deviation using median?

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


Is it correct to calculate the standard deviation using duplicate analysis?

No it is not correct.


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 calculate the parameter to a 99.9 confidence interval using mean and standard deviation?

Did you mean, "How do you calculate the 99.9 % confidence interval to a parameter using the mean and the standard deviation?" ? The parameter is the population mean μ. Let xbar and s denote the sample mean and the sample standard deviation. The formula for a 99.9% confidence limit for μ is xbar - 3.08 s / √n and xbar + 3.08 s / √n where xbar is the sample mean, n the sample size and s the sample standard deviation. 3.08 comes from a Normal probability table.


How do you find graph median by using standard deviation?

You cannot because the median of a distribution is not related to its standard deviation.


Can standard deviation be calculated for non normal data?

Standard deviation can be calculated using non-normal data, but isn't advised. You'll get abnormal results as the data isn't properly sorted, and the standard deviation will have a large window of accuracy.


Which measure of variation is appropriate when using the mean?

The variance or standard deviation.


What is standard deviation stretch?

The standard deviation stretch is used to stretch the output values using a normal distribution. The result of this stretch is similar to what is seen by the human eye.


What are the benefits in using Excel in bakery?

it can make your work easy 2 calculate....^_^ ^_^


How can you use Excel to calculate the remainder of a division question?

By using the =MOD function.


Is a standard deviation of 18 considered high?

The standard deviation, in itself, cannot be high nor low. If the same measurements were recorded using a unit that was a ten times as large (centimetres instead of millimetres), the standard deviation for exactly the same data set would be 1.8. And if they were recorded in metres the sd would be 0.018


How do you find standard deviation using a calculator?

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