edX: Intro Course: Spreadsheets and Statistics

• Master the basics of data analysis in Google Sheets with formatting, formulas, calculations, and charts.
• Prepare data by importing from disparate sources and reducing noise with data cleaning tactics.
• Evaluate the quality of your data and how to best use it.
• Utilize out-of-box statistical visualizations to aid in your exploratory data analysis.

Introduction to Spreadsheets

• The anatomy of a spreadsheet
• Applying basic formatting to data to improve readability
• Manipulating data using rows, columns, and ranges
• Using Formulas and calculations
• Creating charts in Google Sheets and using spreadsheets to communicate insights.

Data Preparation

• The importance of data preparation for effective data analysis
• Importing data from different sources
• Working with datasets in Google Sheets
• Raw data characteristics and common issuesData cleaning
• Using pivot tables to summarize data
• Creating dashboards in Google Sheets

Statistics Fundamentals

• Mean, median, and mode definitions and finding them in Google Sheets
• Visualizing the mean in a chart
• Identifying min, max, and range of a data set
• Methods for inspecting data
• Using and interpreting bar charts, line charts, and histograms

Exploratory Data Analysis

• Identifying patterns of data distribution
• Skew, distribution, and percentilesCalculating variance
• Calculating standard deviation
• Calculating z-score and interpreting it visually
• Creating and interpreting scatterplots