The Importance of Integrity INTRODUCTION

Test your knowledge on data integrity and analytics objectives

1. Which of the following principles are key elements of data integrity? Select all that apply.

2. Which process do data analysts use to make data more organized and easier to read?

3. Before analysis, a company collects data from countries that use different date formats. Which of the following updates would improve the data integrity?

4. Which of the following processes helps ensure a close alignment of data and business objectives?

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

Test your knowledge on insufficient data

1. What should an analyst do if they do not have the data needed to meet a business objective? Select all that apply.

2. Which of the following are limitations that might lead to insufficient data? Select all that apply.

3. A data analyst wants to find out how many people in Utah have swimming pools. It’s unlikely that they can survey every Utah resident. Instead, they survey enough people to be representative of the population. This describes what data analytics concept?

Test your knowledge on testing your data

1. A research team runs an experiment to determine if a new security system is more effective than the previous version. What type of results are required for the experiment to be statistically significant?

2. In order to have a high confidence level in a customer survey, what should the sample size accurately reflect?

3. A data analyst determines an appropriate sample size for a survey. They can check their work by making sure the confidence level percentage plus the margin of error percentage add up to 100%.

Test your knowledge on margin of error

1. Fill in the blank: Margin of error is the _____ amount that the sample results are expected to differ from those of the actual population.

2. In a survey about a new cleaning product, 75% of respondents report they would buy the product again. The margin of error for the survey is 5%. Based on the margin of error, what percentage range reflects the population’s true response?

GOOGLE DATA ANALYTICS COURSERA ANSWERS AND STUDY GUIDE

Weekly Breakdown | Google Study Guides | Back to Top

Process Data from Dirty to Clean Weekly Challenge 1

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

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

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. Which of the following questions can the analyst use this dataset to address? Select all that apply.

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.”

The analyst notices a limitation with the data in rows 8 and 9. What is the limitation?

5. A data analyst is working on a project about the global supply chain. They have a dataset with lots of relevant data from Europe and Asia. However, they decide to generate new data that represents all continents. What type of insufficient data does this scenario describe?

6. In the data analysis process, how does a sample relate to a population?

7. A restaurant gathers data about a new dish by providing free samples to parties of six or more diners. What does this scenario describe?

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.

9. Fill in the blank: Data _____ refers to the accuracy, completeness, consistency, and trustworthiness of data throughout its life cycle.

10. A healthcare company keeps copies of their data at several locations across the country. The data becomes compromised because each location creates a copy of the original at different times of day. Which of the following processes caused the compromise?

11. 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.

12. 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?

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

14. Sometimes during analysis, an analyst discovers that it’s necessary to adjust the business objective. When this happens, the analyst should take the initiative to do so without involving others in order to be respectful of their time.

15. A data analyst is given a dataset for analysis. It includes data about the total population of every country in the previous 20 years. Which of the following questions would the analyst need more data to address? 

16. A restaurant wants to gather data about a new dish by giving out free samples and asking for feedback. Who should the restaurant give samples to?

17. A data analyst at a software company wants to learn more about industry competitors. Because the software industry has more mergers than any other field, the companies and their products are constantly evolving. The analyst has a dataset from three years ago, and they notice that many of the companies and products in the dataset have changed. What makes the analyst decide that the data is insufficient, so they should generate fresh data instead?

18. 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.

19. 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?

20. Fill in the blank: As a data analyst, you need to verify that your data is _____ to ensure your analysis and conclusions are accurate.

21. 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

OR

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

Which of the following has duplicate data?

22. A clothing manufacturer wants to learn more about why their consumers have purchased the brand’s products. How should this manufacturer conduct their survey?

23. A car dealership gathers data about their entire customer population. They decide to conduct a survey to understand why their customers chose their dealership. They send out an email to all customers who have purchased more than two vehicles in the past five years. What does this scenario describe?

24. What can jeopardize data integrity throughout its lifecycle? Select all that apply.

25. A data analyst needs to migrate data from a server located at their company’s headquarters to a remote site. This can lead to what type of data integrity issue? Select all that apply.

26. A data analyst, working for a publishing company, gathers a dataset which includes all books sold in the United Kingdom over the last three years. However, they decide to generate new data that represents global book sales. What type of insufficient data does this scenario describe?

27. A car manufacturer wants to learn more about the brand preferences of electric car owners. There are millions of electric car owners in the world. Who should the company survey?

28. A restaurant gathers data about a new dish by providing free samples to parties of six or more diners. What does this scenario describe?

29. What best describes a sample size?

30. Fill in the blank: In order to have a strong and thorough analysis, a data analyst must verify _____.

31. 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?

32. You are working for a global technology company. You have a dataset with the company’s total cell phone sales by country from 2015 to present. Based on the data you have, what questions are you able to answer?

33. A data analyst is working on a project around a national supply chain. They have a dataset with lots of relevant data from about half of the country. However, they decide to generate new data that represents the entire nation. What type of insufficient data does this scenario describe?

34. A company has multiple retail chain stores. Each store’s database is located onsite and used for various purposes. Which of the following processes could compromise data integrity?

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

36. A high school principal is estimating the total number of students that will attend an upcoming event. She assumes that the older students are unlikely to attend and decides to only survey the first-year students. What issue will the principal face when calculating her estimation? 

37. Fill in the blank: _____ is the process of changing data to make it more organized and easier to read.

38. A company is trying to learn more about their customer base. They would like to conduct a survey to understand why their customers chose their brand. How should the company survey its customers?

39. A candy manufacturer finds an even distribution of sales across all age ranges of customers who purchase their products. The manufacturer decides to conduct a survey to learn more about its customer base. Due to age requirements, they can only send the survey to customers who are 21 years or older. This scenario can be described as what?

40. A data analyst retrieves a sample of their data that is roughly representative of the population as a whole. They realize that there will be some error in their sample results because they didn’t sample the entire population. What is this error called?

The Importance of Integrity conclusion