Assignment using Excel. Marks: 30

First enter the Real Estate data into the Excel Program you are supplied with. Assume the 105 homes is population.

Select a sample of size ------- and answer the following exercises using your sample data.

Exercise 1: Refer to the Real Estate data, which report information on homes sold in the area last year.

1. Determine a frequency table and relative frequency table from the variable Township and interpret.

Develop a Bar Diagram and also a Pie chart for the variable Township. Interpret both the charts

1. Select an appropriate class interval and organize the Selling prices into a frequency distribution table and interpret.
2. Compute the Mean, Median, Mode, Range, Standard Deviation, Variance, Quartiles, Deciles, 85th Percentile of Selling price from the raw data of your sample and interpret.

Determine the skewness and interpret.

Exercise-2: a) Develop a 99 percent confidence interval for the mean selling price of the homes. And interpret.

b) Develop a 95 percent confidence interval for the mean size of homes. And interpret.

Exercise-3: a) Let selling price be the dependent variable and size of the home the independent variable.

Determine the regression equation and interpret.

Write down the reression equation in words.

Estimate the selling price for home with an area of 2,200 square feet.

Determine r, R² and S_y.x . Interpret.

b) Let selling price be the dependent variable and no. of bed rooms the independent variable. Determine the regression equation and interpret.

Determine r, R2 and S_y.x . Interpret.

Estimate the selling price for home with 5 bedrooms.

Exercise-4:

Use the selling price as the dependent variable and determine the regression equation with number of bedrooms, size of the house, whether there is a pool, whether there is an attached garage, distance from the center of the city and number of bathrooms as independent variables.

a) Write out the regression equation. Discuss each of the variables.

Write down the regression equation in words.

How much does a garage or a swimming pool adds to the selling price of a home?

b) Determine the value of R-square. Interpret.

c) Determine the multiple S.E of the estimate and interpret.

Y = Selling Price in $ (Thousand), X1= Number of bedrooms., X2 = Size of the home in
square feet, X3 = Pool (1 = yes, 0 = no)., X4 = Distance from the center of the city, X5 =
Township (1 = Gulshan, 2 = Uttara 3 = DOHS, 4 = Dhanmondi, 5 = Banani)
	x6= Garage	X7 =Number of Bathroom.
	Selling Price	Number of Bedrooms	Size of home	Pool	Distance	Township	Garage	No. of Bathroom
