-
Notifications
You must be signed in to change notification settings - Fork 104
1.4.5.Weekly challenge 4
LATEST SUBMISSION GRADE 100%
In row 1 of the following spreadsheet, the words rank, name, population, and county are called what?
-
Descriptors
-
Characteristics
-
Attributes
-
Criteria
Correct. These words are attributes, referring to the information in the columns below. An attribute is a characteristic or quality of data used to label a column in a table.
In the following spreadsheet, where can you find all of the attributes -- also known as the observation -- of Fayetteville?
-
Cell B7
-
Row 6
-
Row 7
-
Column B
Correct. The observation for Fayetteville is in row 7. An observation is all of the attributes for something contained in a row of a data table.
In the following spreadsheet, what feature was used to alphabetize the city names in column B?
-
Sort range
-
Name range
-
Randomize range
-
Organize range
Correct. Sort range was used to alphabetize the city names in column B. Sorting a range of data from A to Z helps data analysts organize and find data more quickly.
To find the average population of the cities in this spreadsheet, what is the correct AVERAGE function syntax?
-
C2*C11
-
C2:C11
-
C2-C11
-
C2,C11
Correct. The range is C2:C11. The full AVERAGE function syntax is =AVERAGE(C2:C11). AVERAGE returns an average of values from a selected range. C2:C11 is the specified range.
When writing a query, what word does a data analyst use to indicate the table from which the data will be retrieved?
-
SELECT
-
WHERE
-
TABLE
-
FROM
Correct. In a query, data analysts use FROM to indicate the table from which the data will be retrieved.
You are writing a query that asks a database to retrieve data about the customer with identification number 1057. The column name for customer identification numbers is customer_id. What is the correct SQL clause?
-
WHERE customer_id is 1057
-
WHERE_customer_id=1057
-
WHERE customer_id 1057
-
WHERE customer_id = 1057
Correct. The correct WHERE clause syntax is WHERE customer_id = 1057. WHERE is used to extract only those records that meet a specified criteria. customer_id = 1057 tells the database to return only information about the customer whose ID is 1057.
A data analyst creates the following visualization to clearly demonstrate how much more populous Charlotte is than the next-largest North Carolina city, Raleigh. What type of chart is it?
-
A scatter chart
-
A line chart
-
A column, or bar, chart
-
A pie chart
Correct. The chart is a column chart. A column chart is effective at demonstrating the differences between several items in a specific range of values.
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?
-
Area chart
-
Line chart
-
Column chart
-
Bar chart
Correct. This is a line chart. Line charts are effective for demonstrating trends and patterns, such as how population changes over time.
https://www.coursera.org/professional-certificates/google-data-analytics
© 2021 Coursera Inc. All rights reserved.