Create Cross Tabulation Reports in Google Sheets

提供方
Coursera Project Network
在此免费的指导 项目中,您将:

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.

在面试中展现此实践经验

Clock2 hours
Intermediate中级
Cloud无需下载
Video分屏视频
Comment Dots英语(English)
Laptop仅限桌面

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.

必备条件

Some familiarity with spreadsheet software is helpful.

您要培养的技能

Survey AnalysisCompare Group DifferencesBusiness IntelligenceInsight MiningCrosstabulation Analysis

分步进行学习

在与您的工作区一起在分屏中播放的视频中,您的授课教师将指导您完成每个步骤:

  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.

指导项目工作原理

您的工作空间就是浏览器中的云桌面,无需下载

在分屏视频中,您的授课教师会为您提供分步指导

常见问题

常见问题

还有其他问题吗?请访问 学生帮助中心