4 A certified financial planner would like to examine the relationship between the age of her clients and the total amount of money they have in their investment accounts. The ages of clients and...

Extracted text: 4 A certified financial planner would like to examine the relationship between the age of her clients and the total amount of money they have in their investment accounts. The ages of clients and corresponding account balances for a sample of 15 clients appears in the table. Use the regression analysis output from Excel to determine if there is a positive linear relationship between age of client and investment account balance. Test using a significance level of .01. Balance Age ($1000s) 34 38 57 87 44 129 Coefficients Standard Error t stat 183.89 3.522 56 342 Intercept X variable -226.69 50 770 -1.23 2.87 10.104 44 200 54 430 39 55 67 453 29 76 43 230 76 427 m ib 43 188 70 546 275 Linear Regression and Correlation