Question

$723.52 $2,819.06 $975.10 $2,122.52 $1,068.38 $2,253.46 $2,763.40 $1,904.66 $2,111.50 $3,211.64 $2,665.78 $26,286 $26,590 $26.852 $27,146 $27.936 $28,556 $28,874 $29,450 $29,624 $29,690 1. State the null hypothesis and the research hypothesis 2. Using SPSS fill in the ANOVA summary table of results below. Model Summary Model R Square Adjusted R Square Std. Error of the Estimate Question Four - Simple Regression You are being asked to test if there is a relationship between dollars spent on food consumption and income. See below and next page. Food Consumption Income $8,246 $780.70 $8,742 $990.74 $9,048 $1,634.98 $10,584 $1,189.40 $10.626 $1,295.64 $ 10,984 $1,025.52 $11.822 $1,792.18 $12,532 $1,328.00 $12.952 $780.06 $13,220 $1,366.14 $13,386 $2,950.72 $13,746 $1,273.34 $13,946 $1.953.58 $14,206 $866.62 $14,388 $2,125.30 $14,622 $2,372.00 $15,032 $2,477.34 $15,172 $1,148.24 $16,284 $2,108.14 $16,664 $1,810.96 $17,124 $1,776.58 $17,302 $2,295.04 $18,254 $877.52 $18.908 $1,284.00 $18.922 $1,502.94 $19,330 $1,939.00 $20,108 $2,443.06 $20,600 $2,003.44 $21,238 $1,682.36 $22,120 $2,308.16 $22,452 $1,472.44 $23,288 $2,534.66 $23,316 $2,194.76 $23,588 $1,638.26 $23,708 $2,612.00 $23,830 $2,328.96 $23,908 $1,666.90 $24.216 $2,560.22 $25,422 $3,103.54 $25,504 ANOVA Model Sum of Squares df Mean Square 1 Regression Residual | Total Coefficients Standardized Coefficients | Beta Unstandardized Coefficients | B | Std. Error Constant) Income t Sig. 3. What is the meaning of the adjusted R square (see Model Summary) in this model

Answer 1

Answer Date: 02/10/2019 1) To test the hypothesis is that there is a relationship between dollars spent on food consumption and income. The null and alternative hypothesis is, Ho:B2 = 0 H.B. 70 The F-test statistics is, By using SPSS software, find F-test statistics with the help of following steps: 1) Import the data 2) Click Analyze. 3) Choose Linear from Regression. Add Dependent Variable and Independent Variable variables. Click Ok.

Model Summary Adjusted R Model R R Square Square .553 306 292 a. Predictors: (Constant), Income Std. Error of the Estimate 563.66617 ANOVAD Sig. Mean Square 6729175.696 317719.550 21.180 Sum of Model Squares df Regression 6729175.696 Residual 1.525E7 Total 2.198E7 a. Predictors: (Constant), Income b. Dependent Variable: Food_Consumption .000 Coefficientsa Standardized Coefficients Beta Unstandardized Coefficients Model Std. Error (Constant) 714.055 257.781 Income .058 a. Dependent Variable: Food_Consumption 2.770 4.602 Sig. .008 .000 .013 .553

From SPSS output, the F-test statistics is 21.180 The p-value for this test is, From SPSS output, the p value for this test is 0.0000. Decision The conclusion is that p-value in this context is less than 0.05 which is 0.0000, so the null hypothesis is rejected at 5% level of significance. There is sufficient evidence to indicate that there is a relationship between dollars spent on food consumption and income. The result is statistically significant. The meaning of adjusted R-squared from Model summary table SPSS output in part (b) is 0.292 indicate 29.2% of variation explained by only the income that affect food consumption.