excel+courses - Excel 2007 Statistics - Mean and standard deviation

Resolved · Low Priority · Version Standard

Excel 2007 Statistics - Mean and standard deviation

Fraser has attended:
Excel Advanced course

by - delegate Fraser [1 post] (2007 Oct 10 Wed, 16:09) Reply

I need to calculate mean and standard deviation for a large range of data. In the data are a few "outliers" that are still numbers. How can I make Excel calculate the mean and standard deviation without being influenced by the outliers?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	3	book now	£475	£495
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	4	book now	£499	£530
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	8	book now	£345	£425
2003	2009 Jan 22 Thu + 23 Fri	Southwark	5	book now	£450	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	6	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
Full Schedule: See all 34 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Excel 2007 Statistics - Mean and standard deviation

by - trainer David gold contributer [418 posts] (2007 Oct 18 Thu, 14:07) Reply

Have you tried the Tools Analysis Pak addins that come with Excel

· How Excel Training Can Improve Your Company's Sales Process
· Microsoft Excel Features and Functions for Accountants
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· Microsoft Excel Courses Teach Advanced Macro Techniques
· How Small Businesses Profit from Outside Excel Training

Excel tip:

Hiding Formulae in the Formula Bar

It is possible to protect the contents of a cell reference(s) from amendment by applying cell protection. The contents of the cell reference can also be stopped from displaying in the formula bar.

Step 1: Select Format > Cells > Protection.

Step 2: Tick Hidden option. Ensure Locked is ticked

Step 3: Select Tools > Protection > Protect Sheet

(Ensure "Protect worksheet and contents of locked cells" is ticked)

View all Excel hints and tips

Rate this page: