Select Page

For each data set they’re are different questions that need to be answered, please show all your work on the worksheets for each data set

Unformatted Attachment Preview

How to enable Macros
FaQ
What will be considered for grading?
Yes.
What is the best way to present my solution?
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
spreadsheet’s formulas whenever you change a cell value.
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
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.
content contained within this template.
User_ID
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
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.
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
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 …