Layer 1 The fact that the dataset includes people who all live in the same zip code might get in the way of what? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 You’ve reached the share phase of the data analysis process. It involves which of the following? Select all that apply. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Next, you determine the average total daily sales over the past 12 months at all stores. The range that contains these sales is E2:E39. Identify the correct way to write your function. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 During analysis, you create a new column F. At the top of the column, you add: Average Percentage of Total Sales – Splashtastic. What is this column label called? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 While cleaning the data, you notice that information about Splashtastic is missing in row 16. You are unsure of how to proceed, so the best course of action is to ask your supervisor for guidance. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Considering the size of your dataset, you decide a spreadsheet will be the best tool for your project. You proceed by downloading the data from the database. Describe why this is the best choice. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A data analyst wants to demonstrate a trend of how something has changed over time. What type of chart is best for this task? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 In the following spreadsheet, where can you find all of the attributes — also known as the observation — of Fayetteville? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 If a data analyst wants to list the cities in this spreadsheet alphabetically, instead of numerically, what feature can they use in column B? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 You are writing a query that asks a database to retrieve data about the customer with identification number 244. The column name for customer identification numbers is customer_id. What is the correct SQL clause? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A data analyst wants to demonstrate how the population in Charlotte has increased over time. They create the chart below. What is this type of chart called? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Fill in the blank: A data analyst creates a table, but they realize this isn’t the best visualization for their data. To fix the problem, they decide to use the _____ feature to change it to a column chart. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 In row 1 of the following spreadsheet, the words rank, name, population, and county are called what? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 To find the average population of the cities in this spreadsheet, what is the correct AVERAGE function syntax? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Fill in the blank: In row 8 of the following spreadsheet, you can find the _____ of Cary. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 When writing a query, what word does a data analyst use to indicate the table from which the data will be retrieved? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 You are writing a query that asks a database to retrieve data about the customer with identification number 5656. The column name for customer identification numbers is customer_id. What is the correct SQL clause? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Fill in the blank: In the following spreadsheet, the _____ feature was used to alphabetize the city names in column B. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 In the following spreadsheet, the observation of Greensboro describes all of the data in row 4. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 In the following spreadsheet, the column labels in row 1 are called what? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 In the following query, FROM is telling the database to filter out data from the Orders table. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A data analyst wants to demonstrate how the population in Charlotte has increased over time. They create this data visualization. This is an example of an area chart. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 To find the average population of the cities in this spreadsheet, you type =AVERAGE. What is the proper way to type the range that will complete your function? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 In the following query, what does FROM tell the database? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions