Consider the Boston Housing Data file
Study the Neural Networks Prediction and following the example step by step (using the manual neural network classification example)
a. 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.
Note: (Please use the Prediction Option of the Neural Network in order to get RMS error)
b. Please submit your execution results and answers included in MS Excel file
Note:
1. The file BostonHousing.xls is posted along Written Assignment #3B, and description of columns are given in the file.
2. The cloud based XLMiner
Attachment:- Data.rar