# MMIS 643 Data Mining Assignment-3 Solutions

A. A neural network typically starts out with random coefficients (weights); hence, it produce essentially random predications when presented with its first case. What is the key ingredients by which the net (neural network) evolves to produce a more accurate predication? (Please answer your question as clearly

and concisely as possible.) (10 points)

B. Consider the Boston Housing Data file (The schema of the data file is given on page 27 in Table 2.2 of the textbook.). (40 points)

a. Study the Neural Networks Prediction example from the URL: http://www.solver.com/xlminer/help/neural-networks-classification-intro, and following the example

step by step.

b. Using XLMINER’s neural network routine to fit a model using XLMINER default values for neural network parameters by using the predictors such as CRIM, ZN, INDUS, CHAS, NOX, RM, AGE, DIS, RAD to classify the value of CAT.MEDV.

i. Record the RMS errors for the training data and the validation data, and observe the lift charts for repeating the process, changing the number of epochs to 300, 3000, 10,000, 20,000.

ii. What happens to RMS error for the training data set as the number of epochs increases?

iii. What happens to RMS error for the validation data set as the number of epochs increases?

iv. Comments on the appropriate number of epochs for the model.

Note: (Please use the Prediction Option of the Neural Network in order to get RMS)

C. For Association Rule Mining, please define the following terms: (10 points)

a. Support

b. Confidence

c. Lift

D. Study the Association Mining example from the URL: http://www.solver.com/xlminer/help/associationrules.

E. Problem 13. 3 on page 277-278 of the textbook, Data Mining for Business Intelligence: Concepts, Techniques, and Applications in Microsoft Office Excel with XLMiner, 2 edition, 2010, by Galit Shmueli, Nitin R. Patel, and Peter C. Bruce, ISBN: 978-0-470-52682-8. The data file is attached. (40 points)

Note:

1. The data files are posted along Written Assignment #3.

**File Format:**Microsoft Word Document .doc, Microsoft Excel Spreadsheet .xls**Total Number of Pages:**7**Paper Format:**Question Answer Format**Any Figures Included:**No**Custom Solution Available:**Yes