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

13y ago

Still curious? Ask our experts.

Chat with our AI personalities

TaigaTaiga
Every great hero faces trials, and you—yes, YOU—are no exception!
Chat with Taiga
ViviVivi
Your ride-or-die bestie who's seen you through every high and low.
Chat with Vivi
EzraEzra
Faith is not about having all the answers, but learning to ask the right questions.
Chat with Ezra

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.