Purchase Solution

Calculating standard deviation, EXCEL

Not what you're looking for?

Ask Custom Question

Using an excel spreadsheet and the stdav function calculate the following data and answer the following questions nunderneath

The data I choose to observe was how long I spent doing dishes over a 10-day period.

Friday, day 1 - 12 minutes.
Saturday, day 2 - 19 minutes.
Sunday, day 3 - 22 minutes.
Monday, day 4 - 0.
Tuesday, day 5 - 17 minutes.
Wednesday, day 6 - 15 minutes.
Thursday, day 7 - 12 minutes.
Friday, day 8 - 11 minutes.
Saturday, day 9 - 11 minutes.
Sunday, day 10 - 14 minutes.

Calculate the Standard Deviation of your data.

Is this a normal distribution?

What are the implications?

Purchase this Solution
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.

Solution Preview

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 ...

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • Calculate the mean, median, and mode

    please check attachment: one word and one excel. The solution gives detailed steps on calculating some values on descriptive statistics: mean, median, mode, standard deviation and z value of normal distribution.

  • Calculating Expected Return from a Stock's Distribution

    Please refer to the EXCEL for calculation expected return = SUM(Return Rate*Probability) = 23.4% Variance = SUM[(Return Rate-Expected rate)^2 *Probability]] = 0.0295 Standard deviation = SQRT(Variance) = 17.2% coefficient of variation = Standard deviation

  • Sample Mean, Variance, Standard Deviation and Quartiles

    - Compare your calculated values with those given by Excel. Questions - Which formula does Excel use for calculating the sample variance and sample standard deviation? - What are the median and the mode of this sample?

  • T-Test for a population mean with σ unknown

    The solution gives detailed steps on calculating t-statistic and p-value using t test for population mean when standard deviation is unknown.

  • Calculate Mean, Median, and Standard Deviation

    A complete, neat and step-by-step solution is provided in the attached Excel file with regards to calculating mean, median and standard deviation.

  • Pappy's Potato: Calculating Project Cash Flows and NPV for your portfolio

    The standard deviation? Expected return: 14.6%. Variance: 0.015305. Standard deviation: 0.1237. b. If the expected T-bill rate is 4.25 percent, what is the expected risk premium on the portfolio? Risk Premium: 14.6%-4.25%=10.3%. c.

  • Statistics

    Your written work for your standard deviation should match or come close to your Microsoft Excel output. Once you are done calculating descriptive statistics, perform a hypothesis test by typing in your responses on page 5 in this document.

  • Finance : Expected Return and Risk

    (Excel: Calculating means, standard deviations, covariance, and correlation) Given the probability distributions of returns for stock X and stock Y, compute: a.

  • Probability and Returns

    I will need to graph the opportunity set, calculate the weights, expected returns, variance and standard deviation in the attached Excel spreadsheet.

  • Building a Frequency Distribution in Excel

    For calculating the standard deviation, go to an empty cell, click fx, a box opens where you can search for the function you are looking for. Type 'standard deviation' in the box, click Go and in the lower box you see alternative functions to use.

View More Related Solutions