It is Excel work· What portion of the sample is unionized in each region? Calculate the rate of...

Question

It is Excel work· What portion of the sample is unionized in each region?  Calculate the rate of unionization for workers in the northeast, midwest, south, and west.  · To get the portion of workers in the northeast, midwest, south, and west who are unionized, first create new union dummy variables for each region and then calculate the sample average for each new variable.  The sample average will be the rate of unionization for the region. · The union dummy variable is in column B and the northeast dummy variable is in column N, so the new union variable for workers in the northeast is calculated as (type—or cut and paste—this command in each row of a new column)                                                                               =if(N2=1,B2,false). · The union dummy variable is in column B, the northeast dummy variable is in column N, the south dummy variable is in column O, and the west dummy variable is in column P, (midwest is the excluded category) so the new union variable for workers in the midwest is calculated as                                                           =if(N2=0,if(O2=0,if(P2=0,B2,false))),                                                   for workers in the south is calculated as                                                                      =if(O2=1,B2,false),                                                  and for workers in the west is calculated as                                                                     =if(P2=1,B2,false). Here are the answers using the data with the black and Hispanic oversamples: 	Variable  	Average 	Minimum 	Maximum 	 	 	 	 	NortheastUnion 	0.329 	0.000 	1.000 	MidwestUnion 	0.226 	0.000 	1.000 	SouthUnion 	0.115 	0.000 	1.000 	WestUnion 	0.255 	0.000 	1.000   my work 	wage	union	hours	male	black	hispanic	age	grade	marry	kids	exp	tenure	nonwage	nthest	south	west	urban	afqt	agriculture	mining	utilities	construction	manufacturing	trade	transportation	information	finance	realestate	professional	management	education	healthcare	entertainment	food	other	government	military		Northeast 	19.1	0	30	0	0	0	55	12	1	3	21.653846154	8.1538461538	79	0	0	1	1	7.3316585987	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0 	56.25	0	40	1	0	0	56	16	1	3	36.057692308	23.769230769	90	0	0	0	1	58.976203155	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	24.03	0	40	0	0	0	58	14	1	3	36.076923077	11.288461538	47	1	0	0	1	-6.117365578	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0 	40.69	0	40	0	0	0	53	19	0	0	32.557692308	0.2115384615	72.5	1	0	0	1	54.659955497	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0 	37.95	1	38	1	0	0	59	13	0	0	37.653846154	12.538461538	73	1	0	0	1	40.331658599	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0 	65.93	0	35	1	0	0	58	13	0	3	38.173076923	30.423076923	90	0	0	1	1	49.882634422	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	61.05	0	40	0	0	0	57	17	1	1	36.384615385	26.173076923	90	1	0	0	1	9.8935296296	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0 	30	0	32	0	0	0	57	14	1	2	37.826923077	37.807692308	90	1	0	0	0	15.89352963	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	90	0	20	0	0	0	56	16	1	2	21.403846154	9.7307692308	90	1	0	0	1	44.976203155	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0 	12	0	43	1	0	1	53	12	1	2	31.769230769	1.5576923077	68	0	0	1	1	-3.862044503	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0 	25.71	1	35	0	0	0	58	12	1	1	31.673076923	19.384615385	90	1	0	0	1	10.882634422	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	62.5	0	40	0	0	0	54	12	1	0	35.769230769	30.519230769	90	1	0	0	1	-19.30447973	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0 	23.07	0	50	1	0	0	57	12	1	1	38.019230769	10.942307692	88	0	1	0	1	-14.11736558	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	18.07	0	40	1	0	0	57	14	1	2	27.961538462	2.9423076923	90	1	0	0	0	-6.10647037	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0 	65.38	0	50	1	0	0	54	15	1	2	36.596153846	29.288461538	90	1	0	0	1	8.6955202658	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	20	1	40	1	0	0	53	12	1	2	31.673076923	12.634615385	90	1	0	0	1	-13.3400445	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	21	0	40	0	0	0	55	12	1	2	19.923076923	11.884615385	90	1	0	0	0	3.1556929293	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0 	34.96	1	55	1	0	0	57	12	1	0	37.153846154	13.346153846	90	1	0	0	0	28.882634422	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	36.84	1	35	0	0	0	58	12	1	5	36.403846154	11.519230769	90	1	0	0	1	37.882634422	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0 	80.12	0	60	1	0	0	58	14	0	2	38.961538462	18.173076923	90	0	1	0	1	39.882634422	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	27.02	1	37	1	0	0	58	10	1	1	38.038461538	7.8461538462	42	1	0	0	1	2.6546344221	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	14.42	0	2	0	0	0	58	12	0	3	32.076923077	2.0769230769	52	1	0	0	1	-11.11736558	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0 	40.1	0	45	0	0	0	60	17	1	3	39.038461538	39.288461538	90	1	0	0	1	52.331658599	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0 	28.64	0	47	0	0	0	52	16	0	3	35.307692308	9.1153846154	65	1	0	0	1	-0.664951318	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	59.61	0	50	1	0	0	56	16	1	1	36.25	14.25	90	1	0	0	1	50.89352963	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	53.41	0	45	1	0	0	52	18	1	2	33.442307692	6.1153846154	90	1	0	0	1	41.335048682	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0 	24	0	38	0	0	0	57	16	0	0	35.923076923	7	44.5	1	0	0	1	46.89352963	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	89.74	0	60	1	0	0	53	18	1	2	27.538461538	7.3269230769	90	1	0	0	1	30.659955497	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0 	52.44	0	55	0	0	0	55	16	1	2	35.288461538	8.1153846154	90	1	0	0	1	28.695520266	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0 	48.07	0	60	0	0	0	52	16	0	0	32.692307692	13.75	90	1	0	0	1	29.335048682	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0 	11.69	0	37	1	0	0	53	19	0	0	28.615384615	23.769230769	24	0	0	1	1	26.659955497	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	35.33	0	40	1	0	0	52	19	1	1	21.884615385	0.7884615385	90	0	0	1	1	-9.664951318	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	12	0	40	0	1	0	56	9	0	1	25.634615385	16.057692308	24	1	0	0	1	-39.02379685	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	16.82	0	40	1	1	0	59	16	0	2	31.884615385	10.153846154	35	1	0	0	1	38.906365	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	35.09	0	40	0	1	0	58	16	1	1	38.211538462	17.730769231	90	1	0	0	1	39.89352963	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0 	62.98	0	40	1	0	0	58	16	1	1	36.826923077	6.1538461538	90	1	0	0	1	24.882634422	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0 	26.45	1	39	0	0	0	54	12	0	2	33.673076923	25.423076923	42.5	1	0	0	1	-3.304479734	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	33.65	0	40	1	0	0	52	12	0	3	32.442307692	2.1346153846	62	0	0	0	1	-15.66495132	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	15.38	0	40	0	0	0	56	12	0	3	34.788461538	1.8269230769	32	0	0	0	0	-13.02379685	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	30.28	1	40	0	0	0	55	12	1	3	34.884615385	2.0192307692	90	1	0	0	1	-2.844307071	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0 	15.73	0	40	0	0	0	58	14	1	2	34.75	0.8076923077	90	1	0	0	1	10.882634422	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	25.5	1	38	0	0	0	59	14	0	2	37.865384615	9.0576923077	44.5	1	0	0	1	8.1036585987	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	50	1	40	0	0	0	53	12	0	3	32.538461538	28.384615385	90	1	0	0	1	1.6599554974	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0 	43.26	0	40	1	0	0	58	18	0	2	37.461538462	3.3653846154	90	1	0	0	0	15.882634422	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0 	62.98	0	40	1	0	0	55	16	1	0	36.615384615	24.192307692	90	1	0	0	1	57.976203155	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0 	100	0	8	1	0	0	54	16	1	0	38.384615385	1.9230769231	90	1	0	0	0	30.695520266	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0 	50.96	0	40	1	0	0	59	13	1	2	38.173076923	9.8076923077	90	1	0	0	1	25.906365	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0 	19.23	0	50	0	0	0	57	12	1	3	28.923076923	22.423076923	90	1	0	0	1	-11.10647037	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	13	0	40	0	0	0	56	16	1	4	36.730769231	10.942307692	90	1	0	0	1	18.976203155	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0 	21.15	1	40	1	0	0	57	15	1	3	37.115384615	7.3269230769	90	1	0	0	0	47.89352963	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	31	0	40	0	0	0	52	17	0	1	35.653846154	18.576923077	80	1	0	0	1	50.335048682	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0 	31.25	0	40	1	0	0	55	12	1	3	31.903846154	1.7692307692	90	1	0	0	1	24.155692929	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0 	29.02	0	53	1	0	0	58	14	1	2	36.057692308	5.6346153846	90	1	0	0	1	22.882634422	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	60	0	40	0	0	0	58	12	1	2	38.211538462	3.3076923077	90	1	0	0	1	39.882634422	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0 	47.2	0	55	1	0	0	56	16	0	0	36.788461538	34.153846154	90	1	0	0	1	32.976203155	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0 	12	0	24	0	0	0	54	12	1	1	37.634615385	4.3461538462	60	1	0	0	1	12.695520266	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	41	0	40	1	0	0	52	16	1	1	35.442307692	23.230769231	90	1	0	0	0	1.3350486815	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	84.85	0	45	0	0	0	55	16	1	2	37.115384615	16.307692308	90	1	0	0	1	50.155692929	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	16	0	25	0	0	0	54	16	1	3	34.75	3.9423076923	90	1	0	0	1	42.695520266	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	30.69	1	52	0	0	0	58	17	1	1	36.5	36.538461538	90	1	0	0	1	15.882634422	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	28.66	0	48	0	0	0	54	18	1	0	28	18	90	1	0	0	1	34.695520266	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	15.84	0	40	0	0	0	52	12	1	3	21.980769231	8.6346153846	38.64	1	0	0	1	-2.664951318	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	52.88	0	40	1	0	0	52	12	0	2	29.173076923	3.0384615385	90	0	1	0	1	40.659955497	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0 	20	0	15	0	0	0	55	14	1	2	31.980769231	9	90	1	0	0	1	-6.844307071	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	18.83	0	49	1	0	0	53	12	0	0	37.865384615	13.269230769	48	1	0	0	1	30.659955497	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	74.12	0	40	0	0	0	52	12	1	2	37.096153846	2.5	90	1	0	0	1	-3.340044503	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0 	40.25	0	40	0	0	0	55	12	1	0	37.326923077	1.5961538462	89.594	0	0	1	1	55.155692929	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	38.46	1	40	0	0	0	58	17	1	2	39.153846154	9.4615384615	90	1	0	0	1	36.882634422	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0 	41	1	40	0	0	0	56	14	1	1	38.576923077	35.115384615	90	1	0	0	1	44.976203155	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0 	29.32	1	40	0	0	0	56	12	0	2	35.384615385	2.5769230769	65.4	1	0	0	1	-9.844307071	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0 	8.3	0	35	1	1	0	55	16	0	2	7.2692307692	1.5961538462	28	1	0	0	1	-22.84430707	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	52.56	0	45	1	0	0	55	16	1	2	36.673076923	21.076923077	90	0	0	1	1	46.155692929	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	15.86	0	40	0	0	1	56	13	1	2	37.538461538	1.6730769231	59.4	0	1	0	0	7.9762031546	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0 	10	0	10	0	0	0	58	12	1	2	36.384615385	0.5192307692	59.136	1	0	0	1	-6.117365578	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	23.25	0	50	1	0	0	58	12	1	2	35.865384615	1.6153846154	60	0	1	0	1	8.1036585987	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	9.13	0	40	0	0	0	55	16	1	1	27.461538462	0.3653846154	28.6	0	1	0	1	19.976203155	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	54.8	0	60	0	0	0	58	18	0	1	35.538461538	10.230769231	90	1	0	0	1	42.89352963	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	9.79	0	37	0	0	0	58	10	0	1	31.538461538	11.096153846	18	0	1	0	1	-31.11736558	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	62.5	0	40	1	0	0	58	16	1	0	37.480769231	10.519230769	90	0	1	0	0	5.8826344221	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0 	57.69	0	50	0	0	0	55	18	0	1	28.576923077	3.1153846154	90	1	0	0	1	20.155692929	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	86.53	0	50	1	0	0	53	19	1	2	30.865384615	2.0576923077	90	1	0	0	1	40.659955497	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0 	35	0	40	0	0	0	53	16	1	3	28.961538462	7.0384615385	90	1	0	0	1	31.659955497	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0 	55.28	0	40	1	0	0	58	16	1	1	37.730769231	1.3076923077	90	1	0	0	1	4.906365	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0 	100	0	40	1	0	0	57	18	1	3	36.288461538	6.6730769231	90	0	0	1	1	49.89352963	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0 	11	0	40	0	0	0	54	12	0	2	26.326923077	2.5769230769	16.5	0	1	0	1	-18.30447973	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	18	0	50	0	0	0	58	12	1	2	30.903846154	12.365384615	90	1	0	0	1	-24.11736558	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0 	4.8	0	20	1	0	0	59	16	1	2	35.288461538	9.7692307692	90	1	0	0	0	48.906365	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0 	32.05	1	45	1	0	0	54	16	1	2	33.807692308	14.923076923	90	1	0	0	1	6.3316585987	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0 	14.77	1	29	0	0	0	52	16	1	4	19.923076923	5.3653846154	90	1	0	0	1	25.659955497	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	21.15	0	50	1	0	0	56	12	1	2	38.980769231	4.9230769231	90	1	0	0	1	15.155692929	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0 	48.95	0	55	1	0	0	52	15	1	0	36.615384615	4.5769230769	90	1	0	0	1	21.335048682	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	100	0	50	1	0	0	59	16	1	2	37.076923077	1.9230769231	90	1	0	0	1	34.906365	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0 	69.71	0	40	0	0	0	56	20	0	0	38.384615385	19.903846154	90	1	0	0	1	50.155692929	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0 	28.5	1	46	1	1	0	54	12	0	11	36.884615385	31.519230769	90	1	0	0	1	-33.30447973	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	10	1	25	0	1	0	56	12	0	3	26.711538462	26.615384615	15	1	0	0	1	-26.02379685	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	10.22	1	60	0	1	0	59	12	0	4	18.019230769	10.25	35.843	1	0	0	1	-42.093635	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0 	27.17	0	46	1	0	0	52	15	0	0	31.653846154	27.826923077	81.2	1	0	0	0	-2.664951318	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0 	38.46	0	40	0	0	0	59	12	1	2	32.865384615	18.134615385	75	1	0	0	1	-7.093635	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0 	28	0	40	1	0	0	55	14	0	3	35.942307692	8.5192307692	47.01	1	0	0	0	12.155692929	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	22.47	1	40	1	0	0	52	12	1	2	35.346153846	25.461538462	51.8	1	0	0	1	-11.66495132	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	14.37	0	40	1	0	0	55	12	1	2	32.019230769	14.538461538	90	1	0	0	0	-7.844307071	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	22.44	0	45	0	0	0	55	13	1	3	34.519230769	5.1153846154	90	1	0	0	0	30.155692929	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	22.59	0	40	0	0	0	54	12	1	2	35.480769231	18.673076923	90	1	0	0	0	9.6955202658	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0 	74.03	0	40	0	0	0	58	12	1	1	37.942307692	9.3653846154	90	0	0	1	1	-17.11736558	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0 	100	0	40	1	0	0	58	12	1	2	39.269230769	13.903846154	90	0	1	0	1	21.882634422	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	28.98	0	30	0	0	0	54	14	1	3	34.519230769	2.9423076923	54	1	0	0	0	52.695520266	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	40.86	0	40	1	0	0	58	20	0	2	38.538461538	1.8269230769	85	0	1	0	1	13.882634422	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0 	14.7	0	48	1	0	0	54	12	1	0	9.7307692308	0.5192307692	90	1	0	0	1	15.467520266	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	13.6	1	40	1	0	0	52	11	1	0	24.403846154	10.519230769	48	1	0	0	1	-13.66495132	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	17.44	0	40	0	0	0	55	12	0	5	34.461538462	14.153846154	37.04	1	0	0	0	59.155692929	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0 	11.53	0	40	0	0	0	54	12	1	5	26.653846154	3.8076923077	90	1	0	0	1	15.695520266	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0 	7.69	0	15	1	0	0	52	12	0	1	36.865384615	3.2884615385	17.897	0	1	0	1	18.335048682	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0 	15	0	40	1	0	0	58	12	0	4	38.230769231	0.4423076923	53.094	1	0	0	0	16.882634422	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	36.75	0	45	1	0	0	55	16	1	2	38.769230769	1.5384615385	90	1	0	0	1	48.976203155	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	96.15	0	50	1	0	0	57	16	1	4	37.980769231	13.730769231	90	1	0	0	1	29.89352963	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0 	16.02	0	60	1	0	0	57	15	1	2	36.307692308	5.7692307692	74	0	1	0	1	31.89352963	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0 	15.11	0	40	1	0	0	56	13	0	5	28.942307692	0.1153846154	32.134	1	0	0	1	46.976203155	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0 	19.08	0	65	0	0	0	53	14	0	2	30.269230769	3.8653846154	24	0	1	0	1	19.659955497	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0 	40.59	0	45	1	0	0	55	18	1	3	36.711538462	0.7307692308	90	1	0	0	1	44.155692929	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0 	18	0	40	0	0	0	53	16	0	2	29.326923077	0.5384615385	45	1	0	0	1	43.659955497	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0 	41.58	1	40	1	0	1	58	12	0	3	35.903846154	31.423076923	88	1	0	0	1	-23.11736558	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0 	35	1	54	1	0	1	56	12	1	0	34.673076923	22.711538462	90	0	1	0	1	-2.10647037	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	20	0	50	0	0	1	55	12	1	3	36.423076923	10.826923077	90	0	1	0	1	-20.84430707	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	26.92	0	50	0	0	1	52	16	0	0	32.384615385	3.1346153846	70	1	0	0	1	12.335048682	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	5.62	0	20	0	0	1	56	10	1	2	23.423076923	3.0576923077	51	1	0	0	1	-32.02379685	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	29.82	0	53	0	0	0	59	20	0	2	32.557692308	19.230769231	90	1	0	0	1	46.906365	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	20.16	0	41	0	0	0	57	13	1	2	36.769230769	0.25	90	0	1	0	0	42.89352963	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	18	0	40	0	0	0	55	12	1	3	20.730769231	15.403846154	90	1	0	0	1	5.1556929293	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	25	0	35	0	0	1	53	16	1	2	34.346153846	3.9423076923	90	1	0	0	1	-21.3400445	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	28.84	1	40	1	0	1	55	12	1	2	30.596153846	19.403846154	90	1	0	0	1	-15.84430707	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	18.58	0	40	1	0	1	54	12	0	2	30.846153846	29.096153846	36	1	0	0	1	-27.3400445	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	12	0	40	0	0	0	59	12	1	0	36.769230769	6.9807692308	48	0	1	0	1	15.906365	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	52.32	1	40	1	0	0	58	13	1	2	38.5	13.134615385	90	1	0	0	1	-17.10647037	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0 	41.28	1	36	0	0	0	54	16	0	2	29.115384615	6.9807692308	74.664	1	0	0	1	5.6955202658	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	20	1	40	1	0	0	53	11	1	6	33.692307692	20.730769231	52	1	0	0	1	-4.340044503	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	12.5	0	25	1	0	0	52	12	1	2	25.307692308	4.0384615385	36.6	1	0	0	1	-17.3400445	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	21.7	0	50	1	0	0	57	16	1	2	36.365384615	13.730769231	74.1	1	0	0	0	38.89352963	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	20	0	40	0	1	0	59	16	0	1	30.288461538	1.2115384615	30	0	1	0	1	8.3316585987	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	13.45	1	37	0	1	0	55	11	0	1	19.173076923	8.8846153846	30	1	0	0	1	-32.02379685	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	8.13	0	20	0	1	0	54	15	1	3	21.75	2.3076923077	25.743	1	0	0	1	-18.30447973	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	47	0	45	1	0	0	54	18	1	2	32.961538462	19.942307692	90	1	0	0	0	54.695520266	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	16.02	0	30	0	1	0	57	13	0	1	31.942307692	11.442307692	25	0	1	0	1	-48.11736558	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	60	0	50	1	0	0	55	16	0	2	36.807692308	28.519230769	90	0	0	1	1	10.155692929	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0 	8.24	0	28	0	0	0	59	12	1	2	32.461538462	20.307692308	90	1	0	0	1	28.906365	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0 	88.46	0	50	1	0	0	52	13	1	3	37.884615385	30.384615385	90	1	0	0	1	10.335048682	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0 	31.75	1	40	1	0	0	54	12	1	0	36.826923077	29.596153846	90	1	0	0	1	15.695520266	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	50.08	1	48	1	0	0	58	16	1	3	36.115384615	24.596153846	90	1	0	0	1	16.882634422	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0 	40.86	0	40	1	0	0	55	16	1	2	33.307692308	5.7115384615	90	1	0	0	1	-4.844307071	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	21.91	0	48	1	0	0	59	12	0	0	28.019230769	21.230769231	70	1	0	0	0	-33.093635	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	12.5	0	50	0	0	0	55	14	1	5	21.692307692	3.0192307692	90	0	1	0	1	20.155692929	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0 	34.61	0	40	0	0	0	57	16	1	0	36.634615385	17.711538462	90	0	1	0	1	36.89352963	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0 	31.25	1	40	0	1	0	58	17	0	0	29.884615385	12.634615385	61.154	1	0	0	1	29.882634422	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0 	25.64	0	30	0	0	0	58	16	1	2	30.903846154	15.230769231	90	1	0	0	1	45.882634422	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0 	21.63	0	40	0	0	0	57	16	1	0	29.980769231	14.134615385	90	1	0	0	1	44.89352963	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	15	0	40	0	0	0	58	12	1	2	31.807692308	6.0384615385	60	0	1	0	1	-32.11736558	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	7.4	0	24	1	0	0	56	12	0	4	29.403846154	1.6346153846	12	1	0	0	1	-29.02379685	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0 	41.82	1	40	1	0	0	56	20	0	2	28.538461538	16.307692308	90	1	0	0	1	48.976203155	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	17	0	40	1	1	0	55	10	0	2	29.865384615	4.3846153846	25	1	0	0	1	-8.844307071	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0 	10.5	0	13	0	1	0	55	12	1	3	34.307692308	1.6153846154	6.23	1	0	0	1	-10.84430707	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0 	34.65	0	40	0	1	0	54	15	0	3	29.961538462	11.884615385	69	0	1	0	1	36.695520266	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	15.38	1	50	0	1	0	53	12	0	3	28.75	0.9615384615	40	1	0	0	1	-17.3400445	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	28.64	0	47	1	0	0	57	12	0	2	38.826923077	3.8461538462	86	1	0	0	1	43.89352963	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	37.5	0	40	1	0	0	54	13	1	3	38.769230769	18.211538462	90	1	0	0	1	30.695520266	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0 	18.82	0	21	0	1	0	54	14	0	2	11.538461538	1.6153846154	16.308	1	0	0	1	-10.30447973	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	5.69	0	36	0	1	0	58	9	0	4	0.3461538462	0.0384615385	9.66	1	0	0	1	-45.11736558	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	42.44	1	41	0	0	0	59	18	1	1	35.076923077	27.076923077	90	1	0	0	0	28.906365	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	53.84	0	40	0	0	0	55	16	1	1	33.923076923	7.1923076923	90	1	0	0	1	60.155692929	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	18	0	40	0	0	0	55	12	1	2	28.480769231	17.923076923	60	1	0	0	1	-13.84430707	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	12	0	40	0	0	0	58	12	1	3	24.288461538	12.365384615	24	1	0	0	1	-21.093635	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	16	0	40	0	0	0	57	13	1	3	37.980769231	16.923076923	78	1	0	0	1	-20.10647037	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	12.5	0	32	1	0	0	52	14	1	0	33.442307692	5.5576923077	55	1	0	0	1	0.6599554974	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	36.32	0	45	0	0	0	54	18	1	2	34.019230769	1.75	90	1	0	0	1	12.695520266	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0 	61.53	0	50	1	0	0	59	16	1	2	37.75	3.3653846154	90	0	1	0	1	32.906365	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	31.73	1	40	1	0	0	52	14	1	4	32.865384615	17.5	90	1	0	0	0	28.335048682	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0 	37	0	40	1	0	0	54	10	1	1	35.519230769	22	90	1	0	0	0	-22.30447973	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	31.25	0	40	1	0	0	56	12	1	3	38.923076923	22.288461538	90	1	0	0	1	8.9762031546	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	13.25	0	20	0	0	0	52	13	1	1	33.019230769	19.115384615	49.202	1	0	0	1	28.335048682	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0 	21.15	0	50	1	0	0	52	16	1	3	25.980769231	0.3076923077	45	0	1	0	0	18.335048682	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	30.76	0	70	0	0	0	57	20	1	2	36.230769231	14.769230769	90	1	0	0	1	11.748203155	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	27.5	0	40	1	0	0	56	12	1	0	39.019230769	16.038461538	25	1	0	0	1	-37.02379685	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	21.5	1	40	1	0	0	53	12	0	2	34.942307692	6.8846153846	90	1	0	0	1	16.659955497	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0 	13.25	0	40	0	0	0	53	12	1	0	35.173076923	7.25	70.887	1	0	0	1	31.659955497	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	12.75	0	37	0	0	0	59	12	1	3	37.692307692	38.788461538	28.76	1	0	0	1	13.906365	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	20.29	0	45	0	0	0	53	13	0	1	35.057692308	18	47.5	0	1	0	1	32.695520266	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0 	47.61	0	42	0	0	0	55	16	1	2	35.423076923	31.961538462	90	1	0	0	1	42.155692929	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	16.28	0	35	0	0	0	59	13	1	3	30.269230769	26.596153846	81	1	0	0	1	-6.093635	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	16.5	0	20	0	0	0	56	12	1	2	38.307692308	2.0961538462	90	1	0	0	1	27.976203155	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	13.88	0	45	1	0	0	58	20	0	0	32.461538462	2.0192307692	40	1	0	0	1	2.8826344221	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0 	31.46	0	55	1	0	0	56	16	0	3	35.25	4.0192307692	90	1	0	0	1	23.976203155	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	25.78	0	38	0	0	0	53	20	1	3	22.903846154	9.3076923077	90	0	1	0	1	44.659955497	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0 	20.44	0	40	0	0	0	54	13	0	0	38	13.75	40	1	0	0	1	-0.844307071	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	46.15	0	40	1	0	0	55	16	1	0	37.692307692	11.807692308	90	1	0	0	0	51.155692929	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0 	21.63	0	40	0	0	0	56	18	1	1	38.365384615	4.5192307692	90	1	0	0	1	48.89352963	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	23.84	0	50	1	0	0	57	14	1	2	38.807692308	2.75	90	1	0	0	1	40.89352963	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	19.23	1	50	1	0	0	59	19	1	5	36.442307692	19.519230769	62	1	0	0	0	2.678365	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	82.39	0	45	1	0	0	58	16	1	3	36.326923077	33.230769231	90	1	0	0	1	48.882634422	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	14.25	0	40	1	0	0	57	12	0	1	33.057692308	20	29.64	0	0	0	1	8.1036585987	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	10	0	40	0	0	0	52	12	1	2	21.230769231	3.7692307692	67	0	0	0	1	21.107048682	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0 	34.1	1	60	1	0	0	53	16	1	2	31.134615385	27.942307692	90	0	0	0	1	25.659955497	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	25.43	1	40	1	0	0	59	18	1	0	36.75	40.826923077	52	0	0	0	1	6.906365	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0 	48.07	0	40	1	0	0	58	19	1	2	34.923076923	33.634615385	90	0	1	0	1	48.906365	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0 	65.38	0	50	1	0	0	57	19	1	2	33.019230769	27.5	90	0	0	0	1	38.89352963	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	14.5	1	30	0	0	0	55	12	1	3	33.903846154	10.980769231	80.1	0	0	0	1	-17.30447973	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	48.07	0	40	1	0	0	53	12	1	0	35.211538462	18.442307692	90	0	1	0	1	-3.340044503	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0 	26.92	0	40	0	0	0	56	14	1	0	33.346153846	1.5192307692	71.895	0	0	0	1	12.976203155	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0 	30.9	1	56	1	0	0	52	12	1	3	26.730769231	18.557692308	90	0	1	0	1	1.6599554974	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0 	19.5	0	35	0	0	0	55	12	1	3	18.538461538	5.8653846154	90	0	0	0	1	13.155692929	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	21.53	0	40	0	0	0	57	17	0	2	33.115384615	22.423076923	44.8	0	0	0	1	33.976203155	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0 	29.5	0	44	0	0	0	53	17	0	0	17.557692308	11.5	79.2	0	1	0	1	57.695520266	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0 	30.93	0	46	0	0	0	53	19	1	2	29.480769231	25.692307692	90	0	1	0	1	35.659955497	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	56.41	0	45	1	0	0	56	12	0	2	36.615384615	35.807692308	90	1	0	0	1	37.976203155	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0 	34.79	0	42	1	0	0	57	13	1	2	39.442307692	27.788461538	87	0	0	0	1	4.8935296296	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	29.34	1	45	1	1	0	55	14	1	1	34.557692308	29.615384615	90	0	0	0	1	4.1556929293	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	6.25	0	40	1	1	0	54	12	0	0	25.865384615	4.8461538462	0	0	0	0	1	-28.30447973	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0 	17.62	0	60	1	1	0	58	16	1	4	38.711538462	4.1538461538	58	0	0	0	1	-27.11736558	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0 	16.56	0	40	0	1	0	55	13	0	2	31.884615385	8.9038461538	58.004	0	0	0	1	-29.30447973	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0 	33	1	40	1	1	0	54	15	1	1	35.596153846	5.7692307692	90	0	0	0	1	-18.3400445	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0 	25	0	46	0	0	0	59	13	0	0	39.038461538	21	78	0	0	0	1	32.906365	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0 	9.09	0	15	0	0	0	53	12	1	2	31.403846154	0.4807692308	90	0	0	0	0	-6.340044503	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0 	27.88	1	40	1	0	0	53	12	1	3	34.788461538	22.269230769	62.8	0	0	0	1	-29.3400445	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	10.48	0	35	0	0	0	56	12	1	1	33.653846154	1.7692307692	43.786	0	0	0	1	-10.02379685	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	9.06	0	10	0	0	0	52	10	1	2	16.25	5.8653846154	90	0	0	0	1	-11.3400445	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	38.46	0	40	1	0	0	59	11	1	3	37.596153846	0.2307692308	90	0	0	0	0	-11.093635	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	25.3	0	38	0	0	0	54	12	1	4	30.25	15.769230769	72.4	0	0	0	1	26.695520266	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0 	43.6	1	48	1	0	0	55	12	1	2	28.480769231	0.3653846154	90	0	0	0	1	3.1556929293	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	30	1	40	1	0	0	55	16	1	1	32.461538462	10.403846154	90	0	0	1	1	60.155692929	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0 	65.38	0	50	1	0	0	53	19	1	4	14.903846154	0.8269230769	90	0	0	0	1	38.659955497	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	20.76	0	50	0	0	0	54	20	1	3	34.307692308	29.230769231	90	0	0	0	1	42.695520266	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	33.46	1	50	0	0	0	57	20	0	0	32.692307692	1.7884615385	85	0	0	0	1	28.89352963	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	39.26	1	48	1	0	0	54	20	1	3	32.384615385	13.307692308	90	0	0	0	1	24.155692929	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	9.85	1	35	1	0	0	58	14	1	0	29.211538462	0.5769230769	75	0	0	0	1	-10.11736558	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	58.46	0	50	1	0	0	56	13	0	0	34.346153846	3.9807692308	90	0	0	1	1	3.9762031546	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0 	26.7	0	18	0	0	0	54	14	1	2	20.903846154	7.0384615385	90	0	0	0	1	6.6955202658	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0 	18.53	0	55	1	0	0	57	12	0	0	37.923076923	10.326923077	53	0	0	0	1	44.976203155	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0 	61.96	0	45	1	0	0	52	16	1	2	38.153846154	20.038461538	90	0	0	0	1	68.335048682	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0 	24.91	0	48	1	0	0	52	13	1	2	35.557692308	6.5576923077	90	0	0	0	1	27.335048682	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	13.6	0	30	1	0	0	55	17	1	0	37.980769231	5.3461538462	90	0	0	0	1	28.155692929	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	21	0	20	0	0	0	55	18	1	4	22.5	5.1153846154	90	0	0	0	1	55.155692929	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	13.5	0	15	0	0	0	54	13	1	2	17.826923077	7.5576923077	70.75	0	0	0	1	38.695520266	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0 	26.49	0	45	1	0	0	59	13	1	1	38.173076923	8.8653846154	87	0	0	0	1	31.906365	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	10.22	0	40	0	0	0	55	13	1	4	24.365384615	0.6153846154	44.924	0	0	0	0	12.927692929	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0 	20	0	50	1	1	0	53	12	0	1	31.923076923	7.0769230769	47	0	0	1	1	9.6599554974	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	32.9	0	45	1	0	0	52	13	1	2	35.134615385	11.038461538	77	0	0	0	1	19.335048682	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	20.45	0	40	0	0	0	56	16	1	3	31.961538462	13.25	90	0	0	0	1	46.976203155	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	19.71	0	40	0	0	0	55	16	0	0	36.711538462	16.5	41	0	0	0	1	1.1556929293	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	33.28	0	26	0	0	0	58	17	0	0	33.576923077	3.5192307692	48.7	0	0	0	1	5.3316585987	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	38.03	1	45	0	0	1	59	19	1	2	30.211538462	23.423076923	90	0	0	0	1	-24.093635	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	10	1	40	1	1	0	59	12	1	2	39.153846154	39.326923077	85	0	0	0	1	-47.093635	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	10.5	1	40	0	1	0	56	12	0	3	16.826923077	4.3269230769	64	0	0	0	1	-39.02379685	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	36.05	1	40	1	1	0	53	17	1	2	37.557692308	19.384615385	75	0	1	0	0	-11.3400445	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0 	18	0	57	1	0	0	55	8	1	0	33.480769231	0.8461538462	53.631	0	0	0	0	-30.84430707	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0 	10.83	0	60	1	0	0	58	11	1	3	38.019230769	30.980769231	39.9	0	0	0	1	-26.11736558	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0 	16.27	0	20	0	0	0	56	12	1	3	15.961538462	0.75	87	0	0	0	0	-33.02379685	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	9.83	0	30	0	0	0	55	12	0	0	37.346153846	1.3653846154	13	0	0	0	0	-8.844307071	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	48.07	0	40	1	0	0	55	16	1	2	38.980769231	35.384615385	90	0	0	0	0	19.155692929	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	22.5	0	40	1	0	0	53	12	0	1	39	16.192307692	45	0	0	0	1	12.659955497	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	26.83	0	43	0	0	0	53	12	1	2	36.903846154	6.5961538462	90	0	0	0	1	35.659955497	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0 	86.53	1	40	1	0	0	58	20	1	3	35.288461538	4.3269230769	90	0	0	1	1	31.882634422	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0 	34.61	0	50	1	0	0	55	16	1	3	34.192307692	0.7884615385	90	0	0	0	1	46.155692929	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0 	27.77	1	45	1	0	0	56	12	1	2	36.5	31.365384615	70.74	0	1	0	1	8.9762031546	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0 	61.53	0	50	1	0	0	59	17	1	2	37.134615385	27.923076923	90	0	0	0	1	49.331658599	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0 	27.66	0	60	1	0	0	56	18	0	1	34.057692308	1.0192307692	90	0	0	0	1	49.89352963	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0 	13	0	30	0	0	0	52	14	1	1	33.403846154	0.7115384615	73	0	0	0	0	44.335048682	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	37.97	1	40	1	0	0	58	14	1	2	36.807692308	13.057692308	90	0	0	0	1	-3.117365578	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0 	23.65	0	50	0	0	0	56	17	0	2	33.192307692	2.4230769231	63.5	0	1	0	1	16.976203155	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0 	45	0	50	1	0	0	52	14	1	3	35.923076923	6.6346153846	90	0	0	0	1	30.659955497	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0 	29.7	0	24	0	0	0	52	14	1	5	14.615384615	6.3269230769	90	0	0	0	1	-17.66495132	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	9.44	0	8	1	1	0	54	12	1	2	26.653846154	0.3461538462	0	0	0	0	1	-36.84430707	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0 	11	0	20	0	1	0	54	12	0	0	10.480769231	2.4230769231	12	0	0	0	1	-6.340044503	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0 	38.2	0	14	0	1	0	56	18	0	0	37	2.2307692308	45	0	0	0	1	-8.023796845	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	8.9	0	40	1	0	0	54	12	0	0	19.115384615	0.8846153846	8	0	0	0	1	-9.304479734	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	32.69	0	50	1	0	0	53	18	1	0	32.961538462	11.230769231	90	0	0	0	1	42.659955497	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0 	17.03	0	35	0	0	0	54	14	0	2	23.557692308	10.384615385	42.64	0	0	1	0	2.6955202658	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0 	16.01	0	55	1	0	0	54	12	0	2	35.519230769	14.423076923	41	0	0	0	1	23.155692929	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0

Komalavalli · Accepted Answer

The portion of sample that is unionized in North West is 0.25; Midwest is 0.20, south is 0.11 and west is 0.26.
By comparing the unionized rate among four regions it was clear that south has low rate of unionization, while other region has high rate of unionization.

· What portion of the sample is unionized in each region? Calculate the rate of unionization for workers in the northeast, midwest, south, and west. · To get the portion of workers in the northeast,...

Answer To: · What portion of the sample is unionized in each region? Calculate the rate of unionization for...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment