Consumer Credit Behaviors The file credit.xls contains a recent survey about 50 consumers. The data were collected on annual income, household size, and annual credit card charges. You are to analyze the data and write a managerial report on your findings using EXCEL or PHStat2. The following is a minimum guideline about what you should analyze. You need to perform more in-depth analysis for a better grade than a C. For example, you may have to use such tools as confidence interval estimates, one or two-sample hypothesis tests on the data to improve the quality of your report. a) State statistical objective(s) for the project. b) Perform EDA (Section 3.3) including numerical descriptive measures. Comment on the findings. c) Construct scatter diagrams for pairs of variables. Do any of these appear to have some association? d) From (b) and (c), does any simple linear model appear to hold? You may want to run some testing to substantiate your findings. e) Does a multiple regression model appear to hold? You may want to run some testing to substantiate why or why not. If so, is there more than one variable that may be used as a dependent variable? f) Is the regression significant? Report the results of the appropriate test, and interpret its meaning. g) Discuss the need for other independent variables that could be added to the model. What additional variables might be helpful? h) Do you find any dummy variable in the model that makes a significant contribution to the model?