1	267.1	4	2300	0	17	Banani	1	2
2	186.4	4	2100	1	19	Dhanmondi	0	2
3	246.1	3	2300	1	12	DOHS	0	2
4	217.6	2	2200	1	16	Uttara	0	3
5	143.9	2	2100	1	28	Gulshan	0	2
6	249.4	2	2100	0	12	Gulshan	1	2
7	331.2	6	2500	1	15	DOHS	1	2
8	275.8	2	2100	1	9	Uttara	1	3
9	225.1	3	2300	0	18	Gulshan	0	2
10	270.6	4	2400	1	13	Dhanmondi	1	2
11	296.4	4	2100	1	14	DOHS	1	2
12	213	2	1700	1	8	Dhanmondi	1	2
13	274.8	6	2500	1	7	Dhanmondi	1	2
14	250.1	4	2100	1	18	DOHS	1	2
15	198.4	2	2300	1	11	DOHS	0	2
16	285.3	3	2100	1	16	Uttara	1	2
17	176.7	4	2200	0	16	DOHS	0	2
18	211.5	5	2300	0	21	Dhanmondi	0	3
19	202.9	3	2200	0	10	Dhanmondi	1	2
20	213.3	6	1900	0	15	Dhanmondi	1	2
21	256.3	4	2600	1	8	Dhanmondi	1	2
22	196.9	4	1900	0	14	Uttara	1	3
23	213.3	5	2100	1	20	Banani	0	2
24	349.3	8	2600	1	9	Dhanmondi	1	2
25	330.3	6	2100	1	11	Banani	1	3
26	177.1	2	2200	0	21	Banani	1	2
27	191	2	1900	1	26	Dhanmondi	0	2
28	261.2	2	2100	1	9	Dhanmondi	1	2
29	237	3	2200	1	14	DOHS	1	2
30	184.4	2	2000	1	11	Banani	0	2
31	238	2	1700	1	19	DOHS	1	2
32	211.1	2	2000	1	11	Banani	1	2
33	251.7	5	2400	1	16	Uttara	1	2
34	170.2	3	2000	0	16	Uttara	1	2
35	181.1	2	1900	1	10	Banani	1	2
36	186.7	4	2000	0	14	Dhanmondi	0	3
37	220	4	2300	1	19	Uttara	0	2
38	316.1	6	2600	1	7	Banani	1	3
39	203.8	3	2100	1	19	DOHS	1	2
40	277.2	5	2200	1	16	Uttara	1	3
41	210	3	2100	0	9	DOHS	0	2
42	236.2	3	1900	0	16	Gulshan	1	2
43	202.3	4	2100	0	19	Gulshan	1	2
44	209.1	3	2000	0	20	Dhanmondi	0	2
45	179.6	4	2300	0	24	Dhanmondi	1	2
46	311.8	3	2400	0	21	Uttara	1	3
47	273.2	5	2200	1	8	Banani	1	3
48	228.8	3	2200	1	17	Gulshan	1	3
49	175.6	3	2000	0	16	Dhanmondi	0	2
50	220.8	3	2200	1	15	Gulshan	1	2
51	196.6	6	2200	0	14	Gulshan	0	2
52	240.4	5	2200	1	20	DOHS	1	2
53	176.4	3	2200	1	23	DOHS	0	2
54	255.4	3	1900	1	12	Uttara	1	2
55	250	6	2300	1	7	DOHS	1	3
56	151.4	6	1700	0	12	Gulshan	0	2
57	180	4	2200	1	15	Gulshan	1	2
58	232.4	3	2300	1	17	Banani	1	2
59	170.5	3	1600	0	19	DOHS	0	3
60	193.4	4	2200	1	24	Gulshan	1	2
61	316.1	7	2400	1	13	DOHS	1	3
62	293.8	6	2000	1	21	DOHS	1	3
63	273.9	5	2200	0	11	Dhanmondi	1	3
64	158.3	2	2000	1	13	Uttara	0	2
65	226.1	2	2100	1	9	Banani	1	2
66	213.7	5	2200	0	13	Uttara	1	2
67	194.9	3	2200	0	18	DOHS	1	2
68	258.3	4	2500	0	15	DOHS	1	2
69	211.5	3	2100	0	10	Uttara	0	2
70	213.7	4	2200	0	19	Uttara	1	2
71	298	2	2100	1	13	Uttara	1	3
72	180.3	2	2000	0	17	DOHS	0	2
73	298.3	7	2400	1	8	Dhanmondi	1	2
74	228	3	1900	0	6	Gulshan	1	2
75	129	2	1900	1	18	Dhanmondi	0	2
76	240.8	4	2600	0	17	Banani	1	2
77	168.1	4	2300	1	19	Dhanmondi	0	2
78	221.8	3	2500	1	12	DOHS	0	2
79	196.2	2	2400	1	16	Uttara	0	3
80	129.9	2	2400	1	28	Gulshan	0	2
81	224.9	2	2300	0	12	Gulshan	1	2
82	298.5	6	2700	1	15	DOHS	1	2
83	248.6	2	2300	1	9	Uttara	1	3
84	203	3	2500	0	18	Gulshan	0	2
85	244	4	2600	1	13	Dhanmondi	1	2
86	267.2	4	2300	1	14	DOHS	1	2
87	192.1	2	1900	1	8	Dhanmondi	1	2
88	247.7	6	2700	1	7	Dhanmondi	1	2
89	225.5	4	2300	1	18	DOHS	1	2
90	179	2	2500	1	11	DOHS	0	2
91	257.2	3	2300	1	16	Uttara	1	2
92	159.4	4	2400	0	16	DOHS	0	2
93	190.7	5	2500	0	21	Dhanmondi	0	3
94	183	3	2400	0	10	Dhanmondi	1	2
95	192.3	6	2100	0	15	Dhanmondi	1	2
96	231.1	4	2900	1	8	Dhanmondi	1	2
97	177.6	4	2100	0	14	Uttara	1	3
98	192.3	5	2300	1	20	Banani	0	2
99	314.8	8	2900	1	9	Dhanmondi	1	2
100	297.7	6	2400	1	11	Banani	1	3
101	183	3	2400	1	8	Dhanmondi	1	2
102	192.3	6	2100	0	14	Uttara	1	3
103	231.1	4	2900	1	20	Banani	0	2
104	177.6	4	2100	1	9	Dhanmondi	1	2
105	192.3	5	2300	1	11	Banani	1	3