Тесты СинергияАртём Хелп
Артём Help онлайнПолучить расчёт
Бесплатно оценим сроки и стоимостьОтправить задание в Telegram
Decision Management Technology.d

Decision Management Technology.d

Просмотрите все вопросы и варианты бесплатно. Правильные ответы скрыты и открываются только после получения доступа.

91 вопрос Вариант 1 Доступ 7 дней
Содержание теста

Вопросы и варианты

Без отметок и подсказок к правильным ответам

Вопрос 1

Descriptive analytics:

  1. can predict risk and find relationships in data not readily apparent with traditional analyses.
  2. helps companies classify their customers into segments to develop specific marketing campaigns.
  3. helps detect hidden patterns in large quantities of data to group data into sets to predict behavior.
  4. can use mathematical techniques with optimization to make decisions that take into account the uncertainty in the data.
Вопрос 2

A manager at Gampco Inc. wishes to know the company's revenue and profit in its previous quarter. Which of the following business analytics will help the manager?

  1. Prescriptive analytics
  2. Normative analytics
  3. Descriptive analytics
  4. Reductive analytics
Вопрос 3

Predictive analytics:

  1. Summarizes data into meaningful charts and reports that can be standardized or customized.
  2. Identifies the best alternatives to minimize or maximize an objective.
  3. Uses data to determine a course of action to be executed in a given situation.
  4. Detects patterns in historical data and extrapolates them forward in time.
Вопрос 4

A trader who wants to predict short-term movements in stock prices is likely to use … Analytics.

  1. Predictive
  2. Descriptive
  3. Normative
  4. Prescriptive
Вопрос 5

Which of the following questions will prescriptive analytics help a company address?

  1. How many and what types of complaints did they resolve?
  2. What is the best way of shipping goods from their factories to minimize costs?
  3. What do they expect to pay for fuel over the next several months?
  4. What will happen if demand falls by 10% or if supplier prices go up 5%?
Вопрос 6

The demand for coffee beans over a period of three months has been represented in the form of an L-shaped curve. Which form of model was used here?

  1. Mathematical model
  2. Visual model
  3. Kinesthetic (tactile) model
  4. Verbal model
Вопрос 7

Decision variables:

  1. Cannot be directly controlled by the decision maker.
  2. Are assumed to be constant.
  3. Are always uncertain.
  4. Can be selected at the discretion of the decision maker.
Вопрос 8

Identify the uncontrollable variable from the following inputs of a decision model.

  1. Investment returns
  2. Machine capacities
  3. Staffing levels
  4. Intercity distances
Вопрос 9

Which of the following inputs of a decision model is an example of data?

  1. Estimated consumer demand
  2. Inflation rates
  3. Costs
  4. Investment allocations
Вопрос 10

Descriptive decision models:

  1. Aim to predict what will happen in the future.
  2. Describe relationships but do not tell a manager what to do.
  3. Help analyze the risks associated with various decisions.
  4. Do not facilitate evaluation of different decisions.
Вопрос 11

Prescriptive decision models help:

  1. Make predictions of how demand is influenced by price.
  2. Make trade-offs between greater rewards and risks of potential losses.
  3. Decision makers identify the best solution to decision problems.
  4. Describe relationships and influence of various elements in the model.
Вопрос 12

The manager at Soul Walk Inc., a shoe manufacturing company, wants to set a new price (P) for a shoe model to maximize total profit. The demand (D) as a function of price is represented as: D = 1,500 - 2.5P. The total cost (C) as a function of demand is represented as: C = 3,200 + 3.5D Which of the following is a model for total profit as a function of price?  

  1. (1,508.75× price) - (2.5 × price2) - 8,450
  2. (3.5 × price2) + 3,200 - (1925.50 × price)
  3. (1,250 × price) + (5 × price2) - 8,320
  4. [4521 + (4.5 × price)] × price - 9684.25
Вопрос 13

What is a database?

  1. a structured collection of related files and data
  2. simply a collection of data
  3. a data file holding a single file
  4. flat files used to store data
