I have below assignment to be done for Data Mining, I am having trouble using XLMiner and need help with that.

Consider the Boston Housing Data file (The schema of the data file is given in Table 3.1 on page 54 of the

textbook.)

Using XLMINER's neural network routine under predict menu 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, TAX, PTRATIO, B, LSTAT to predict the value of the outcome variable

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.