MSIS 3223 - Nord - Okstate - Exam 1Latest

MSIS 3223 - Nord - Okstate - Exam 1Latest Update - Sources with Questions and Verified Correct Answers Golden Ticket to Guaranteed A+ Verified by Professor

_______ is a measure of the linear relationship between two variables, X and

Y, which does not depend on the units of measurement. - CORRECT ANSWER:

Correlation

________ is a logical function that returns one value if the condition is true and another if the condition is false. - CORRECT ANSWER: IF(condition, value if true, value if false)

________ is a measure of the linear association between two variables, X

and Y - CORRECT ANSWER: Covariance

________ measures the worth of a stream of cash flows, taking into account

the time value of money. - CORRECT ANSWER: Net present value

A graphical depiction of a frequency distribution for numerical data in the

form of a column chart is called a ________. - CORRECT ANSWER: histogram

Complete the following sentence: a Dashboard... - CORRECT ANSWER: All of these.

Decision variables: - CORRECT ANSWER: can be selected at the discretion of the decision maker

• / 2

Descriptive analytics: - CORRECT ANSWER: helps companies classify their customers into segments to develop specific marketing campaigns.

Descriptive decision models: - CORRECT ANSWER: describe relationships but do not tell a manager what to do.

During which phase in problem solving is a formal model often developed? - CORRECT

ANSWER: structuring the problem

Following are the components of a data set containing purchase details of a shoe manufacturing company. Identify the ratio data. - CORRECT ANSWER: Item cost

For two variables, a positive correlation coefficient indicates ________. - CORRECT ANSWER: a linear relationship exists for which one variable increases as the other also increases

How is the return to risk described in financial statistics? - CORRECT ANSWER: as the reciprocal of coefficient of variation

In a MATCH function, if the match_type = 0, then ________. - CORRECT ANSWER:

MATCH finds the first value that is exactly equal to lookup_value

In statistical notation, the elements of a data set are typically labeled as

________. - CORRECT ANSWER: subscripted variables

In statistics, ________ refers to the peakedness or flatness of a histogram. - CORRECT

ANSWER: kurtosis

Lauren, a stock broker, has data consisting of price, price/earnings ratio, and

• / 2