- is an Excel tool that quantifies the impact of changing multiple inputs on one or more outputs of interest.
- A make-versus-buy decision involves comparing the costs of manufacturing in-house to the costs of _____ production to another firm.
- Spreadsheet models are without question the most used business analytics tool because they • provide easy-to-use, sophisticated mathematical and logical functions, • allow for easy instantaneous recalculation of the output for a change in model inputs, • are less expensive than specialized software packages, • often come preloaded on computers, and • are reasonably easy to use.
- Make-versus-Buy Decision: The total cost of manufacturing a product can be defined as the sum of two portions:
- The height of each branch (cluster) or sub-branch (sub-cluster) indicates how ______ it is from the other branches or sub-branches with which it is merged.
- An _____ diagram is a visual representation of which entities influence others in a model.
- the aprioro method Eliminates ____- items that are below the support value
- Association rule analysis is essentially a "__ ___ ___ ___ ___" study.
- The _____ function returns the sum of the products of elements in a set of arrays
- Scenario manager is useful when the impact on the output variables of more than two input variables cannot be ______ with the data table tool.
- The _____ function counts the number of times the condition is true in a given range of cells
- When a large distance to merge sub-clusters is detected, it suggests the presence of
- A ___ is defined as a setting composed of multiple inputs
- How tree is set up: - Called a dendrogram - Branches are clusters - An observation is a "leaf" - Visually inspect the clustering result and determine the appropriate number of clusters
- The _____ algorithm is designed to recursively generate item sets that exceed a predetermined frequency threshold.
- Sort all the rules by lift ratio in ____ order and focus on strong associations only.
- _____ of the association rule is the probability of the If-Then statement
- Both of these can be misleading, if the antecedent and consequent are common yet _____.
- Look for an association rule that has _____ support and confidence
- One of the most widely used methods fo association rule analysis is called the