Activity 5 Bus Stat

 Activity I – Last year, your firm collected data on each of its 107 division managers. The data contain growth figures for each manager’s division, the manager’s tenure with the firm, and the manager’s score on a leadership test, which was administered firmwide. These data are contained in the file attached.

1. Run a regression designed to determine the effect of manager tenure on division growth.
2. What role, if any, can the manager’s leadership test score play in the regression you ran for Part a? Explain.

Activity II – Use the data in the attached for this question.

You are working as an analyst for a large cable company that offers bundles of channels all across the United States. One of the bundles is the “basic package,” which includes network channels along with a few other basic cable channels. You are interested in learning how the price of this basic package influences the rate of subscriptions in a market. You have data on subscriptions per 1,000 local residents, price for the basic package, and average local household income. You also have data on local telecom labor costs per subscriber. You believe this last variable influences the local price but not subscriptions per se.

1. Based on the data provided, write out an expression for the data-generating process for subscriptions per 1,000 local residents.
2. Estimate the effect of basic package price on subscriptions per 1,000 local residents using OLS. Why might you distrust this result as being a causal effect?

2

>Sheet

1 6

3

4

9

0

3

5
9

2
9

4

13

1

3
4

16

7
26

7

4
10

5
9

9
25

7
11

10
4

0
14

13

2
1
11
9
26

5

91

3
2
6
6

8

5

4
10

12

3

4
19

7
19
46
2
7
41
7

40

9
8

7
24

3

13

2

3
14

9
24

0
5
20
6
15

5
11
24
7
8

7
4
54
9
21

5
13

6
13

1
5
9
6
25

1
22
11
4
9

4
18

6
16
41
12
27

10
25

9
27

8
18

3
15

1
14
14
11
13
60
11
27

8
19
54
1
13
20
7
21

5
12

3
5
6
7
11

6

66

7
20

8
10
20
9
8

7
11

2
2
25
7
18

7
18

9
7

7
30

5
10

7
12
67
7
8
55
3
17
17
9
17

10
23
104
8
24

5
6
27
9
22
67
6
26
99
12
22
94
5
24
75
6
5
30
4
28
101
2
10

6
9

11
24

9
7
101
2
21
11
5
28

2
11
102
2
21
60
1
2
11
10
11
101
10
24
79
9
19
100
6
13
94
14
18
107
2
25
58
2
6

Growth	Tenure	Test Score
											4																6						14
																			7	6										3
		16	1																			9
															5	4									8
			26			1		0
					25									13
86
89
			17
							24	83
		41
													11	59
								10
	91
	79
				27
96
	46
32
-1		40
98
		30
					12
	23		66
42
				20		102
				19	50
					18
				21
74
		54
			22
		15			60
	58
33
	107
		67
56
57
64
		94
		28
97
77
73
78
70
	75
	104
61
34
	55
29
47
90
	100
85
			101
	99
95
52
92
36
88
-2
81
51
72

Sheet1

Subs per 1000
Price
Income
Labor

440.7088560406
41.9736426734
67.867
12

475.0794335609
41.4217389268
64.549
6

426.013408628
36.224901438
53.664
6

437.3416206739
45.6521034457
60.429
12

424.3132452812
40.6073742135
52.669
8

405.8547973626
29.8266328938
60.895
6

392.3133086757
40.3683847793
61.103
15

477.0864376661
50.3749062777
65.837
12

487.1057145355
49.3809524226
56.82
8

488.8287286504
50.3002881084
68.027
9

489.1651805929
46.8303634322
55.183
8

517.7953709658
48.8980618276
62.407
6

508.5574656594
57.2917442766
66.807
13

455.5854771951
48.6299128659
62.806
12

442.4767970965
49.9781328494
53.608
13

452.0480126306
44.1163354384
59.35
11

505.8553431506
48.0017238584
64.845
7

424.0854643019
43.587410717
53.561
12

450.9913706579
49.8445617763
57.924
13

440.1421516895
49.6698586149
64.123
14

458.4030341013
38.5660056836
60.007
6

524.0989899155
50.3169983193
67.197
7

449.6943836438
44.277397274
52.03
9

473.3537491048
44.8719581841
63.122
7

440.6714647857
38.6295774643
63.894
6

460.3150733765
47.3636788961
56.133
12

463.3133672025
40.4573945337
68.569
7

483.3185747802
53.26842913
64.708
13

485.182586227
45.0945977045
63.615
6

455.6776429492
53.6777738249
61.611
15

444.9937570251
37.2276261708
54.628
6

458.1288704425
45.7286450737
60.757
11

455.5963424942
49.2550570824
68.066
14

542.7305048484
54.3710841414
60.504
5

464.580054209
44.3266757015
55.62
6

451.3592228654
48.7102038109
62.098
15

501.7435013321
45.484250222
66.838
6

496.0710398957
52.3838399826
58.768
10

528.0587312932
52.3894552155
62.722
6

503.9196202184
54.5032700364
56.9
9

447.3272048757
42.927534146
55.762
10

472.0317233279
50.3032872213
57.212
12

467.9481011125
51.1880168521
51.82
12

512.8771417729
56.2321902955
65.484
11

462.8304808295
43.1750801383
52.78
5

457.3451212344
51.5681868724
50.936
15

452.2986256655
49.5616042776
64.929
15

403.7495936667
42.1057656111
61.115
14

457.4643150574
38.8492191762
67.369
5

439.6837280845
42.2569546808
49.142
7

427.1804167438
38.3369027906
53.159
9

436.1152505275
45.9728750879
63.278
14

463.4571323993
52.7301887332
54.076
14

469.2879976081
52.2009996014
54.082
12

