1.1 Organizing data for analysis

Fill in the blank: The goal of analysis is to identify ___ within data in order to accurately answer questions and solve problems.

A. value and meaning

B. all possible insights

C. trends and relationships

D. opportunities and risks

C. trends and relationships

A data analyst organizes a database to show only the 100 most recent real estate sales in Stamford Connecticut. What steps do they take?

A. Add a filter to return only sales in Stamford, Connecticut, then sort the most recent sales at the top of the list.

B. Filter out sales in Stamford, Connecticut, then sort the most recent sales at the top of the list.

C. Fitter out sales in Stamford, Connecticut, then sort the least recent sales at the top of the list.

D. Add a filter to return only sales in Stamford, Connecticut, then sort the least recent sales at the top of the list.

A. Add a filter to return only sales in Stamford, Connecticut, then sort the most recent sales at the top of the list.

What term describes data points that are very different from similarly collected data and, therefore. might not be reliable values?

A. Norms

B. Errors

C. Outliers

D. Noise

C. Outliers

In what way is the SQL WHERE clause similar to filtering in spreadsheets?

A. Both the WHERE clause and spreadsheet filters enable data professionals to remove duplicate columns.

B. Both the WHERE clause and spreadsheet filters enable efficient sorting of data.

C. Both the WHERE clause and spreadsheet filters return a subset of data based on specified criteria.

D. Both the WHERE clause and spreadsheet filters can be used to create pivot tables.

C. Both the WHERE clause and spreadsheet filters return a subset of data based on specified criteria.