hello dear this assignment must be work in Microsoft Excel and Word documentï»¿ï»¿ï»¿ to answer the question in lab_Direct I attached :
a) Using XLminer, run a neural net model on these data, using the option to normalize the data, setting the number of epochs at 30, and requesting lift charts for both the training and validation data. Interpret the meaning (in business terms) of the leftmost bar of the validation lift chart (the bar chart).
b) Comment on the difference between the training and validation lift charts.
c) Run a second neural net model on the data, this time setting the number of epochs at 100. Comment now on the difference between this model and the model you ran earlier, and how overfitting might have affected results.
d) What sort of information, if any, is provided about the effects of the various variables?