Ask Question
3 June, 06:51

A bank developed a model for predicting the average checking and savings account balance as balance = - $17,732 + 367 x age + $1300 x years education + 0.116 x household wealth.

a. explain how to interpret the numbers in this model

b. using excel input a customer 32 years old, is a college graduate (16 years of education) and has a household wealth of $150,000. what is predicted bank balance using excel

+1
Answers (1)
  1. 3 June, 07:59
    0
    A) the balance formula is:

    balance = - $17,732 + 367 x age + $1300 x years education + 0.116 x household wealth

    On average, for every year a person has lived he or she will have $367 in their bank accounts.

    This means that for every year of education that a customer completed he will have an extra $1,300 in his account.

    Additional to the previous considerations, their clients will keep 11.6% of their total wealth in the bank.

    B) - $17,732 + (367 x 32) + ($1,300 x 16) + (0.116 x $150,000) = - $17,732 + $11,744 + $20,800 + $17,400 = $32,212
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “A bank developed a model for predicting the average checking and savings account balance as balance = - $17,732 + 367 x age + $1300 x years ...” in 📙 Business if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers