Prepare Data for Exploration Course Challenge Answers (Part 2: Q11–20)
This is Part 2 of the Module 6 quiz answers for “Prepare Data for Exploration Course Challeng” from the Google Data Analytics Professional Certificate on Coursera.
Here, we’ll walk through questions 11 to 20 with detailed explanations to support your learning.
To find answers to the remaining questions, check out the full module breakdown below:
11. Scenario 1, questions 1-5
You’ve been working at a data analytics consulting company for the past six months. Your team helps restaurants use their data to better understand customer preferences and identify opportunities to become more profitable.
To do this, your team analyzes customer feedback to improve restaurant performance. You use data to help restaurants make better staffing decisions and drive customer loyalty. Your analysis can even track the number of times a customer requests a new dish or ingredient in order to revise restaurant menus.
Currently, you’re working with a vegetarian sandwich restaurant called Garden. The owner wants to make food deliveries more efficient and profitable. To accomplish this goal, your team will use delivery data to better understand when orders leave Garden, when they get to the customer, and overall customer satisfaction with the orders.
Before project kickoff, you attend a discovery session with the vice president of customer experience at Garden. He shares information to help your team better understand the business and project objectives. As a follow-up, he sends you an email with datasets.
Click below to read the email:
And click below to access the datasets:
Reviewing the data enables you to describe how you will use it to achieve your client’s goals. First, you notice that all of the data is first-party data. What does this mean?
- It’s data that was collected from outside sources.
- It’s data that was collected by Garden employees using the company’s own resources. ✅
- It’s a type of data that’s categorized without a set order.
- It’s subjective data that measures qualities and characteristics.
Explanation:
This reaffirms Q1: First-party means collected directly by the business (Garden).
12. Scenario 1 continued
Next, you review the customer satisfaction survey data. To use the template for the customer satisfaction survey data, click the link below and select “Use Template.”
Link to template: Customer Satisfaction Survey data
OR
If you don’t have a Google account, download the CSV file directly from the attachment below.
You notice that the data in column E is an example of Boolean data. Why did you come to this conclusion?
- It has each subject in multiple rows.
- It is qualitative data with a set order or scale.
- It has only two possible values. ✅
- It is organized in a certain format, such as rows and columns.
Explanation:
Boolean data is binary, having only two possible states, such as “Yes/No,” “True/False,” or “1/0.” This type of data is commonly used in decision-making and logical operations.
13. Scenario 1 continued
Now, you review the data on delivery times and the distance of customers from the restaurant.
To use the template for the dataset, click the link below and select “Use Template.”
Link to template: Delivery Times/Distance
OR
If you don’t have a Google account, download the CSV file directly from the attachment below.
Fill in the blank: The data in column E is an example of _____ data. Select all that apply.
- continuous
- qualitative
- discrete ✅
- quantitative ✅
Explanation:
Quantitative data measures numerical facts and is often classified as either discrete or continuous. Discrete data has a limited number of values (e.g., counts of deliveries), making it specific and countable.
14. Scenario 1 continued
The next thing you review is the file containing pictures of sandwich deliveries over a period of 30 days. What type of data is this?
- Ordinal
- Unstructured ✅
- Discrete
- Relational
Explanation:
Images, videos, audio—these are all unstructured data types.
15. Scenario 1 continued
Now that you’re familiar with the data, you want to build trust with the team at Garden.
What actions should you take when working with their data? Select all that apply.
- Keep the data safe by implementing data-security measures, such as password protection and user permissions. ✅
- Share the client’s data with other delivery restaurants to compare performance.
- Post on social media that you’re working with Garden and would like feedback from any of your contacts who have ordered there before.
- Organize the data using effective naming conventions. ✅
Explanation:
Security (e.g., passwords) and good organization build trust. Sharing data without permission damages trust.
16. Scenario 2, questions 6-10
You’ve completed this program and are interviewing for a junior data scientist position at a company called Sewati Financial Services.
Click below to review the job description:
So far, you’ve successfully completed the first interview with a recruiter. They arrange your second interview with the team at Sewati Financial Services.
Click below to read the email from the human resources director:
You arrive 15 minutes early for your interview. Soon, you are escorted into a conference room, where you meet Kai Harvey, the senior manager of strategy. After welcoming you, he begins the behavioral interview.
Consider and respond to the following question. Select all that apply.
Our data analytics team often surveys clients to get their feedback. If you were on the team, how would you ensure the sample is representative of the population as a whole?
- Only include participants who can answer survey questions in a timely manner.
- Make sure the sample is chosen at random. ✅
- Include clients with disabilities in the survey sample. ✅
- Use a randomized sample of the population that includes all genders. ✅
Explanation:
To get a representative sample, you must:
- Use random sampling
- Avoid bias or exclusion
- Ensure diversity in the sample
17. Scenario 2 continued
Next, your interviewer wants to better understand your knowledge of basic SQL commands. He asks: How would you write a query that retrieves only data about people who joined our firm in 2019 from the Clients table in our database?
18. Scenario 2 continued
For your final question, your interviewer explains that Sewati Financial Services cares about its clients’ trust, and this is an important responsibility for the data analytics team. They do this by:
protecting clients from unauthorized access to their private data
ensuring freedom from inappropriate use of client data
getting consent to use someone’s data
He asks: Which data analytics practice does this describe?
- Encryption
- Bias
- Data privacy ✅
- Sharing permissions
Explanation:
Data privacy ensures that personal information is protected during collection, storage, and use. It’s a fundamental practice for building trust and complying with regulations.
19. Scenario 1 continued
Next, you review the customer satisfaction survey data. To use the template for the customer satisfaction survey data, click the link below and select “Use Template.”
Link to template: Customer Satisfaction Survey data
OR
If you don’t have a Google account, download the CSV file directly from the attachment below.
The question in column E asks, “Was your order accurate? Please respond yes or no.” What kind of data is this?
- Second-party data
- Ordinal data
- Clean data
- Boolean data ✅
Explanation:
This question only allows two possible answers: “yes” or “no”. That makes it Boolean data — a type of data that can have only two values (like true/false, yes/no). It’s commonly used in surveys or situations where a simple binary response is needed.
20. Scenario 1 continued
The next thing you review is the file containing pictures of sandwich deliveries over a period of 30 days. This is unstructured data, which means what?
- It’s organized in a certain format.
- It’s not organized in an easily identifiable manner. ✅
- It’s objective and measures facts.
- It’s collected by a group directly from its audience and then sold.
Explanation:
Unstructured data, like images or videos, lacks a predefined format and is not stored in rows and columns. It requires specialized tools and methods for analysis.
Hope this helped! Use the buttons below to move to the previous or next part.