How to Calculate Pooled Standard Deviations in Excel

Written by carter mcbride
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Calculate Pooled Standard Deviations in Excel
Use Excel to save you time on difficult calculations. (laptop image by Ewe Degiampietro from Fotolia.com)

Microsoft Office allows you to perform complex functions in Microsoft Excel. For most calculations, Excel has a set function you can use. Excel does have a standard deviation function, which you need to calculate pooled standard deviation. However, there is not have a pooled standard deviation function you can use. Since there is no pooled standard deviation function, you need to recreate the formula in steps across several different cells. This will save you the time of calculating pooled standard deviation by hand.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

    Open a new Microsoft Excel spreadsheet.

  2. 2

    Enter your first set of data into column A of the Excel spreadsheet. Use one cell for each data entry.

  3. 3

    Enter your second set of data into column B. Use one cell for each data entry.

  4. 4

    Type "=(N-1)*(STDEV(A1:Bxx)^2)" in cell C1. Replace N with the number of data entries you have in column A. Replace xx with the cell location of the last data entry in column A. For example, if you had 25 cells taken up in column A, you would replace N and xx with 25.

  5. 5

    Type "=(N-1)*(STDEV(B1:Bxx)^2)" in cell C2. Replace N with the number of data entries you have in column B. Replace xx with the cell location of the last data entry in column B.

  6. 6

    Type "=c1+c2" in cell C3.

  7. 7

    Type "=sqrt(C3/(Na+Nb-2)) in cell C4. Replace Na with the number of data entries you have in column A. Replace Nb with the number of data entries you have in column B. The result in C4 is the pooled standard deviation.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.