Summarizing Data Using Google Sheets

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

Use Google Sheets to construct frequency tables, bar charts, histograms, scatter plots, pie charts to analyze your data.

ClockThis is a project-based course that should take approximately 2 hours to complete.
CloudNo download needed
VideoSplit-screen video
Comment DotsEnglish
LaptopDesktop only

This project gives you easy access to the invaluable summarizing data techniques used by experts in business, science, math, sports, art, music, literature, and many other disciplines. We’ll learn how to summarize vast amounts of data into a few numbers, charts, and graphs to gain the invaluable insights hidden in them. We’ll also cover the most commonly used methods in the business setting while focusing on how to develop them and when one is more appropriate than others. We will use Google Sheets and large data sets to illustrate how to create the summary techniques. Using these techniques, no matter what your skill levels in the topic, you can change your way of solving problems using data and approaching them. If you’re already an expert, this peep under the methods in data science will give you ideas for turbocharging successful learning, including tips and insights that will help you make the best use of data for your decision-making. If you’re struggling, you’ll see a structured treasure trove of practical techniques that walk you through what you need to do to get on track. If you’ve ever wanted to become better at summarizing data, this project will help serve as your guide. This Guided Project was created by a Coursera community member.

Skills you will develop

Data Summarizing TechniquesGoogle SheetsData AnalysisData Visualization (DataViz)Frequency Distribution

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. Task 1: Frequency tables in Google sheets – Quantitative Data

  2. Task 2: Frequency tables in Google Sheets – Qualitative Data

  3. Task 3: Presenting Frequency Tables as a Bar Graph in Google Sheets

  4. Task 4: Histograms in Google Sheets

  5. Task 5: Pie Charts in Google Sheets

  6. Task 6: Scatter plots in Google Sheets

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.