Good news for survey researchers: Excel can be used for real data analysis. Have your computer handy and Excel launched for this fun, fast-paced, hands-on class for anyone wanting to analyze data—without using SPSS. This 4-part program starts with pivot tables, covers t-test and chi-square tests, and continues up to and including regression. All in Excel.

Note that these real-time classes are taught by Instructor Dan Reynolds in the Research Rockstar virtual classroom. All sessions include hands-on practice sessions with sample data relevant to market researchers, and additional course materials will help students translate statistical procedures into reportable results. During in-class assignments, students will get real-time feedback from the instructor.

Pre-requisite Knowledge: This class will not teach statistical concepts.  It will focus on how Excel can help you calculate the statistical values. Prior to this class, you should have a working knowledge of T-Tests, Chi-squared, and P-values.

NOTE: this class has homework requirements of roughly one hour per week.

Upon course completion, you will be able to:

• Learn the basics of the Excel environment
• Calculate descriptive statistics
• Create one- and two- dimensional pivot tables
• Conduct three kinds of inferential tests: chi-square,  t-test,  and ANOVAs
• Create scatterplots, correlation matrices, and run regressions
• Apply all the above skills, using completed in-class exercises as reference materials