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?)
| 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 | Jamestown | |||
| 2 | Houston | |||
| 3 | Dallas | |||
| 4 | San Lucas | |||
Step by Step Solution
3.48 Rating (148 Votes )
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
Document Format ( 2 attachments)
60d5e1d223f25_220879.pdf
180 KBs PDF File
60d5e1d223f25_220879.docx
120 KBs Word File
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Accounting Volume 2
Authors: James Reeve, Jonathan Duchac, Sheila Elworthy, Carl S. Warren
2nd Canadian edition
176501452, 978-0176501457, 978-0176509743