469.6511059452
44.2333509909
70.251
7

463.3870350382
39.5905058397
66.844
7

540.5173261432
55.1742210239
54.472
7

494.7101661845
55.8745276974
59.463
13

519.1608018812
63.3934669802
61.8
15

449.3304619219
45.9252436536
60.779
10

426.4762936441
43.6215489407
60.747
14

470.9543456424
44.0927242737
54.398
7

486.1558391561
53.0344731927
52.949
11

428.2706986331
48.8472831055
56.187
15

475.3330935213
56.7250155869
62.983
15

450.2224818009
46.5719136335
59.791
13

462.3126544098
40.2769424016
57.651
6

485.3413950121
56.4193991687
62.825
15

384.7280268104
42.4148378017
54.239
15

460.0327307913
50.9234551319
67.492
13

424.4351346863
40.5866891144
51.915
11

441.0487153365
39.5666192227
49.649
7

459.7077877482
43.7736312914
50.066
7

503.7665327286
53.2754221214
65.114
10

537.3140167077
52.9125027846
67.839
5

428.3412425837
44.554873764
67.012
15

444.8506977973
37.7772829662
57.187
6

466.6000753127
46.9211792188
52.073
9

424.279358431
41.5090597385
57.225
10

455.627635612
55.5414392687
51.379
15

493.2373910226
51.2605651704
64.674
12

476.5030928596
41.1326821433
67.707
6

433.9799887336
35.0121647889
61.907
5

518.6142562966
48.7837093828
68.912
5

477.0363681631
50.1073946938
63.392
10

519.3980671875
54.0525111979
67.083
11

455.0285791075
44.5735965179
50.587
9

434.2688435389
36.1181405898
52.56
5

454.4045715461
48.0857619243
55.89
11

475.8695754624
45.0787625771
63.397
6

452.4523826313
46.7097304386
53.194
12

422.5947251083
36.0369541847
59.373
8

456.9028191799
41.9613031967
65.135
8

398.572163764
36.8626939607
60.396
10

416.4805601597
37.7522600266
52.967
7

462.1727124997
40.5616187499
58.803
7

475.0905822353
47.3782637059
54.821
9

506.0490929035
50.9326821506
69.453
9

459.4490198506
46.2058366418
55.214
9

542.0293132446
61.9338855408
58.426
10

455.5305571929
37.3632595322
64.351
6

504.2161786654
47.7321964442
62.823
7

455.8070895093
42.5020149182
60.795
8

468.7930456807
49.6353409468
54.981
10

407.862593687
37.9209322812
69.337
10

388.1759727087
33.2751621181
51.525
10

478.7805062634
40.4940843772
65.816
5

372.619441888
38.295073648
51.849
14

459.2343690548
48.1525615091
67.319
12

419.9634727525
42.9014121254
58.555
11

492.1801672348
49.5315278725
68.991
11

418.7865803424
41.7089300571
55.533
12

491.0079191592
46.1201531932
57.287
6

476.9268645861
49.096977431
64.345
10

426.2766254924
48.6529375821
63.359
15

452.4921531259
47.8768588543
52.231
13

468.735423581
49.2739039302
67.092
13

423.3410046392
39.1605007732
58.378
9

457.1469203077
53.1741533846
53.102
14

433.2557232623
51.2229538771
52.918
15

417.396359144
41.049226524
59.101
13

465.0585272158
38.206254536
66.821
5

482.8881376639
42.9571896107
60.145
5

381.4898902764
33.4603150461
54.728
9

461.6202158813
49.6138693135
61.937
11

418.0751400598
39.57119001
69.648
13

479.6254035064
43.7855672511
61.912
7

397.4317606383
35.0151267731
55.341
9

485.3607692117
45.7687948686
69.748
7

423.023869745
39.9003116242
54.622
8

422.0467217079
31.9042869513
54.621
5

444.4458418464
38.9228069744
58.909
7

434.2189267393
41.2969877899
55.437
9

473.3161115408
43.3971852568
61.933
6

445.8169350347
50.4628225058
63.04
14

426.1656260658
40.6241043443
63.421
12

490.5561512084
43.3355252014
59.543
5

416.5152045201
36.85236742
63.401
9

494.6223731382
47.366895523
62.421
6

448.8182530727
46.2002088455
68.617
11

537.0895936149
48.9237656025
66.547
5

410.0478948848
35.8449824808
64.978
10

526.6479534223
55.9913255704
67.7
10

430.130534054
45.7474223423
52.646
12

471.4404788618
56.8244131436
50.494
14

501.7190322921
53.6058387154
70.084
13

424.1284307298
36.336738455
53.108
7

462.510090752
42.274681792
67.862
8

453.105811728
42.8154686213
62.213
8

441.1548315591
43.1966385932
54.975
8

396.4919676141
32.828661269
54.52
9

456.2877384373
49.6481230729
68.399
15

432.5143669935
39.4290611656
57.94
8

476.7206458753
48.8086076459
50.869
8

496.0396506732
47.8876084455
63.714
6

493.3903821198
43.7272303533
55.027
5

419.7498283034
42.4028047172
60.333
13

500.2342312684
50.9283718781
61.664
9

519.0706378846
50.8072729808
64.227
6

467.8400159222
43.7000026537
63.64
6

480.9888718536
39.9969786423
66.007
5

496.37747115
50.641578525
61.528
10

427.1513732147
39.9473955358
55.467
9

472.3866942667
48.1747823778
50.338
8

445.807501324
40.906583554
63.368
7

529.4489974771
52.8619995795
68.277
9

427.8311595969
44.1926932661
58.675
13

441.1062785972
45.3230464329
54.168
11

489.9268080116
49.6421346686
57.074
8

