PRACTICE QUIZ

This situation describes sampling bias. Sampling bias occurs when a sample isn’t representative of the population as a whole.

To change how cells appear when they meet a certain value, use conditional formatting.

To divide the text strings in Column G around the commas and put each fragment into a new, separate cell, you use SPLIT. SPLIT is a spreadsheet function that divides text around a specified character and puts each fragment into a new, separate cell.

To remove duplicates in SQL, include DISTINCT in your SELECT statement.

The CAST function is used to convert data in a SQL table from one datatype to another.

Using the CONCAT function to combine each string into a single text string would enable you to create a unique key. You can use the key to tell products apart and count them more easily.

To eliminate extra spaces for consistency, use the TRIM function.

Before repeating the survey, it’s necessary to talk with stakeholders, explain the new timeline, and ask for approval.

Without enough data to identify long-term trends, one option is to talk with stakeholders and ask to adjust the objective. You could also ask to wait for more data and provide an updated timeline.

To put each of the colors in Column G into a new, separate cell, use SPLIT. SPLIT is a spreadsheet function that divides text around a specified character and puts each fragment into a new, separate cell.

To search for a certain value in a spreadsheet column to return the corresponding piece of information, use VLOOKUP. 13.Next, 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. Does this mean the team has to remove the duplicate data in a spreadsheet before transferring data to our database? a) Yes b) No (Correct)

The CAST function is used to convert data in a SQL table from one datatype to another.

The TRIM function is used to eliminate extra leading or trailing spaces.

To address some of the issues associated with sampling bias, random sampling can help. With random sampling, analysts can select a sample from a population so that every possible type of the sample has an equal chance of being chosen. In addition, by increasing sample size, you’re more likely to survey part of a population that is representative of the whole.

With numerous duplicates, the best option is to talk with stakeholders and ask for more time. Then, you can repeat the survey in order to create a new, improved dataset.

To add strings together to create new text strings, use the CONCAT function.

To eliminate extra spaces for consistency, use the TRIM function.

The commas are delimiters, which are characters that indicate the beginning or end of a data item.

VLOOKUP searches for a value in the first column of a given range and returns the value of a specified cell in the row in which it is found.

To remove duplicates in a SQL query, include DISTINCT in your SELECT statement.

The CAST function is used to convert currency, dates, and times in a SQL table from one datatype to another. 9, Scenario 1 continued The 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. If you are using the template, please refer to the New Meer-Kitty survey feedback tab located at the bottom of the page. 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. Which tool do you use? a) Conditional formatting (CORRECT) b) Data validation c) Filtering d) CONCATENATE Explanation: To change how cells appear when they meet a certain value, use conditional formatting.