Friday 22, 2006

mzl.qrasnfnv.100x100 75 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://www.articlesbase.com/small-business-articles/standard-deviation-calculations-with-microsoft-excel-319906.html

About the Author

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.


,
Small Biz Buzz
  • Cisco WAP2000 Wireless-G Access Point – POE
  • Managing Google PPC In A Small Business – Account Set Up
  • What Are The Most Important Questions To Ask Of Small Business Accounting Software
  • Accounting Software Selection Advice
  • Small Business Accounting Troubles Gets Solved With Accounting Software!


4 Responses

  • jabbamonkey says:
    Wednesday, 31st January 2007 at 2:46 pm

    In Outlook 2003, how do you make an email acct automatically download emails into a specified folder?
    This is for Outlook (not Outlook Express), that came with Microsoft Small Business 2003.

    I have several email acounts (work, home, one for each website, etc.). I know how to create an email account in Outlook (Go to Tools – Email Accounts …). I need to know how to make one of those email accounts download into a new folder I created for each email account (rather then putting ALL the emails into the Inbox). Please let me know, and please provide detailed steps (or links to tutorials). Thanks!

    Reply
    • rchilly2000 says:
      Thursday, 28th December 2006 at 2:53 pm

      OK. You click on tools then go to rules and alerts. click on the e-mail rules tab. then click on add new rule. then from there you just follow the directions. you can create a rule from a template which is probably the best for what you want to do. you can create a rule to move e-mails to a folder based on who it sent from or other ways. Hope this helps!

      Reply
  • g.law333 says:
    Saturday, 27th January 2007 at 11:58 pm

    Web Design?
    Hey I’m a piano tutor in Glasgow and I’ve just recently designed a website (using Microsoft Office Small Business) to help me. The website shows information regarding prices, etc but theres something else that I want to be able to do. I want to be able to give each student a login username and password to a secured area of the site so that they can view their account history (i.e. payments, etc) and when their next lesson/payment is due as well as being able to download anything they need to (i.e. homework/music). If you could help me then this would be great.

    Thanks

    Reply
    • kimmer0616 says:
      Saturday, 20th January 2007 at 2:09 am

      You would need a database to house the information, and front-end web pages with forms as a previous poster mentioned, where the users input their user ID and password. This can be done in a very secure way, provided you have someone that knows how to set this sort of thing up. Have you tried calling technical support for the product?

      On a less serious note, I’d love to take care of it for you if it means I’d get to go to Glasgow..wow! ;-P

      Reply


Leave a Reply