Question

Consider the following output from the model that relates proportion of household’s budget spent on beverages (WBEV) to total expenditure (TE), age of head of the household, and number of children in the household (NK) with a sample size of 144. Regression Analysis: WBEV versus TE, AGE, NK:

SUMMARY OUTPUT
Regression statistics
Multiple R	(       )
R Square	(       )
Adjusted R Square	0.3837
std	(       )
Observations	144
variance analysis
	df	SS	MS	F	Significance F
regression analysis	(       )	(       )	(       )	(       )	0.000
Residual	(       )	3.7538	0.0268	-	-
sum	143	6.2209	-	-	-
	Coefficients	std	t Stat	P-value
Intercept	0.0090	0.0190	0.4737	0.635
TE	0.0280	0.0042	(       )	0.000
AGE	(       )	0.0009	-6.9600	0.000
NK	-0.0130	0.0033	-3.9394	0.000

1. Fill in the blanks when you see? please write the calculating process.

Answer 1

SUMMARY OUTPUT
Regression statistics
Multiple R	0.629747956
R Square	0.3965824881
Adjusted R Square	0.3837
std	0.1637070554
Observations	144
variance analysis
	df	SS	MS	F	Significance F
regression analysis	3	2.4671	0.8223666667	30.68532338	0
Residual	140	3.7538	0.0268	-	-
sum	143	6.2209	-	-	-
	Coefficients	std	t Stat	P-value
Intercept	0.009	0.019	0.4737	0.635
TE	0.028	0.0042	6.666666667	0
AGE	-0.006264	0.0009	-6.96	0
NK	-0.013	0.0033	-3.9394	0