## Week 6 – Course challenge – Shuffle Q/A 1

#### 13. Scenario 1 continuedThe stakeholders understand your concerns and agree to repeat the indoor paint survey. In a few weeks, you have a much better dataset with more than 150 responses and no duplicates. To use the template for the survey feedback, click the link below and select “Use Template.” Link to template: Kitty Survey FeedbackORIf you don’t have a Google account, download the file directly from the attachment below.If you are using the template, please refer to the New Meer-Kitty survey feedback tab. You notice that questions 4 and 5 are dependent on the respondent’s answer to question 3. So, you need to determine how many people answered Yes to question 3, then compare that to responses to questions 4 and 5. That way, you will know if questions 4 and 5 have any nulls.You decide to use a spreadsheet tool that changes how cells appear when they contain the word Yes. When using this tool, what is the word Yes?

• The value in a VLOOKUP statement
• The value in a conditional formatting rule
• The value in a CONCATENATE range
• The value in the COUNTA range

• True
• False

• Yes
• No

#### 16. Scenario 2, continuedNow, your interviewer explains that the data team usually works with very large amounts of customer survey data. After receiving the data, they import it into a SQL table. But sometimes, the new dataset imports incorrectly and they need to change the format. She asks: Is there a SQL function that can convert data types such as currency, dates, and times in a SQL table?

• Yes, data types including currency, dates, and times can be converted.
• No, only currency can be converted.

• COMBINE
• COALESCE
• CREATE
• CONCAT

• TRIM
• LEN
• SUBSTR
• LENGTH

#### 19. Scenario 1 continuedNow that you’ve identified some limitations with Meer-Kitty’s data, you want to communicate your concerns to stakeholders. In addition to insufficient video trend data, your main concern with the indoor paint survey is that the data isn’t representative of the population as a whole. Clearly, one particular respondent, the superfan, is overrepresented. This means the data doesn’t represent the population as a whole.When surveying people for Meer-Kitty in the future, what are some best practices you can use to address some of the issues associated with sampling bias? Select all that apply.

• Increase sample size
• Use data that keeps updating
• Use data from only one source
• Use random sampling

• True
• False

## Shuffle Q/A 2

#### 21. Scenario 2, continuedNext, your interviewer wants to know more about your understanding of tools that work in both spreadsheets and SQL. She explains that the data her team receives from customer surveys sometimes has many duplicate entries. She says: Spreadsheets have a great tool for that called remove duplicates. In SQL, you can include DISTINCT to do the same thing. In which part of the SQL statement do you include DISTINCT?

• The UPDATE statement
• The SELECT statement
• The FROM statement
• The WHERE statement

• True
• False