Data fra forsvaret indvandrere sessionsprøven IQ

	A	B	C	D	E	F	G	H	I	J	K	N	O	P	Q	T	U	V
1		DK	DK	ET	ET	DK-ET
2	BPP score	antal	BPP-1 g.snit	antal	BPP-1 g.snit	BPP-1 g.snit
3	0	0		1
4	1	0		0
5	2	2		0
6	3	1		0
7	4	2	2.5	1	3	-0.5
8	5	4	2	1	2	0
9	6	5	2	2	2	0
10	7	3	3	4	2.25	0.75
11	8	12	3.17	4	3.25	-0.08
12	9	14	2.93	7	2.43	0.5
13	10	8	3.25	11	2.91	0.34
14	11	13	3.54	7	4	-0.46
15	12	19	3.32	8	3.13	0.19
16	13	22	3.77	17	4.18	-0.41
17	14	22	3.91	15	3.8	0.11
18	15	41	4.66	14	3.93	0.73
19	16	51	4.1	19	4.47	-0.37
20	17	50	4.62	22	5.32	-0.7
21	18	56	4.79	24	4.88	-0.09
22	19	77	5.13	28	4.89	0.24
23	20	97	5.22	25	5.28	-0.06
24	21	100	5.48	29	5.72	-0.24
25	22	120	5.76	39	5.44	0.32
26	23	124	5.86	32	6.56	-0.7
27	24	147	6.26	27	6.78	-0.52
28	25	167	6.67	37	6.81	-0.14
29	26	186	6.4	30	6.5	-0.1
30	27	159	6.82	29	7.21	-0.39
31	28	254	6.87	40	7.38	-0.51
32	29	293	7.3	50	7.34	-0.04
33	30	311	7.59	43	7.7	-0.11
34	31	330	7.82	47	7.94	-0.12
35	32	375	7.97	49	8.41	-0.44
36	33	404	8.39	54	8.63	-0.24
37	34	491	8.41	42	8.6	-0.19
38	35	534	8.79	61	9.21	-0.42
39	36	582	9.08	50	9.06	0.02
40	37	592	9.21	50	9.52	-0.31
41	38	687	9.39	51	9.9	-0.51
42	39	766	9.5	52	9.87	-0.37
43	40	784	9.75	33	10.18	-0.43
44	41	806	10	47	10.64	-0.64
45	42	896	10.21	31	10.65	-0.44
46	43	885	10.46	45	11.22	-0.76
47	44	912	10.63	31	11.23	-0.6
48	45	964	10.86	40	11.07	-0.21
49	46	906	10.95	34	11.38	-0.43
50	47	902	11.18	40	11.57	-0.39
51	48	792	11.47	25	12.4	-0.93
52	49	801	11.61	25	11.92	-0.31
53	50	712	11.61	23	12.09	-0.48
54	51	746	11.81	17	12	-0.19
55	52	656	11.95	18	12.5	-0.55
56	53	545	12.11	11	12.55	-0.44
57	54	514	12.36	10	13.1	-0.74
58	55	449	12.44	11	13.18	-0.74
59	56	345	12.46	2	12	0.46
60	57	340	12.54	3	11.67	0.87
61	58	259	12.76	2	12.5	0.24
62	59	206	12.96	3	13.33	-0.37
63	60	160		0
64	61	126	13.31	2	13	0.31
65	62	97	13.33	1	14	-0.67
66	63	86		0
67	64	44		0
68	65	49	13.92	1	14	-0.08
69	66	27	13.89	2	16.5	-2.61
70	67	13		0
71	68	12		0
72	69	1		0
73	70	0		0
74	71	1		0
75	72	1		0
76	73	0		0
77	74	1		0
78	75-78	0		0
79
80
81
82
83
84
85
86
87
88
89
90	Data
91	BPP score	danskere antal	indvandrere antal	Andel danskere	Andel indvandrere	Percentil danskere	Percentil indvandrere	Vægtet score danskere	Vægtet score indvandre	Afstand til gns.^2 * antal danskere	Afstand til gns.^2 * antal indvandrere	Lagt sammen til en sample	Andel	Vægtet score	Afstand fra gns.^2*antal	INDV to DK forhold	Justeret for forhold	Moving avg.
92	0	0	1	0	0.000676132522	0	0.000676132522	0	0	0	1122.408559	1	0.00004417351356	0	1780.08101	#DIV/0!	#DIV/0!	#DIV/0!
93	1	0	0	0	0	0	0.000676132522	0	0	0	0	0	0	0	0	#DIV/0!	#DIV/0!	#DIV/0!
94	2	2	0	0.00009452242545	0	0.00009452242545	0.000676132522	0.0001890448509	0	3329.008507	0	2	0.00008834702712	0.0001766940542	3230.63397	0	0	#DIV/0!
95	3	1	0	0.00004726121272	0	0.0001417836382	0.000676132522	0.0001417836382	0	1583.907581	0	1	0.00004417351356	0.0001325205407	1535.934973	0	0	#DIV/0!
96	4	2	1	0.00009452242545	0.000676132522	0.0002363060636	0.001352265044	0.0003780897018	0.002704530088	3010.621816	870.389627	3	0.0001325205407	0.0005300821627	4375.65888	0.5	7.153144016	3.290446247
97	5	4	1	0.0001890448509	0.000676132522	0.0004253509145	0.002028397566	0.0009452242545	0.00338066261	5714.85694	812.384894	5	0.0002208675678	0.001104337839	6915.854738	0.25	3.576572008	7.105456389
98	6	5	2	0.0002363060636	0.001352265044	0.0006616569781	0.00338066261	0.001417836382	0.008113590264	6770.587811	1512.760322	7	0.0003092145949	0.00185528757	9168.522545	0.4	5.722515213	8.059208925
99	7	3	4	0.0001417836382	0.002704530088	0.0008034406163	0.006085192698	0.0009924854672	0.01893171062	3844.562668	2809.501713	7	0.0003092145949	0.002164502165	8668.848457	1.333333333	19.07505071	8.059208925
100	8	12	4	0.0005671345527	0.002704530088	0.001370575169	0.008789722786	0.004537076421	0.0216362407	14531.0906	2601.482781	16	0.000706776217	0.005654209736	18704.39856	0.3333333333	4.768762677	11.27812373