423.8769483297
45.9034913883
52.456
12

423.6237309531
40.4201218255
54.103
11

442.3048418923
42.5984736487
63.714
11

472.6381136933
54.3806856155
62.354
15

379.0955200105
39.1510866684
60.189
14

474.8429762418
54.3533293736
61.723
13

400.7194357104
38.9947392851
53.751
13

477.6011899566
42.8793649928
66.325
7

403.3158446321
34.0228074387
52.179
7

461.700837385
40.8784728975
57.43
5

480.1768286261
50.2601381043
50.616
8

453.0300655428
49.3253442571
55.078
14

478.0256816111
42.7854469352
60.313
6

398.9652488713
42.4490414786
51.271
14

457.1494159235
50.6027359872
67.533
14

483.4363334374
55.4070555729
55.994
12

486.2939530951
44.0629921825
52.916
6

370.851438964
38.1420731607
51.999
15

405.9808525392
38.1719754232
70.949
12

437.2217073559
45.7352845593
61.81
12

451.3719343488
40.5894890581
54.835
5

451.1899334197
50.89915557
49.795
15

461.2608453011
48.0596408835
51.903
11

482.1830138882
49.531835648
59.992
10

432.4264623995
38.8924103999
65.072
8

514.3450944283
49.6426824047
66.489
5

416.7543827634
38.1695637939
68.737
12

454.580872109
51.3263120182
55.623
15

447.5880396763
38.0676732794
55.182
5

498.3487933412
51.0859655569
58.833
8

449.814686443
45.6317810738
63.024
10

479.0455544693
42.7977590782
54.259
6

423.4818154371
39.9414692395
63.833
11

412.1426444494
36.6411074082
61.296
9

425.3230037749
36.9745006292
52.476
6

460.2404760631
46.7007460105
68.036
10

478.3965686596
40.4150947766
60.906
5

512.7050302139
49.9815050356
57.816
7

506.3577401063
53.8054566844
59.525
10

425.3642908894
41.5358818149
68.149
11

492.3879050306
59.8521508384
54.275
14

523.8199278713
50.5939879785
67.256
8

467.6369845024
45.2064974171
66.398
10

413.6776967544
42.9941161257
64.713
14

444.4216102335
38.3892683723
55.086
5

461.7966543773
53.2279423962
54.429
13

504.4381171359
44.641852856
70.587
6

533.6265853819
55.935930897
69.011
10

425.6497289308
47.7874548218
53.925
15

447.2054101853
52.6335683642
53.404
15

455.2392377537
53.046372959
65.961
15

404.037651839
31.3747753065
54.789
7

467.8131462369
47.5645243728
52.426
10

470.1276946402
49.51578244
51.033
10

449.7165248751
45.1755874792
53.663
9

447.2107924601
50.1037987434
49.588
12

435.8961795015
40.2090299169
66.642
11

450.9909966373
46.4433327729
59.331
12

421.8467039188
35.7844506531
50.14
6

468.5864517872
44.8769086312
57.325
7

418.6925325381
42.3314220897
70.704
12

439.3146550066
33.6174425011
62.61
5

464.8225483872
45.9112580645
50.355
9

414.6686329003
46.4789388167
51.795
15

435.8472083564
47.0220347261
52.715
12

457.1433006935
40.9560501156
66.407
6

458.9141682594
42.5220280432
59.782
9

479.6872016736
48.5432002789
60.428
10

512.5798510705
47.5259751784
64.424
5

463.3355918448
52.0892653075
55.8
13

442.7725280951
50.6000880158
67.172
15

454.1913320483
42.0175553414
51.086
8

445.8711614613
47.8113602435
60.003
14

476.6797617904
46.7129602984
64.402
9

509.1485902181
55.1860983697
70.032
11

449.7843498332
49.7150583055
56.494
12

439.7286992614
45.1222832102
55.995
13

447.5955456619
48.1710909436
52.569
13

479.0418562111
55.9216427019
60.512
15

424.1577107837
45.9709517973
61.332
14

452.6748430811
41.8278071802
49.708
5

446.2972997905
37.5525499651
62.982
7

432.9893929739
44.2627321623
62.413
13

425.7505608763
41.8304268127
65.768
12

424.8970350698
37.5483391783
65.607
8

469.5451324078
48.554022068
59.221
9

423.7235763439
43.2374293906
59.299
14

369.4439512029
35.1813252005
68.356
15

442.5367815951
40.8837969325
51.234
7

512.308080809
55.1886801348
64.176
10

482.2746485314
53.5341080886
56.07
11

472.7297393989
40.2026232331
55.514
5

465.2472806874
43.5133801146
67.167
9

474.6769171533
47.9813195255
61.789
10

487.5959692449
48.8758282075
52.341
7

517.6538900974
51.4981483496
66.665
6

491.1074654101
45.8914109017
56.759
7

446.1241641662
41.360527361
66.961
10

474.093364936
55.8855608227
54.78
15

450.1016749661
42.167779161
64.095
8

449.3841443731
41.0753573955
49.932
5

430.218019339
40.6891698898
66.083
12

470.879442329
41.8644070548
67.693
7

435.1151862846
40.6451977141
68.244
10

420.135253392
40.6032088987
65.516
11

445.9559329017
49.4624888169
61.181
13

452.8227664146
50.6757944024
53.768
15

420.2913057227
32.5162176204
54.194
5

466.2945989111
52.8422664852
65.241
15

459.0844851968
50.4315808661
56.495
12

431.3004112323
44.4647352054
53.512
10

417.8790295095
44.0256715849
56.725
15

441.4679363315
43.2823227219
59.774
11

434.6765205158
49.429420086
55.1
15

