Question: I need help with the question below, please. Account Balance Income Years of Education Size of Household 8976 12 8308 14 10028 52 16 11256
I need help with the question below, please.

Account Balance Income Years of Education Size of Household 8976 12 8308 14 10028 52 16 11256 64 15 9869 47 17 10194 74 15 8706 49 12 9557 58 14 0565 70 16 9434 69 11 9687 25 18 9490 57 15 8806 46 9561 18 11757 80 15 9406 56 14 11150 16 7671 28 8803 53 13 9571 52 15 9566 77 12 7885 32 14 9773 55 11 9121 52 15 9298 43 14 10285 65 15 7801 38 12 9323 52 14 8643 36 16 12466 85 15 9447 54 14 10727 36 15 9243 57 15 9311 68 12 11033 74 14 1172 82 16 8727 24 15 8438 37 15 8317 55 12 8617 50 14 9052 39 16 10889 73 15 7766 26 14 9189 47 15 NEW W I N W W N W N W N N N W N E N W N E W W N E N W N W N W H W W W N N NN ANNA Use data in to complete the following. You will need to use a statistical package such as StatTools or the Regression program within Excel's Data Analysis Add-in to generate the estimated regression equation and the ANOVA etc. a. What is the estimated regression equation using Account Balance as the dependent variable, and Income, Years of Education, as well as Size of Household as the independent variable? Comment on the goodness of fit of the model using the coefficient of determination. Conduct an F test with the critical value approach to see whether the overall model is significant. Use a = 0.01. Perform a t test with p-value approach for the significance of the Income variable. Use a = 0.05. e . Perform a t test with the p-value approach for the significance of the Size of Household variable. Use a = 0.05. Estimate the Account Balance of a customer who has an income of $62 thousand, 14 years of education, and a household size of 3
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
