Managerial Economics

dataassignment2.xlsx

Sheet1

Area	Y	X1	X2	X3	X4	X5	X6
1	29.67	97.3	26.88	98.8	1	0	18.0096
2	36.21	101.2	39.54	95.2	1	1	28.0734
3	39.24	91	21.855	110.8	1	0	14.64285
4	41.7	95	16.55	91.9	0	0	11.4195
5	26.79	109.6	21.84	100	1	0	15.0696
6	24.15	126.4	18.5	100.8	0	0	12.765
7	11.94	126.4	26.22	122.9	1	0	17.5674
8	9.54	149.4	30.69	149.1	1	1	21.483
9	45.21	78.8	43.89	102.4	1	1	31.1619
10	35.58	75.7	20.94	87.8	1	0	14.658
11	39.3	91.9	18.255	80.2	0	0	12.7785
12	41.61	103.4	15.64	75.2	0	0	10.7916
13	36.06	101.6	28.08	99.6	1	1	19.0944
14	30.57	113	31.035	123.5	1	1	21.7245
15	29.64	121.7	26.445	131.2	0	0	18.24705
16	35.82	112.6	31.065	79.2	1	1	21.7455
17	32.79	150.1	32.865	88.5	1	1	23.33415
18	35.97	100.3	26.955	94.1	1	0	18.8685
19	30	151.4	27	101.6	1	0	18.9
20	24.36	145.3	28.065	90	1	1	19.36485
21	27.54	150.5	37.515	94.3	1	1	27.0108
22	29.58	129.7	27.66	98.4	1	0	19.362
23	33	123	36.225	95	1	1	25.3575
24	35.73	104.5	34.305	99.8	1	1	24.35655
25	39.36	82	28.125	100.9	1	1	19.6875
26	30.06	100.3	27.945	112.1	1	0	19.5615
27	26.73	109.4	19.525	124.3	0	0	13.277
28	23.88	128.1	20.985	90.2	0	0	14.6895
29	23.67	155.1	13.245	80.5	0	0	9.2715
30	14.88	148.7	20.745	97.1	1	0	14.5215
Y =	Average quantity of good A sold per month
X1 =	Average price per A in SEK
X2 =	Average monthly income per household in thousand SEK in the area
X3 =	Average price for good B in SEK in the area
X4 =	Urban dummy variable
X5 =	Dummy for household income 28 thosands SEK or more
X6 =	Average monthly disposable income (income after tax) per household in thousand SEK in the area