OMGT TEST # 1 QUESTIONS & ANSWERS
The standardized residual test for an outlier effectively assumes.. - Answer -That the
underlying data is normally distributed
If the mean of a data set is 75, and its standard deviation is 25, then a data point with a
value of 10 ... - Answer -Is a mild outlier
In a decision-making problem, items controlled by the decision maker are termed ... -
Answer -Decision alternatives
In a decision-making problem, uncontrollable events are termed ... - Answer -States of
nature
The result of entering the formula = -1^2+4 in Excel is ... - Answer -5
If the EXCEL formula =$A3+B$2 is copied from one cell to another cell located two rows
down and three columns to the right, the resulting formula will be ... - Answer -
=$A5+E$2
Hurwicz Criterion - Answer -Weights the best and thee worst payoffs according to the
decision maker's optimism
The minimax regret criterion - Answer -Chooses the decision that results in the
minimum regret
The maximax criterion - Answer -Chooses the best of the best payoffs
The maximin criterion - Answer -Chooses the best of the worst payoffs
SUM If - Answer -The first two arguments are the test conditions, and the third
argument is the sum range.
In EXCEL, if cell A3 contains the value 50 and B3 contains the value 60, then the
calculated result for the EXCEL formula =IF(A3>50,IF(B3<=60,1,0),IF(A3<60,1,0)) is -
Answer -1
The result of entering the formula = -1^2+2 in Excel is ... - Answer -3
The EXCEL function to calculate the variance of a data range is ... - Answer -
=VAR(data range)
The reason that 2 is used as a standardized residual border for outliers is ... - Answer -
The standardized residual test for an outlier effectively assumes.. - Answer -That the
underlying data is normally distributed
If the mean of a data set is 75, and its standard deviation is 25, then a data point with a
value of 10 ... - Answer -Is a mild outlier
In a decision-making problem, items controlled by the decision maker are termed ... -
Answer -Decision alternatives
In a decision-making problem, uncontrollable events are termed ... - Answer -States of
nature
The result of entering the formula = -1^2+4 in Excel is ... - Answer -5
If the EXCEL formula =$A3+B$2 is copied from one cell to another cell located two rows
down and three columns to the right, the resulting formula will be ... - Answer -
=$A5+E$2
Hurwicz Criterion - Answer -Weights the best and thee worst payoffs according to the
decision maker's optimism
The minimax regret criterion - Answer -Chooses the decision that results in the
minimum regret
The maximax criterion - Answer -Chooses the best of the best payoffs
The maximin criterion - Answer -Chooses the best of the worst payoffs
SUM If - Answer -The first two arguments are the test conditions, and the third
argument is the sum range.
In EXCEL, if cell A3 contains the value 50 and B3 contains the value 60, then the
calculated result for the EXCEL formula =IF(A3>50,IF(B3<=60,1,0),IF(A3<60,1,0)) is -
Answer -1
The result of entering the formula = -1^2+2 in Excel is ... - Answer -3
The EXCEL function to calculate the variance of a data range is ... - Answer -
=VAR(data range)
The reason that 2 is used as a standardized residual border for outliers is ... - Answer -
