# How to Calculate Pooled Standard Deviations in Excel

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.

Open a new Microsoft Excel spreadsheet.

- Microsoft Office allows you to perform complex functions in Microsoft Excel.
- For most calculations, Excel has a set function you can use.

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

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

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.

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

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.

Type "=c1+c2" in cell C3.

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.

- 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.
- Type "=c1+c2" in cell C3.

Writer Bio

Carter McBride started writing in 2007 with CMBA's IP section. He has written for Bureau of National Affairs, Inc and various websites. He received a CALI Award for The Actual Impact of MasterCard's Initial Public Offering in 2008. McBride is an attorney with a Juris Doctor from Case Western Reserve University and a Master of Science in accounting from the University of Connecticut.