461.2455873684
49.3077645614
54.399
11

473.3100828495
45.8440138082
62.246
7

439.1421717454
47.4188619576
60.629
15

469.229568334
51.7375947223
53.804
13

472.6090081958
47.1063346993
56.971
9

452.2349821023
50.3604970171
64.072
14

458.8086518595
52.3356086433
65.795
14

449.9397858676
40.0367976446
64.719
9

440.2493414462
45.025390241
56.097
12

417.3031798519
38.047696642
51.017
8

448.3612183578
49.3342030596
59.356
13

454.2643038313
51.6448839719
63.395
14

480.2428535303
50.9463089217
54.565
12

500.8637526095
54.4672921016
69.06
13

422.1831133757
42.4453522293
66.511
13

450.2898605212
43.9266434202
52.73
8

445.966772404
45.6877954007
61.84
10

451.2143641661
43.3413940277
64.166
11

496.6747015429
45.1401169238
62.834
6

416.4393847662
45.8282307944
57.47
15

406.9956043415
34.5896007236
50.458
6

438.5189621359
48.8384936893
64.488
14

428.9806966849
40.2984494475
51.19
10

501.830763354
43.8256272257
70.877
5

447.4278888847
43.6899814808
62.288
10

457.2901081441
47.6696846907
60.272
11

416.1933835735
34.1673972622
59.189
5

459.0636394486
38.8816065748
58.774
6

436.4194458934
41.1289076489
66.646
11

439.2728045186
49.0476340864
52.987
14

486.7455045263
48.1989174211
65.552
8

466.9040282658
45.0933380443
69.344
8

443.6872119862
35.8122019977
67.814
7

480.7993191076
47.5300531846
65.619
10

448.9369832165
43.4651638694
57.146
9

423.0552892066
43.3657148678
59.861
12

471.850127446
44.655021241
51.92
5

502.4507911012
48.4411318502
69.804
9

426.0831482017
47.4530247003
52.365
15

515.5813408726
59.9998901454
62.582
14

498.183751107
59.5084585178
63.133
15

457.5017520049
52.9457920008
60.827
14

507.5211548581
49.2211924764
67.194
9

501.9208528976
53.7149754829
49.631
10

412.5109656232
43.9231609372
66.972
15

476.8986106982
55.6342684497
66.093
15

402.164529275
34.8607548792
48
6

476.9366313379
44.2252718896
51.585
7

448.8873295893
45.3953882649
55.515
11

490.2612304158
45.5915384026
67.712
7

477.2890007566
56.2306667928
61.905
15

435.5037136178
49.510285603
68.442
15

457.6364447545
45.8197407924
63.718
12

464.3372692302
41.852378205
58.223
7

451.6673760739
49.0267293457
49.507
12

427.9289427552
40.6554904592
50.996
8

516.9114571924
52.6464095321
64.033
7

490.0823558667
49.0328926445
51.885
9

482.3098648358
42.557810806
58.963
5

475.8937064066
52.7792844011
68.218
14

504.0270846797
54.4286807799
66.455
11

433.6591080888
35.5711846815
68.232
5

403.6237989185
36.8377998197
55.597
11

419.9203810496
42.2562301749
59.383
13

415.0138413175
35.1209735529
56.288
7

425.5204989145
35.1614164858
66.552
6

423.7230904218
48.7925150703
59.968
15

414.5475112895
38.5742518816
54.102
11

531.0636192622
56.7894365437
52.327
9

444.4225400143
44.3725900024
55.187
10

428.9576557124
42.0871092854
49.435
9

462.2743585017
54.482726417
55.378
14

395.0007912301
40.1412985383
60.153
15

490.0360628865
54.6673438144
65.032
14

422.2640867287
45.1631811215
58.285
14

431.435315121
49.5575525202
56.09
15

455.6376174759
53.4206029126
64.114
15

489.8009097712
50.0656516285
60.407
11

446.8263264291
41.7845544048
50.119
8

402.9290552684
35.2423425447
53.475
8

465.1457868931
54.2184644822
62.835
15

436.5993426383
38.0838904397
55.096
5

390.4271139739
36.6336856623
50.625
12

497.050904989
45.6239841648
62.307
6

439.2056403419
39.307940057
54.358
7

492.3705221979
48.429087033
59.796
7

467.5738431258
56.2448071876
52.105
14

460.0843491057
39.3423915176
65.03
7

445.5181611713
44.1643601952
65.532
12

466.4252421365
44.4775403561
59.56
8

457.8702935916
48.3377155986
50.844
10

450.4706222629
52.6276037105
53.705
14

419.1195732938
39.9039288823
51.696
11

441.6711465101
42.561191085
58.304
10

470.183372102
47.4842286837
62.278
10

492.7797700017
47.5737950003
64.337
7

441.448681727
47.5824469545
67.954
13

458.8569906631
42.6524984439
59.942
9

474.0964243178
45.2875707196
55.371
8

483.3222121904
47.1652020317
52.331
7

429.5886513264
35.0804418877
63.106
5

491.7566579088
46.7449429848
60.287
5

447.9079804758
43.9908300793
62.963
12

487.6858799639
49.784479994
58.979
10

497.1448279982
57.358471333
53.994
13

480.8277552137
50.5339592023
66.624
11

478.1161548545
54.6628591424
62.139
13

434.5745403752
47.2357567292
57.16
15

389.9244510447
39.0837418408
50.422
13

430.1651254007
40.1188542335
64.452
10

455.2068130319
53.082802172
50.71
14

445.3204469116
46.2570744853
64.778
11

440.321575233
40.4397625388
52.683
9

467.0693239759
50.442553996
58.414
13

