COSC 4381 Exam 1 review

Excel is one of the most widely used data-mining and analytic tools.

Which describes database operations that support reporting, decision-support operations, and other analytic operations?

he two common entity relationship diagram (ERD) types are snowflake and frog's foot.

There are three forms of machine learning: supervised, unspervised, and hybrid.

Which contains data for the dependent variables, which influence the dependent variable, and the correct results?

Orange and Rapid Miner are examples of:

MongoDB is a commonly-use relational database.

_____ is the science of making intelligence machines that can perceive visual items, recognize voices, make decisions...

Which of the following represents how the values from one location compare to values in a different location?

Database designers reduce the possibility of insert and update anomalies through a process called:

To normalize data, the designer will decompose a table into one or more related tables.

Data analysts normally use 50% of a data set for training and 50% for testing.

Excel is one of the most widely used visualization tools.

The process of assigning data to matching groups (categories).

NoSQL databases normally store data in _________ format

Which of the following are not commonly used to determine data quality

An Excel CSV file is actually a compressed (zipped) file that contains XML files for each sheet.

_____ offers layers of machine learning for which the output of one layer becomes the input to the next.

______ charts represent how one or more values relate to a larger whole.

_____ is a statistical measure of the relationship between two variables.

To perform forecasting, Excel provides conditional formatting.

Artificial intelligence is a subset of machine learning.

To compare the trends of several related values you should use a ______ chart.

The proportional area of each slice of a pie chart represents its percentage of the entire pie.

To reduce the impact of outlier values on an average, Excel users use the _____ function.

accuracy: Divide the number of predictions that are correct by the total number of items in the set.

Which of these is defined as the middle value in a list of sorted numbers?

Which of the following describes a representation of an object?

The process of identifying patterns in data is

Data mining only applies to numeric data.