Coursera Google Data Analytics Professional Process Data from Dirty to Clean (Week 4) Quiz Answer-Verify and report on your cleaning results.

   Recommended Courses:

1. Coursera: Machine Learning
2. Google Data Analytics Professional Certificate.

4.Verify and report on your cleaning results.

Question 1

The data collected for an analysis project has just been cleaned. What are the next steps for a data analyst? Select all that apply.

• Verification
• Certification
• Reporting
• Validation

Verification and reporting are the next steps for a data analyst after the data is cleaned.

Question 2

A data analyst is in the verification step. They consider the business problem, the goal, and the data involved in their analytics project. What scenario does this describe?

• Seeing the big picture
• Considering the stakeholders
• Reporting on the data
• Visualizing the data

To see the big picture when verifying data cleaning, consider the business problem, the goal, and the data.

 

Question 3

Which function removes leading, trailing, and repeated spaces in data?

• CUT
• TRIM
• CROP
• TIDY

TRIM is a function that removes leading, trailing, and repeated spaces in data.

Question 4

A data analyst uses the COUNTA function to count which of the following?

• The total number of headers in a specific range.
• The total number of entries in a changelog.
• The total number of values within a specified range.
• The specific numbers in a dataset.

A data analyst uses the COUNTA function to count the total number of values within a specified range.

 

Question 5

A WHEN statement considers one or more conditions and returns a value as soon as that condition is met.

• True
• False

A CASE statement considers one or more conditions and returns a value as soon as that condition is met.

Question 6

What is the process of tracking changes, additions, deletions, and errors during data cleaning?

• Recording
• Observation
• Documentation
• Cataloging

Documentation is the process of tracking changes, additions, deletions, and errors during data cleaning.

 

Question 7

Fill in the blank: A changelog contains a _____ list of modifications made to a project.

• approximate
• random
• chronological
• synchronized

A data analyst uses a changelog to access the information needed. A changelog is a file that contains a chronological list of modifications made to a project.

 

Question 8

Reviewing version history is an effective way to view a changelog in SQL.

• False
• True

Reviewing version history is an effective way to view a changelog in spreadsheets.

• 一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一

                         Machine Learning Coursera-All weeks solutions [Assignment + Quiz]   click here

                                                                                &

                         Coursera Google Data Analytics Professional Quiz Answers   click here

Have no concerns to ask doubts in the comment section. I will give my best to answer it.

If you find this helpful kindly comment and share the post.

This is the simplest way to encourage me to keep doing such work.

Thanks & Regards,

- Wolf