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.

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 inc reases?

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