Databases
Types of Data
Data Visualization
Data Analytics
Hypothesis Tests
100
Most widely used database system. Consists of a database with a set of formally described tables linked to each other by a shared reference.
What is a relational database?
100
This type of data does not have a predefined data model or is not stored in a traditional database structure.
What is unstructured data?
100
This type of graph is used to compare.
What is bar graph?
100
This test allows an analyst to determine the likelihood that a hypothesis is true given the data present in the sample
What is a hypothesis test?
100
This hypothesis test is used to compare two or more populations. It is used to analyze continuous variables.
What is analysis of variance (ANOVA)?
200
Software tools used to store, analyze, modify, and access data.
What are database management systems (DBMS)?
200
This is considered ____________ data.
What is structured?
200
This type of chart is used to present data by comparing area based on the percentage of a group relative to a whole.
What is pie chart?
200
This type of data has a natural order.
What is ordinal data?
200
This hypothesis test is used to determine if the means of two groups are statistically different from each other. It is used to analyze continuous variables.
What is two sample t-test?
300
A formal language used to retrieve information stored in relational databases.
SELECT patient_name FROM patient WHERE gender = "f"
What is SQL?
300
This data quality characteristic is free from error.
What is accuracy?
300
What is a dashboard?
300
Shows the spread of values.
What is standard deviation?
300
This hypothesis test is used to compare a proportion to a standard. It is used to analyze categorical variables.
What is a one sample Z-test for proportions?
400
Inlcudes data on births, deaths, fetal deaths, marriages, and divorces
What is vital statistics?
400
Statistics that are used to describe the distribution of the variable of interest.
(i.e. mean, median, mode)
What are descriptive statistics?
400
This displays the relationship between two quantitative variables.
What is scatter plot?
400
This is an example of this type of chart
What is pareto chart?
400
This statement is used to describe the expected result of a statistical test if there is no difference between the two or more values being compared.
Ex: There is no significant difference in the mean ages of the two populations.
What is a null hypothesis (H0)?
500
A set of descriptions of data items in a data model for reference for systems users.
0=unknown
1=male
2=female
What is data dictionary?
500
The capability of different ISs and software applications to communicate and exchange data.
What is interoperable?
500
This displays a frequency or density distribution of a single numeric variable.
What is a histogram?
500
This statistic is used to describe the association or relationship between two variables.
What is correlation?
500
The smallest alpha level for which the null hypothesis would be rejected, or the probability of incorrectly rejecting the null hypothesis given the sample data collected.
What is a p-value (probability value)?