449.55544783
45.4690746383
70.741
12

393.4591927298
33.7145321216
50.172
7

456.7267343221
50.0097890537
51.668
11

455.5242342946
46.9720390491
61.692
13

474.182059197
46.2553431995
59.65
9

437.0019709249
46.1956618208
58.828
13

483.712174332
45.505195722
68.681
7

463.0884981453
44.7939163576
68.325
8

479.4908937429
42.3159822905
66.595
7

416.771119608
37.3076866013
53.925
9

499.000772233
46.9799620388
61.121
6

460.3496378199
46.4769396367
64.488
10

433.4672907815
38.5890484636
48.933
5

435.8826192903
44.291103215
50.136
12

499.8866337002
56.0532722834
67.567
14

393.2875350076
35.3665891679
58.088
10

454.065207553
41.8695345922
51.848
6

434.8780009331
50.7361668222
58.461
15

451.0329368465
38.7928228077
51.276
6

507.8604664868
46.4720777478
58.028
5

481.1461589923
53.3921931654
68.793
14

470.375529945
47.5959216575
52.8
8

472.640958536
44.640659756
61.797
6

421.6142086041
42.9235347673
59.073
14

494.7021538007
49.6511923001
50.795
8

489.5756153792
48.0682692299
62.166
8

485.9583932403
48.8472322067
57.875
8

386.675504129
38.3690840215
52.461
11

478.9159933045
53.4406655508
56.272
14

422.0910889318
35.981514822
61.202
8

451.3667323565
40.7116220594
58.097
7

432.1659170732
48.1233195122
57.426
14

493.2229089693
53.6146514949
60.535
10

399.2562310812
36.0070385135
54.214
11

438.9997776203
44.51179627
57.929
12

415.8979642158
33.3756607026
53.644
5

486.9370209153
58.8033368192
57.117
15

475.6029334994
54.4598222499
67.844
14

466.0203812665
39.2867302111
54.3
5

456.3625275478
39.2357545913
67.948
7

438.8811597402
43.43219329
61.288
11

433.7578739355
45.0449789893
53.488
11

458.5051077593
50.4686846265
69.693
13

513.2956125248
48.2106020875
65.032
7

420.1710396009
45.4573399335
56.427
15

457.115096145
43.0658493575
66.72
9

434.7043691967
40.1095615328
53.047
7

417.468441998
48.1960736663
55.292
15

487.7444360497
46.3659060083
65.549
9

449.6967492072
43.6871248679
51.574
9

462.7865808658
45.2297634776
60.408
9

424.0478390424
39.6676398404
51.042
8

516.5236210393
51.0484368399
66.233
6

400.4639964403
38.0689994067
53.05
12

425.9248315361
47.7144719227
48.638
15

481.6879413
50.2969902167
55.906
10

387.1161808239
38.8110301373
54.25
12

395.3993644959
43.342227416
56.346
14

482.0940940737
48.6450156789
53.224
10

440.2132533865
36.3768755644
51.952
5

469.1544404052
47.0315734009
55.965
9

413.6956196795
37.6626032799
60.72
9

458.5840162637
44.125836044
49.829
6

468.4459386614
50.5041564436
63.421
14

498.357171491
52.7765285818
60.698
11

415.8089901939
39.814331699
51.923
10

432.7029358155
36.7926559692
53.947
5

436.8412279551
37.3530379925
61.723
5

464.9683005762
48.7752167627
67.317
14

426.306143516
41.533190586
63.107
12

485.0008303876
47.2769717313
63.339
8

481.2872761626
46.0938793604
55.724
6

442.8592780864
46.4792130144
58.984
11

508.7752848159
47.1463808027
65.897
7

381.2974318037
38.1915719673
63.148
15

435.3681356617
36.3613559436
60.2
6

453.7700984147
52.3378497358
61.743
15

500.330409357
54.5210682262
63.204
10

500.6497247238
53.3911207873
69.303
13

470.6872825206
39.0718804201
65.256
5

538.406108144
53.9143513573
58.92
6

439.3936480424
48.1592746737
65.438
14

433.8567310914
51.5317885152
51.666
15

519.9624291231
48.5282381872
68.793
7

463.3937012327
48.7699502055
66.774
13

429.1388711442
39.120478524
63.416
9

473.9796541916
48.1737756986
49.937
8

437.9992671034
48.8222111839
57.066
13

464.4553923431
52.0798987239
56.976
15

449.8525352323
46.2220892054
49.52
11

462.4463059693
43.2992176616
62.651
8

533.9176759955
58.4002793326
67.516
10

478.714183899
48.2226973165
54.378
7

419.5927088502
42.8971181417
65.21
15

451.2410088531
43.3255014755
53.288
9

431.034054361
43.0341757268
57.829
11

435.7627878185
38.3972979697
54.379
6

400.4678321574
34.4636386929
49.686
6

420.2678020851
44.8636336808
57.086
15

517.0847337096
52.7371222849
55.662
8

446.2351408915
43.6390234819
59.401
10

465.8444998074
54.3980833012
61.456
15

461.7773687091
52.6410614515
58.931
13

390.1167159369
36.7342859895
56.711
13

476.0673481722
55.1542246954
55.142
15

436.8606074963
42.141767916
70.01
11

398.167298933
41.0138831555
59.084
13

490.7114733886
47.1667455648
62.711
6

463.2738696339
49.542644939
54.018
13

496.4705739434
57.6339289906
61.667
15

510.3263832833
49.2613972139
49.758
5

460.2881200377
42.0228533396
58.151
6

448.3999283973
52.5618213996
55.029
14

444.476619654
47.2937699423
65.714
15

452.4901571924
41.8663595321
62.292
9

