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

The Answer is in the image, click to view ...

Question: 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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Hi again, I was hoping you can help with this investment management assignment. I am attaching the word document. It is 4 problems about asset management. Thank you for your help! Fin 6310 1. Assume...

Hello, I am struggling with this assignment, I am unable to determine the below questions based off the attached 10K. I have also attached a spreadsheet from another answer to a part of this question...

Even if you can one answer question 1, any help would be greatly greatly appreciated!! and if you could show your work so I can understand it would be really helpful!!! Thank You!!! D G H G8212 CASE...

'l of? -|- Automatic Zoom v I Arizona Microbrewery, Inc.: An Instructional Case on Management Decision Making Janet A. Samuels Arizona State University Kimberly M. Sawers Seattle Pacific University...

Question 1 , Question 2 and Question 5 part (ii) thanks alot Faculty of Business, Economics & Accounting Department of Accounting and Finance HELP Bachelor of Business (Hons) Year 3 INTERNAL SUBJECT...

Hi guys I hope your doing well. I know this is a long case but I do not need you to do all of the questions just 1 of them. The only reason I provided screenshot is so you can have the background...

In 2015, Alex Montella quit his job at a large beer company to start his own brewery, Siena Brewery, Inc. (SI). His family supported his decision and invested in the business along with Alex. Siena...

Hudson: Lisa: Fred: Jake: We've made a lot of progress researching various ERP vendors. However, ERP software for car dealerships is still fairly expensive for a small dealership like ours. Combine...

i just need to complete the excel Frenchies Signature Assignment Joseph Preimesberger posted on Nov 8, 2021 9:35 AM Edited This is a shortened assignment, so just complete the three Excel tabs given...

Strategic Leadership Real Life Case Study Assignment (Individual Basis) Purpose of the learning activity: This project will allow the students to use the concepts of Strategic Leadership learned over...

You are one of five risk-neutral bidders participating in an independent private values auction. Each bidder perceives that all other bidders valuations for the item are evenly distributed between...

At Morris Mart Inc., all sales are on account. Mary Morris-Manning is responsible for mailing invoices to customers, recording the amount billed, opening mail, and recording the payment. Mary is very...

Given the following information, calculate the ROI of the marketing initiative: Unit price $ 15.50 Units before the initiative 12,000 Units after the initiative 15,000 COGS $ 13.80 Cost of the...

Pick a product/service for Business Markets and prepare a role play/presentation on grounds for selling your chosen product. (Monologue: Minimum Three Minutes) Recall that business products are for:...

Take responsibility for the other persons or others experience of the situation.

Pollution

The fear of making a fool of oneself