6. Filtering and Exploring Data Free Online FlashCards

What does filtering do?

Filtering displays only rows that satisfy specified conditions while leaving the underlying values unchanged when used as a view or query.

In a data table, what do rows and columns represent?

Rows represent observations, while columns represent variables such as date, region, product, quantity, or price.

What is sorting?

Sorting rearranges rows according to one or more columns, such as alphabetically, numerically, chronologically, or by custom categories.

What does grouping do?

Grouping combines records that share a category or interval so they can be compared or summarized.

How does grouping differ from sorting?

Grouping creates categories for comparison, whereas sorting only places records in an order.

What is an aggregation?

An aggregation reduces many values to a summary value, such as a count, sum, average, median, minimum, or maximum.

What formula calculates order revenue?

Revenue equals Units × Unit Price. In the example, the three orders generate $48, $40, and $36.

How is weighted average price calculated?

Weighted average price equals total revenue divided by total units, giving each unit the appropriate influence.

Which chart examines change over time?

A line chart is appropriate for examining change over time.

Which chart examines two numeric variables?

A scatter plot examines the relationship between two numeric variables.

What should be done with raw data first?

Preserve an unchanged copy of the original file before transforming or analyzing the data.

What should be documented after applying a filter?

Record the exact filtering rule and the number of rows remaining after filtering.