Questions and Answers.
What is a row in a dataset? - Answer Horizontal record of data.
What is a column in a dataset? - Answer Vertical field representing a variable.
What is a table? - Answer 2D structure made of rows and columns.
Machine learning is a subset of what? - Answer Artificial Intelligence.
When is machine learning useful? - Answer When rules can't be coded easily and lots of data
exist.
When is machine learning NOT ideal? - Answer When rules are simple and datasets are
small.
What is sampling bias? - Answer Some groups are over- or under-represented in the sample.
What is selection bias? - Answer Flawed process for choosing participants.
Examples of aggregate functions - Answer SUM, COUNT, AVG.
What does a scatter plot show? - Answer Relationship between two continuous variables.
When should you not use a pie chart? - Answer When there are more than 4-5 categories.
What does a box plot help identify? - Answer Outliers.
What is a pivot table used for? - Answer Summarizing, grouping, and aggregating data.
What happens to granularity when data is aggregated? - Answer It decreases.
What is metadata? - Answer Data that describes other data.