1 What is the Sample Regression Equation y x1 x2 x3 x4 x5 109000 0 19 133 7300 85 44003745 66 595 155000 0 41 13 18700 136 7479433 6 705 86060 0 11 0 15000 122 4744871 0 055 120000 0 68 31 14000 118 3215957 15 84 153000 0 4 33 23300 152 6433752 16 7 170000 1 21 23 14600 120 8304597 12 105 90000 0 8...

ANSWER 1 The Sample Regression Equation The sample regression equation is the equation that represents the linear relationship between the dependent variable y and the independent variables x1 x2 x3 x ...

1. What is the Sample Regression Equation? y x1 x2 x3 x4 x5 109000 0.19 133 7300...

Fantastic news! We've Found the answer you've been seeking!

Question:

1. What is the Sample Regression Equation?

y	x1	x2	x3	x4	x5
109000	0.19	133	7300	85.44003745	66.595
155000	0.41	13	18700	136.7479433	6.705
86060	0.11	0	15000	122.4744871	0.055
120000	0.68	31	14000	118.3215957	15.84
153000	0.4	33	23300	152.6433752	16.7
170000	1.21	23	14600	120.8304597	12.105
90000	0.83	36	22200	148.9966443	18.415
122900	1.94	4	21200	145.6021978	2.97
325000	2.29	123	12600	112.2497216	62.645
120000	0.92	1	22300	149.3318452	0.96
85860	8.97	13	4800	69.2820323	10.985
97000	0.11	153	3100	55.67764363	76.555
127000	0.14	9	300	17.32050808	4.57
89900	0	88	2500	50	44
155000	0.13	9	300	17.32050808	4.565
253750	2	0	49800	223.159136	1
60000	0.21	82	8500	92.19544457	41.105
87500	0.88	17	19400	139.2838828	8.94
112000	1	12	8600	92.73618495	6.5
104900	0.43	21	5600	74.83314774	10.715
148635	0.32	1	6200	78.74007874	0.66
150000	0.03	24	5100	71.41428429	12.015
90400	0.36	16	5200	72.11102551	8.18
248800	4	28	5500	74.16198487	16
135000	1.83	126	6000	77.45966692	63.915
145000	3	26	4500	67.08203932	14.5
457000	0.43	53	2700	51.96152423	26.715
140000	0.44	56	19400	139.2838828	28.22
130000	1.24	51	24800	157.4801575	26.12
187000	0.46	3	15200	123.2882801	1.73
229000	0.87	9	41100	202.7313493	4.935
227000	1.8	201	25500	159.6871942	101.4
179900	0.46	1	15200	123.2882801	0.73
169900	0.91	19	20200	142.126704	9.955
209900	0.46	1	15200	123.2882801	0.73
169900	0.59	0	17300	131.5294644	0.295
293000	7.24	43	36600	191.3112647	25.12
245900	0.19	0	20700	143.8749457	0.095
157000	0.46	45	20200	142.126704	22.73
195000	0.41	32	27100	164.6207763	16.205
150000	0.78	54	24500	156.5247584	27.39
234900	0.89	9	41600	203.9607805	4.945
279550	1.34	0	44400	210.7130751	0.67
246500	1	0	17100	130.7669683	0.5
124000	1	98	15500	124.498996	49.5
138000	0.27	54	8900	94.33981132	27.135
290000	0.71	73	61000	246.9817807	36.855
108000	0.9	48	19000	137.8404875	24.45
134900	0.24	10	8000	89.4427191	5.12
64500	0.06	16	1600	40	8.03
142000	0.55	20	13800	117.4734012	10.275
125000	0.34	32	11100	105.3565375	16.17
88000	0.19	15	3400	58.30951895	7.595
135000	0.23	135	8100	90	67.615
90000	0.07	14	1800	42.42640687	7.035
90100	0.09	15	2400	48.98979486	7.545
126900	0.25	10	8400	91.6515139	5.125
175000	0.47	15	27200	164.924225	7.735
158000	0.36	10	12100	110	5.18
92000	0.07	14	1800	42.42640687	7.035
82800	0.11	225	3900	62.44997998	112.555
140000	0.23	25	8300	91.10433579	12.615
171000	3.16	15	24100	155.241747	9.08
200640	0.08	0	32000	178.8854382	0.04
139000	0.57	30	7500	86.60254038	15.285
225000	0.5	12	15300	123.6931688	6.25
182000	1	16	26600	163.0950643	8.5
208767	0.5	0	32000	178.8854382	0.25
186000	0.55	0	4400	66.33249581	0.275
93000	0.1	14	2600	50.99019514	7.05
257386	0.5	0	32000	178.8854382	0.25
161000	0.31	10	10400	101.9803903	5.155
92000	0.28	18	6300	79.37253933	9.14
211002	0.06	0	32000	178.8854382	0.03
115000	0.06	14	1600	4	7.03

3. Test the overall significance of the model by conduction an F test.

4. What is the value of adjusted r-square? Verify its value, using the formula for adjusted r-square and using the values in your Excel Printout.

5. Comment on the Normality assumption for the residuals for this model. In other word, has the normality assumption been satisfied? Explain your answer (Hint: you need to run Excel?s Histogram feature for Column of the Residuals)