Fluent Essays

For each data set theyre are different questions that need to be answered, please show all your work on the worksheets for each data set business_analytics_assignment_2.xlsm Unformatted Attachment Preview Copyright © 2019, Udaptive. All Rights Reserved. How to enable Macros FaQ What will be considered for grading? Only Answer Sheets will be considered for grading. Can I add additional worksheets? Yes. What is the best way to present my solution? Complete your work in your worksheet and reference or hardcode your answer in the yellow cells provided in the Answer sheet. Why is my formula not working in Excel? Check for Automatic Calculation. On the Formulas ribbon [Excel Opions], look to the far right and click Calculation Options. When this option is set to automatic, Excel recalculates the spreadsheets formulas whenever you change a cell value. Terms of Use This template is considered a copyrighted work under the Unites States and other copyright laws and is the property of Udaptive. The items listed below are additional points to help clarify how you may use this template. Not for Resale or Public Sharing You may make archival copies and customize this template only for your personal use and not for resale sharing. or public You may not remove or alter any logo, trademark, copyright, disclaimer, brand, terms of use, attribution, or other proprietary notices or marks within this template. This template and any customized or modified version of this template may NOT be sold, distributed, published to an online gallery, hosted on a website, or placed on a public server. Disclaimer This template is provided for informational or educational use only and is not intended to be relied on as medical, financial, legal, or other professional advice. Udaptive makes no guarantee or representations about this template, or the accuracy or completeness of the content contained within this template. User_ID AnswerSheets Course 2356458 4 220 Please answer all questions based on the data provided below and Dataset_1. If you cannot answer the question due to formatting of the yellow cells. Round to three digits after decimal. 1) Develop a regression model to identify the relationship between billable hours (x) and the total costs (y). Intercept (β0) Slope (β1) 2) Interpret the coefficients of your regression model. Specifically, what does the intercept of the model mean to the co answer: 3) If a special job requiring 4000 billable hours generates a revenue of $482,000, would your recommend the firm to acc Total Cost accept the job? 4) How good is your model? Use the Coefficient of determination (R2) the assess the quality of your model. answer f you cannot answer the question due to insufficient data, enter NA. Do not change the rs (x) and the total costs (y). he intercept of the model mean to the consulting firm? , would your recommend the firm to accept the job? ess the quality of your model. Dataset_1 Total Costs $551,617 $471,238 $587,148 $366,626 $358,740 $565,045 $634,949 $334,678 $338,929 $636,988 $392,349 $700,211 $595,464 $480,975 $570,933 $343,311 $604,160 $602,563 $551,992 $478,380 $622,976 $373,107 $493,619 $456,132 $604,270 $574,533 $312,181 $338,028 $412,886 $314,168 $506,345 $578,759 $600,413 $716,160 $371,936 $595,480 $391,932 $524,096 $669,633 $425,485 $532,517 $549,401 $445,321 $375,632 $667,247 Assume a clean dataset. Billable Hours 6,900 5,500 7,400 4,000 3,100 9,100 8,600 2,300 2,600 8,400 4,500 10,000 9,000 6,200 6,600 2,900 7,400 9,900 6,600 4,600 9,100 4,300 5,600 5,400 8,800 8,800 2,500 3,400 3,600 2,300 5,500 7,400 7,800 9,500 3,500 8,000 3,900 5,700 9,400 4,800 7,300 6,900 5,500 3,600 9,700 $556,278 $551,220 $590,689 $608,886 $332,847 $315,326 $559,114 $532,600 $550,467 $317,733 $445,404 $731,897 $540,702 $620,108 $373,147 $295,195 $480,331 $386,176 $486,762 $597,834 $582,732 $550,109 $365,488 $560,989 $369,151 $439,198 $477,768 $349,910 $456,653 $374,230 $549,080 $596,531 $331,342 $320,454 $380,363 $508,431 $662,816 $521,132 $355,304 $480,595 $674,253 $618,464 $690,723 $514,707 $509,096 $620,380 $555,410 6,900 6,800 8,500 9,900 2,400 3,000 7,000 7,100 6,700 2,800 5,200 9,800 6,400 8,800 3,700 2,000 5,800 3,800 5,000 8,800 8,100 7,300 3,300 8,300 3,400 4,700 6,600 3,000 4,900 3,200 7,100 9,100 3,100 2,100 4,100 6,600 9,600 5,900 3,800 5,000 8,700 9,100 9,800 5,400 5,600 9,400 8,500 $336,799 $377,845 $518,057 $336,471 $492,583 $326,573 $570,472 $374,800 $331,648 $617,402 $418,453 $545,661 $449,057 $633,412 $617,345 $383,545 $696,573 $401,371 $459,663 $484,051 $365,713 $439,147 $660,431 $354,922 $658,009 $364,244 $401,869 $364,629 $571,276 $416,590 $546,453 $626,466 $576,372 $412,406 $541,155 $744,702 $583,705 $673,493 $434,681 $603,089 $294,389 $489,859 $371,447 $328,792 $633,056 $444,100 $517,990 2,400 3,700 7,100 3,200 7,400 2,200 8,400 3,000 2,100 9,600 3,700 7,800 4,500 8,900 7,900 3,900 8,600 5,400 4,700 5,900 3,900 5,300 9,900 3,000 8,900 3,400 4,200 2,500 6,800 4,300 7,700 7,900 9,200 3,900 6,400 9,800 8,100 8,900 5,100 8,400 2,600 6,700 4,100 2,200 9,200 4,700 6,300 $347,926 $446,582 $581,232 $616,049 $418,530 $395,371 $527,939 $483,605 $327,394 $430,789 $313,120 $674,727 $604,777 $739,368 $570,899 $651,760 $648,884 $678,063 $510,132 $423,348 $390,142 $589,366 $330,808 $452,412 $559,996 $350,539 $493,601 $642,625 $398,490 $335,699 $601,633 $354,377 $567,019 $566,655 $663,100 $580,636 $540,785 $489,914 $394,247 $370,444 $411,103 $447,769 $348,817 $466,366 $395,441 $428,957 $517,298 2,500 6,200 8,700 7,400 5,000 4,100 6,700 6,200 2,800 4,300 2,300 8,800 8,200 9,900 7,600 9,300 8,900 9,700 5,700 4,000 3,600 9,000 2,000 5,600 8,300 2,800 7,600 8,700 4,500 3,200 7,900 3,300 8,700 7,300 9,700 8,200 6,800 5,100 3,400 2,800 3,600 4,800 2,700 4,300 4,200 4,300 7,000 $571,870 $418,707 $370,397 $373,449 $615,201 $511,393 $653,555 $332,037 $378,305 $584,934 $643,478 $578,918 $477,616 $551,617 $372,075 $468,703 $579,480 $629,878 $722,645 $525,507 $361,685 $458,369 $410,326 $696,071 $391,118 $571,265 $416,337 $503,734 $662,347 $349,550 $387,621 $590,918 $583,378 $346,812 $673,239 $566,004 $423,627 $439,962 $680,400 $434,430 $589,887 $450,366 $640,640 $425,183 $322,905 $547,945 $493,267 7,000 4,600 2,600 3,400 9,400 6,200 8,400 2,100 3,200 7,700 8,600 6,500 5,500 8,100 3,600 5,100 9,600 8,300 9,500 6,500 2,800 5,500 5,300 9,100 4,200 8,200 5,100 6,300 9,700 3,300 4,400 7,800 7,300 3,600 10,000 8,300 5,200 3,900 9,600 4,900 8,900 4,500 9,000 4,300 2,000 5,700 6,300 $526,431 $651,330 $564,928 $593,046 $564,609 $436,291 $451,162 $527,923 $431,929 $359,581 $407,994 $553,213 $420,152 $307,899 $384,620 $448,750 $340,117 $734,776 $609,856 $448,027 $644,755 $418,028 $655,695 $445,995 $521,210 $444,853 $458,582 $465,914 $487,874 $597,707 $384,680 $453,085 $364,343 $642,751 $629,875 $379,087 $578,187 $286,895 $357,318 $414,038 $499,695 $454,829 $536,440 $460,627 $462,599 $359,317 $518,982 7,800 8,100 8,500 9,000 7,300 5,600 5,300 6,300 4,000 3,200 3,800 8,100 4,300 2,600 3,600 4,900 3,200 9,200 9,800 4,200 9,300 4,200 9,200 4,500 6,300 6,200 6,100 5,700 5,100 8,000 3,900 5,700 3,600 9,900 8,600 4,000 8,300 2,300 4,200 4,900 6,700 4,900 5,600 4,900 5,000 2,800 5,500 $509,080 $594,686 $489,489 $390,227 $415,498 $338,411 $465,150 $470,520 $547,139 $373,419 $624,862 $471,273 $567,336 $603,000 $431,793 $362,753 $390,549 $645,546 $363,082 $612,968 $577,828 $567,598 $400,392 $582,880 $384,227 $654,957 $515,904 $635,226 $464,006 $448,802 $392,810 $459,979 $615,092 $469,392 $504,648 $579,427 $520,314 $367,961 $548,491 $404,540 $429,417 $630,277 $435,028 $547,026 $320,417 $401,492 $601,852 5,900 9,300 7,300 4,100 5,100 3,700 6,600 5,100 7,700 4,000 8,100 5,700 6,500 7,300 5,000 3,300 4,200 8,900 2,700 6,900 8,600 8,300 4,100 8,000 3,100 9,500 7,100 9,000 6,700 5,200 3,100 5,500 9,800 5,500 6,000 8,000 7,100 4,000 6,500 4,300 5,400 8,300 4,000 7,300 2,100 3,200 9,500 $518,763 $585,644 $480,121 $674,341 $411,576 $479,889 $377,483 $534,901 $600,283 $487,128 $592,855 $484,386 $669,379 $313,371 $605,374 $374,187 $481,189 $708,903 $317,911 $497,880 $609,959 $603,557 $564,493 $628,661 $628,890 $612,281 $424,547 $328,725 $559,104 $387,827 $544,256 $403,346 $479,390 $471,673 $535,021 $524,225 $411,171 $492,532 $585,994 $433,482 $340,648 $390,965 $321,192 $651,976 $719,069 $506,207 $401,001 5,800 8,200 5,300 9,800 4,000 6,000 3,200 8,500 7,200 5,800 7,800 5,200 9,400 2,500 8,700 3,800 5,200 9,200 2,300 5,800 10,000 8,600 9,200 9,700 9,600 9,000 4,600 3,100 9,000 4,000 7,200 3,300 6,800 4,900 6,900 6,900 4,100 7,200 7,600 4,400 3,600 4,100 2,300 8,700 9,600 7,500 4,200 $352,611 $298,625 $454,871 $529,997 $381,560 $480,267 $307,385 $313,993 $331,264 $597,523 $381,005 $486,907 $415,359 $596,307 $534,625 $341,840 $411,536 $372,775 $390,542 $561,696 $424,040 $393,988 $520,562 $633,160 $443,752 $454,344 $668,496 $615,863 $692,966 $550,107 $465,434 $452,249 $414,988 $518,462 $381,355 $571,035 $510,277 $528,553 $353,946 $552,122 $506,391 $519,532 $525,337 $553,307 $377,577 $605,495 $461,545 3,500 2,200 4,700 6,800 3,900 5,600 2,100 2,600 2,500 7,900 4,000 6,100 4,900 7,700 6,300 2,800 4,200 3,200 3,400 7,900 4,400 3,500 5,800 9,100 5,300 4,800 8,900 8,900 9,500 6,000 7,000 5,400 3,800 7,500 3,800 7,900 6,600 7,000 2,600 7,900 6,700 7,200 6,100 7,900 4,700 8,900 4,700 $493,377 $373,538 $531,312 $572,702 $538,663 $649,329 $688,582 $541,467 $497,830 $351,100 $404,474 $407,086 $612,881 $598,823 $702,635 $423,673 $702,077 $450,057 $548,894 $494,308 $590,324 $523,287 $319,395 $690,481 $406,285 $506,031 $627,354 $476,275 $313,109 $368,646 $510,759 $604,466 $512,243 $550,343 $519,850 $348,490 $559,637 $371,630 $460,120 $479,776 $343,602 $627,662 $478,022 $459,064 $507,572 $546,720 $444,727 6,700 3,000 7,500 8,900 7,600 9,100 9,300 7,700 6,200 3,500 3,400 4,200 8,700 7,500 9,300 5,700 8,900 5,100 6,700 6,000 9,000 7,100 2,400 9,500 4,200 6,000 8,400 7,200 2,800 3,400 5,800 7,500 6,800 8,600 7,100 2,400 6,700 3,700 5,100 6,900 2,200 9,200 6,600 5,300 6,700 6,100 4,100 $447,632 $389,178 $501,885 $630,300 $611,741 $337,406 $588,591 $536,480 $584,049 $531,498 $620,484 $496,004 $380,081 $541,400 $376,439 $431,830 $481,174 $346,610 $281,322 $690,003 5,700 4,700 5,800 9,900 8,500 3,700 6,700 8,100 9,400 6,700 8,900 5,000 2,700 6,200 4,600 5,200 6,100 2,400 2,000 9,100 Please answer all questions based on the data provided below and Dataset_2. If you cannot answer the question due to the formatting of the yellow cells. Round to three digits after decimal. 1) Construct a correlation matrix to describe the relationship of the variables in your dataset. Credit Score Income p.a. Years of Credit History Homevalue Credit Score Income p.a. Years of Credit History Homevalue Revolving Utilization Revolving Balance 2) If you can only use one independent (x) variable to estimate the credit score of a customer, which one would you pick input variable 3) Build the simple regression model (one-factor) based on your recommendation in 2). Provide the coefficients of your m your model. Intercept Slope R2 4) Assume your manager decided to build a regression model based on Homevalue only (!). Estimate the credit scores o Credit Score $ 310,100 $ 294,600 $ 259,800 Customer1 Customer2 Customer3 5) Homevalue Years of Credit History Revolving Balance 9 $ 12 $ 13 $ 10,978 9,732 15,173 Build a multi-factor regression model based on Homevalue and Income p.a.. Provide the coefficients of your model model. Intercept Slope (Homevalue) Slope (Income p.a.) R2 6) Assume your manager decided to use the model from question 5. Again, estimate the credit scores of the same custom Credit Score Customer1 Customer2 Customer3 Homevalue $ 310,100 $ 294,600 $ 259,800 Years of Credit History Revolving Balance 9 $ 12 $ 13 $ 10,978 9,732 15,173 Do you think your new credit score predictions are more accurate? cannot answer the question due to insufficient data, enter NA. Do not change dataset. Revolving Utilization Revolving Balance stomer, which one would you pick to get the most accurate prediction? ). Provide the coefficients of your model below and assess the predictive power of nly (!). Estimate the credit scores of the following new customers: Revolving Utilization Income p.a. 24\% $ 13\% $ 70\% $ 66,000 54,000 30,000 ide the coefficients of your model below and assess the predictive power of your he credit scores of the same customers: Revolving Utilization 24\% $ 13\% $ 70\% $ Income p.a. 66,000 54,000 30,000 Assume a clean dataset. Dataset_2 Credit Score Homevalue Years of Credit History 514 $ 327,700 9 482 $ 359,600 4 562 $ 326,500 8 651 $ 439,900 7 399 $ 361,900 4 536 $ 415,900 11 641 $ 579,000 14 606 $ 566,600 5 650 $ 408,000 13 705 $ 650,300 8 563 $ 590,200 7 595 $ 379,000 4 506 $ 279,500 12 626 $ 406,500 2 516 $ 534,100 7 512 $ 455,100 1 511 $ 387,300 13 474 $ 241,200 1 562 $ 477,700 8 581 $ 393,300 8 654 $ 444,900 11 476 $ 633,200 4 496 $ 297,100 4 551 $ 584,400 14 651 $ 679,600 3 685 $ 677,100 8 503 $ 430,700 5 484 $ 355,600 3 439 $ 266,700 18 540 $ 659,400 7 552 $ 631,800 5 578 $ 534,100 1 560 $ 394,600 3 674 $ 674,700 3 517 $ 241,500 1 501 $ 526,600 7 418 $ 293,800 6 545 $ 577,600 1 615 $ 301,100 10 589 $ 421,300 5 474 $ 445,700 4 522 $ 444,400 8 643 $ 391,000 13 526 $ 674,600 1 585 $ 598,700 12 Revolving Balance $ 5,325 $ 13,844 $ 18,830 $ 7,781 $ 1,090 $ 10,158 $ 26,445 $ 24,754 $ 6,608 $ 16,860 $ 11,309 $ 1,879 $ 4,850 $ 7,015 $ 18,382 $ 11,522 $ 5,513 $ 21,201 $ 3,043 $ 6,167 $ 13,936 $ 20,068 $ 22,964 $ 24,416 $ 9,091 $ 11,381 $ 15,985 $ 4,187 $ 3,746 $ 9,123 $ 27,207 $ 3,364 $ 6,820 $ 8,583 $ 30,003 $ 11,929 $ 12,690 $ 21,768 $ 11,810 $ 28,418 $ 12,044 $ 13,099 $ 35,610 $ 27,223 $ 19,069 596 526 610 658 540 585 584 632 432 409 689 591 466 591 582 510 614 474 620 578 329 508 648 608 453 528 603 507 470 514 673 434 508 590 513 713 550 519 411 668 612 504 522 643 583 437 420 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 554,400 329,900 638,800 424,800 686,300 452,600 666,400 479,000 322,400 364,400 481,600 457,700 443,500 594,600 514,900 319,700 478,200 383,800 573,500 513,500 293,600 573,200 577,900 467,700 400,700 622,600 544,900 322,000 416,700 623,700 304,000 240,200 470,500 335,600 352,500 671,400 680,600 381,800 445,300 542,400 622,200 433,200 346,100 506,300 349,200 240,300 252,900 7 1 14 9 3 11 12 2 3 1 7 10 1 6 8 9 6 7 14 6 7 5 1 6 1 2 17 2 8 8 15 8 4 2 1 2 9 12 2 3 1 2 12 6 8 5 6 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 4,677 10,777 21,546 29,274 15,530 4,413 17,542 19,481 11,132 6,383 14,171 23,823 16,070 24,736 12,583 25,924 5,565 14,576 2,436 16,510 2,280 21,132 39,244 35,091 35,702 21,151 25,723 13,708 7,038 3,027 31,534 17,487 25,468 2,326 27,265 3,958 15,648 31,956 43,844 4,622 11,310 38,500 20,073 33,882 15,773 9,567 8,965 528 492 524 568 664 592 448 590 575 580 537 345 472 677 481 541 499 490 577 448 567 482 580 588 455 569 528 565 544 589 486 483 612 536 495 649 499 515 655 609 562 458 421 418 412 551 624 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 674,700 634,000 280,200 299,400 428,900 576,800 389,700 316,200 584,500 366,000 621,500 260,600 567,000 380,000 479,500 495,500 263,300 594,800 585,400 322,900 618,000 295,000 581,900 635,000 431,300 586,900 413,600 472,700 431,800 638,700 362,100 359,800 561,000 519,900 342,100 431,100 295,600 534,500 462,700 684,000 526,000 305,700 435,000 506,500 318,800 650,000 630,000 4 4 2 2 15 10 9 2 4 8 2 6 2 13 11 14 3 8 13 10 8 2 15 8 4 3 6 11 4 3 11 4 4 6 15 12 2 3 16 12 4 1 8 5 7 2 4 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 13,166 5,389 7,788 15,969 8,034 10,904 6,086 28,257 10,622 9,190 23,444 10,528 22,943 18,846 24,979 9,616 35,125 24,992 25,145 8,301 24,030 6,819 11,315 5,277 4,077 2,500 34,959 15,233 16,487 3,205 16,142 28,928 23,646 20,721 20,279 15,279 12,003 19,176 25,850 7,938 28,553 25,047 20,368 10,228 10,155 32,375 33,226 657 641 382 475 561 528 562 584 607 567 501 538 344 561 592 693 602 628 588 585 506 532 497 508 604 530 676 577 652 645 572 541 530 372 591 603 539 453 654 513 573 649 582 587 570 630 553 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 567,800 568,200 328,100 294,500 374,600 456,600 631,500 372,000 577,600 380,000 331,400 426,800 376,600 431,800 419,600 650,900 283,600 447,100 260,900 554,800 342,000 382,700 440,100 560,200 482,200 655,700 449,500 431,500 529,100 528,400 516,100 309,100 643,300 257,000 505,600 424,200 659,600 409,400 456,800 317,000 429,100 645,500 428,400 420,700 685,700 331,000 699,100 11 5 6 14 10 14 14 1 8 2 9 10 2 4 7 13 7 7 15 12 9 3 14 7 3 3 18 3 10 7 9 11 1 3 11 7 8 5 9 2 2 5 9 5 2 14 4 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 28,202 14,846 7,680 3,633 9,331 6,387 10,119 5,551 11,709 12,993 11,336 14,606 16,173 17,477 17,820 16,585 20,192 9,205 12,460 12,243 13,897 32,733 22,322 18,158 20,506 7,297 7,831 9,767 4,024 12,851 21,182 17,459 19,059 27,992 29,013 12,260 16,146 30,078 16,859 20,628 16,414 21,039 4,883 23,116 24,789 16,534 20,172 524 588 736 603 638 492 775 611 561 593 434 537 558 525 523 675 502 656 541 553 571 388 559 591 428 570 516 633 498 587 544 495 369 629 657 488 511 629 657 528 485 597 514 649 549 504 520 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 676,600 519,100 661,900 343,800 413,700 443,300 660,700 540,500 316,800 319,700 344,300 351,500 500,200 364,900 539,100 636,400 276,200 699,200 498,900 440,200 662,300 349,100 313,800 433,300 326,600 346,600 307,900 524,000 264,600 503,700 301,300 241,200 470,700 625,700 486,900 363,100 698,600 585,800 617,300 423,900 424,500 391,500 485,500 273,800 274,800 687,300 253,600 14 4 8 5 18 1 7 5 6 8 9 4 9 6 10 8 2 5 5 7 7 1 6 3 4 7 13 12 6 7 11 3 10 6 17 3 7 5 5 12 3 6 4 13 6 1 12 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 43,402 6,196 16,161 23,416 38,698 17,694 17,893 10,367 4,730 4,253 7,902 18,150 32,399 29,854 25,584 41,647 23,194 15,216 40,359 1,223 13,790 8,523 21,763 8,885 2,411 19,886 6,913 5,354 14,958 4,056 8,354 20,653 29,103 21,506 16,660 8,021 16,344 18,430 19,549 15,015 9,241 9,761 36,296 13,070 9,030 18,104 6,334 536 481 673 567 511 571 615 662 565 461 595 498 516 480 627 443 553 631 614 542 539 589 664 486 563 591 566 581 541 526 548 567 508 589 646 442 486 614 525 575 612 566 513 700 513 445 557 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 515,700 541,500 694,000 496,100 319,800 268,200 506,900 617,700 263,900 523,300 447,400 263,400 269,700 529,600 409,100 480,800 401,500 550,500 473,600 565,900 495,000 582,600 654,400 308,600 579,400 292,500 660,400 692,600 499,200 439,000 363,500 570,400 534,400 562,800 369,800 443,600 394,400 378,200 488,900 683,300 294,200 565,000 684,300 668,500 496,600 635,300 421,000 3 10 3 5 5 17 5 6 2 5 5 11 7 3 5 8 1 8 1 6 5 9 7 6 7 8 6 6 6 6 2 7 7 12 11 8 2 11 2 5 7 8 12 8 10 3 5 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 15,497 5,664 9,403 6,395 16,780 11,846 11,087 8,882 24,245 13,092 14,131 18,768 4,931 22,852 10,627 34,248 9,457 18,354 9,262 25,261 13,143 6,289 10,675 7,035 16,685 8,530 11,565 20,351 7,490 21,638 10,624 36,572 10,021 7,106 16,621 21,378 20,366 10,790 23,190 7,262 23,236 12,874 30,483 3,518 10,901 16,091 42,068 454 562 667 523 473 570 661 519 508 524 559 645 645 632 461 583 603 580 665 390 626 520 423 577 556 678 685 500 525 598 392 574 535 452 568 417 538 518 513 588 491 659 519 713 562 646 635 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 463,100 527,200 545,300 366,300 638,000 276,700 530,800 250,500 464,000 382,300 282,900 681,800 461,500 442,200 395,700 313,400 392,900 651,000 654,100 303,400 637,500 441,900 413,900 446,500 535,400 628,300 681,600 546 ... Purchase answer to see full attachment