Week 1 – The importance of integrity

process data from dirty to clean weekly challenge 1 answers

1. Fill in the blank: If a data analyst is using data that has been _____, the data will lack integrity and the analysis will be faulty.

  • wide
  • compromised
  • public
  • clean

2. A financial analyst imports a dataset to their computer from a storage device. As it’s being imported, the connection is interrupted, which compromises the data. Which of the following processes caused the compromise?

  • Data analysis
  • Data gathering
  • Data manipulation
  • Data transfer

3. A data analyst is given a dataset for analysis. It includes data about the total population of every country in the previous 20 years. Based on the available data, an analyst would be able to determine the reasons behind a certain country's population increase from 2016 to 2017.

  • True
  • False

4. A data analyst is given a dataset for analysis. To use the template for this dataset, click the link below and select “Use Template.”

Link to template: June 2014 Invoices


If you don’t have a Google account, download the CSV file directly from the attachment below.

Which of the following has duplicate data?

  • Data for Symteco on 2/21/2014
  • Data for Symteco on 5/20/2014
  • Data for Valando on 2/18/2014
  • Data for Valando on 1/1/2014

5. A data analyst at a nonprofit organization is working with a dataset about a summer fundraiser. Although they have a lot of useful data by the end of the month, they recognize that the data is insufficient. So, they decide to wait until the end of the season to begin working with the dataset. Which type of insufficient data does this example describe?

  • Outdated data
  • Data from only one source
  • Geographically limited data
  • Data that keeps updating

6. When gathering data through a survey, companies can save money by surveying 100% of a population.

  • True
  • False

7.Fill in the blank: Sampling bias in data collection happens when a sample isn’t representative of _____.

  • the population as a whole
  • a dataset about the population
  • a subset of the population
  • the population most affected by the data


8. Data and business objectives might not align for a number of reasons. Which of the following issues can prevent alignment? Select all that apply.

  • Sampling bias
  • Data integrity
  • Data visualization
  • Insufficient data

Shuffle Q/A 1

9. Which of the following conditions are necessary to ensure data integrity? Select all that apply.

  • Privacy
  • Completeness
  • Statistical power
  • Accuracy

10. What is one potential problem associated with data manipulation that analysts must be aware of?

  • Data manipulation can separate a dataset among different locations.
  • Data manipulation can help organize a dataset.
  • Data manipulation can introduce errors.
  • Data manipulation can make a dataset easier to read.

Devendra Kumar

Project Management Apprentice at Google

Leave a Reply