excel+courses - excel statistics

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

resolvedResolved · Low Priority · Version 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


Server loaded in 0.08 secs.