1.4.5.Weekly challenge 4 - sj50179/Google-Data-Analytics-Professional-Certificate GitHub Wiki

LATEST SUBMISSION GRADE 100%

Question 1

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.

Question 2

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.

Question 3

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.

Question 4

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.

Question 5

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.

Question 6

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.

Question 7

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.

Question 8

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.