Please answer the question using excel.

Consumer Research Inc. is an independent agency that conducts research on consumer attitudes and behaviors for a variety of firms. In one study, a client asked for an investigation of consumer characteristics to explain the annual amount that credit card users charge on their accounts. Data collected on 50 credit card holders on explanatory variables income (in thousands of dollars), household size and dependent variable credit card amount expressed in dollars are portrayed on scatter plots below a. (2pt)Refer to scatter diagrams and comment on the relationship of each explanatory variable to Credit card amount. Model 1 - run a regression using income as the only explanatory variable a . (2priComment on the goodness of fit of Model 1. Model 1 - Model Summane. Adjusted R| Sto. Error of Mode R Square Square the Estimate 386 731.713 a. Predictors: (Constant). (prague )houseOct. b. Dependent Variable: Cordi avaroguo! b. (2pt)Report the statistical significance of the model. Model 1 - ANOVAL Sum C Model Squared Mean Square So Regression 1.700 1.70087 31.751 .000 Residual 2.570 48 535-404.251 Total 127087 49 c. (1pt)Write the regression equation for Model 1 a. Predictors: (Constant), lacage khousauce b. Dependent Variable: CoedCaudArgu0 Model 1 - Coefficients Instandardized Standardized Coefficient Doefficients Model B Sid. Error Bets (Constant) 2204.00 329.049 6.698 Income 40.480 7.18 631 5.635 000 a. Dependent Variable: Coli award !OH