In the following spreadsheet, the observation of greensboro describes all of the data in row 4.

Question 1

Question 1

The column attributes for rank, name, population, and county are located in which row of the following spreadsheet?

• 11
• 1
• 2
• 10

The column labels in row 1 are attributes that refer to the data in the column. An attribute is a characteristic or quality of data used to label a column in a table.

 Question 2

Fill in the blank: In row 8 of the following spreadsheet, you can find the _____ of Cary.

• criteria
• attribute 
• format
• observation

The observation of Cary is in row 8. An observation is all of the attributes for something contained in a row of a data table.

Question 3

If a data analyst wants to list the cities in this spreadsheet alphabetically, instead of numerically, what feature can they use in column B?

• Organize range
• Sort range
• Name range
• Randomize range

Sort range would be 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

A data analyst types =POPULATION(C2:C11) to find the average population of the cities in this spreadsheet. However, they realize that have used the wrong formula. What syntax will correct this function? Type your answer below.

The correct 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

In the following query, what is FROM telling the database to do?

• From which field data should be stored
• From which table to select data
• From which filter data should be selected
• From which field data should be updated

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 5656. The column name for customer identification numbers is customer_id. What is the correct WHERE clause syntax? Type your answer below.

The correct WHERE clause syntax is WHERE customer_id = 5656. WHERE is used to extract only those records that meet a specified criteria. Customer_id = 5656 tells the database to return only information about the customer whose ID is 5656.

 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 pie chart
• A line chart
• A column, or bar, chart 

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?

• Column chart
• Area chart
• Line chart
• Bar chart

This is a line chart. Line charts are effective for demonstrating trends and patterns, such as how population changes over time.

• 一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一

                         Machine Learning Coursera-All weeks solutions [Assignment + Quiz]   click here

                                                                                &

                         Coursera Google Data Analytics Professional Quiz Answers   click here

Have no concerns to ask doubts in the comment section. I will give my best to answer it.

If you find this helpful kindly comment and share the post.

This is the simplest way to encourage me to keep doing such work.

Thanks & Regards,