Create Cross Tabulation Reports in Google Sheets

von
Coursera Project Network
In diesem Kostenloses angeleitetes Projekt werden Sie:

Understand the fundamentals of crosstabulation analysis.

Select the categoric variables for the crosstabulation analysis based on business needs, audience, dependencies, and actionability in Google Sheets.

Create a crosstabulation report using an alternative method and visualize results of the analysis in Google Sheets.

Präsentieren Sie diese praktische Erfahrung in einem Vorstellungsgespräch

Clock2 hours
IntermediateMittel
CloudKein Download erforderlich
VideoVideo auf geteiltem Bildschirm
Comment DotsEnglisch
LaptopNur Desktop

Cross tabulation or x-tab reports present select slices of data in a matrix format making it easier to visualize patterns and explore similarities and differences between categoric variables. In this project, you will gain hands-on experience cutting through the noise in a data set by creating crosstab reports to methodically compare the differences between groups. You will also understand how cutting through the group differences will aid in gaining insights that a business can use for decision-making. By the end of this project, you will be able to further your business intelligence goals by confidently creating cross tabulation reports to cut through the complexity of survey data to highlight only meaningful group differences. 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.

Anforderungen

Some familiarity with spreadsheet software is helpful.

Kompetenzen, die Sie erwerben werden

Survey AnalysisCompare Group DifferencesBusiness IntelligenceInsight MiningCrosstabulation Analysis

Schritt für Schritt lernen

In einem Video, das auf einer Hälfte Ihres Arbeitsbereichs abgespielt wird, führt Sie Ihr Dozent durch diese Schritte:

  1. Review the fundamentals of crosstabulation analysis.

  2. Identify use cases for creation of crosstab reports and review how they cut through differences in survey data groups.

  3. Begin Exploratory Data Analysis (EDA) and chose categoric variables for the crosstabulation analysis.

  4. Create an x-tabs report with the pivot table method.

  5. Create a second crosstabs report using an alternative method and visualize the results of the crosstabulation analysis.

Ablauf angeleiteter Projekte

Ihr Arbeitsbereich ist ein Cloud-Desktop direkt in Ihrem Browser, kein Download erforderlich

Ihr Dozent leitet Sie in einem Video mit geteiltem Bildschirm Schritt für Schritt an.

Häufig gestellte Fragen

Häufig gestellte Fragen

Haben Sie weitere Fragen? Besuchen Sie das Hilfe-Center für Teiln..