D467 Exploring Data - Set 5 - Part 2

Correct Answer: The average of all values in a dataset

The mean is the sum of all values in a dataset divided by the number of values, representing the average of the dataset.

Correct Answer: Groups records that have the same values in specified columns

The GROUP BY clause in SQL groups records with the same values in specified columns, allowing aggregate functions to be applied to each group.

Correct Answer: It provides a range of values that likely contain the true population parameter

A confidence interval provides a range of values, based on a sample, that is likely to contain the true value of the population parameter.

Correct Answer: Filters records based on specified conditions

The WHERE clause in SQL filters records in a query based on specified conditions, returning only the records that meet those conditions.

Correct Answer: The process of matching fields from one data source to another

Data mapping is the process of matching fields from one data source to another, ensuring that the data is consistent and accurate across systems.

Correct Answer: To represent data graphically for easier interpretation

Data visualization involves the graphical representation of data, such as through charts or graphs, to make the information easier to understand and interpret.

Correct Answer: A method of selecting a sample where every individual in the population has an equal chance of being selected

Random sampling ensures that every member of the population has an equal chance of being included, reducing bias in the sample.

Correct Answer: The process of storing the same data in multiple locations

Data replication involves storing copies of data in different locations, providing redundancy and ensuring data availability.

Correct Answer: To summarize, sort, reorganize, group, count, and average data

A pivot table allows users to organize and summarize large amounts of data by grouping and performing calculations like sums, averages, and counts.

Correct Answer: Combining rows from two or more tables based on a related column

The SQL JOIN clause is used to combine rows from multiple tables based on a common field, enabling the retrieval of related data from different sources.

Correct Answer: Counts the number of cells that contain numbers

The COUNT function is used to count the number of cells in a range that contain numeric values.

Correct Answer: Individuals have the right to control the data they provide

The principle of ownership ensures that individuals have control over their personal data and can decide how it is used.

Correct Answer: Joins two or more text strings into one

The CONCATENATE function is used to join two or more text strings into a single string in a spreadsheet.

Correct Answer: The tendency to search for or interpret information in a way that confirms pre-existing beliefs

Confirmation bias occurs when people favor information that confirms their pre-existing beliefs, potentially leading to skewed analysis results.

Correct Answer: Removing personally identifiable information from a dataset to protect privacy

Data anonymization is used to remove identifying information from a dataset, ensuring the privacy of individuals whose data is being analyzed.

Correct Answer: A method for determining if the results of a survey or experiment are statistically significant

Hypothesis testing is a statistical process used to determine whether the results of a study are meaningful or occurred by chance.

Correct Answer: Removes leading and trailing spaces from text

The TRIM function in SQL is used to remove unwanted spaces from the beginning and end of text strings, ensuring data consistency.

Correct Answer: The process of selecting a portion of the population to represent the entire population

Sampling involves selecting a representative subset of the population for analysis to draw conclusions about the entire population.

Correct Answer: A field that links records in one table to records in another table

A foreign key creates a relationship between two tables by linking records in one table to records in another, facilitating data integrity.

Correct Answer: It indicates the maximum expected difference between the sample results and the true population values

The margin of error reflects the level of precision in a survey or experiment, indicating how much the sample results are expected to differ from the true population values.