quiz 1, quiz 2, quiz 3, quiz 4, quiz 5, Quiz 6, quiz 7

How many characteristics are there that distinguish Big Data from traditional data?

Three

A choropleth map is also known as a _____ map.

filled

What is the function of the xlim and ylim flags?

To set the upper and lower bounds on the axes in the graph

Business intelligence (Bl) has been defined as:

a broad category of applications, technologies, and processes for gathering, storing, accessing, and analyzing data to help business users make better decisions.

By using which function, can a user insert a vector of numbers?

c()

Where will the Solver button appear if the Solver Add-in is already loaded?

In the Data tab, under the Analysis section

What is the function of the report filter?

It allows a user to select only a subset of the data, such as Frozen Treats.

What is the purpose of the PivotTable builder?

It allows to take the columns from the original selected data and use them as report filters, column and row labels for grouping, or values.

Which of the following statements is true regarding the subjective method?

It comes from the person's intuition or reasoning.

Which of the following statements is true regarding prescriptive analytics?

It goes beyond descriptive and predictive models by recommending one or more courses of action.

Which of the following statements describes Comprehensive R Archive Network (CRAN)?

It is a repository of many of the useful packages that can be loaded into R to extend its functionality.

Which of the following statements is true regarding master data management?

It is a strategy for implementing data governance.

Which of the following statements is true regarding a linear program?

It is characterized as a set of decisions that need to be made to optimize an objective in light of some constraints.

Which of the following statements is not true about the structured decisions?

It is one in which there is no standardized procedure for carrying out any of the three phases of the decision process.

Which of the following statements is true regarding the skmeans package?

It is written by a third party as a package that a user can load into R and use.

In the figure given below, if you will apply the VLOOKUP function in the cell F2, like: =VLOOKUP(A2,Calories!$A$1:$B$15,2,FALSE) What does FALSE at the end of the VLOOKUP formula mean?

It means that you will not accept approximate matches for "Beer."

What does the expression P(EI n E2) denote?

Joint probability

Which of the following tasks is not possible in a database management system (DBMS)?

Maintaining the fragility of stored data

Which of the following probabilities is denoted by P(E)?

Marginal

Which model includes an error term that allows the y values to vary for any given value of x?

Probabilistic

Which of the following statements is true regarding the color vision deficiency (CVD) type?

Protanopia is the lack of long-wave cones.

is the process of constructing a mathematical model or function that can be used to predict or determine one variable by another variable or other variables.

Regression analysis

Which formula in Excel retums numeric values based on their position in a list, ranked by value?

SMALL

By which of the following chart types can a user compare two different measures?

Scatterplot

What is the formula of the standard error of the estimate?

Se =

Which action cannot be performed by the decision support systems (DSSs)?

Slicing and dicing data stored in a dimensional format

For what purpose is diverging color used?

To show a range differing from a midpoint

Which analysis attempts to predict the impact of changes in the assumptions on the proposed solution?

What-if

By using Rs ______ function, it's easy to determine the points and their indices that violate the fences.

Which()

A(n) _____ is a repository of historical data that is organized by subject to support decision makers in the organization.

data warehouse

A joint probability table displays the joint probabilities along with the probabilities of a given problem.

marginal

Which of the following is an example of the false positives value?

Calling a not-so-pregnant customer pregnant

is a measure of the degree of relatedness of variables.

Correlation

What does MapReduce refer to?

The software procedure of dividing an analysis into pieces that can be distributed across different servers in different locations

Which of the following statements is true regarding outliers?

They can be the result of misrecorded or miscoded data.

Which formula in Excel retums a vertical range of cells as a horizontal range or vice versa?

TRANSPOSE

Which package involves the lofactor() function?

DMwR

What is the function of data mining?

It identifies previously unknown patterns.

A logical grouping of related records is called a data file or a(n):

table.

Which formula in Excel is used for reading the normal CDF backward?

NORMINV

Which parameters are used to plot the receiver operating characteristic (ROC) curve?

The false positive rate versus the true positive rate

Which of the following is an orientation preattentive feature?

The one line that isn't in line.

What is the shortcut key in Excel to open the Replace tab on the Find and Replace window?

CTRL + H

What does a decision refer to?

A choice among two or more alternatives that individuals and groups make

What is a Bayes' rule?

A formula that extends the use of the law of conditional probabilities to allow revision of original probabilities with new information

What is an example of union probability?

A person owns a Ford or a Chevrolet.

How will a user define the term management?

A process by which an organization achieves its goals through the use of resources

What does a list of collectively exhaustive events contain?

All possible elementary events for an experiment

Which of the following colors is referred to as color-blind-friendly that can be used in place of green?

Blue

is the process of developing actionable decisions or recommendations for actions based upon insights generated from historical data.

Business analytics

How will a user navigate to the Conditional Formatting option in Excel?

By clicking Home > Styles > Conditional Formatting

Which of the following is an example of categorical data?

By profession, Brent Spiner is an actor.

is an approach to managing information across an entire organization.

Data governance

What is the first step in data reduction?

Descriptive analytics

Which type of color vision deficiency (CVD) is the lack of medium-wave cones?

Deuteranopia

Which of the following is not a characteristic of data that is required by all information technology (IT) applications?

Discursive

What does the data model represent?

Entities in the database and their relationships

What are elementary events?

Events that cannot be decomposed or broken down into other events

Which of the following statements describes the difference between explicit and tacit knowledge?

Explicit knowledge consists of the organization's information technology (IT) infrastructure, whereas tacit knowledge consists of the organization's insights.

Why is the DEVSQ function used?

For calculating the sum of the squared deviations from the mean for a given set of data

Which non-linear function is used for logical checks??

IF

When are two or more events called mutually exclusive?

If the occurrence of one event precludes the occurrence of the other event(s).

The working directory is:

the folder in which the user can put data so that the R console can find it and read it in.

What is the formula for calculating the relative frequency of occurrence?

the number of times the event has happened in the past / the total number of opportunities for the event to have happened