Data Basics
What is "the collection of recorded observations"?
Data
Is a pie graph for categorical or numerical data?
Categorical data
What format should your original data be in before you begin creating Pivot Tables/Charts from the data?
Table
What is the statistical term for a measure of center, or average?
mean
Name one benefit data science brings to companies.
Making better decisions, increase efficiency, predict outcomes or trends, develop better products...
What is "data that is collected about us through our digital behavior and recorded by digital services, systems, and tools."?
Data Trail
Simple graph that shows each data value as a dot aboves its location on a number line.
Dotplot
What do we call a visual representation within an Excel spreadsheet that summarizes key information about a data set on a single sheet that is visually appealing?
Dashboard
What is a numerical measure that represents how spread out from the mean a set of data is?
Standard Deviation
What type of math plays a vital role in data science?
Statistics
Is favorite sport a categorical or numerical variable?
Categorical
What type of shape does a graph have (dotplot or histogram) if the mean is greater than the median?
Right-skewed
What tool can be inserted alongside your Pivot Tables/Charts to "filter" your data by the press of a button?
Slicer
Known as the "proportion of observations that belong to a category."
Relative Frequency
The ability of digital computers to perform tasks that are commonly performed by humans is called what?
Artificial Intelligence
What is it called when you go through the process of correcting or removing incorrect, incomplete, or duplicated data in a data set?
Data Cleaning
The shape of a histogram or dotplot is analyzed according to what two things?
Symmetry and Number of Peaks
Why is the name "Pivot" used in Pivot Tables and Charts?
Because you can easily "Pivot" the data from columns to rows and vice versa.
What value is Q3 - Q1 or the 3rd quartile - the 1st quartile? (This is known as the range of the middle 50% of the data).
IQR - Interquartile Range
What is the term used for "a collection of huge data sets that normal computing techniques cannot process"?
Big Data
Is this a valid statistical question?
How long can students at your school hold their breath?
Yes
What type of graph is used to plot numerical bivariate data to see if there is a relationship between them?
Scatterplot
If you want to connect data from more than 1 table or sheet to use in the same Pivot Table or Chart, what do you need to create?
Data Model
Interpret this value of r according to three things:
r = -0.89
Strong, Negative, Linear correlation between x and y
What comes next?
byte (B), kilobyte (KB), Megabyte (MB), Gigabyte (GB), ??
Terabyte (TB)