Question
Treasure Valley National Bank is investigating their accounts, hoping to predict account balances from other characteristics. They have collect data from 60 random accounts. Using
Treasure Valley National Bank is investigating their accounts, hoping to predict account balances from other characteristics. They have collect data from 60 random accounts. Using the account balance as the dependent variable, and independent variables: number of ATM transactions, number of other banking services used, whether the customer has a debit card, whether the account receives interest, and the city where banking is done, determine which independent variables seem related to the account balance. Also determine how well the independent variables explain variation in account balances. Should all independent variables be used in the analysis or can some of them be dropped (if so, which ones?)
please do work in excel, thanks! sorry about the format!
Balance ATM Services Debit Interest City 1756 13 4. 0. 1 2 748 9 2. 1. 0. 1 1501 10 1 0 0 1 1831 10 4 0 1 3 1622 14 6 0 1 4 1886 17 3 0 1 1 740 6 3 0 0 3 1593 10 8 1 0 1 1169 6 4 0 0 4 2125 18 6 0 0 2 1554 12 6 1 0 3 1474 12 7 1 0 1 1913 6 5 0 0 1 1218 10 3 1 0 1 1006 12 4 0 0 1 2215 20 3 1 0 4 137 7 2 0 0 3 167 5 4 0 0 4 343 7 2 0 0 1 2557 20 7 1 0 4 2276 15 4 1 0 3 1494 11 2 0 1 1 2144 17 3 0 0 3 1995 10 7 0 0 2 1053 8 4 1 0 3 1526 8 4 0 1 2 1120 8 6 1 0 3 1838 7 5 1 1 3 1746 11 2 0 0 2 1616 10 4 1 1 2 1958 6 2 1 0 2 634 2 7 1 0 4 580 4 1 0 0 1 1320 4 5 1 0 1 1675 6 7 1 0 2 789 8 4 0 0 4 1735 12 7 0 1 3 1784 11 5 0 0 1 1326 16 8 0 0 3 2051 14 4 1 0 4 1044 7 5 1 0 1 1885 10 6 1 1 2 1790 11 4 0 1 3 765 4 3 0 0 4 1645 6 9 0 1 4 32 2 0 0 0 3 1266 11 7 0 0 4 890 7 1 0 1 1 2204 14 5 0 0 2 2409 16 8 0 0 2 1338 14 4 1 0 2 2076 12 5 1 0 2 1708 13 3 1 0 1 2138 18 5 0 1 4 2375 12 4 0 0 2 1455 9 5 1 1 3 1487 8 4 1 0 4 1125 6 4 1 0 2 1989 12 3 0 1 2 2156 14 5 1 0 2
Column A Account balance in $ Column B Number of ATM transactions per month Column C Number of other bank services used Column D Has a debit card (0 - no, 1 - yes) Column E Receives interest on the account (0 - no, 1 - yes) Column F City where banking is done: 1 Boise 2 Meridian 3 Nampa 4 Caldwell
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started