What you’ll learn in this course

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-week 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

As a student, you get lots of helpful videos, readings and reference material.

 

Take a look inside the course

  • 1

    Welcome

    • Getting Ready to Rock!

    • Rockstar Workbook

    • Table of Recordings

    • Access Your Live Sessions Here

  • 2

    Descriptives and Pivot Tables

    • Rockstar Practice Pre-Assignment

    • Lesson Plan

    • Descriptives and Pivot Tables [Lecture]

    • Descriptives and Pivot Tables [Slide Viewer]

    • Descriptives and Pivot Tables [Slide File Download]

    • Calculating Descriptives and Constructing Pivot Tables Assignment [Action Required]

  • 3

    Inferential Tests

    • Rockstar Practice Pre-Assignment

    • Lesson Plan

    • Inferential Tests [Lecture]

    • Inferential Tests [Slide Viewer]

    • Inferential Tests [Slide File Download]

    • Rockstar Practice

  • 4

    Correlation & Regression

    • Rockstar Practice Pre-Assignment

    • Lesson Plan

    • Correlation & Regression [Lecture]

    • Correlation & Regression [Slide Viewer]

    • Correlation & Regression [Slide File Download]

    • Rockstar Practice [Action Required]

  • 5

    Data Lab

    • Rockstar Practice Pre-Assignment

    • Lesson Plan

    • Data Lab [Lecture]

    • Date Lab [Slide Viewer]

    • Data Lab [Slide File Download]

    • Rockstar Practice [Action Required]

  • 6

    Assessment

    • Your Rockstar Status Awaits: Final Assessment

Meet Your Instructor

Dan Reynolds, PhD

Assistant Professor of Education

Dan Reynolds has more than eleven years' teaching experience including high school, undergraduate, and master's classes — and two years with Research Rockstar. His expertise crosses many kinds of statistics, from basic inferential stats to more complex regressions, multilevel models, structural equation models, and item response models. Dan is an Assistant Professor of education at John Carroll University. He received his PhD in Education from Vanderbilt University in 2017, specializing in quantitative methodologies for social science research with a focus on high school literacy instruction. He also holds an Master's in Education and a Bachelor's in English from the University of Notre Dame.

Frequently Asked Questions

We are committed to advancing the work, and careers, of Market Research & Insights Professionals

  • What is 'hybrid eLearning'?

    Many Research Rocksktar students enjoy the schedule flexibility of our on-demand training format. That's great! But for those seeking an interactive experience with real-time instructor demonstrations and support, nothing beats our real-time sessions! All Research Rockstar courses are offered twice a year in real-time. And 24/7 in the on-demand format.

  • Why memberships?

    Most of our students are working professionals with busy schedules. Sometimes they intend to complete training more quickly than the reality of looming project deadlines allow. With a membership, students have access to all of their classes. No time-outs!

  • Can I get a Free Trial?

    Yes! You can try us out with a 14-day Free Trial.

  • Can I get a group discount?

    Yes. If you have a team of five or more people, please contact [email protected] to ask about volume discounts. We also offer private training for groups either in the virtual classroom or at your location.

Want to Unlock This Course?

Get access to this course and 25+ market research courses with a Backstage Pass membership.

Join Now