Trace the process of copying and pasting a cell, which has a formula in it, such that the
formula is not retained in the pasted cell.
A) Home – Paste – Paste Special – Paste Values
B) Home – Paste – Paste Special – Paste Validation
C) Home – Paste – Paste Special – Paste Formats
D) Home – Paste – Paste Special – Paste Formulas
For the given data, what is the sales forecast for the year 1992 (in thousands)?
A) 1256.87
B) 1317.91
C) 1285.74
D) 1350.08
Which of the following is a difference between interval estimates and point estimates?
A) Point estimates cannot be used to calculate statistical error, while interval estimate is
used to calculate statistical error.
B) Point estimates provide only a single value for a sample, while interval estimates
provide a range of values.
C) Point estimates indicate the magnitude of potential error in the estimate, while
interval estimates don’t.
D) Point estimates on an average provide more information than interval estimates.
Which decision model incorporates the uncertainty element?
A) predictive
B) normative
C) prescriptive
D) descriptive
Below is the spreadsheet for a portfolio allocation model.
Answer the following question(s) using a model with uncertainty on type of investment
return. Assume that the distributions of life insurance annual return is uniform with
minimum 4% and maximum 6%, bond mutual funds annual return is normal with mean
7% and standard deviation 1%, stock mutual funds annual return is lognormal with
mean 11% and standard deviation 4%. Use 10,000 trials and 1 for random seed for the
simulation.
What is the value of mode obtained from the simulation results for maximizing the total
expected return? [Hint: Choose the approximate value.]
A) $ 6,378.39
B) $ 5,848.24
C) $ 5,281.79
D) $ 7,025.86
Use the table below to answer the following question(s) using the standard Solver.
Below is the spreadsheet for a plant location model:
What is the total amount shipped by the Baltimore plant to the distribution centers?
A) 750
B) 1,000
C) 1,250
D) 1,300
Below is the table showing rate of shoes sold per day and the highest-priced shoe sold
that day for a one-week period. The rate of shoes sold per day (X) and the price of the
shoes (Y).
Use Excel to calculate the coefficient of variation of X.
A) 0.42
B) 0.31
C) 7.04
D) 16.47
Below is a spreadsheet of purchase orders for a computer hardware retailer
To find the total order cost, what Excel formula should be used in A12?
A) =COUNT(C4:C10)
B) =COUNT(C4:C7)
C) =MAX(C4:C10)
D) =SUM(E4:E10)
What is the formula used to calculate the value of bt in the linear trend equation Ft+k =
at + btk while using double exponential smoothing?
A) bt = β(bt – bt–1) + (1 –β)bt–1
B) bt = αFt–1 + (1 – α)(at +1 + bt+1)
C) bt = αFt + (1 – α)(at –1 + bt-1)
D) bt = β(at – at–1) + (1 –β)bt–1
Which of the following is true about cross-tabulation?
A) All subcategories together must constitute the complete data set.
B) A cross-tabulation table is often called a latent class model.
C) Each observation can be classified into many subcategories.
D) The table displays the number of categorical variables between two observations.
Which of the following is the first phase in problem solving?
A) defining the problem
B) analyzing the problem
C) recognizing the problem
D) structuring the problem
Use the table below to answer the following question(s) using the standard Solver.
Below is the spreadsheet for a plant location model:
Which of the following constraints is used in Solver?
A) $F$16:$F$19 >= $F$6:$F$9
B) $B$20:$E$20 < $B$10:$E$10
C) $B$20:$E$20 = binary
D) $F$16:$F$19 <= $F$6:$F$9
Below is the spreadsheet for an economic order quantity model.
Assume that the distribution of demand is normal with a mean of 20,000 and standard
deviation of 2,000.
Which of the following cells is defined as the uncertain output cell?
A) B13
B) C15
C) C19
D) B22
Which of the following is a parameter in the Normal Distribution Dialog of the Risk
Solver Platform?
A) maximum value
B) minimum value
C) most likely value
D) mean
The Atlas Movies Theater is planning to reprice their ticket rates to maximize revenues.
They have three classes of tickets: Classic, Silver, and Gold. The table below provides
information on the average ticket sales, revenue and price elasticity on demand. They
have a total seating capacity of 300. The table also provides the price range within
which they plan to reduce their ticket rates.
According to the nonlinear model, which of the following is the projected revenue
figure for Silver tickets based on its new price?
A) $1,163.02
B) $1,132.08
C) $1,224.63
D) $1,316.92
Standard residuals:
A) help detect outliers that may bias the results of a regression analysis.
B) cause differences in the regression equation by changing the slope and intercept.
C) point out the ranges for the population intercept and slope at a 95% confidence level.
D) provide information for testing hypothesis associated with the intercept and slope.
Briefly explain classification as a data-mining tool with an example.
What are the properties of a probability mass function?
Explain how the Data Validation feature in Excel helps in increasing spreadsheet
quality.
What are the differences between an aggressive strategy and a conservative strategy?
Use the data given below to answer the following question(s).
At a casino, a combination of two spinners is used to decide the winner based on the
sum of scores from spinning. The spinners each have four colored spaces – red, yellow,
blue, and green. Red = 1, Yellow = 2, Blue = 3, and Green = 4
What is the probability that the spinners land on colors summing up to exactly 3?
List the systematic approach to build good multiple regression models.
Why is testing for independence important for businesses?
What is the importance of Integer Tolerance in Solver?
How are objects clustered in agglomerative hierarchical clustering?
Which of the following computes the probability of an event P given that event Q is
known to have occurred?