425.0925755223
48.0645959204
52.705
15

482.8411146757
46.5226857793
62.705
7

437.3103017814
45.7195502969
57.993
11

458.5446895312
48.1244482552
65.798
14

418.6242291501
41.8375381917
55.599
12

499.3497523408
55.8791253901
65.075
13

453.1763217453
50.1475536242
57.291
13

441.0950819351
53.3461803225
49.018
15

452.005383132
40.771730522
56.375
8

478.6566774922
40.4174462487
65.152
5

447.1959652652
45.2518275442
67.685
12

436.0771727808
48.9745287968
66.23
15

425.2453291068
47.1440548511
63.381
14

461.3006454293
43.7424409049
61.846
10

466.6257836396
50.0121306066
68.553
14

445.3896188235
50.2019364706
61.178
15

453.8388360937
41.801139349
60.032
7

525.133245363
61.8947075605
65.765
13

467.8652269677
46.0027044946
57.849
10

477.1037035064
48.3149505844
58.214
10

484.686418439
48.5137364065
52.604
8

552.2209092546
54.3898182091
67.882
5

463.1975835887
54.6077639314
56.551
14

438.5477758462
43.3087959744
57.695
12

466.1115371584
39.4824228597
67.217
6

420.0629021798
34.6369836966
58.241
6

425.8801720225
45.6995286704
50.683
12

487.2679300197
59.1651550033
59.277
15

455.641703127
43.7506171878
57.138
10

445.2113816972
41.9800636162
64.331
10

429.1804270682
44.943571178
66.519
14

448.9037273084
45.5151212181
65.813
11

468.7472360268
54.0913726711
58.199
13

463.0551774128
45.2658629021
56.46
10

518.2017570318
51.3697928386
54.983
7

407.3136190181
33.5851031697
49.803
6

492.4922504139
45.7627084023
68.916
6

417.2423895176
43.6170649196
50.54
11

530.1302501474
58.6763750246
58.072
12

465.5288637368
42.4761439561
66.672
8

501.6441851504
52.8316975251
69.654
11

470.7091416014
45.0608569336
65.344
8

415.7122579796
41.3265429966
55.753
10

446.8181049016
48.7758508169
59.163
15

400.8708517345
40.0019752891
53.859
13

496.1840865634
57.3848477606
59.875
14

486.9697669258
55.2802944876
63.288
13

433.3914616844
41.2862436141
58.674
8

485.3422175124
51.5455362521
63.069
13

459.0788962392
41.2596493732
65.521
8

412.3716375934
36.1952729322
56.2
8

485.4558278407
44.0419713068
62.204
5

481.9459360042
58.0598226674
61.587
15

459.2644680425
37.2344113404
69.858
6

451.7500691663
40.7760115277
62.094
8

453.1597221878
43.889953698
56.82
9

478.0667797779
53.2872966297
64.343
13

475.0669367256
52.4919894543
65.115
12

436.2644590372
37.2899098395
59.525
8

421.5600312147
40.3735052024
57.319
11

453.1553054815
51.0600509136
64.795
15

506.1839696546
49.4446616091
52.516
5

408.491223535
45.4140372558
55.007
14

379.0122458821
35.7550409803
52.482
13

438.6646534919
46.8606089153
52.501
13

493.9054452089
46.0204075348
60.783
6

442.2443451022
41.687557517
58.119
8

474.6866959881
51.6627826647
70.71
12

469.7877838082
46.929463968
61.211
11

431.3574025553
44.6792337592
48.282
12

453.6634829308
41.0944138218
59.097
7

432.41820343
38.8228672383
58.481
7

415.3706571689
48.2396095281
52.933
15

457.146846205
42.4528077008
58.43
9

407.4723731055
41.6483955176
69.582
15

408.6557097783
40.1396182964
52.818
11

423.3088644328
34.7324774055
63.914
6

417.3894745442
43.6660790907
59.393
12

490.382064403
50.0501774005
63.081
11

490.4289526045
49.9714921008
59.6
10

455.6187556371
51.3622926062
55.445
14

452.1072574565
50.3973762428
65.723
14

462.4073430414
42.5868905069
63.886
6

443.7602147348
44.2030357891
49.542
11

425.8461623614
43.1648603936
60.857
13

490.8333751676
45.2817291946
64.143
6

414.0434095166
45.5119015861
61.972
15

474.5695103975
47.2364183996
63.151
8

444.458138047
43.0358563412
52.243
10

413.9760483042
42.796341384
52.198
13

445.38588123
39.0398135383
62.147
7

464.7478408764
49.7254734794
64.395
12

477.6510184765
51.3150030794
50.761
9

464.7064245316
40.9792374219
57.831
7

462.3275900229
42.7602650038
67.766
9

494.0764548009
47.1149091335
57.387
6

449.4026154789
39.2889359131
64.669
6

446.5583253501
46.408054225
55.11
10

435.4883806993
46.8443967832
58.422
15

474.0224729544
51.2769121591
53.361
12

463.393465723
44.8380776205
61.365
9

500.0436272936
52.6452712156
50.172
8

454.7707944077
40.0877990679
64.244
5

456.5654413793
40.8342402299
68.56
9

459.7183386609
51.8393897768
57.682
15

415.0376277921
37.678604632
64.966
10

540.2407389348
55.3951231558
66.87
7

449.9311639145
52.1763606524
63.873
15

474.3003876995
43.5705646166
68.877
9

440.5475107732
35.8504184622
57.445
5

358.6127858756
29.2129643126
60.335
10

429.534358743
43.0870597905
52.012
10

479.7212268364
49.5990378061
62.127
9

480.7078868636
52.1853144773
64.596
14

