Update 2024-2025 Actual Exam from Credible
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
, 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