Layer 1 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? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 As the survey has too few responses and numerous duplicates that are skewing results, you should remove the duplicates and continue analyzing the remaining 29 responses. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 There is a spreadsheet function that 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. It is called SEARCH. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 She asks: What function would you use to convert data in a SQL table from one datatype to another? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 You decide to use a spreadsheet tool that changes how cells appear when they contain the word Yes. Which tool do you use? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 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. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 In situations such as this one, could you use the CONCAT function to add strings together to create new text strings? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 She asks: Is there a command or function that converts data in a SQL table from one datatype to another? You respond: Yes, it’s the CAST function. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 She asks: Which SQL function enables you to eliminate those extra spaces for consistency? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 You use a spreadsheet function to divide the text strings in Column G around the commas and put each fragment into a new, separate cell. In this example, what are the commas called? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 As the survey has too few responses and numerous duplicates that are skewing results, you decide to repeat the survey in order to create a new, improved dataset. What is your first step? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 She says: Spreadsheets have a great tool for that called remove duplicates. But when writing a SQL query, what command should you include in your SELECT statement to remove duplicates? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 There is a spreadsheet function that allows a data analyst to search for a value in the first column of a given range and return the value of a specified cell in the row in which it is found. What function allows you to complete these tasks? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 She asks: Which function would enable you to eliminate those extra spaces? You respond: To eliminate extra spaces for consistency, use the TRIM function. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 She then asks: If you were to use the CONCAT function to complete this task, what would it enable you to do? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Clearly, one particular respondent, the superfan, is overrepresented. What does this situation describe? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Without enough data to identify long-term trends about the video subjects that people prefer, what should you do? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 As part of the data-cleaning process, a data analyst creates a rule to highlight any empty cells in a bright blue color. This is an example of data visualization. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Fill in the blank: Data mapping is the process of _____ fields from one data source to another. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 They want to create employee identification numbers (IDs) in column D. The IDs should include the year hired plus the last four digits of the employee’s Social Security Number (SS#). What function will create the ID 20093208 for the employee in row 5? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 In which of the following situations would a data analyst use SQL instead of a spreadsheet? Select all that apply. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A data analyst is cleaning transportation data for a ride-share company. The analyst converts the data on ride duration from text strings to floats. What does this scenario describe? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A data analyst is working with customer data. The analyst includes the DISTINCT clause in their SELECT statement for the customer_id field. They get a list of customer_id without duplicates. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A data analyst is analyzing medical data for a health insurance company. The dataset contains billions of rows of data. Which of the following tools will handle the data most efficiently? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions