Question 2

In the Excel Sheet the manager is trying to analyze the average price of the house. In one of the analyses, please help the manager in creating the bed-room-wise average cost of the house. Also, determine which size of the bedroom has the highest average price. [Hint: You can use the PivotTable option in Microsoft Excel] -

Question 3

In the Excel Sheet the manager is trying to do a descriptive analysis of the column with the name Area (Square Feet). Please compare the mean and median for the same [Hint: You can use Data Analysis Tab in Microsoft Excel]. -

Question 4

In the Excel Sheet the manager is trying to do a scatter plot analysis of the column with the name Area (Square Feet) and Price. [Hint: You can use Insert Chart Tab in Microsoft Excel]. -

Question 5

In the Excel Sheet the manager is trying to predict the price of the house using a multiple linear regression model by using 2 independent variables: Area and Bedroom only. What is the equation of the model? [Hint: You can use Regression in Data Analysis Tab in Microsoft Excel]. -

Where 1 = Yes and 0 = No for Chimney

Sr N	Area (Sqft)	Bedrooms	Chimney where 1 = yes & 0 = no	Cost (INR)
1	6,752	4	1	1,17,04,000
2	8,154	4	1	1,07,80,000
3	9,064	3	1	1,07,80,000
4	6,825	4	1	1,07,49,200
5	6,752	4	1	1,00,40,800
6	6,825	3	1	95,48,000
7	7,808	4	1	89,32,000
8	14,742	5	1	89,32,000
9	7,371	4	1	86,85,600
10	5,233	3	1	86,24,000
11	12,012	3	1	86,24,000
12	5,460	4	1	85,19,280
13	5,961	4	1	81,92,800
14	3,185	4	1	81,31,200
15	7,098	3	1	81,31,200
16	5,460	4	1	80,08,000
17	6,006	4	1	80,08,000
18	7,735	3	1	78,84,800
19	4,186	3	1	78,23,200
20	5,842	3	1	77,92,400
21	3,931	3	1	77,00,000
22	6,511	3	1	76,38,400
23	7,326	3	1	76,07,600
24	4,150	3	1	76,07,600
25	8,008	3	1	75,46,000
26	5,951	4	1	75,15,200
27	5,460	3	1	74,47,440
28	8,076	3	1	73,92,000
29	7,235	5	1	73,92,000
30	5,005	4	1	73,92,000
42	5,788	3	1	68,99,200
43	5,897	3	1	67,76,000
44	5,460	4	1	67,76,000
45	5,460	4	1	66,52,800
46	5,460	3	1	66,52,800
47	5,460	3	1	66,22,000
48	6,006	3	1	65,91,200
49	3,913	3	1	65,60,400
50	6,770	3	1	65,29,600
51	6,770	3	1	65,29,600
52	5,756	3	1	65,29,600
53	5,460	4	1	64,68,000
54	4,687	3	1	64,68,000
55	5,460	3	1	64,68,000
56	5,460	3	1	64,68,000
57	10,410	4	1	64,61,840
58	8,190	4	1	63,75,600
59	6,989	4	1	63,44,800
60	5,460	3	1	63,44,800
78	5,915	3	1	58,52,000
79	5,187	3	1	58,52,000
80	5,460	3	1	58,52,000
81	5,460	3	1	58,33,520
82	3,640	3	1	58,21,200
83	9,555	3	1	58,21,200
84	5,460	3	1	57,90,400
85	3,422	3	1	57,28,800
86	7,508	3	1	57,28,800
87	6,070	3	1	57,28,800
88	3,604	3	1	56,98,000
89	6,743	3	1	56,98,000
90	7,808	5	1	56,67,200
91	4,550	3	1	56,67,200
92	6,143	2	1	56,48,720
93	4,368	3	1	56,36,400
94	6,552	3	1	55,44,000
95	5,460	4	1	55,44,000
96	3,731	3	1	55,44,000
97	8,190	3	1	55,44,000
115	6,188	2	1	52,97,600
116	7,280	3	1	52,97,600
117	6,279	3	1	52,97,600
118	3,367	4	1	52,36,000
119	5,842	3	1	52,36,000
120	6,388	3	1	52,36,000
121	5,951	3	1	52,36,000
122	6,580	3	1	52,36,000
123	5,691	4	1	52,36,000
124	6,661	4	1	52,36,000
125	5,938	3	1	52,36,000
126	14,196	3	1	52,29,840
127	6,516	3	1	51,74,400
128	5,915	3	1	51,74,400
129	5,005	3	1	51,68,240
130	10,429	3	1	51,68,240
131	4,368	3	1	51,62,080
132	5,303	4	1	51,12,800
133	4,732	3	1	51,12,800
149	5,788	3	1	49,28,000
150	6,006	4	1	49,28,000
151	4,674	3	1	49,28,000
152	4,004	4	1	48,97,200
153	4,914	5	1	48,97,200
154	3,003	3	1	48,66,400
155	3,322	3	1	48,66,400
156	5,551	3	1	48,66,400
157	6,279	3	1	48,60,240
158	2,563	4	0	48,35,600
159	7,262	3	1	48,35,600
160	2,867	3	1	48,04,800
161	5,651	4	1	48,04,800
162	5,551	3	1	48,04,800
163	6,006	4	1	48,04,800
164	6,211	3	1	47,74,000
165	6,106	3	1	47,43,200
166	5,870	3	1	47,37,040
167	7,098	3	1	46,81,600
168	4,186	2	1	46,50,800
169	3,877	4	1	46,20,000
170	5,951	4	0	46,20,000
171	5,005	3	1	46,20,000
172	9,345	3	1	46,20,000
173	7,644	3	1	46,20,000
174	4,823	4	1	46,20,000
175	3,458	3	1	46,20,000
176	8,918	4	1	46,20,000
177	7,753	3	1	46,20,000
178	5,506	3	1	46,13,840
179	6,447	3	1	46,01,520
180	2,894	3	1	45,89,200
181	4,095	4	0	45,89,200
182	6,552	3	1	45,89,200
183	3,103	3	0	45,27,600
184	7,262	3	1	45,27,600
185	2,730	3	1	44,96,800
186	2,730	3	1	44,96,800
187	10,383	2	1	44,96,800
188	5,551	3	1	44,96,800
189	5,205	2	1	44,66,000
190	3,221	2	0	44,35,200
191	6,916	4	1	44,35,200
192	9,737	3	1	44,35,200
193	6,006	3	1	44,35,200
194	4,368	2	1	44,29,040
195	7,417	3	1	44,04,400
196	4,013	4	1	43,73,600
197	6,994	3	1	43,73,600
198	2,548	3	0	43,61,280
199	5,413	3	1	43,42,800
200	3,822	3	1	43,18,160
201	4,113	3	1	43,12,000
202	3,726	3	0	43,12,000
203	3,749	2	1	43,12,000
204	4,914	4	1	43,12,000
205	4,341	3	1	43,12,000
206	5,733	3	1	43,12,000
207	5,278	2	1	43,12,000
208	2,730	3	1	43,12,000
209	2,703	3	1	43,12,000
210	6,115	3	1	43,12,000
211	4,228	3	1	43,12,000
212	11,739	3	1	43,12,000
213	3,112	4	1	43,05,840
214	4,545	4	1	43,05,840
215	3,959	2	1	42,81,200
216	3,786	3	1	42,50,400
217	5,496	3	1	42,50,400
218	6,244	3	1	42,50,400
219	4,382	2	1	42,50,400
220	6,370	3	1	42,19,600
221	7,371	4	1	42,19,600
222	3,112	4	1	41,94,960
223	8,341	2	1	41,88,800
224	5,752	3	1	41,88,800
225	9,318	2	1	41,88,800
226	5,860	2	1	41,82,640
227	4,705	3	1	41,27,200
228	5,460	2	1	41,27,200
229	3,303	3	1	41,27,200
230	8,797	4	1	41,27,200
231	4,914	2	1	41,27,200
232	3,931	3	1	41,27,200
233	3,408	3	1	40,96,400
234	3,786	3	1	40,65,600
235	3,531	3	1	40,65,600
236	5,169	3	1	40,65,600
237	2,612	2	1	40,65,600
238	4,559	3	1	40,65,600
239	4,104	4	1	40,59,440
240	3,640	3	1	40,34,800
241	3,494	3	1	40,34,800
242	3,422	3	1	40,04,000
243	3,312	3	1	40,04,000
244	2,321	3	1	40,04,000
245	4,841	3	1	40,04,000
246	4,878	3	1	40,04,000
247	3,203	3	1	40,04,000
248	7,644	4	1	40,04,000
249	3,731	2	1	39,97,840
250	4,541	4	1	39,97,840
251	3,194	3	1	39,73,200
252	3,140	3	1	39,73,200
253	8,973	3	1	39,73,200
254	3,203	2	1	39,73,200
255	4,104	4	1	39,42,400
256	5,355	2	1	39,42,400
257	3,640	3	1	39,42,400
258	7,508	3	1	39,42,400
259	3,676	3	1	39,42,400
260	5,788	2	1	39,36,240
261	2,877	3	1	39,36,240
262	3,194	3	1	39,36,240
263	3,413	2	1	39,11,600
264	3,611	3	0	38,80,800
265	4,459	2	1	38,80,800
266	2,621	3	1	38,74,640
267	4,441	3	1	38,74,640
268	4,477	3	1	38,74,640
269	4,505	4	1	38,56,160
270	3,549	3	1	38,50,000
271	4,095	3	1	38,19,200
272	1,734	5	0	38,19,200
273	3,708	3	1	38,19,200
274	3,185	4	1	38,19,200
275	5,870	4	1	38,19,200
276	3,669	2	1	38,00,720
277	4,004	2	1	37,88,400
278	9,428	2	1	37,88,400
279	3,094	3	1	37,63,760
280	5,788	2	1	37,57,600
281	5,788	2	1	37,57,600
282	4,095	2	1	37,57,600
283	1,979	3	0	37,57,600
284	3,968	4	1	37,57,600
285	7,071	2	1	37,57,600
286	6,052	3	1	37,26,800
287	2,536	3	1	37,26,800
288	5,005	3	1	36,96,000
289	4,586	3	1	36,96,000
290	5,324	2	1	36,96,000
291	2,375	4	0	36,96,000
292	2,687	3	1	36,96,000
293	2,500	4	0	36,96,000
294	4,013	2	0	36,96,000
295	3,640	4	0	36,96,000
296	2,116	3	0	36,96,000
297	4,186	3	1	36,96,000
298	3,312	3	1	36,96,000
299	5,278	3	1	36,96,000
300	6,370	3	1	36,96,000
301	3,712	3	1	36,96,000
302	3,203	3	1	36,96,000
303	1,952	3	1	36,96,000
304	4,095	3	1	36,96,000
305	7,508	3	1	36,89,840
306	3,140	3	1	36,89,840
307	4,404	3	1	36,65,200
308	3,713	3	1	36,65,200
309	3,682	3	1	36,65,200
310	4,215	4	1	36,34,400
311	5,446	3	1	36,34,400
312	5,515	2	1	36,28,240
313	3,276	3	1	36,06,680
314	3,349	3	1	36,03,600
315	3,676	2	1	36,03,600
316	5,096	2	1	36,03,600
317	5,369	4	0	35,72,800
318	4,543	3	1	35,72,800
319	3,949	3	1	35,72,800
320	2,730	4	1	35,72,800
321	3,931	3	1	35,72,800
322	3,303	3	1	35,42,000
323	3,149	3	1	35,42,000
324	4,914	3	1	35,42,000
325	4,095	3	0	35,26,600
326	3,149	4	1	35,26,600
327	3,731	4	0	35,11,200
328	5,897	3	0	35,11,200
329	4,095	3	0	35,11,200
330	3,604	3	1	35,11,200
331	3,686	2	1	35,11,200
332	6,607	3	1	34,49,600
333	5,005	4	1	34,49,600
334	2,730	3	1	34,49,600
335	2,994	2	1	34,49,600
336	3,473	2	1	34,49,600
337	7,353	3	1	34,49,600
338	1,952	4	1	34,49,600
339	3,440	2	1	34,18,800
340	2,894	4	1	34,18,800
341	4,823	5	1	33,88,000
342	2,894	2	1	33,88,000
343	6,508	3	1	33,88,000
344	3,713	2	1	33,88,000
345	3,504	2	1	33,88,000
346	1,834	3	1	33,88,000
347	1,980	2	1	33,88,000
348	3,049	3	1	33,75,680
349	2,867	2	0	33,57,200
350	4,386	3	1	33,26,400
351	3,112	2	1	33,26,400
352	3,276	2	1	33,26,400
353	5,305	2	1	33,26,400
354	2,599	3	1	33,26,400
355	7,644	2	1	33,26,400
356	7,508	3	1	33,20,240
357	2,293	5	0	33,20,240
358	6,306	4	0	33,20,240
359	3,167	2	1	32,95,600
360	3,276	3	1	32,64,800
361	3,676	2	1	32,64,800
362	5,478	3	1	32,64,800
363	3,686	2	1	32,64,800
364	3,261	2	1	32,64,800
365	2,839	3	0	32,58,640
366	4,960	2	1	32,58,640
367	3,303	2	1	32,34,000
368	3,303	2	1	32,34,000
369	5,132	2	0	32,34,000
370	3,276	2	1	32,34,000
371	3,895	2	1	32,03,200
372	3,249	3	1	32,03,200
373	2,894	3	0	32,03,200
374	2,730	2	1	32,03,200
375	3,203	2	1	32,03,200
376	5,424	3	1	32,03,200
377	3,758	3	1	32,03,200
378	2,594	3	0	32,03,200
379	2,070	3	1	32,03,200
380	3,203	3	1	31,97,040
381	4,095	2	1	31,72,400
382	3,640	2	1	31,72,400
383	2,867	3	1	31,41,600
384	4,095	4	1	31,41,600
385	4,095	2	0	31,41,600
386	3,312	2	1	31,41,600
387	3,504	3	1	31,10,800
388	3,858	3	1	30,80,000
389	3,322	3	1	30,80,000
390	4,186	4	1	30,80,000
391	1,943	3	0	30,80,000
392	2,763	3	1	30,80,000
393	3,631	3	1	30,80,000
394	6,756	3	0	30,80,000
395	3,167	3	0	30,80,000
396	3,276	6	1	30,80,000
397	3,312	2	1	30,80,000
398	5,369	2	1	30,80,000
399	2,839	3	1	30,80,000
400	6,689	2	1	30,80,000
401	3,196	2	1	30,80,000
402	8,645	3	1	30,80,000
403	5,351	2	1	30,80,000
404	11,779	3	1	30,80,000
405	4,459	3	0	30,73,840
406	2,785	3	1	30,49,200
407	4,841	2	1	30,49,200
408	1,952	3	1	30,49,200
409	3,640	2	1	30,18,400
410	2,898	2	1	30,18,400
411	3,504	3	1	30,18,400
412	1,952	3	1	30,18,400
413	2,375	3	1	30,18,400
414	1,775	3	1	30,18,400
415	3,676	2	1	30,12,240
416	4,354	3	1	29,87,600
417	3,140	3	1	29,87,600
418	3,312	2	1	29,87,600
419	3,185	4	1	29,56,800
420	4,514	4	0	29,56,800
421	3,749	2	1	29,56,800
422	4,323	2	1	29,56,800
423	3,385	2	0	29,56,800
424	3,413	3	1	29,56,800
425	2,821	3	0	29,56,800
426	2,898	2	1	29,56,800
427	2,457	3	0	29,50,640
428	1,952	3	1	29,32,160
429	3,676	2	1	29,26,000
430	4,345	4	1	29,26,000
431	2,275	2	0	28,95,200
432	2,894	4	1	28,95,200
433	5,515	3	1	28,95,200
434	3,167	4	0	28,95,200
435	3,451	4	1	28,95,200
436	3,676	2	1	28,95,200
437	1,952	3	1	28,95,200
438	5,351	3	1	28,95,200
439	4,095	2	0	28,64,400
440	3,576	2	0	28,64,400
441	3,312	4	1	28,45,920
442	3,977	3	1	28,33,600
443	2,442	2	1	28,33,600
444	3,931	3	0	28,33,600
445	2,839	3	0	28,33,600
446	3,140	1	1	27,72,000
447	3,627	2	0	27,72,000
448	3,185	2	0	27,72,000
449	3,726	2	1	27,72,000
450	1,502	3	0	27,72,000
451	3,140	3	1	27,72,000
452	6,143	2	1	27,72,000
453	8,190	3	1	27,72,000
454	2,793	2	1	27,72,000