Purchase Solution

Standard Deviation vs. Population Standard Deviation

Not what you're looking for?

Ask Custom Question

Can you provide some guidance as to when I should be using standard deviation vs. population standard deviation, particularly in Excel.

Purchase this Solution
Solution Preview

In Excel, you use STDEV when you want to compute the standard deviation of the sample - that is you only have a sample of the population data. However, if you have the data comprising the entire population (not a sample), you would have ...

Solution provided by:
Edwin Sinclar, MBA
Education
  • MBA, Aspen University
  • Bachelor of Science , Berea College
Recent Feedback
  • "Thank u"
  • "Thank You!"
  • "Thanks!"
  • "Thank you so much"
  • "Great job...thanks."
Purchase this Solution
Free BrainMass Quizzes
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.

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.

Measures of Central Tendency

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

View More Free Quizzes
Related BrainMass Solutions

  • Population variance

    a. 4.93 b. 18.1 c. 34.5 d. 35.9 When the sample of 26 observations yields a standard deviation of 7 and standard deviation is calculated by: SD=SQRT(Vs/(n-1)) So the sample variance will be: Vs=SD^2*(n-1)=7^2*(26-1)= 1225 Then X2 = Vs/Vp=1225

  • Multiple choice on Hypothesis testing, distributions

    Answer: C.  Since we are dealing with the standard deviation of all college seniors (entire population and not the sample), 1.3 is the population standard deviation denoted by .

  • Pediatric lung function vs level of cigarette smoking in home

    The test statistic is , where denote the standard deviation of the population. Since population standard deviation is not given, we can approximate the population standard deviation by the sample standard deviation. Thus the test statistic is .

  • Population means

    A random sample of 15 observations from the first population revealed a sample mean of 350 and a sample standard deviation of 12. a random sample of 17 observations from the second population revealed a sample mean of 342 and a sample standard deviation

  • Hypothesis Test for Grocery Receipts

    A simple random sample of 100 grocery receipts was drawn from a normal population. The mean and standard deviation of the sample were $120 and $25, respectively. Test the hypothesis H0: u = 125 vs H1:u not = 125 at the 10% significance level.

  • Hypothesis testing standard deviation with one sample. Minitab

    Use the systolic blood pressures of women listed in the below Data Set to test the claim that the sample comes from a population with a standard deviation of 23.4.

  • Hypothesis test: equal population variances

    On one day the standard deviation in the percent change for a sample of 10 NASDAQ leading gainers was 15.8.

  • Two statistics questions: National average for BMI

    population for BMI): Since the population standard deviation is not known, we use the t- test for a population mean Ho: mu = 26.5 vs Ha: mu ≠ 26.5 t = (x-bar - μ)/(s/√n) = (26.06 - 26.5)/(5.37/√70) = -0.6855 Degrees of freedom = n - 1 = 70

  • Hypothesis testing

    Details Z Test of Hypothesis for the Mean Data Null Hypothesis = 74.5 Level of Significance 0.01 Population Standard Deviation 8 Sample Size 225 Sample Mean 75.9 Intermediate Calculations Standard Error of the Mean

View More Related Solutions