Excel 2010-Statistical Features

About the Class:

This workshop lasts 3 hours.

While Excel’s statistics capabilities are not as refined as those of dedicated statistics applications like SPSS, it can be used to perform many common statistical analyses. This workshop is intended for participants who are already comfortable using Excel and who have a familiarity with statistical concepts and terminology, and would like to learn how to perform statistical analyses in Excel. Participants will learn how to perform a variety of statistical procedures in Excel using the function wizard and add-in modules, and how to interpret the results.

What You’ll Learn:

  • Find the mean for a range of data
  • Find the standard deviation of a variable
  • Generate a pivot table
  • Find the correlation among several variables
  • Perform simple regressions and t-tests
  • Interpret the results of these procedures

What You Need to Know:

  • Read a file into Excel
  • Copy, paste and hide columns
  • Switch from one worksheet to another
  • Understand basic statistical concepts

If you y don’t have those skills, consider first taking the workshop:

  • Excel 2010 – The Basics

Resources

Excel 2010(PC) Excel 2011(Mac)
 Microsoft Office: Excel Functions (by Category) Microsoft Office: List of all Functions(by category)
 Microsoft Office: Statistical Functions (reference) Microsoft Office: Standard Deviation Function
 Microsoft Office: Quick Start: Create a PivotTable Report Microsoft Office: Create a PivotTable