The standard deviation would be 5.926400444
The average is 13.3 min
To test for normal distribution, we can look at the skew of the data. This is -0.988717886, which tells us that the data is skewed to the left, so on most days you did less then 13.3 minutes of dish washing. However, one day you did not do any dishes, which will definitely impact the data, which is seen as an outlier.

What if we took at day 4 ...

Solution Summary

This posting uses excel to calculate standard deviations. The excel worksheet is attached to the posting. It also looks at characteristics of the data such as is the distribution is normal (or is it skewed)? It also discusses the implications of having non-normal data.

... to calculate standard deviation and variance on excel. Use the data below to answer the determine variance and standard deviation. (note: carry your calculator...

... Compare your calculated values with ... Questions - Which formula does Excel use for calculating the sample variance and sample ... Use these values to calculate the z ...

... done using excel and showing how the answers were calculated. ... 8.56 This is calculating the PMT for an annuity ... We can also calculate the value directly by using ...

...deviations of each variable. x y Mean 41.95 245.3 Standard Deviation 18.2799142 130.6127664 Please see the excel spreadsheet. c) Working in Excel, calculate...

... To calculate the variance of a portfolio of two ... expected return of 11% the standard deviation will be ... This solution calculates the expected return and standard...

how to calculate mean and standard deviation. ... all formulas and demonstrates how mean and standard deviation are calculated... Results are also calculated in Excel. ...

... gives detailed steps on computing the mean, variance and standard deviation using both hand and excel. 1) Please calculate the standard deviation, mean, and ...

... predict the limits of expected variation by calculating the mean ... 2. Calculate the standard deviation for each. ... use Excel, or you may use a calculator or other ...

... will make the right side show all the statistical tests you can do with EXCEL. Pick "average" and it will calculate the mean, pick "standard deviation", and it ...

... We can however calculate the coefficient of variation = standard deviation divided by the ... This job calculates the problem's expected NPV, standard...