Credit Card Use. Consider the following
hypothetical bank data on consumers’ use of credit card
credit facilities in Table 11.3. Create a small worksheet in
Excel, like that used in Example 1, to illustrate one pass
through a simple neural network.
Here is the Table 11.3
a. Use XLMiner’s neural network routine to fit a model
using the XLMiner default values for the neural net
parameters, except normalizing the data. Record the RMS
error for the training data and the validation data. Repeat
the process, changing the number of epochs (and only this)
to 300, 3000, and 10,000.
i. What happens to the RMS error for the training data as
the number of epochs increases?
ii. What happens to the RMS error for the validation data?
iii. Comment on the appropriate number of epochs for the
model.
b. Conduct a similar experiment to assess the effect of
changing the number of layers