Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
excel+courses - excel statistics

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+courses - Excel 2007 Statistics - Mean and standard deviation

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

ResolvedVersion Standard

Fraser has attended:
Excel Advanced course

Excel 2007 Statistics - Mean and standard deviation

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?

RE: Excel 2007 Statistics - Mean and standard deviation

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

Excel tip:

Repeat action

The F4 key will usually repeat your last action. e.g. delete a row, then select another row and press F4 to delete again.

View all Excel hints and tips

TrustPilot
TrustScore 4.9 / 5       2394 reviews

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

STL training logo

Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Verified by Visa
Security verified
Microsoft Partner
Terms & Conditions Privacy & Cookie Policy Consent preferences
Server loaded in 0.09 secs.