433.7148909342
47.5838151557
49.212
14

475.5668779344
41.0956463224
64.993
5

471.023914301
40.9908190502
69.079
5

405.4957203775
37.0332867296
56.296
8

458.3863035877
46.8602172646
48.225
11

437.6742282241
38.9660380373
57.878
8

454.0114262009
40.1394043668
66.175
7

472.0935580772
53.3247596795
65.145
14

460.2482949953
40.8387158326
63.216
5

449.3773433306
46.3512238884
69.27
14

495.9253063186
46.3848843864
56.616
6

479.4197536245
46.6927922708
58.263
8

464.2639431116
48.6028238519
62.647
11

474.5770255619
46.947170927
57.894
7

485.9691751649
40.1726958608
67.933
5

497.1383334213
52.4572222369
52.395
10

519.7203104314
58.9578850719
67.973
13

493.9845797813
47.7250966302
66.634
7

491.4220575228
52.0238429205
66.279
10

465.1237851783
38.0579641964
68.776
6

498.6215462176
46.2229243696
68.284
7

420.1096469553
44.8921078259
49.757
13

456.9569178478
39.8046529746
60.129
5

478.0885826112
45.6060971019
70.452
7

465.0318896369
47.1389816062
63.198
12

493.8503743108
46.5315623851
51.661
6

438.8625835025
46.4127639171
60.386
13

435.0177517223
45.1307919537
55.233
11

447.917939103
42.6844898505
54.811
7

510.0965582904
47.8877597151
54.77
6

483.7043265811
41.2073877635
68.46
5

460.6265600765
43.6209266794
51.901
7

395.0880627829
37.4566771305
51.348
10

409.3529667466
39.0916611244
54.803
9

469.3509513123
47.465658552
65.557
12

440.9797524782
41.8042920797
51.154
9

438.9136933846
42.6211155641
59.187
10

507.8835878888
63.2347646481
52.475
15

463.5066043907
47.3146007318
68.619
10

551.11795858
65.8944930967
50.751
14

471.1016800413
41.0596133402
62.744
6

450.7760782751
45.9573463792
52.032
10

428.2926489107
44.8199414851
56.373
12

477.095840497
50.5676400828
53.69
9

509.5205625052
53.1699270842
56.501
10

435.2206595441
46.337109924
52.198
13

421.1880673081
46.5466778847
56.908
15

407.496644986
35.0586074977
55.145
7

447.8267206034
50.7419534339
56.375
13

471.9565737066
51.1804289511
51.874
13

388.5864757644
37.0714126274
52.158
12

428.9449902539
38.106331709
70.307
9

472.0445913117
56.4974318853
56.06
15

467.0175866649
46.9945977775
64.05
9

446.6214664724
48.1234110787
61.881
15

453.7931671645
49.0858611941
62.278
14

398.0317949064
41.4049658177
48.602
13

469.531192124
42.6101986873
63.87
6

467.3206041706
51.8184340284
70.41
13

414.9108616675
40.2678102779
54.304
12

464.0629827851
53.1798304642
53.984
15

490.4686415946
53.2247735991
55.12
11

471.9154683748
54.4639113958
60.132
14

430.4175919757
45.185431996
54.305
11

457.4407620016
42.3422936669
51.387
8

418.0976926794
42.3477821132
52.011
12

507.7838764082
55.291646068
69.034
12

464.9999266799
46.3913211133
59.652
9

451.7720818229
41.2093469705
52.516
5

472.9665089221
47.3370848203
61.944
11

452.4772809415
38.9658801569
63.682
7

400.566840927
36.3569734878
50.425
9

501.7173465351
49.6345577559
55.91
6

521.8616399008
53.7924399835
56.107
6

469.6710597836
38.1198432973
63.952
5

472.238451784
46.6094086307
62.582
10

457.717049932
39.4696749887
57.899
5

445.8619449679
48.8466574947
57.782
13

491.4456651145
52.2782775191
57.776
9

390.8850068465
31.9613344744
57.117
9

499.1107158392
47.5957859732
52.536
6

451.6365427387
45.8357571231
67.622
12

472.9502724946
43.3928787491
62.593
6

474.2910387759
51.4636731293
62.509
11

432.4047074429
41.0311179071
49.218
10

468.4794666588
40.5699111098
55.06
5

457.5768725625
49.6813120937
53.489
12

454.6420627775
40.9098437963
60.183
6

477.9589891608
49.3361648601
60.942
9

470.4769239384
46.9929873231
68.519
12

450.0530240772
40.8171706795
68.15
9

463.5599539644
49.9483256607
54.87
12

492.1247901647
53.6801316941
68.044
12

538.9847909271
63.8706318212
53.761
11

443.5583802673
38.1093967112
63.902
8

402.8097585792
39.4592930965
51.054
12

478.3792253746
43.5730375624
52.941
5

454.7600290932
51.3496715155
61.662
14

468.0569919712
45.8614986619
63.888
8

465.5400963294
40.0343493882
49.334
5

452.4789588321
37.2129931387
69.201
6

439.0254290419
46.3687381737
53.813
12

429.1985547054
46.8602591176
61.037
14

456.0070475614
40.7366745936
67.587
6

483.3489472636
52.6169912106
64.647
14

457.3726981413
38.0029496902
66.355
6

450.9975188086
41.4137531348
62.515
8

438.8371409242
43.447190154
54.154
9

486.5645896489
48.3092649415
69.709
8

415.9529343693
31.5409890615
49.707
5

490.5805417823
44.1750902971
63.53
6

415.0931376036
39.9215229339
68.564
12

427.1596159062
35.3067693177
64.319
6

451.2678070235
42.6948011706
59.099
7

