DATA MINING
The 7 steps in the Data Mining Process?
What is:
1. Identify Opportunity
2. Collect Data
3. Explore, Understand, and Prepare Data
4. Identify Task and Tools
5. Partition Data
6. Build and Evaluate Models
7. Deploy Models
Spreadsheet model definition?
What is a computer, implemented by the spreadsheet.
Optimization in Business Analytics is used for?
What is help a company use its limited resources in the most efficient way.
Step 4 in implementing Linear Programming Model?
What is For each constraint, create a formula in a separate in the spreadsheet that corresponds to the Left-Hand Side-LHS of the constraint.
Decision variables in the algebraic formulation of a model go along with?
What is variable cells in the excel spreadsheet
Name 3 common data mining techniques that a task can fall under?
What is Classification, Prediction, and Association/Segmentation.
The Business Analytics field use this to solve business problems?
What is data, computers, statistics, and mathematics.
Characteristics of optimization problems include?
What is decision, constraints, and objectives
Step 1 in implementing Linear Programming Model
What is Organize the data for the model on the spreadsheet
The Left-Hand Side-LHS formulas for each constraint in an LP model must be implemented in?
What is different cells in the excel spreadsheet
Partitioning the data in the data mining process means?
What is divide, distribute, or portion the data.
2 benefits of modeling?
What is
1. provides a simplified version of the object or decision problem they represent
2. less expensive to analyze decision problems using a model
3 models are frequently helpful to examine things that would be impossible to do in reality
4 models allow us to gain insight and understanding about the object or decision problem under investigation
f(X1, X2 …. Xn) ≤ b represents?
What is A less than or equal to constraint
Step 3 in implementing Linear Programming Model?
What is Create formula in a cell in the spreadsheet that corresponds to the objective function in the algebraic model.
A cell in the excel spreadsheet must represent?
What is the objective function in the LP model.
Classification does this in the data mining process?
hint, how does it use the information
What is takes a data mining problem and uses the information available in a set of independent variables to predict the value of a discrete or categorical(clear-cut) dependent variable.
Simplest and most common logical math model:
What is Profit = Revenue – Expenses
f(X1, X2 …. Xn) = b represents?
What is A equal to constraint.
Step 2 in implementing Linear Programming Model?
What is Reserve separate cells in the spreadsheet to represent each decision variable in the algebraic model.
A good spreadsheet implementation represents the problem in a way that ?
What is clearly communicates its purpose and is reliable, auditable, and modifiable
6 common techniques used for Classification Problems?
What is Discriminate Analysis, Logistic Regression, Classification Trees, K-Nearest Neighbor KNN, Naive Bayes, and Neural Networks.
Y = f(X1, X2)
f = define the relationship?
What is Defines the relationship between the dependent variable Y and the independent X1 and X2.
MAX or MIN: f0(X1, X2 …. Xn) represents?
What is objective function that will be either maximized or minimized
Solve Linear Programming Problem use?
What is built in Solver in Excel
3 steps to create a comment in Excel?
What is
1. Click the cell to select it
2. Choose Review, New Comment(or press Shift + F2)
3. Type the comment for the cell, and then select another cell.