World Health Organization data - using a pivot table to make sense of it

World Health Organization data - using a pivot table to make sense of it

Assessment

Interactive Video

Computers

9th - 10th Grade

Hard

Created by

Quizizz Content

FREE Resource

This video tutorial on the Global Health YouTube channel explains how to download data from the World Health Organization's website and analyze it using Microsoft Excel Pivot Tables. The tutorial covers the basics of Pivot Tables, including how to summarize data by categories, and provides a step-by-step guide to downloading and preparing data for analysis. It also demonstrates how to create and customize Pivot Tables to analyze data by country and year, and how to filter and visualize the data effectively.

Read more

5 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What is the purpose of using a Microsoft Excel Pivot table in data analysis?

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

Describe the steps to download data from the World Health Organization's webpage.

Evaluate responses using AI:

OFF

3.

OPEN ENDED QUESTION

3 mins • 1 pt

How can you ensure that the data you are working with in Excel is accurate and not derived from formulas?

Evaluate responses using AI:

OFF

4.

OPEN ENDED QUESTION

3 mins • 1 pt

What are the key components you need to set up a Pivot table in Excel?

Evaluate responses using AI:

OFF

5.

OPEN ENDED QUESTION

3 mins • 1 pt

Explain how to filter data in a Pivot table to focus on specific countries and years.

Evaluate responses using AI:

OFF