Вопрос 14

In a database, information is stored and maintained in .

  1. Fields
  2. Measurements
  3. Entities
  4. Attributes
Вопрос 15

The sort buttons in Excel can be found under:

  1. The Data tab in the Sort & Filter group.
  2. The Home tab in the Styles group.
  3. The Insert tab in the Sort group.
  4. The Sort tab in the Filter group.
Вопрос 16

… is a logical function that returns one value if the condition is true and another if the condition is false.

  1. OR (condition 1, condition 2…)
  2. AND (condition 1, condition 2…)
  3. TO (value if true, value if false)
  4. IF (condition, value if true, value if false)
Вопрос 17

Which of the following functions is a logical function that returns TRUE if any condition is true and FALSE if not?

  1. TO (value if true, value if false)
  2. AND (condition 1, condition 2…)
  3. OR (condition 1, condition 2…)
  4. IF (condition, value if true, value if false)
Вопрос 18

Give the logical function for the following: If cell B7 equals 12, check contents of cell B10. If cell B10 is 10, then the value of the function in the string is YES; if not, it is a blank space. If cell B7 does not equal 12, then the value of the function is 7.

  1. =IF(B7=12,(AND(B10=10, "")(YES)),7)
  2. =IF(B10=10,(OR(B7=12,"")"YES")7)
  3. =IF(B7=12,(IF(B10=10,"YES", "")),7)
  4. =IF(B7=12,(AND(B10=10,"YES","")(B10="NO"),7)
Вопрос 19

If cell G7 contains the function …, it states that if the value in cell C3 is 9, the number 7 will be assigned to cell G7; if the value in cell C3 is not 9, the number 4 will be assigned to cell G7.

  1. =IF(G7=9)(G7=7)=OR(G7=4)
  2. =IF(G7=7)=THEN(C3=9)=OR(C3=4)
  3. =IF(C3=9)(C3=7)=OR(C3=4)
  4. =IF(C3=9,7,4)
Вопрос 20

The function … returns a value or reference of the cell at the intersection of a particular row and column in a given range.

  1. VLOOKUP(lookup_value, table_array, col_index_num)
  2. INDEX(array, row_num, col_num)
  3. MATCH(lookup_value, lookup_array, match_type)
  4. HLOOKUP(lookup_value, table_array, row_index_num)
Вопрос 21

Which of the following Lookup functions returns the relative position of an item in an array that equals a specified value in a specified order?

  1. HLOOKUP(lookup_value, table_array, row_index_num)
  2. MATCH(lookup_value, lookup_array, match_type)
  3. INDEX(array, row_num, col_num)
  4. VLOOKUP(lookup_value, table_array, col_index_num)
Вопрос 22

In a MATCH function, if the match_type = 0, then … .

  1. The function finds the largest value that is less than or equal to lookup_value
  2. The function finds the smallest value that is greater than or equal to lookup_value
  3. MATCH finds the first value that is exactly equal to lookup_value
  4. The values in the lookup_array must be in a particular order
Вопрос 23

For which of the following MATCH functions must the values in the lookup_array be ordered in a descending order?

  1. When match_type = -1
  2. When match_type >1
  3. When match_type = 0
  4. When match_type = 1
Вопрос 24

To select a chart type in Excel from the Charts group, which tab has to be accessed?

  1. Design tab
  2. Layout tab
  3. Insert tab
  4. Format tab
Вопрос 25

Roger wants to compare values across categories using vertical rectangles. Which of the following charts must Roger use?

  1. Line chart
  2. Clustered column chart
  3. Pie chart
  4. Stacked column chart
Вопрос 26

Which of the following charts provides a useful means for displaying data over time?

  1. Scatter chart
  2. A doughnut chart
  3. Pie chart
  4. Line chart
Вопрос 27

Philip wishes to understand the relative proportion of each data source to the total. Which of the following charts must Philip use?

  1. Pie chart
  2. Bar chart
  3. Scatter chart
  4. Column chart
Вопрос 28

Observations consisting of pairs of variable data are required to construct a … chart.

  1. doughnut
  2. scatter
  3. radar
  4. line
Вопрос 29

Which of the following charts shows three-dimensional data?

  1. Surface chart
  2. Column chart
  3. Stock chart
  4. Doughnut chart
Вопрос 30

Peige, a stock broker, has data consisting of price, price/earnings ratio, and market capitalization for seven different stocks on one particular day. She wishes to plot these three variables in two dimensions. Which of the following charts must Peige use?

  1. Stock chart
  2. Surface chart
  3. Bubble chart
  4. Line chart
Вопрос 31

Which of the following charts allows plotting of multiple dimensions of several data series?

  1. Doughnut chart
  2. Bubble chart
  3. Radar chart
  4. Area chart
Вопрос 32

After choosing the PivotTable, the PivotChart can be found on the … tab.

  1. Design
  2. View
  3. Analyze
  4. Layout
Вопрос 33

How many types of Spark lines are available?

  1. 2
  2. 3
  3. 4
  4. 5
Вопрос 34

Which of the following is an example of a measure of continuous metrics?

  1. Four errors revealed in an invoice
  2. A delivery delayed by seven days
  3. Weight and volume of a sheet of steel
  4. Three incomplete orders on a day
Вопрос 35

Nominal data:

  1. Are ranked according to some relationship to one another.
  2. Have constant differences between observations.
  3. Are continuous and have a natural zero.
  4. Are sorted into categories according to specified characteristics.
Вопрос 36

Which of the following is a disadvantage of ordinal data?

  1. They bear no relationship to one another.
  2. They have no fixed units of measurement.
  3. They have no natural zero.
  4. They are not comparable with each other.
Вопрос 37

Which of the following allow meaningful comparison of ranges, averages and other statistics?

  1. Interval data
  2. Categorical data
  3. Ratio data
  4. Ordinal data
Вопрос 38

Following are the components of a data set containing purchase details of a shoe manufacturing company. Identify the ratio data.

  1. Item Number
  2. Rank of suppliers
  3. Item cost
  4. Arrival date
Вопрос 39

When data are classified by the type of measurement scale, which is the strongest form of measurement?

  1. nominal
  2. interval
  3. ordinal
  4. ratio
Вопрос 40

To construct a frequency distribution for categorical data, the

  1. Observations that appear in each category must be summed up.
  2. Number of observations that appear in each category must be counted.
  3. Observations in each category must be multiplied by observations in the corresponding category.
  4. Number of observations in each category must be divided by the total number of observations in all categories.
Вопрос 41

If a data set has 'c' number of observations, the relative frequency of category 'l' is computed as … .

  1. (frequency of category 'l') / 'c'
  2. 'c' × (number of observations in category 'l')
  3. (sum of all observations in category 'l') / 'c'
  4. sum of ('c' + each observation in category ‘l')
Вопрос 42

Which of the following is true of an unbiased estimator value?

  1. The expected value will align perfectly with the population mean.
  2. The expected value will not equal the population's parameters.
  3. The expected value will not be greater than zero.
  4. The expected value will equal the population's parameter.
Вопрос 43

Which of the following probabilities gives the confidence coefficient?

  1. P (rejecting H0 | H0 is true)
  2. P (not rejecting H0 | H0 is false)
  3. P (rejecting H0 | H0 is false)
  4. P (not rejecting H0 | H0 is true)
Вопрос 44

Identify the power of the test from the following probabilities.

  1. P (rejecting H0 | H0 is true)
  2. P (not rejecting H0 | H0 is false)
  3. P (rejecting H0 | H0 is false)
  4. P (not rejecting H0 | H0 is true)
Вопрос 45

In a linear relationship, which of the following accounts for the many possible values of the dependent variable that vary around the mean?

  1. The coefficient of the dependent variable X
  2. The value of the intercept ß0
  3. The random error term ε
  4. The standard error SYX
Вопрос 46

Which of the following is true about the classical definition of probability?

  1. It is based on judgment and experience.
  2. If the process that generates the outcomes is known, probabilities can be deduced from theoretical arguments.
  3. The probability that an outcome will occur is simply the relative frequency associated with that outcome.
  4. It is based on observed data.
Вопрос 47

John and Mike were offered mints. What is the probability that at least John or Mike would respond favorably? (Hint: Use the classical definition).

  1. 1/8
  2. ½
  3. ¾
  4. 3/8
Вопрос 48

Consider an event X comprised of three outcomes whose probabilities are 9/18, 1/18, and 6/18. Compute the probability of the complement of the event.

  1. 2/18
  2. ½
  3. 16/3
  4. 16/18
Вопрос 49

What is the probability that either event X or Y occurs?   Use the data given below to answer the following question(s). In an event X, the probability of rolling a sum of 8 on two dice is 5/36 while the probability of rolling an 11 is 2/36 . In another event Y, the probability of rolling a 2 is 1/36, the probability of rolling a 9 is 4/36 , and the probability of rolling a 4 is 3/36 .

  1. 8/36
  2. 15/36
  3. 7/36
  4. 1/36
Вопрос 50

What is probability that neither X nor Y will occur?

  1. 29/26
  2. 1/36
  3. 28/36
  4. 21/36
Вопрос 51

Consider an event Z that includes all outcomes of rolling two dice whose sum is odd. What is the probability that either event Y or Z occurs?

  1. 26/36
  2. 22/36
  3. 10/36
  4. 18/36
Вопрос 52

Which of the following computes the probability of an event P given that event Q is known to have occurred?

  1. P(P|Q) = P(P and Q) / P(Q)
  2. P(Q|P) = P(Q) - P(P)
  3. P(P|Q) = P(Q) - P(P or Q)
  4. P(Q|P) = P(P or Q) - P(Q)
Вопрос 53

What is the probability that a respondent is male and prefers Arts?   Use the data given below to answer the following question(s).   15 students were asked to choose between the broad categories of Arts, Science, and Math as their preferred area of study.   Respondent Gender Preference 1 Female Arts 2 Male Science 3 Male Math 4 Female Arts 5 Female Math 6 Male Science 7 Male Math 8 Male Math 9 Female Arts 10 Male Arts 11 Male Science 12 Female Science 13 Female Math 14 Male Arts 15 Female Arts

  1. 8/15
  2. 10/15
  3. 2/15
  4. 6/15
Вопрос 54

What is the probability that a respondent prefers Science given that the respondent is female?

  1. 1/15
  2. 1/7
  3. 7/15
  4. 4/7
Вопрос 55

Use the multiplication law of probability to compute the probability that the respondent is male and prefers Math.

  1. 8/75
  2. 3/8
  3. 3/225
  4. 3/15
Вопрос 56

Which of the following will hold true if events X and Y are independent?

  1. P(X) = P(Y) × P(X and Y)
  2. P(Y) = P(X|Y)
  3. P(X and Y) = [P(X) + P(Y)] - P(X or Y)
  4. P(X) = P(X|Y)
Вопрос 57

A … is a description of the approach that is used to obtain samples from a population prior to any data collection activity.

  1. Population frame
  2. Sampling weight
  3. Sampling plan
  4. Probability interval
Вопрос 58

Which of the following is true of judgment sampling?

  1. It selects samples based on expert opinion.
  2. It selects samples based on ease of data collection.
  3. It selects samples based on random procedures.
  4. It selects samples based on full representation of all subsets in a population.
Вопрос 59

Which of the following types of sampling involves using random procedures to select a sample?

  1. Judgment sampling
  2. Probabilistic sampling
  3. Subjective sampling
  4. Convenience sampling
Вопрос 60

… Involves selecting items from a population so that every subset of a given size has an equal chance of being selected.

  1. Convenience sampling
  2. Subjective sampling
  3. Judgment sampling
  4. Simple random sampling
Вопрос 61

Which of the following sampling methods bases its selection of samples on the ease of data collection?

  1. Probabilistic sampling
  2. Judgment sampling
  3. Simple random sampling
  4. Convenience sampling
Вопрос 62

Which of the following describes periodic sampling?

  1. It is a sampling method based solely on expert opinion.
  2. It is a sampling method based on selecting a time and then sampling the products after that time.
  3. It is a sampling method based on selecting every nth item from a population.
  4. It is a sampling method exclusively used for population that is divided into subsets.
Вопрос 63

… sampling applies to populations that are divided into natural subsets and allocates the appropriate proportion of samples to each subset.

  1. Systematic
  2. Stratified
  3. Cluster
  4. Continuous process
Вопрос 64

… is based on dividing a population into subgroups, sampling a set of subgroups, and conducting a complete census within the subgroups sampled.

  1. Cluster sampling
  2. Continuous process sampling
  3. Judgment sampling
  4. Systematic sampling
Вопрос 65

In sampling, … involves assessing the value of an unknown population parameter– such as a population mean, population proportion, or population variance–using sample data.

  1. Distribution
  2. Randomization
  3. Estimation
  4. Substitution
Вопрос 66

From the standard deviation formula ∑(s–s̅)2 / n-1, identify the estimator formula

  1. s2
  2. σ2
  3. s
Вопрос 67

A(n) …is a single number derived from sample data that is used to estimate the value of a population parameter.

  1. Confidence interval
  2. Frequentist interference
  3. Interval estimate
  4. Point estimate
Вопрос 68

For which of the following is the value of the estimator said to be biased?

  1. If the expected value of the estimator does not equal the population parameter
  2. If the expected value of the estimator equals the population parameter
  3. Only if the expected value of the estimator is zero
  4. Only if the expected value of the estimator goes below zero
Вопрос 69

Which of the following propositions describes an existing theory or belief?

  1. Standard deviation
  2. Null hypothesis
  3. Proportion
  4. Alternative hypothesis
Вопрос 70

Which of the following is the initial step in conducting a hypothesis test?

  1. Collecting data and calculating a test statistic
  2. Selecting a level of significance
  3. Identifying the population parameter of interest
  4. Determining a decision rule
Вопрос 71

Which of the following is a valid one-sample hypothesis test?

  1. H0: population parameter ≠ constant vs. H1: population parameter = constant
  2. H0: population parameter > constant vs. H1: population parameter ≤ constant
  3. H0: population parameter < coxnstant vs. H1: population parameter ≥ constant
  4. H0: population parameter = constant vs. H1: population parameter ≠ constant
Вопрос 72

A manufacturer wishes to determine if the average profit from the sale of his product exceeds $6,710. Which of the following is the appropriate hypothesis test?

  1. H0: population means profit from sale > $6,710 vs. H1: population mean profit from sale ≤ $6,710
  2. H0: population means profit from sale ≤ $6,710 vs. H1: population mean profit from sale > $6,710
  3. H0: population means profit from sale < $6,710 vs. H1: population mean profit from sale ≥ $6,710
  4. H0: population means profit from sale ≥ $6,710 vs. H1: population mean profit from sale < $6,710
Вопрос 73

Which of the following is true about determining the proper form of the hypotheses?

  1. H0 is statistically proved true while testing
  2. failure to reject H0 proves H1 wrong
  3. H0 is always assumed to be true in testing
  4. H1 is always assumed to be true in testing
Вопрос 74

Which of the following is a Type I error?

  1. The null hypothesis is actually true, and the hypothesis test correctly fails to reject it
  2. The null hypothesis is actually false, but the test incorrectly fails to reject it
  3. The null hypothesis is actually false, and the test correctly rejects it
  4. The null hypothesis is actually true, but the hypothesis test incorrectly rejects it
Вопрос 75

Robin Inc. feared that the average company loss is running beyond $34,000. It initially conducted a hypothesis test on a sample extracted from its database. The hypothesis was formulated as H0: average company loss $34,000 vs. H1: average company loss > $34,000. The test resulted in favor of Robin Inc.'s loss not exceeding $34,000. Detailed study of company accounts later revealed that the average company loss had run up to $37,896. Which of the following errors were made during the hypothesis test?

  1. Type III error
  2. Type II error
  3. Type I error
  4. Type IV error
Вопрос 76

Type II error occurs when the test:

  1. Correctly fails to reject an actually true null hypothesis.
  2. Incorrectly fails to reject an actually false null hypothesis.
  3. Correctly rejects an actually false null hypothesis.
  4. Incorrectly rejects an actually true null hypothesis.
Вопрос 77

Level of significance is the probability of:

  1. Incorrectly rejecting an actually true null hypothesis.
  2. Correctly failing to reject an actually true null hypothesis.
  3. Incorrectly failing to reject an actually false null hypothesis.
  4. Correctly rejecting an actually false null hypothesis.
Вопрос 78

The confidence coefficient is denoted by:

  1. α
  2. 1 - β
  3. β
  4. 1 - α
Вопрос 79

What is the confidence coefficient when the level of significance is 0.03?

  1. 0.9700
  2. 0.0376
  3. 0.7924
  4. 0.7776
Вопрос 80

Which of the following denotes the power of the test?

  1. α
  2. 1 - β
  3. β
  4. 1 - α
Вопрос 81

A regression model that involves a single independent variable is called .

  1. Single regression
  2. Unit regression
  3. Simple regression
  4. Individual regression
Вопрос 82

Regression models of … data focus on predicting the future.

  1. missing
  2. time-series
  3. panel
  4. cross-sectional
Вопрос 83

What is the relationship between the age of the furniture and their values?   The following table exhibits the age of antique furniture and the corresponding prices. Use the table to answer the following question(s). (Hint: Use scatter diagram and the Excel Trendline tool where necessary).   Number of years Value ($) 78 930 91 1010 83 970 159 1950 134 1610 210 2880 88 980 178 2010 124 1370 72 900

  1. Nonlinear
  2. Linear
  3. Curvilinear
  4. No relationship
Вопрос 84

Which of the following is true of linear functions used in predictive analytical models?

  1. It is used when the rate of change in a variable decreases or increases quickly and then levels out.
  2. It is used when there is a steady decrease or increase over a range of a variable.
  3. It is used when there is increase at a specific rate.
  4. It is used when there is a rise or fall at a constantly increasing rate.
Вопрос 85

… are mathematical functions used in predictive analytical models which define phenomena that increase at a specific rate, and is represented by the formula y = axb

  1. Exponential functions
  2. Power functions
  3. Polynomial functions
  4. Logarithmic functions
Вопрос 86

Which of the following mathematical functions, used in predictive analytical models, is represented by the formula y = ax3 + bx2 + cx + d?

  1. Exponential functions
  2. Power functions
  3. Logarithmic functions
  4. Polynomial functions
Вопрос 87

In … functions, represented by y = abx, y rises or falls at constantly increasing rates.

  1. logarithmic
  2. power
  3. exponential
  4. polynomial
Вопрос 88

In Excel's Trendline tool, the value of the … gives the measure of fit of the line to the data.

  1. linear function
  2. R-squared
  3. moving average
  4. set intercept
Вопрос 89

Which of the following is true of the R-squared (R2) value in Excel's Trendline function?

  1. A value of 1.0 for R2 indicates maximum deviation of the data from the line.
  2. If the value of R2 is above 1.0, the line will be at a perfect fit for the data.
  3. The value of R2 will always be between -1 and 1.
  4. As the value of R2 gets higher, the line will be a better fit for the data.
Вопрос 90

Which of the following equations correctly expresses the relationship between the two variables?

  1. Value = (-181.16) + 13.493 × Number of years
  2. Number of years = Value / 12.537
  3. Value = (459.34 / Number of years) × 4.536
  4. Number of years = (17.538 × Value) / (-157.49)
Вопрос 91

What is the expected value for a 90 year-old piece of furniture?

  1. $1002.45
  2. $997.98
  3. $934.56
  4. $1033.21