Design a Factor Analysis Using Survey Data in Google Sheets

10 ratings
Offered By
Coursera Project Network
In this Free Guided Project, you will:

Understand the fundamentals of factor analysis.

Examine the factors in survey data that will aid in finding insights.

Conduct a factor analysis with survey data.

Showcase this hands-on experience in an interview

Clock2 hours
CloudNo download needed
VideoSplit-screen video
Comment DotsEnglish
LaptopDesktop only

Surveys collect a wide variety of data covering a wide variety of topics and experiences. To further the complexity of survey data, the respondents answering the questions come from a wide variety of backgrounds and stages in their customer journey. It is reasonable that it would be a challenge to boil down survey data into actionable insights because it can be deceptively complex. Conducting a factor analysis is a useful tactic to cut through the complexity in survey data so that we can land on insights that can fuel decision-making. In this project you will gain hands-on experience designing and conducting a factor analysis with survey data. To do this you will work in the free-to-use spreadsheet software Google Sheets. By the end of this project, you will be able to confidently apply factor analysis techniques to find actionable insights within survey data using any spreadsheet software. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.


Some familiarity with spreadsheet software is helpful, but not required.

Skills you will develop

Drill Down AnalysisSurvey MethodologyStrategic Decision MakingBusiness IntelligenceFactor Analysis

Learn step-by-step

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

  1. Identify how survey data variables can be factored.

  2. Identify use cases for factor analysis and refine variable selection for the project.

  3. Access Google Sheets, import survey data, and choose factors that will aid in finding insights.

  4. Select factors and conduct an analysis with survey data.

  5. Create a visualization and report the analysis findings.

How Guided Projects work

Your workspace is a cloud desktop right in your browser, no download required

In a split-screen video, your instructor guides you step-by-step



View all reviews

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.