Standard Deviation Calculations With Microsoft Excel

Search:

Standard Deviation Calculations With Microsoft Excel

Excel provides useful statistical functions for finding the standard deviation of a data set. In general, these standard deviation functions retrieve a set of values stored in a worksheet range and then make the expected calculation.

A standard deviation, just to remind readers, is a common measure of describing the spread of observations in a distribution. A standard deviation is related to another statistical measure, the variance. A standard deviation is equal to the square root of the variance.

Standard Deviation of a Sample with the STDEV Function

To find the standard deviation of a sample, ignoring logical values and text, use the STDEV function. This function has the following syntax:

=STDEV(data set range)

For example, to find the standard deviation in the worksheet containing a 10-game sample of a bowler’s scores stored in the worksheet age B2:B11, you could enter:

=STDEV(B2:B:11)

Standard Deviation of a Sample with the STDEVA Function

To find the standard deviation of a sample, and include cells containing the logical value TRUE as 1 and cells containing text or the logical value FALSE as 0 (zero), you use the STDEVA function. This function has the following syntax:

=STDEVA(data set range)

Standard Deviation of a Population with the STDEVP Function

To find the standard deviation of a population, ignoring logical values and text, use the STDEVP function. This function has the following syntax:

=STDEVP(data set range)

Standard Deviation of a Population with the STDEVPA Function

Finally, to find the standard deviation of a population, and include cells containing the logical value TRUE as 1 and cells containing text or the logical value FALSE as 0 (zero), use the STDEVPA function. This function has the following syntax:

=STDEVPA(data set range)

A Final Note About the Data Set Range Argument

One other, final point is worth making: You can include multiple worksheet ranges as your data set range. For example, if you were calculating the standard deviation of a population using the STDEVP function and had your data stored in several different worksheet ranges, your function might look like this:

=STDEVP(B2:B:11,U81:I812,Z100:Z200)

Article Source: http://articlenexus.com

About the author: Seattle accountant and bestselling computer book author Stephen L. Nelson wrote the MBA's Guide to Microsoft Excel, from which this short article is adapted. Nelson also writes and edits downloadable do-it-yourself kits that businesses and investors can use for setting up a Texas limited liability company or a Washington limited liability company<

Please Rate this Article

Not yet Rated

Click the XML Icon Above to Receive Accounting Articles Via RSS!

Additional Articles From - Home | Accounting

	Print This Article
	Add To Favorites
	Email to Friends
	Ezine Ready

Submit Articles
Member Login
Top Authors
Most Popular Articles
Submission Guidelines
Ezine Notifications
Article RSS Feeds

(Your 160x160 ad here)
Only $50 a month-click here

Everything you need for your website and home business.
	Adsense Site Builder
	Adsense Analyzer Software
	Clip Art
	Domain Names
	Header Graphics
	Internet Business Info
	Photo Art
	SEO Software
	Web Hosting $4.95/mo
	Website Templates
	Web Site Promotion Tools
AdvancedWebsiteTools.com

Link Exchange
Blog by WordPress
Privacy Policy
Terms of Service
About Us
Contact Us
Banner Advertisements

Have you Victimized by a Business or the Government? File your consumer complaints or business complaints at BusinessReporter.net!

Structured Settlement?
Free information to help you learn more about structured settlements, your rights, and how to select the best company for you.

Affordable Discount Dental Plans
Choose from over 30 top-quality national and regional discount dental plans. Save 10% to 60% on most dental procedures

Hair Loss Remedies

Remove Bad Credit
Legally Erase Bad Credit and Improve Your Credit Rating
with Self Help Credit Repair
Do It Yourself Credit Repair

Free Diabetic Supplies

Antique Radios | Ham Radios