1. Please use data pizza4.dat to estimate the coefficients of the following model. Please provide...

Question

1. Please use data pizza4.dat to estimate the coefficients of the following model. Please provide the Excel results.

Data
    pizza    female    hs    college    grad    income    age
    109    1    0    0    0    19.5    25
    0    1    0    0    0    39    45
    0    1    0    0    0    15.6    20
    108    1    0    0    0    26    28
    220    1    1    0    0    19.5    25
    189    1    1    0    0    39    35
    64    1    1    0    0    15.6    40
    262    1    1    0    0    15.6    22
    64    1    1    0    0    36.4    30
    35    1    1    0    0    28.6    21
    94    1    1    0    0    57.2    40
    71    1    0    1    0    13    21
    403    1    0    1    0    288.6    45
    41    1    0    1    0    41.6    36
    10    1    0    1    0    58.5    36
    110    1    0    1    0    71.5    40
    239    1    0    1    0    37.7    23
    63    1    0    1    0    50.7    32
    0    1    0    1    0    91    52
    106    1    0    0    1    71.5    30
    0    1    0    0    1    117    45
    141    0    0    0    0    7.8    32
    299    0    0    0    0    23.4    20
    148    0    0    0    0    71.5    55
    424    0    1    0    0    13    18
    242    0    1    0    0    29.9    30
    119    0    1    0    0    45.5    45
    338    0    1    0    0    49.4    40
    135    0    1    0    0    58.5    50
    590    0    1    0    0    110.5    32
    324    0    1    0    0    28.6    30
    87    0    1    0    0    32.5    51
    395    0    0    1    0    37.7    22
    513    0    0    1    0    171.6    40
    56    0    0    1    0    45.5    30
    400    0    0    1    0    104    36
    384    0    0    1    0    71.5    27
    262    0    0    1    0    39    24
    336    0    0    1    0    35.1    21
    281    0    0    0    1    104    45

question-o0qf41nq.docx pizza4-xpfubqby.xlsx pizza4-feqkns4t.def

Atul · Accepted Answer

Sheet4
	SUMMARY OUTPUT
	Regression Statistics
	Multiple R	0.5738038291
	R Square	0.3292508343
	Adjusted R Square	0.2929941227
	Standard Error	131.0700989746
	Observations	40
	ANOVA
		df	SS	MS	F	Significance F
	Regression	2	312015.178727045	156007.589363522	9.0811002783	0.0006185326
	Residual	37	635636.721272955	17179.370845215
	Total	39	947651.9
		Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
	Intercept	342.8848278531	72.3434196586	4.7396823301	0.0000314373	196.303136191	489.4665195152	196.303136191	489.4665195152
	income	1.8324789338	0.4643007414	3.9467499627	0.0003409429	0.891716271	2.7732415966	0.891716271	2.7732415966
	age	-7.5755558941	2.316987583	-3.2695712094	0.0023326067	-12.2702186717	-2.8808931164	-12.2702186717	-2.8808931164
	RESIDUAL OUTPUT
	Observation	Predicted pizza	Residuals
	1	189.2292697094	-80.2292697094
	2	73.4514910361	-73.4514910361
	3	219.

Please provide the regression model in Excel and teach me step-by-step how to get the correct regression model.

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment