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.

(Description continued below)

Participants will:

• 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

The following workshops are suggested prerequisites to this workshop:

• Excel: The Basics

Participants should already be able to:

• read a file into Excel
• copy, paste and hide columns
• switch from one worksheet to another
• understand basic statistical concepts