In: Statistics and Probability
Task : Input this data into the SPSS and do the regression analysis as discussed today in the class.
SN | Food exp. | Monthly income | family size |
1 | 3 | 8 | 5 |
2 | 4 | 12 | 7 |
3 | 5 | 15 | 5 |
4 | 2 | 5 | 6 |
5 | 5 | 4 | 4 |
6 | 3 | 8 | 9 |
7 | 4 | 13 | 10 |
8 | 7 | 9 | 6 |
9 | 5 | 11 | 7 |
10 | 6 | 12 | 8 |
11 | 4 | 7 | 8 |
12 | 8 | 8 | 12 |
13 | 4 | 9 | 11 |
14 | 2 | 6 | 5 |
15 | 3 | 7 | 3 |
Coefficientsa |
||||||
Model |
Unstandardized Coefficients |
Standardized Coefficients |
t |
Sig. |
||
B |
Std. Error |
Beta |
||||
1 |
(Constant) |
1.708 |
1.631 |
1.047 |
.316 |
|
Monthly_income |
.128 |
.149 |
.231 |
.859 |
.407 |
|
Family_Size |
.210 |
.177 |
.319 |
1.187 |
.258 |
|
a. Dependent Variable: Food_Exp |
The regression equation is,
Y = 1.708 + 0.128 * monthly Income + 0.210 Family* Size
Interpretation of regression Coefficient:-
β1 = 0.128
β1 = As One unit increase in the variable monthly Income there is 0.128 Unit increase in the Food Exp .
β2 = 0.210
β2 = As One unit increase in the variable Family Size there is 0.210 Unit increase in the Food Exp .
Model Summary |
||||
Model |
R |
R Square |
Adjusted R Square |
Std. Error of the Estimate |
1 |
.439a |
.192 |
.058 |
1.66783 |
a. Predictors: (Constant), Family_Size, Monthly_income |
r square = 0.192
19.2 % represents a model that explain the variation in the response variable around its mean.