Use Google Sheets to construct frequency tables, bar charts, histograms, scatter plots, pie charts to analyze your data.
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.
In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:
Task 1: Frequency tables in Google sheets – Quantitative Data
Task 2: Frequency tables in Google Sheets – Qualitative Data
Task 3: Presenting Frequency Tables as a Bar Graph in Google Sheets
Task 4: Histograms in Google Sheets
Task 5: Pie Charts in Google Sheets
Task 6: Scatter plots in Google Sheets
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
What will I get if I purchase a Guided Project?
By purchasing a Guided Project, you'll get everything you need to complete the Guided Project including access to a cloud desktop workspace through your web browser that contains the files and software you need to get started, plus step-by-step video instruction from a subject matter expert.
Are Guided Projects available on desktop and mobile?
Because your workspace contains a cloud desktop that is sized for a laptop or desktop computer, Guided Projects are not available on your mobile device.
Who are the instructors for Guided Projects?
Guided Project instructors are subject matter experts who have experience in the skill, tool or domain of their project and are passionate about sharing their knowledge to impact millions of learners around the world.
Can I download the work from my Guided Project after I complete it?
You can download and keep any of your created files from the Guided Project. To do so, you can use the “File Browser” feature while you are accessing your cloud desktop.
What is the refund policy?
Is financial aid available?
Financial aid is not available for Guided Projects.
Can I audit a Guided Project and watch the video portion for free?
Auditing is not available for Guided Projects.
How much experience do I need to do this Guided Project?
At the top of the page, you can press on the experience level for this Guided Project to view any knowledge prerequisites. For every level of Guided Project, your instructor will walk you through step-by-step.
Can I complete this Guided Project right through my web browser, instead of installing special software?
Yes, everything you need to complete your Guided Project will be available in a cloud desktop that is available in your browser.
What is the learning experience like with Guided Projects?
You'll learn by doing through completing tasks in a split-screen environment directly in your browser. On the left side of the screen, you'll complete the task in your workspace. On the right side of the screen, you'll watch an instructor walk you through the project, step-by-step.
More questions? Visit the Learner Help Center.