403.82074929
35.3426248817
57.765
10

453.4821718945
47.8606953158
61.318
13

483.7702721924
53.5567120321
61.43
13

457.4128105429
42.3921350905
53.06
6

491.7160476691
53.1760079449
69.66
11

475.8312749286
47.9595458214
51.074
10

379.3579402548
37.9593233758
53.602
14

443.4023222747
46.3318870458
51.411
11

501.1727683669
46.0781280612
67.704
5

462.3002528382
47.1507088064
66.396
10

488.0517868282
41.142631138
65.196
5

410.8007088973
38.9772848162
55.937
11

429.4161065738
38.4650177623
65.626
9

443.0252964225
51.8952160704
53.654
15

461.9771017895
48.6561836316
52.04
9

458.1958110904
39.5544685151
53.869
6

475.3083236531
42.5455539422
49.035
5

455.154825459
42.6824709098
51.06
7

412.7651919117
45.2410319853
64.319
15

436.3873231693
42.2722205282
53.754
8

460.0330187777
44.1401697963
59.192
10

399.3418215264
34.0118035877
51.271
8

463.8077537482
45.7837922914
66.105
10

485.5389024878
44.468483748
67.728
6

491.6658495894
53.1796415982
60.588
10

486.6756890676
54.2451148446
66.205
15

466.8635321761
39.949588696
64.166
6

476.9109814063
54.0733302344
68.471
15

513.0795618429
48.3347603071
67.071
5

384.2364080814
33.8477346802
54.15
8

426.1060629213
45.0441771535
58.841
15

489.2308934089
52.3824822348
68.936
13

469.3763493242
51.552891554
61.059
13

498.6675180298
49.4575863383
50.922
6

468.314591622
48.0792652703
67.839
10

412.9906829384
33.0051138231
56.96
7

392.9653971139
31.4015661856
59.556
8

483.881395046
43.4878991743
65.954
6

525.811531959
53.0917553265
57.261
6

432.6232366939
47.7463727823
67.145
14

424.7441778923
32.6971963154
67.561
7

428.3457970641
44.451132844
63.639
14

494.7143884843
47.117231414
66.011
7

509.0300945465
52.6260157578
68.274
9

493.8897464538
52.3529577423
66.772
10

489.8280152952
50.3556692159
51.694
10

447.962715744
47.073452624
68.522
14

428.4733757962
39.5610626327
58.107
9

443.5670939423
42.9428489904
51.91
8

409.1124670329
37.2097445055
59.854
8

430.4545594472
34.9165932412
53.955
6

485.2461944405
49.4535324068
65.525
11

381.0654603975
37.0165767329
50.966
12

447.8292135928
42.2133689321
61.549
8

424.3206674939
47.3297779156
67.342
15

450.1010828589
43.6925138098
51.946
10

445.08088063
45.267980105
53.473
11

421.858719136
38.7429531893
58.401
9

508.7386930642
57.374948844
61.489
12

420.4220256862
49.5818376144
50.931
15

473.8323789624
52.4388964937
64.199
15

454.5177441044
49.9186240174
48.006
13

460.7002107604
46.6772017934
64.637
11

486.4509135731
58.8306522622
57.467
15

488.8071818806
56.9211969801
68.28
14

444.1857819612
46.1229636602
62.448
14

487.9175703753
45.6130950625
60.239
7

473.7654627122
43.262910452
59.188
6

476.353673349
51.1084455582
58.703
11

363.6658049537
38.005134159
55.635
14

462.5951588566
46.4728598094
65.758
12

431.2797375054
37.5392895842
53.044
7

456.8017287715
38.6829547952
59.704
5

436.8611276297
40.2500212716
61.361
8

384.3332808328
39.3157134721
69.439
14

447.4804731899
36.4052455316
60.049
6

451.6573333813
49.3707222302
57.433
14

451.8397884242
46.125131404
61.089
11

412.6972659957
46.7107109993
55.433
15

418.0526103427
37.6389350571
63.219
8

447.0805893517
46.7564315586
54.542
13

475.9910397191
47.1321732865
56.198
9

400.1346729807
30.2374454968
53.71
5

463.0453602383
40.7247267064
60.697
5

397.5310719114
43.4045119852
67.104
15

482.1275685925
53.5965947654
65.548
15

407.1919537414
41.1179922902
53.484
13

468.6788359473
41.3238059912
64.736
6

478.0117437704
46.9106239617
55.548
7

421.2605085761
43.4577514294
55.514
11

466.3953896326
48.0865649388
57.876
12

399.029119337
41.9358532228
51.414
14

493.7764365722
47.6974060954
52.592
6

452.1587392857
51.141789881
58.308
14

437.4061126874
48.6656854479
65.412
14

476.9186869111
46.9782811519
68.049
11

454.5622795197
36.8415465866
62.513
5

472.1988970409
45.5131495068
51.12
7

449.5142028528
48.3605338088
51.351
11

404.9266095295
43.2526015882
50.411
12

438.1128059482
35.0681343247
58.704
6

470.0162384558
46.3550397426
53.886
9

408.1864725349
36.4835787558
58.285
9

498.2949243392
50.7441540565
66.83
9

453.4968303458
49.4908050576
68.552
13

438.2058705516
45.6023117586
62.592
14

422.2490681424
43.2781780237
65.58
14

357.4821170556
35.6648528426
50.493
14

455.4646396593
49.0882732765
66.935
13

439.4248483252
45.5988080542
54.832
10

412.4238954515
33.2741492419
59.779
8

457.2148815134
44.2443135856
53.749
9

434.3319176546
41.3668196091
56.131
9

472.9584024797
44.9272337466
54.395
6

Sheet2

Sheet3