DATA TYPES
This describes data that can be sorted into categories and labeled.
Categorical
This type of chart uses bars to show quantities or numbers.
Bar graph
Name any two types of joins.
inner join
outer join
Natural join/Equi join/cross join
left outer/right outer/full outer
What is prescriptive analytics?
Asking what should we do about it
What does SMART stand for?
Specific, Measurable, Achievable, Relevant, Time-bound
When analyzing your household income, you are looking at which type of data?
Numeric
A circle graph is often called this because it looks like a popular dessert and you will never use after this class.
Pie Chart
What does an INNER JOIN return?
Rows with matching values in both tables.
What is diagnostic analytics?
Asking why something occurred
What are the four types of analytics?
Descriptive, Diagnostic, Predictive, and Prescriptive
"Date of Birth" refers to this type of data
Special
This type of graph uses points connected by lines to show changes over time.
Line graph
Returns all records from the left table and matched records from the right table.
LEFT JOIN
What are commonly used measures of center?
Mean, Mode, and Median
The answer when you divide the sum of all items in a data set by the number of items.
Mean
This data type consists of names or labels other than numbers.
qualitative
On this type of graph, data is plotted as points and can show a trend or pattern.
Scatter plot
Explain the difference between inner join and outer join.
Inner join returns only matching rows; outer join returns matching rows plus non-matching rows with NULLs.
In the dataset 5, 8, 8, 10, 13, find the median.
8
This number appears most often in a data set.
Mike now wants to bring in data about the students’ report card scores. He has obtained this data and stored them as numbers in a variable called “Score”. Is this variable categorical or quantitative?
Quantitative because it can be used for mathematical calculations
This chart uses boxes to show data distribution, showing minimum, maximum, and median.
Box plot
Returns all records when there is a match in either left or right table.
FULL OUTER JOIN
The measure that describes the typical difference between each data point and the mean.
Standard deviation
The measure that shows the spread or range of data in a set.
Range