Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Linear Algebra With Applications

Authors: Gareth Williams

8th Edition

1449679579, 9781449679576

More Books

Students also viewed these Mathematics questions

Question

Pollution

Answered: 1 week ago

Question

The fear of making a fool of oneself

Answered: 1 week ago