finance due 1.5 hrs

takeaway_test_2014_s1.xlsx

Home >Business & Finance homework help >finance due 1.5 hrs

Basic Data Analysis (30 marks)

					marks
1. Use this work area to make your SUBTOTAL calculations
Use SUBTOTAL function to calculate	Lecture	Seminar	Feedback
Average					3
St DevP					3
2. Number of students in each department
Engineering					1
Art					1
Management					1
Total					1
3. Averages	Lecture	Seminar	Feedback
Engineering					3
Art					3
Management					3
4. Standard Deviation (STDEV.P)	Lecture	Seminar	Feedback
Engineering					3
Art					3
Management					3
5. & 6. be prepared to answer these questions in the Moodle quiz.					2
				total	30
Working Data -->	Students	Department	Lectures	Seminars	Feedback
	1	Engineering	64	70	52
	2	Engineering	86	59	72
	3	Art	90	49	66
	4	Engineering	60	66	92
	5	Management	86	27	59
	6	Management	88	90	78
	7	Management	84	72	59
	8	Art	66	59	52
	9	Art	61	45	57
	10	Management	82	99	68
	11	Engineering	66	66	66
	12	Management	90	49	60
	13	Art	82	25	79
	14	Management	88	47	37
	15	Engineering	64	60	86
	16	Art	85	43	67
	17	Management	85	52	72
	18	Engineering	63	76	63
	19	Art	65	49	68
	20	Management	85	60	67
	21	Art	69	59	59
	22	Art	64	37	55
	23	Management	61	47	55
	24	Management	68	36	75
	25	Art	61	60	52
	26	Management	84	37	65
	27	Art	95	29	99
	28	Engineering	86	66	56
	29	Art	86	62	66
	30	Engineering	63	76	69
	31	Management	65	60	56
	32	Engineering	89	56	66
	33	Engineering	62	53	37
	34	Engineering	62	42	76
	35	Engineering	88	47	82
	36	Art	84	36	56
	37	Art	90	60	29
	38	Art	61	56	62
	39	Art	82	53	66
	40	Art	90	39	67
	41	Management	64	90	70
	42	Management	69	49	58
	43	Art	62	56	63
	44	Management	89	74	23
	45	Management	66	55	69
	46	Engineering	62	53	96
	47	Management	84	57	56
	48	Art	62	42	62
	49	Art	94	37	62
	50	Engineering	84	57	69

The Data below contains data related to a survey of 50 students and their satisfaction in their Lectures, on Seminars and Feedback. Each of the three aspects was measured on a ratio scale from 0 to 100. The data collected show the Department the students were from. You are required to use various Excel summarising and descriptive techniques to answer the following questions. Remember, that doing the calculations by hand or eye will gain little credit. You MUST use the Autofilter mechanism and SUBTOTAL function. You must copy and paste your answers from the area in Q1 into the relevant answer boxes in Qs 3 & 4. You must enter your answers to these questions into the Moodle quiz. Put your formulae in the yellow boxes. 1. Use the SUBTOTAL function to calculate the Average and Standard Deviation (Population) for the three measures of satisfaction. (6 marks) 2. Determine the numbers of students in the sample from each department. (4 marks) 3. Calculate the average of the satisfaction levels of the students from each department and for each of the three aspects of satisfaction in the survey (i.e. 9 averages). (9 marks) 4. Calculate the standard deviation of the satisfaction levels of the nurses from each type of hospital and for each of the three aspects of satisfaction in the survey (i.e. 9 standard deviations). (9 marks) 5. Which aspect of their courses were the students most satisfied with overall? (1 mark) 6. Which Department had the poorest satisfaction and in which aspect? (1 mark) Total marks (30 marks) You may want to copy the original data to somewhere safe on the worksheet so that you can get back to it easily.

Pivot Tables (20 marks)

Data ê
emp_firm	export	competition	ownership	mne_country	degree_m	degree_nm
700		8	Founder	UK	20	0
180		10	Managers	US	50	30
500	45	6	Private Individuals		75	10
1600	10	4	Private Individuals	Austria	70	0
350		4	Dispersed Shareholders	UK	0	0
900		3	Dispersed Shareholders	UK
200		6	Managers	UK	45	13
140		10	Private Individuals	UK	50	0
4300		10	Dispersed Shareholders	Germany	15	0
219	50	10	Founder	Netherlands	2	2
872		10	Private Equity
139	60	4	Private Individuals	US	10	20
121		10	Private Individuals	UK	45	5
170		10	Family owned, family CEO	UK	20	0
160		2	Founder	Japan	2	5
184	15	10	Founder	UK	5	5
230		10	Dispersed Shareholders	UK	50	2
750		5	Private Equity	UK
400		10	Dispersed Shareholders	UK
130		4	Private Individuals	France	50	0
400		10	Private Individuals		60	2
161	50	4	Dispersed Shareholders	US	50	5
200		6	Private Individuals		50	18
550		10	Dispersed Shareholders	US	70	30
360	60	5	Private Equity	UK	35	30
130	100	3	Dispersed Shareholders		0	0
200		3	Dispersed Shareholders	UK	20	80
413	60	10	Family owned, external CEO	US	70	28
2800	90	8	Dispersed Shareholders	US	95	80
3000	85	0	Dispersed Shareholders	Switzerland	25	0
133	0	4	Dispersed Shareholders		60	3
400		6	Family owned, family CEO	UK	70	5
540			Government	France
300	1	5	Private Equity		10	0
250		3	Private Individuals	UK	40	15
4522	15	10	Dispersed Shareholders	Korea	30	0
1123	0	10	Private Individuals	US	30	8
168	60	10	Private Individuals	US	60	50
190	10	6	Family owned, external CEO	Germany	80	15
200		5	Private Individuals	UK	100	10
1000	0	1	Private Individuals		50	5
2800		10	Dispersed Shareholders	France	25	0
600	50	2	Family owned, family CEO		40	15
336		6	Dispersed Shareholders	UK	45	20
250	5	4	Family owned, family CEO		25	0	Put Pivot Tables hereê
300		10	Private Individuals	UK	20	0
110	0	8	Private Individuals		100	0
420		8	Dispersed Shareholders	Finland	75	3
136	80	10	Dispersed Shareholders	US	70	0
3111	85	3	Dispersed Shareholders	Germany	20	5
993	60	6	Dispersed Shareholders	UK	60	30
191		4	Dispersed Shareholders	US	3	0
295			Family owned, external CEO
100		10	Family owned, external CEO	Switzerland	80	10
200		10	Private Individuals	UK	75	25
210		2	Dispersed Shareholders	US	30	2
2247	90	4	Dispersed Shareholders	Germany	20	0
500		10	Family owned, family CEO		70	10
170	30	10	Dispersed Shareholders	Netherlands	0	0
286		10	Dispersed Shareholders	US	50	10
3000		10	Dispersed Shareholders	US	95	15
200	25	10	Family owned, family CEO		20	0
3500		10	Dispersed Shareholders	Holland	50	1
461		10	Private Equity	Holland	25	0
324		5	Private Equity	UK	0	0
250		10	Private Individuals	UK	60	6
100	0	6	Private Individuals		5	0
280	67	10	Dispersed Shareholders		75	10
200		10	Family owned, family CEO	UK	50	60
150		3	Founder	UK
102		10	Dispersed Shareholders	US	10	0
100		4	Family owned, family CEO	UK	50
140	90	10	Other	US	15	20
120		5	Managers		20	10
140		8	Private Individuals	UK	85	15
220		10	Dispersed Shareholders		20	3
438		10	Family owned, family CEO	Japan	70	10
190		5	Family owned, family CEO	UK	0	0
600		4	Managers	UK	50	5
250	60	10	Managers	UK	50	10
240	35	10	Private Individuals		65	2
160	2	10	Managers	UK	0	0
550		5	Founder		75	10
150		10	Founder		80	0
120	20	10	Other	France	75	10
260		10	Private Individuals	UK	50	17
1450			Dispersed Shareholders	UK	100	35
380		10	Family owned, family CEO	Germany	20	13
180		3	Private Equity	UK	15	5
300		3	Family owned, family CEO	UK	10	0
500	1	3	Private Individuals		10	15
100	15	10	Private Individuals		10	15
1874	75	7	Private Individuals	UK	33	0
260	60	9	Dispersed Shareholders	UK	60	0
350	85	0	Dispersed Shareholders	US	100	5
1200		10	Family owned, family CEO	UK	66	50
200		4	Managers	UK	90	20
180	95	10	Dispersed Shareholders		3	3
200	0	5	Dispersed Shareholders		13	2
300		1	Dispersed Shareholders	US	90	30
110	0	10	Private Individuals		20	2
192		10	Founder	UK	35	13
130	4	3	Private Equity		75	9
2500	0	6	Dispersed Shareholders	US	66	5
372	95	10	Private Equity	US	50	15
3000	30	10	Dispersed Shareholders	US	15	10
165		5	Private Individuals	UK	10	0
230			Dispersed Shareholders
500		2	Dispersed Shareholders	US	50	3
2000		10	Dispersed Shareholders	France	25	0
190	2	10	Family owned, family CEO		10	1
250			Family owned, family CEO	UK	0	0
4992	90	5	Private Individuals	Canada	90	30
1000		4	Dispersed Shareholders	Switzerland	80	20
130	90	3	Family owned, family CEO		5	0
150		3	Dispersed Shareholders	UK	50	50
104		10	Private Individuals	UK	70	25
600		10	Private Individuals	UK	30	10
2000	70	4	Dispersed Shareholders	US	50	5
500		5	Dispersed Shareholders	Germany	70	25
200		10	Private Individuals	UK	80	15
333		2	Family owned, family CEO	Germany	75	5
200	0	2	Founder	Ireland (Uk)	100	35
2000	70	2	Dispersed Shareholders	UK	15	5
800	0	8	Family owned, family CEO	UK	5	2
909			Founder	UK	0	0
100	0	6	Managers		10	0
318		6	Dispersed Shareholders	Japan	50	1
4600	2	2	Family owned, family CEO		50	5
150		6	Managers	UK	90	10
800		2	Dispersed Shareholders	UK	40	3
250	15	10	Founder		0	5
185		10	Private Equity	UK	65	40
300	30	10	Dispersed Shareholders		15	10
500		3	Dispersed Shareholders	UK	15	0
438			Managers	UK	20	20
100		1	Managers		30	10
107	50	6	Dispersed Shareholders	US	44	0
250	75	10	Family owned, external CEO	UK	75	0
100	40	10	Family owned, family CEO	UK	80	5
197		6	Managers	UK	100	50
447	85	10	Dispersed Shareholders	Germany	75	8
450		2	Family owned, family CEO	UK	75	5
362	100	1	Dispersed Shareholders	Germany	55	10
130	30	2	Founder		0	5
350		4	Dispersed Shareholders	UK	80	80
1200	50	0	Dispersed Shareholders	UK	90	26
350	70	10	Private Equity	Switzerland	40	5
250		10	Dispersed Shareholders	Canada	50	10
750		3	Dispersed Shareholders	US
500		4	Dispersed Shareholders	UK	25	0
280		7	Other	US	60	5
600	0	4	Private Individuals	UK	60	0
108		5	Private Individuals	UK	0	0
205	0	3	Private Individuals		15	0
210	10	3	Family owned, external CEO		15	0
450		10	Family owned, family CEO	UK	30	0
300		10	Dispersed Shareholders	UK	80	0
1000		10	Dispersed Shareholders	US	70	8
170		5	Managers	UK	40	30
190	80	10	Dispersed Shareholders		90	3
230		5	Founder		50	0
1000		10	Dispersed Shareholders	UK	75	2
250	25	10	Family owned, external CEO	UK	50	20
500	60	5	Family owned, family CEO	Ireland (Uk)	40	2
400		10	Private Equity	Holland	42	5
100	0	10	Private Individuals			0
394		10	Family owned, family CEO	UK	0	0
300		5	Family owned, family CEO	Japan	45	5
200		7	Managers	UK	25	7
2500		10	Private Individuals	Hong Kong	50	0
900		3	Dispersed Shareholders	Switzerland	85	5
500		6	Family owned, family CEO	UK	70	1
420		10	Other	UK	10	0
235	2	6	Private Individuals	Germany	10	1
2805	95	3	Dispersed Shareholders	US	50	3
159		7	Dispersed Shareholders	Canada	0	0
122	70	10	Private Individuals	US	40	0
150		5	Dispersed Shareholders	US	40	3
1000		5	Dispersed Shareholders		50	8
185	85	3	Dispersed Shareholders	UK	100	5
4000		4	Government	France	50	10
1300		7	Other	UK	90
228			Dispersed Shareholders	US	0	0
150		10	Private Individuals	UK	80	10
220	0	7	Founder		20	10
270		10	Dispersed Shareholders	France	20	2
399		10	Family owned, external CEO	UK	30	10
181		10	Family owned, family CEO	UK
240		6	Founder		0	0
3700	40	10	Founder	Japan	2	1
566	0	10	Dispersed Shareholders	Austria	10	0
170	5	10	Dispersed Shareholders	UK	33	2
110	0	6	Family owned, family CEO		8	0
2500		5	Dispersed Shareholders	US	95	6
350	10	5	Managers	UK	50	0
1500	50	10	Private Equity	US	75	50
420	5	10	Dispersed Shareholders	UK	70	5
500	75	4	Family owned, family CEO	UK	35	5
400	80	6	Private Equity	UK	25	0
135		2	Family owned, family CEO	UK	0	0
450		3	Dispersed Shareholders	France	30	10
230		10	Dispersed Shareholders	US	100	30
117		10	Dispersed Shareholders	Japan	60	20
100		5	Dispersed Shareholders	Sweden	80	10
500		10	Family owned, family CEO	UK	0	0
114		10	Managers	US	50	5
100		10	Other	Norway	35	0
200		4	Private Individuals	US
2000		7	Dispersed Shareholders	US	70	5
1500	10	1	Family owned, external CEO	US	100	1
155		10	Private Equity	UK	20	0
500		10	Dispersed Shareholders	US	50	5
200	0	10	Family owned, family CEO		10	0
190		0	Family owned, family CEO	US	60	0
124	10	2	Dispersed Shareholders	US	10	5
100	85	3	Dispersed Shareholders	US	20	10
263	10	10	Founder		5	0
500	50	7	Private Equity		60	8
340			Dispersed Shareholders	UK
380		6	Dispersed Shareholders	Holland	20	4
350		5	Other		70	0
2400	70	5	Private Equity	Sweden	100	25
708	5	10	Dispersed Shareholders	Japan	40
3000	0	10	Private Equity	Sweden	18	1
454		10	Dispersed Shareholders	Iceland	50	5
400		10	Family owned, family CEO	UK	10	1
200		10	Managers	UK
200		5	Family owned, family CEO		50	13
350		5	Family owned, external CEO	UK		0
130		4	Dispersed Shareholders	Canada	0	0
750		10	Dispersed Shareholders	Germany	50	5
300		1	Family owned, family CEO	UK	0	0
180			Founder
230		10	Private Individuals	UK	50	2
500		4	Dispersed Shareholders	UK	80	15
110		3	Family owned, family CEO	UK	50	5
180		5	Private Individuals	UK	3	0
2000	5	10	Other	UK	0	0
180	30	10	Private Individuals		50	5
150	40	6	Dispersed Shareholders	France	50	0
202		5	Managers	UK	1	1
900		9	Dispersed Shareholders	US	100	90
869		3	Dispersed Shareholders	UK	40	5
100	10	10	Managers		5	0
249		6	Family owned, family CEO	UK
650	70	6	Family owned, external CEO	UK	50	30
750		10	Family owned, family CEO	UK	50	3
170	10	10	Private Individuals		2	0
140		8	Private Individuals	UK	20	0
850	50	10	Family owned, family CEO	Ireland (Uk)	20	0
200		10	Dispersed Shareholders	Sweden	80	20
1050		10	Founder	UK	20	0
202		10	Dispersed Shareholders	UK	5	1
450	10	8	Dispersed Shareholders	Ireland	33	0
250		10	Dispersed Shareholders	UK	50	5
150		10	Family owned, family CEO	UK	80	10
500		10	Private Equity	Holland	100	0
2000		10	Dispersed Shareholders	Germany	30	0
1000		5	Dispersed Shareholders	UK	75	20
500	50	7	Dispersed Shareholders	UK	35	0
200		10	Dispersed Shareholders	UK	100	80
195		3	Dispersed Shareholders	Spain	30	0
140		10	Family owned, family CEO	UK	2	0
160	0	8	Founder		0	0
650		5	Dispersed Shareholders	Denmark	50	6
669	30	5	Family owned, external CEO	US	80	3
800		1	Founder	UK	100	5
184		10	Founder	UK	90	0
110	20	10	Other	UK	10	1
110		3	Dispersed Shareholders	US	100	45
486		6	Dispersed Shareholders	Germany	90	7
152		7	Dispersed Shareholders	US	5	2
185		10	Other	UK	60	21
100	60	5	Managers		80	4
200		4	Other	UK	80	90
746			Private Individuals		50	0
112		3	Dispersed Shareholders	Sweden	0	0
150		10	Family owned, family CEO	UK	40	5
170	0	4	Private Individuals	UK
210		10	Founder		2	0
1100	0	6	Dispersed Shareholders	UK	50	2
254	0	6	Family owned, family CEO		25	0
150		10	Family owned, family CEO	UK	30	5
150	2	3	Managers		0	2
2200	1	10	Private Individuals	Germany	75	0
1700		5	Private Equity	UK	10	10
150	0	5	Family owned, family CEO		30	0
120	0	6	Private Individuals		50	6
200	0	10	Government	Sweden	20	1
200	60	10	Other	Italy	25	1
135		10	Private Individuals	UK	25	0
250		7	Dispersed Shareholders		80	5
150		10	Dispersed Shareholders	Sweden	25	2
170		10	Family owned, family CEO	UK	90	8
550		2	Family owned, family CEO	UK
250			Managers	UK	25	0
450		7	Managers	UK	20	0
1100	99	7	Dispersed Shareholders	US	90	20
300		8	Founder	Ireland	90	10
600		10	Other	UK	50	1
3000		1	Private Individuals	Germany	90	45
241		4	Dispersed Shareholders	US	75	10
149	20	5	Dispersed Shareholders	Ireland (Uk)	0	0
300		2	Private Equity	UK	0	0
205		6	Private Individuals	UK	90	5
200		1	Family owned, family CEO	UK
350		10	Other	UK	5	0
160		10	Private Individuals	UK	60	0
2500	5	3	Dispersed Shareholders		40	0
300		4	Managers	UK	25	0
250		3	Dispersed Shareholders	UK	90	50
450		10	Dispersed Shareholders	Ireland	50	3
190	5	3	Family owned, family CEO		40	30
270		6	Managers		10	0
600	100	10	Dispersed Shareholders	Denmark	45	10
150		5	Dispersed Shareholders	UK	80	20
150		6	Founder
550		6	Private Individuals	UK	60	4
300	15	5	Dispersed Shareholders	UK	5	2
300		6	Dispersed Shareholders	UK	50	39
200		4	Family owned, family CEO	UK	15	0
250	3	10	Founder		5	5
150		10	Dispersed Shareholders	Germany	25	0
2000	100	10	Dispersed Shareholders	Japan	80	5
150	0	4	Family owned, family CEO			0
227	25	3	Dispersed Shareholders	UK	50	0
220		10	Dispersed Shareholders	US	67	5
250		9	Dispersed Shareholders	UK	50	23
180	87	10	Family owned, family CEO	US	100	5
186	95	5	Dispersed Shareholders	France	1	0
160		10	Founder	UK
580		10	Private Equity		50	1
1800		10	Dispersed Shareholders	US	40	5
380		7	Dispersed Shareholders	UK	30	0
1787	10	5	Dispersed Shareholders	France	80	2
450		10	Family owned, family CEO	UK	0	0
450		5	Private Individuals	UK	33	5
150		4	Private Individuals		12	1
2500	95	3	Private Individuals	US	50	10
639		6	Dispersed Shareholders	Germany	90	3
215			Family owned, external CEO	UK
300		10	Family owned, family CEO	Canada	10	0
2000	50	10	Private Equity	US	60	5
450		10	Private Equity		20	0
589	5	2	Dispersed Shareholders		14
250		5	Dispersed Shareholders	France
700		4	Dispersed Shareholders	US	75	0
140	0	10	Founder		10
600		10	Private Individuals	UK	3	0
450		10	Dispersed Shareholders	UK	20	0
150		10	Dispersed Shareholders	UK	15	0
250		10	Dispersed Shareholders	UK	15	15
750		6	Family owned, family CEO	UK	25	0
1285	75	3	Private Equity	UK	84	1
100		10	Founder		10	0
250	75	5	Dispersed Shareholders	US	50	0
231	0	4	Dispersed Shareholders	Ireland	88	5
250		10	Family owned, family CEO	UK	75	15
220		10	Private Individuals	UK	1	1
170		10	Family owned, family CEO	UK	100	40
125	8	10	Family owned, family CEO		5	0
500		1	Dispersed Shareholders	UK	10	1
260		3	Managers	UK	70	0
135		10	Private Individuals	UK	1	0
250	70	6	Family owned, family CEO		50	0
1250	0	1	Other		25	0
160	90	10	Private Equity		50	5
280		9	Dispersed Shareholders	US	85	8
571	40	3	Dispersed Shareholders	UK	7	0
250		10	Dispersed Shareholders	US	30	30
250	0	10	Private Equity	UK	50	10
220		3	Family owned, external CEO	US	20	1
506			Family owned, external CEO		5	0
170		8	Family owned, family CEO	UK	5	0
1200		10	Founder	UK	75	18
739			Private Individuals	UK	0	0
2200		1	Dispersed Shareholders	UK	20	0
1000		8	Family owned, family CEO	UK	0	0
204	100	1	Family owned, family CEO	Austria	70	0
426		8	Dispersed Shareholders	US	75	3
2400	80	5	Founder	UK	90	50
277		0	Family owned, family CEO	Japan	33	0
350		3	Managers		95	30
200		10	Managers	UK	80	30
300	10	3	Managers		0	2
1500	3	2	Private Individuals	US	40	1
263		0	Private Individuals	UK	70	10
220		3	Private Individuals		0	0
200		5	Private Individuals		20	0
250		10	Family owned, external CEO		5	5
250		10	Managers	UK	75	4
322	35	10	Dispersed Shareholders	US
1000		4	Family owned, external CEO	Sweden	50	15
710	40	4	Family owned, family CEO	UK	100	10
100		0	Dispersed Shareholders	Sweden	50	3
400	80	10	Dispersed Shareholders	Norway	50	45
300	5	3	Managers		5	1
101		2	Dispersed Shareholders	US	90	10
200		4	Private Equity	Holland	25	1
380	0	3	Private Individuals	China	50	5
161		3	Dispersed Shareholders	Holland	40	0
200		10	Dispersed Shareholders	Germany	45	10
313	40	5	Family owned, family CEO	Germany	100	5
550	20	10	Managers		50	20
120		10	Other	Lichtenstein	75	15
360		10	Private Individuals	UK	25	3
160		3	Private Individuals	Luxembourg	35	0
500	75	4	Dispersed Shareholders	UK	60	30
400		10	Dispersed Shareholders	Holland	50	0
170		2	Dispersed Shareholders	US	75	25
250		10	Family owned, external CEO	US	100	0
170	45	10	Managers		85	2
120		10	Founder	UK	0	0
260		5	Managers		0	0
145		10	Family owned, family CEO	UK	5	10
170	100	4	Government	France	75	5
900		10	Family owned, external CEO	UK	95	75
400		10	Family owned, family CEO	UK	80	10
197	75	3	Dispersed Shareholders	France
2000		5	Founder	Ireland (Uk)	100	30
4000	10	5	Private Individuals	France	100	50
371	35	6	Dispersed Shareholders	US	33	1
110		10	Family owned, family CEO	France	60	0
1700	0	10	Other	Ireland (Uk)	35	0
610		4	Dispersed Shareholders	US	80	5
1000	100	4	Private Equity	UK	5	0
564	20	6	Managers		0	0
120	70	10	Family owned, family CEO		22	11
3000		10	Dispersed Shareholders	UK	2	0
380		10	Family owned, external CEO		4	8
1500	50		Dispersed Shareholders	US	90	10
150		10	Family owned, family CEO	UK	60	20
150		10	Dispersed Shareholders	Japan	70	2
800		10	Dispersed Shareholders	Japan	50
133		5	Government	Saudi Arabia	10	1
120		7	Managers		50	0
450	10	10	Dispersed Shareholders
500		10	Dispersed Shareholders	UK	40	5
450		10	Private Individuals	UK	50	0
3000	0	5	Dispersed Shareholders		20	0
170	90	2	Dispersed Shareholders		80	20
161		3	Founder		10	0
487	100	2	Dispersed Shareholders	UK	80	40
914		10	Family owned, external CEO	UK	30	0
500	30	10	Dispersed Shareholders	UK
200	2	5	Family owned, family CEO		50	5
475		10	Family owned, external CEO	US	30
600		10	Family owned, family CEO	UK	10	3
230		10	Family owned, family CEO	Switzerland	70	50
500		10	Family owned, family CEO	US	13	1
200	60	2	Dispersed Shareholders	US	90	10
125		10	Managers	UK	83	5
250	5	10	Managers		40	10
400		10	Founder	UK	10	4
170		7	Private Individuals	UK	50	10
160	20	6	Private Individuals	Netherlands	30	5
500	0	10	Dispersed Shareholders	UK	30	40
420	0	3	Founder		5	2
155		10	Dispersed Shareholders	Germany	10	0
190			Family owned, family CEO	UK	5	2
125	80	5	Managers		20	0
684		7	Dispersed Shareholders	Japan	10	0
2200	3	10	Managers		25	10
500		10	Other	Japan	60	0
550		10	Private Equity	UK	75	10
3000		2	Dispersed Shareholders	Denmark	50	0
200	80	10	Family owned, external CEO	UK	90	20
400	45	5	Family owned, family CEO	UK	33	6
108		10	Family owned, family CEO	UK	0	0
100		5	Family owned, external CEO	US	3	1
180	60	10	Private Individuals		100	15
4000	95	4	Dispersed Shareholders	US	90	50
200		1	Dispersed Shareholders	US	10	5
110	80	6	Managers	UK	50	0
225	3	3	Private Individuals	Belgium	30	15
110		10	Other	US	20	0
353		4	Private Individuals	France	100	60
400		10	Private Individuals	UK	0	5
916		8	Dispersed Shareholders	US	50	80
100		6	Private Equity	US	55	0
350		10	Dispersed Shareholders	US	66	5
120		6	Family owned, external CEO		30	0
558		3	Family owned, family CEO	UK	100	0
150	20	7	Family owned, family CEO		60	20
199		10	Private Individuals	UK	50	10
350		10	Private Equity	UK	90	30
300		10	Dispersed Shareholders		20	0
400		3	Dispersed Shareholders	UK	50	0
272		3	Dispersed Shareholders	UK	83	30
150		1	Government	France	100	50
300		2	Family owned, family CEO	UK	25	2
150			Private Individuals
1000		10	Dispersed Shareholders	UK	100	5
3153			Family owned, family CEO
263			Managers		0	0
202		2	Dispersed Shareholders	US	80	5
120		10	Private Individuals	UK	10	0
300	70	5	Family owned, family CEO	Japan	40	1
118	0	3	Family owned, family CEO		40	0
114	70	10	Dispersed Shareholders	UK	60	20
400		10	Family owned, family CEO	UK
164		1	Dispersed Shareholders	US	50	5
400	20	10	Family owned, family CEO	France	65	0
400		10	Government	Finland	33	4
1500		5	Dispersed Shareholders	UK	60	50
400	7	10	Family owned, family CEO		5	5
400	80	6	Private Individuals	Germany	50
800	10	10	Private Individuals		20	2
1016		10	Dispersed Shareholders			20
650		10	Family owned, family CEO	UK	0	0
1800	28	3	Other		25
800	20	10	Private Individuals		100	10
150		10	Private Individuals	UK	30	5
644		10	Dispersed Shareholders	Germany	45
255	0	6	Founder		30	0
633		4	Other	Denmark
120		10	Family owned, family CEO		100	0
117		3	Private Individuals	UK	57	5
145		8	Founder		40	3
2209		5	Other	Denmark	50	20
450		10	Other	UK	20	5
600		5	Dispersed Shareholders	UK	90	20
2500	85	3	Private Individuals	France	5	0
3000		2	Dispersed Shareholders	UK	5	0
200		6	Dispersed Shareholders	UK	20	0
110		7	Founder	UK	70	0
2000	10	4	Private Equity	Sweden	25	0
380		5	Private Equity	US	40	2
140		10	Family owned, family CEO	UK	20	3
450		7	Private Equity	UK	33	0
1200	30	5	Other	UK	85	7
500		10	Dispersed Shareholders	UK	50	5
160		10	Dispersed Shareholders	US	75	0
182		10	Private Individuals	Luxembourg	50	0
250		10	Private Individuals	UK	50	20
850	25	2	Government	France	95	20
345		6	Private Individuals	UK	50	60
110		10	Dispersed Shareholders	Japan	40	3
300	10	5	Family owned, family CEO	UK	15	0
100		10	Founder	UK		0
500	80	5	Founder	Japan	6	3
180	95	3	Managers	UK	65	10
200		8	Private Equity	Finland	30	0
400	1	10	Private Individuals		25	0
250		10	Dispersed Shareholders	US	30	3
328			Family owned, family CEO	UK	40	0
290	60	10	Family owned, family CEO		30	40
600	0	10	Private Equity	Netherlands	30	5
450	70	10	Dispersed Shareholders		10	0
150		3	Dispersed Shareholders	US	75	0
120	20	3	Private Individuals	UK	25	0
280	3	10	Family owned, family CEO	UK	25	5
431	90	10	Dispersed Shareholders	Japan	100	85
1579		10	Private Individuals	Sweden	25	0
245		6	Dispersed Shareholders	UK	30	0
100		2	Founder		0	0
350	40	4	Family owned, family CEO	UK	20	15
200		3	Family owned, family CEO	UK	45	0
150		5	Dispersed Shareholders	UK	25	0
401	10	9	Dispersed Shareholders	US	50	5
125	0	10	Managers		25	0
298	0	3	Dispersed Shareholders	Spain	15	1
294		5	Dispersed Shareholders	Sweden	50	4
130		6	Founder	UK	80	50
150	30	5	Managers	Ireland (Uk)	30	5
270		3	Other	France	25	0
138		10	Family owned, family CEO	UK	2
114	5	10	Family owned, family CEO	US	20	5
850	50	10	Family owned, family CEO		50	10
250	20	10	Family owned, family CEO		50	0
260		10	Founder	UK	30	2
750	20	5	Dispersed Shareholders	France	70	30
120		10	Dispersed Shareholders	Canada	90	13
550	50	8	Managers	UK	11	1
190	35	5	Private Individuals		50	5
750	0	10	Private Individuals		40	2
1000		10	Dispersed Shareholders	Switzerland	90	10
192	90	6	Dispersed Shareholders	Sweden	50	20
399	20	10	Family owned, external CEO	UK	20
117		4	Founder	Germany	1	0
200		10	Dispersed Shareholders	US
300		10	Family owned, family CEO	UK	50	0
500		5	Family owned, family CEO	Denmark	30	5
135		1	Private Equity	UK	20	0
500		1	Dispersed Shareholders	US	15	0
320	5	5	Family owned, external CEO		50	0
260	0	9	Family owned, family CEO		18	1
120		4	Family owned, family CEO	UK	1	3
2000		10	Government	Sweden	20	0
205		8	Family owned, external CEO	UK	35	5
271		10	Private Equity	US	75	10
146		8	Private Individuals	UK	2	98
723	90	6	Dispersed Shareholders	Australia	67	10
150		10	Founder		50	2
350		7	Government	Norway	100	15
320	2	2	Private Equity		50	6
529		4	Dispersed Shareholders	UK
486		10	Family owned, external CEO	US	14	2
420		10	Dispersed Shareholders	US	90	5
120	2	3	Founder	Germany	40	20
120		10	Private Individuals	Italy	20	0
140	90	0	Dispersed Shareholders	US	90	80
1500		5	Dispersed Shareholders	UK	95	10
300		1	Dispersed Shareholders	UK	70	15
170		3	Founder		0	0
100	5	10	Founder		50	0
427		5	Dispersed Shareholders	US		0
2000	5	2	Private Individuals		70	0
800		10	Family owned, external CEO	US	50
250	40	10	Dispersed Shareholders	US
250		10	Family owned, family CEO	UK	10	0
600	60	5	Private Equity	UK	33	5
160		10	Private Equity		0	0
180	0	5	Dispersed Shareholders	UK
279		10	Family owned, family CEO	UK	100	0
110		10	Founder	UK		13
145	35	10	Founder		10	5
100	50	10	Private Individuals	UK	50	3
250	15	2	Family owned, external CEO		12	0
190		6	Private Equity	Sweden	15	0
1768		2	Managers	UK	25	2
200		10	Private Individuals
4000		5	Dispersed Shareholders	US	85	10
500		10	Managers	UK	5
234	8	3	Private Equity	Netherlands	8	0
475		10	Dispersed Shareholders	US	40	1
150		2	Dispersed Shareholders	US	80	10
800		10	Private Equity		60	0
200		5	Private Individuals	UK	70	5
600	15	4	Family owned, external CEO		15	0
150		10	Private Individuals	US	80	0
1000		10	Dispersed Shareholders	France	40	8
2000		1	Dispersed Shareholders	UK	50	2
1161	80	5	Dispersed Shareholders	US	50	5
830			Other
230			Private Individuals
1200		10	Private Individuals	UK	20	0
170		10	Dispersed Shareholders	UK	60	2
1000		5	Dispersed Shareholders	UK	50	3
110		5	Founder		61	0
650		10	Dispersed Shareholders	US	90	10
300		10	Managers	UK	60
280	22	10	Private Individuals	UK	35	5
180	0	6	Managers		0	2
209		10	Private Individuals	Germany	95	6
3000	1	3	Dispersed Shareholders	Sweden	33	0
4400		10	Private Equity	US	100	0
115	20	10	Family owned, external CEO		20	0
170		4	Family owned, family CEO	UK	100	5
214	70	3	Dispersed Shareholders	US	14	0
300		5	Dispersed Shareholders	Sweden	50	0
119	60	7	Family owned, external CEO	Germany	70	10
370	70	3	Private Individuals	UK	50	20
3300		7	Dispersed Shareholders	UK	15	0
202	15	3	Other		25	0
120		10	Family owned, external CEO	US	100	20
370		4	Dispersed Shareholders	US	40	7
2500		5	Other	Luxembourg	100	30
160		6	Dispersed Shareholders		0	0
180		5	Private Individuals	UK	1	0
200		10	Dispersed Shareholders	US	50	0
171	75	5	Dispersed Shareholders	US	50	5
400		5	Dispersed Shareholders	US	100	10
200		10	Family owned, family CEO	UK	50	60
1000		3	Founder	UK
2500	2	5	Private Equity	Belgium
350		10	Dispersed Shareholders	UK	20	1
225	4	8	Dispersed Shareholders	Japan	10	0
250		5	Private Individuals	UK	10	0
200		5	Family owned, external CEO	UK	80	20
153	40	2	Founder		57	3
100		5	Dispersed Shareholders	US	90	1
205		10	Founder	UK	70	10
120		4	Managers	Ireland	92	5
450		6	Private Equity	UK	0	0
500		6	Family owned, family CEO	UK	9	4
350		3	Dispersed Shareholders	UK	50	1
300		4	Dispersed Shareholders	US	60	20
375		4	Family owned, external CEO	UK	60	5
375		10	Family owned, external CEO	UK	40	3
426		10	Dispersed Shareholders	US	25	0
120	75	10	Dispersed Shareholders	US	80	2
392	50	10	Dispersed Shareholders	UK	33	3
303		5	Private Individuals	US	0	0
150		5	Managers	UK	20	2
320	33	10	Private Individuals		50	1
2000	0	4	Private Individuals	US	10	2
175		10	Founder	UK		0
1877	60	2	Private Individuals	Germany	100	3
150		10	Private Individuals	UK	60	0
170		1	Dispersed Shareholders		50	0
200	98	10	Private Individuals	Switzerland	50	10
301		9	Private Individuals	Finland	80	5
2000	100	5	Dispersed Shareholders	Japan	27	3
1000		10	Dispersed Shareholders	UK	38	0
330		10	Dispersed Shareholders	UK	99	75
143	45	10	Family owned, external CEO		0	2
245	40	4	Dispersed Shareholders	UK	75	4
850		10	Private Individuals	UK	20	1
900	10	4	Private Individuals	Spain	10	5
4060	20	5	Dispersed Shareholders	Austria	30	10
224	50	5	Family owned, family CEO		80	50
100	50	10	Managers		30	0
350		10	Private Equity		50	50
120		1	Dispersed Shareholders	South Africa	10	0
520	15	10	Private Individuals	Hong Kong	10	0
250	45	3	Dispersed Shareholders	UK		5
160	5	5	Family owned, family CEO		25	0
201		10	Other	UK
107	25	5	Family owned, family CEO		10	0
550	70	5	Private Individuals	US	50	10
500		5	Dispersed Shareholders	Australia	0	0
300		10	Family owned, family CEO	UK	25	0
400		10	Family owned, family CEO	UK		0
180	95	10	Private Individuals		50	10
378	30	10	Family owned, family CEO		90	30
200		1	Dispersed Shareholders	Finland	0	0
550		1	Dispersed Shareholders		60	10
160		10	Family owned, family CEO		0	2
240		10	Family owned, family CEO	UK	13	8
3000	40	5	Private Individuals	Switzerland	50	5
250		5	Dispersed Shareholders	UK	100	5
403	60	8	Family owned, family CEO	Germany	90	30
135	15	10	Family owned, family CEO		25	10
200		10	Managers	UK	25	25
100	10	2	Managers		100	11
118			Dispersed Shareholders	Germany
250			Dispersed Shareholders	Austria	2	1
585		10	Dispersed Shareholders	UK
150	98	6	Founder		50	0
180		1	Private Equity	UK
175	15	5	Dispersed Shareholders	Australia	15	5
400		3	Founder	UK	50	0
105		3	Dispersed Shareholders	UK	95	0
220	2	10	Dispersed Shareholders		60	5
240		10	Family owned, family CEO		3	1
130		10	Founder		75	12
1000		4	Dispersed Shareholders	UK	50	50
850		10	Private Individuals	US	95
120	7	5	Dispersed Shareholders	Norway	50	5
500		10	Private Equity	US	60	2
250	7	5	Private Individuals		80	20
217			Private Individuals	UK	5	0
180	1	10	Founder		35	2
500	30	3	Private Equity	US	50	35
488			Private Individuals	UK	0	0
250	90	10	Dispersed Shareholders	Japan	55	0
225		4	Dispersed Shareholders	Holland	60	5
1500		5	Dispersed Shareholders	UK		0
1000	99	4	Dispersed Shareholders	UK	100	5
120		10	Family owned, family CEO		87	30
150		3	Founder	Japan	0	15
143		10	Other	US	34	0
580	5	4	Founder		25	0
220	2	10	Founder		50	5
402		6	Family owned, family CEO	Germany	0	0
120	0	10	Founder		30	10
110		6	Managers		0	0
4500	80	8	Private Equity	US	20	3
1000		7	Government	France	90	40
180		6	Private Equity		70	10
135		5	Dispersed Shareholders	UK	80	40
256		5	Dispersed Shareholders	Finland	50
100	0	10	Private Individuals		38	0
200	30	10	Private Individuals	UK	20	5
650		6	Family owned, family CEO	Germany	50	2
229		3	Dispersed Shareholders	UK	0	0
2000		4	Dispersed Shareholders	US	100	0
850	95	3	Family owned, family CEO		95	75
300		10	Founder	UK	20	0
550		4	Other		10	1
200		3	Managers	UK	95	1
2000		10	Dispersed Shareholders	UK	80	50
110	25	6	Founder		35	0
749		5	Founder	Ireland	20	3
1200		10	Dispersed Shareholders	UK	10	30
110		8	Family owned, family CEO	UK	0	0
155	80	3	Dispersed Shareholders	UK	100	5
300	50	10	Family owned, external CEO		0	0
104		6	Family owned, family CEO	Germany	80	15
140	0	10	Founder		30	0
350		4	Family owned, family CEO	UK	12	2
180	70	2	Dispersed Shareholders	US	20	2
3961	10	10	Dispersed Shareholders		99	70
2000		10	Dispersed Shareholders	Switzerland	75	8
220		2	Founder	US	1	0
200	50	10	Other	UK	10	0
500		10	Dispersed Shareholders	US	60	5
135		3	Dispersed Shareholders	Sweden	30	0
110	10	2	Founder		38	5
201		10	Other	UK
200		5	Private Individuals	Netherlands	45	20
350		10	Founder			10
800		6	Private Equity		30	7
1000		2	Private Equity	Netherlands	66	0
3500	66	3	Dispersed Shareholders	France	50	50
400	60	10	Founder		80	10
2500		8	Family owned, family CEO	US	50	10
250		6	Family owned, family CEO	UK		10
700	10	5	Private Individuals	US	16	5
250			Private Individuals	UK	0	0
3000	0	6	Dispersed Shareholders		60	20
1800		10	Founder	UK	22	1
120		5	Dispersed Shareholders	UK	25	0
450	85	3	Family owned, family CEO
180	100	6	Family owned, external CEO		80	3
394		4	Family owned, family CEO	UK	0	0
160		10	Founder	UK	0	0
310		6	Private Individuals	Germany	100	5
350	0	2	Dispersed Shareholders	Denmark	25	5
130		8	Dispersed Shareholders	US	66	15
100		10	Family owned, family CEO	UK	33	0
2500	100	3	Private Individuals	Ireland (Uk)	100	10
2500	95	4	Dispersed Shareholders	US	50	0
190		10	Dispersed Shareholders	US	80	5
1000		5	Family owned, external CEO		50	10
130		6	Managers	UK	0	2
250			Dispersed Shareholders	UK	0	0
247		4	Managers		10
350	40	10	Private Equity		10	12
120		5	Family owned, external CEO	Canada
155		10	Managers	US	10	1
140	5	5	Other	Netherlands	29	0
310	10	5	Dispersed Shareholders	Germany	30	0
145	3	10	Family owned, family CEO		50	0
600		10	Dispersed Shareholders	France
500		2	Family owned, external CEO		5	0
130	0	1	Private Individuals		50	0
150		10	Dispersed Shareholders	UK	100	5
300	0	10	Dispersed Shareholders	US	10	0
200	25	1	Family owned, family CEO		50	0
250		5	Family owned, family CEO	UK	0	5
1500		6	Family owned, family CEO	US	90	5
109		10	Founder	UK		0
3500		2	Dispersed Shareholders	UK	25	0
250			Dispersed Shareholders		50	10
250	0	10	Other		20	5
1300		3	Dispersed Shareholders	Japan	66	10
250	100	4	Dispersed Shareholders	UK	90	5
1000	99	3	Dispersed Shareholders	UK	50	10
110	18	3	Managers		80	50
180		10	Dispersed Shareholders	UK	70	1
600	1	10	Other		0	5
3326		1	Dispersed Shareholders	UK	100	50
145		10	Family owned, family CEO	UK	50	1
1100		3	Family owned, family CEO	Ireland (Uk)	50
320	30	6	Private Individuals	UK	70	2
380	89	10	Dispersed Shareholders	UK		0
100		3	Family owned, family CEO	UK	15	0
119	0	6	Dispersed Shareholders	Germany	20	10
2300		3	Dispersed Shareholders	UK	50	10
2800	73	10	Managers		70	5
250		2	Founder		20	0
120		5	Private Individuals	UK	10	10
200		0	Family owned, family CEO	Switzerland	40	10
220		10	Private Individuals	Germany	80	5
1347		10	Dispersed Shareholders	UK
2700	60	5	Dispersed Shareholders	US	75	0
2996		8	Private Individuals	US	5	5
600	80	10	Dispersed Shareholders	UK	80	6
400	25	6	Dispersed Shareholders	UK	80	75
310		4	Family owned, external CEO	Germany
300		10	Family owned, family CEO	UK	20	12
2000	95	10	Dispersed Shareholders	Japan	2	2
270		10	Other	Belgium	30
472	80	10	Dispersed Shareholders	Germany	10	0
125	40	10	Managers		50	8
1409		10	Private Equity	Belgium	10	2
122		8	Founder		30	0
250		5	Managers	UK	25	7
105		5	Private Individuals	Hong Kong	95	20
237	33	10	Family owned, family CEO		30	0
100		6	Founder	UK	0
350		10	Private Equity	UK	30	5
250	75	4	Dispersed Shareholders	US	35	10
300	2	2	Dispersed Shareholders		33	2
140		6	Family owned, family CEO	UK	50	10
3500		3	Family owned, family CEO		17	2
450		10	Dispersed Shareholders	Switzerland	95	2
1700		10	Private Equity	US	100	2
650		6	Dispersed Shareholders	UK	66	5
503	0	10	Dispersed Shareholders	US
900	5	1	Family owned, family CEO	US	50	5
250		3	Founder	UK	5	0
205		6	Private Individuals	US	60	3
300		8	Family owned, external CEO	UK	34
550	60	4	Other	Germany	50	5
122		5	Family owned, family CEO		2	1
3500		4	Founder	Ireland	3	5
350		5	Private Equity	US	20	8
280		3	Dispersed Shareholders	UK	2	1
300	50	10	Dispersed Shareholders	US	80	20
700		10	Private Equity	UK	25
100	15	3	Family owned, family CEO		60	2
100		10	Managers	UK	50
250		10	Dispersed Shareholders	UK	50	2
1100		2	Private Equity	US	80	3
548		6	Dispersed Shareholders	Germany	60	3
350	80	4	Dispersed Shareholders	UK	90	0
170		1	Other		25	0
192		3	Private Equity	UK	75	0
150		6	Dispersed Shareholders		25	2
100	50	4	Managers		65	5
350	30	10	Private Individuals		0	0
250		10	Private Equity	UK		30
2000		3	Dispersed Shareholders	US	50
100	50	6	Private Individuals	UK	50	1
100		5	Private Individuals	US	50	0
169	95	10	Dispersed Shareholders	US	30	10
125	0	10	Family owned, family CEO		40	0
200		10	Managers		50	20
145	85	5	Private Individuals	UK	25	0
250	5	10	Founder		2	10
450		4	Private Equity	UK	25	5
180		10	Dispersed Shareholders	US	50	10
160		3	Dispersed Shareholders	Austria	50	25
1000	90	5	Dispersed Shareholders	US	90	60
152		3	Family owned, family CEO		10	20
400	90	3	Managers	UK	20	4
300		4	Private Individuals		30	5
142	75	4	Dispersed Shareholders	US	10	1
190		6	Family owned, external CEO		0	0
330		8	Family owned, external CEO	Germany	30	0
350		3	Family owned, family CEO	UK	15	1
350		10	Dispersed Shareholders	UK	20	1
220		10	Private Individuals		50	15
129		10	Dispersed Shareholders	Japan	5	0
150		1	Founder	UK	50	50
1000		5	Dispersed Shareholders	UK	10	10
450	60	3	Dispersed Shareholders	Japan	30	1
140		4	Family owned, family CEO	UK	50	20
300		6	Private Equity	US	10	0
250	70	5	Private Individuals	Germany	30	30
150		10	Dispersed Shareholders	UK	25
250		10	Family owned, external CEO	Germany	75	15
2500	4	8	Private Equity	UK	60	8
380	90	10	Family owned, family CEO	Japan	70	10
250		5	Dispersed Shareholders	Australia	2	0
200		4	Private Individuals	UK	10	5
1000	40	10	Family owned, family CEO	UK	50	10
120		10	Family owned, family CEO	UK
2000		2	Family owned, family CEO	UK	33	5
130		6	Dispersed Shareholders	UK	50	5
450	98	3	Dispersed Shareholders	US	30	2
220		10	Dispersed Shareholders	US	50	5
121		10	Dispersed Shareholders	US	60	0
700	25	10	Founder		0	0
110		8	Managers		50	5
635	50	8	Dispersed Shareholders	UK	50	25
120	0	10	Dispersed Shareholders		0	0
750		4	Family owned, family CEO	UK	10
150		10	Family owned, family CEO	UK	25
200		7	Private Individuals		80	20
1500		6	Dispersed Shareholders	UK	50	0
410	100	10	Dispersed Shareholders	US	100	30
225		6	Private Individuals	UK	0	0
300		10	Dispersed Shareholders	US	80	50
100		6	Founder		2	3
150		10	Managers	Ireland (Uk)	2	0
3000		10	Dispersed Shareholders	Japan	20	0
1000		10	Dispersed Shareholders	Canada	50	7
145	70	6	Managers	UK	66	10
132	1	10	Private Individuals
200	0	5	Dispersed Shareholders	Canada	50	5
100	0	2	Family owned, family CEO		50	10
119	10	10	Founder		0	0
160	2	10	Founder		50	0
550		4	Private Equity	UK	75	10
251		5	Dispersed Shareholders	Netherlands	60	5
370	25	3	Family owned, family CEO		100	10
170		6	Dispersed Shareholders	UK	8	0
3000	50	10	Dispersed Shareholders	Japan	0	0
125		10	Family owned, external CEO	UK	50	6
2996		6	Private Individuals	US	20	2
100		10	Private Individuals		0	0
180		5	Private Individuals	Netherlands	60	30
330		6	Dispersed Shareholders	US	95	70
280	15	8	Managers	UK	30	0
355	60	5	Private Individuals		0	0
517		10	Dispersed Shareholders	France	100
148	20	5	Private Individuals		20	0
258		6	Dispersed Shareholders	Japan	28	0
166	5	10	Family owned, family CEO		20	0
215	80	10	Founder		50	0
205		10	Private Individuals	Germany	100	10
100		0	Founder	UK	75	30
1500		5	Dispersed Shareholders	UK	100	50
450	30	3	Dispersed Shareholders	US	75	75
230	5	5	Family owned, family CEO		70	0
350		1	Government	Norway	70	10
500		10	Managers	UK	20	10
303		10	Dispersed Shareholders	UK	0	0
557		6	Private Equity	UK	10	2
600	0	1	Dispersed Shareholders		1	0
1500		8	Dispersed Shareholders	UK	50	15
150		10	Founder	UK	33	20
200		8	Private Individuals		43	1
1140		3	Dispersed Shareholders	US	14	5
589		9	Dispersed Shareholders	UK
240	15	2	Family owned, external CEO		65	0
260	10	3	Founder		50	0
550		10	Other	US	5	5
200	0	6	Private Individuals		0	0
381		10	Founder	Netherlands	20	2
2500	2	10	Dispersed Shareholders		70	20
300		5	Family owned, family CEO		50	0
360		7	Private Equity	Sweden	80
800		5	Dispersed Shareholders	US	33	20
242		3	Dispersed Shareholders	US	80	20
120		2	Private Equity	UK	5	0
150	10	10	Private Individuals
293			Dispersed Shareholders	UK	100
150		8	Dispersed Shareholders	Germany	75	15
125		10	Family owned, family CEO	UK	10	0
600		10	Family owned, family CEO	US	100	5
250	0	7	Private Individuals		0	0
340	75	10	Dispersed Shareholders	Japan	20	0
478	100	1	Dispersed Shareholders	US	9	0
160		7	Dispersed Shareholders	UK	60	0
4000		10	Family owned, family CEO	France	75	0
170			Private Individuals	UK
550		5	Family owned, family CEO	Austria	20	0
2000		8	Dispersed Shareholders	UK	50	20
140		4	Dispersed Shareholders		40	5
160	30	10	Dispersed Shareholders	Germany	30	5
1500		6	Family owned, external CEO	UK	90	80
105		10	Other	UK
220		4	Private Equity	UK	50	5
600		1	Dispersed Shareholders	UK	70	5
2000		2	Family owned, external CEO	UK	50	15
400	50	6	Family owned, family CEO	UK	15	13
1500	28	4	Private Individuals	Germany	29	1
400		4	Dispersed Shareholders	UK	35	0
300	83	10	Dispersed Shareholders	UK
120			Dispersed Shareholders	UK
176		10	Dispersed Shareholders	Finland	33	3
500	70	5	Private Individuals	UK	18	2
150		3	Private Individuals	UK
2000		10	Dispersed Shareholders	UK	30	20
280		10	Dispersed Shareholders	US	100	30
700		7	Family owned, family CEO		0	0
3326		6	Dispersed Shareholders	UK	50	0
120	4	10	Dispersed Shareholders	UK	100	7
203	10	10	Founder	US	50	10
700		10	Managers	US	5	5
534		10	Other	Greece	98	5
3000		5	Dispersed Shareholders	US	90	10
1049	90	4	Dispersed Shareholders	US		5
300		10	Family owned, family CEO		30	15
109		10	Dispersed Shareholders	Japan	0	0
2359	0	1	Private Individuals	US	2	0
115		5	Family owned, family CEO	UK	0	0
250			Founder	UK	0	0
180		10	Dispersed Shareholders	Singapore	100	0
250		4	Family owned, family CEO	UK	25	0
199	20	3	Family owned, family CEO	Canada	33	0
220		10	Private Individuals	UK	60	5
500		2	Private Individuals	Germany	2	0
550	0	6	Private Individuals	UK	50	0
250		0	Dispersed Shareholders	Brazil	75	5
100		3	Dispersed Shareholders	UK	25	33
178		4	Dispersed Shareholders	Holland	90	10
1020	35	6	Other	India	50	15
280		10	Private Equity	UK	80	2
161	80	1	Private Individuals	Germany	60	10
2000		2	Other	UK	33	5
309			Private Individuals	UK
250		10	Dispersed Shareholders	US	33	20
2000	99	6	Founder		4	4
115	30	4	Founder		0	5
1461		10	Dispersed Shareholders	UK	30	5
180	0	10	Founder		100	20
180	50	6	Founder		50	10
1300	80	6	Dispersed Shareholders		45	10
650		4	Dispersed Shareholders	Greece	60
180		7	Dispersed Shareholders		100	8
1914	100	4	Dispersed Shareholders	US	100	5
600	0	3	Dispersed Shareholders		25	0
500	35	10	Dispersed Shareholders	UK	40	5
340	30	10	Dispersed Shareholders		20	1
128		1	Dispersed Shareholders	US	50	0
2300		6	Private Equity	UK	0	0
600	50	10	Dispersed Shareholders		100	0
1300		3	Dispersed Shareholders	UK	15	0
720		10	Dispersed Shareholders	Japan
230		10	Dispersed Shareholders	UK	100	80
260	50	10	Private Individuals		60	10
2000		4	Family owned, external CEO	Denmark
230		10	Family owned, family CEO	UK	2	0
220	2	10	Private Individuals		8	2
2626	100	10	Dispersed Shareholders	Sweden	50	5
190		3	Managers	China	50	20
500		6	Private Individuals	US
220		3	Private Individuals	UK	30	0
111	0	4	Private Individuals	Portugal	90	0
400	20	4	Family owned, family CEO
750		6	Other	UK	50	2
500		3	Dispersed Shareholders	UK	90
1500		0	Dispersed Shareholders	UK	25	18
400		3	Other	Germany	66	25
200	10	5	Private Individuals		15	0
2000			Dispersed Shareholders	UK	50	5
173			Dispersed Shareholders
250		10	Founder	UK	75	10
420		10	Family owned, family CEO	UK	30	10

The data to the left shows the analysis of 1105 UK companies resposnes to a questionnaire. Using the data given to you, insert Pivot Tables to show the following: 1. The distribution of employees by ownership versus country of parent company. (3 marks) 2. The distribution of average percentage of managers with degrees by country of parent company versus ownership. (3 marks) 3. The distribution of average percentage of non-managers with degrees by country of parent company versus ownership. (3 marks) 4. The distribution of the number of competitors by ownership versus country of parent company. (3 marks) 5. The distribution of the average number of employees by ownership versus country of parent company. (Whole numbers) (3 marks) 6. The distribution of the standard deviation (STDEV) of number of employees by ownership versus country of parent company. (Whole numbers) (3 marks) 7. The count of the number of competitors by ownership versus country of parent company. (2 marks) Total marks (20 marks) The Moodle quiz will ask you to enter various (but not all) numeric values from your pivot tables. Format all stdev and average data with 0 decimal places and format all count data with zero decimal places. You must not sort the data in any other order. Data source: http://worldmanagementsurvey.org/ Key to column headings: emp_firm number of employees export percentage of production exported competition number of competitors ownership who owns the firm mne_country country of parent company degree_m percentage of managers with a degree degree_nm percentage of non-managers with a degree

Pictures of data (30 marks)

English Rugby Union Premiership League Data from 2013-14 Season
Position	Team	Won	Drawn	Lost	For	Against	Diff	Points	Total Attendance	Avg Attendance	The Won, Drawn and Lost columns refer to the number of games.
	Bath Rugby	14	2	6	495	388		67	130,897		The For, Against and Diff columns refer to the number of game points scored in all games.
	Exeter Chiefs	9	0	13	426	480		45	98,840		The Points column refers to the number of league points awarded
	Gloucester Rugby	8	0	14	440	539		44	154,160
	Harlequins	15	0	7	437	365		67	207,263
	Leicester Tigers	15	2	5	542	430		74	251,377
	London Irish	7	0	15	396	496		36	155,056
	London Wasps	9	0	13	451	533		49	153,691
	Newcastle Falcons	3	0	19	281	544		22	56,491
	Northampton Saints	16	2	4	604	350		78	157,501
	Sale Sharks	12	0	10	432	399		57	69,851
	Saracens	19	0	3	629	353		87	179,651
	Worcester Warriors	2	0	20	325	581		16	88,694
	Source
	http://www.premiershiprugby.com/stats

Below is some data from the 2013-14 English Rugby Union Premiership 1. Determine the position in the league for each team and put the answer in the 'Position' column. (3 marks) 2. Calculate the points difference for each team by putting a formula in the 'Diff' column. (3 marks) 3. Calculate the average attendance for each team rounded to nearest whole number by putting a formula in the 'Avg Attendance' column. (3 marks) 4. Format the table using the “Insert Table” option (choose a pattern which you think is attractive). Include an extra row above the table with the text “English Rugby Union Premiership League Data from 2013-14 Season”. Use Merge and Centre to have the text spanning the width of the table. (3 marks) 5. Sort the table by Team's Name. (2 mark) 6. Use “Insert” Tab to draw a Column Chart showing the Average Attendance for the clubs. Use “Chart Tools, Layout” to include:- Title, Vertical Axis Title, Value Data Labels. The chart should show attendances on the vertical axis and club names along the horizontal axis. (5 marks) 7. Produce another instance of the table below the chart just drawn. Copy and Paste the whole table. Sort the table by the League position. (4 marks) 8. Use “Insert” Tab to draw a Line Chart showing the Average Attendance for the clubs on the vertical axis and the League position on the horizontal axis. Use “Chart Tools, Layout” to include:- Title, Vertical Axis Title, Value Data Labels. (5 marks) 9. What conclusion, if any, might you make from looking at this graph? Use a Call-out to give a simple description of your conclusion. Overlay the Call-out on the Chart. (2 mark) Total marks (30 marks) All teams played 22 games. Source http://www.premiershiprugby.com/stats

Descriptive stats (50 marks)

Using Microsoft Excel for Descriptive Sample Statistics
	This worksheet contains numerical descriptive statistics and histograms and ogives produced using Excel.
Suppose the sales values below have been recorded during the day in a small shop.
Describe the data. Put your formulae/answers in the shaded cells.
marks
										1)
Raw Data Author: Mahmut (Maho) Sonmez: I have named the cells below raw_data, using Insert - Name - Define or Insert - Name - Create		Descriptive sample statistics using raw data
£16.31		n		1	min		1
£20.40		mean		1	max		1
£20.40		median		1						Five-point summary
£16.79		mode		1						min
£17.31		range		1						first quartile	1
£17.74		MAD		MAD: mean absolute deviation			1			median
£4.85		variance samp		sample			1			third quartile	1
£13.11		variance popl		population)			1			max
£13.75		St Dev samp		sample			1
£23.40		St Dev popl		population)			1			IQR	1
£23.32		CV (coef of variation)					1			Inner fences		1	1
£16.99		skew					1			Outer fences		1	1
£11.28		kurtosis					1
£12.18
£10.42											Put box and whisker plot here ê			5
£24.62		Data Grouping
£6.93		class width	10
£12.08		Class	Lower	Upper	Midpoint	Frequency	Cumulative
£11.49			class limit	class limit	M	f	Frequency
£21.94			£	£	£			f	cf
£27.17		1	0.01					1
£22.53		2						1	1
£15.51		3						1
£11.63		4							1
£17.31		5						1
£28.27		6							1
£12.12		7						1
£5.73		8							1
£12.89		9						1	1
£19.36					SUM:
£6.27
£17.52
£21.13		HISTOGRAM:
£10.53
£17.84
£19.05		Put histogram here ê
£22.82												5
£13.18
£17.92
£9.04
£6.80
£12.37
£8.02
£12.05
£8.37
£11.98
£11.85
£15.15
£19.41
£19.48
£49.31
£51.98
£54.29
£41.26
£62.25
£48.04
£24.90
£19.86
£48.30
£46.95
£45.46
£54.12			2)									5
£76.18			description of box and whisker here è
£35.50
£50.57
£64.93
£65.80		Put descriptive statistics here
£29.20		ê
£52.12				2
£54.17
£61.48
£49.65
£69.16
£22.80
£62.19
£23.86
£39.96
£47.11
£52.92
£65.34
£44.97
£43.02
£40.96
£49.38
£63.76
£68.34
£37.73
£31.94		total marks	50
£40.24
£33.59
£38.60
£32.77
£71.90
£36.16
£55.08
£59.43
£75.09
£65.48
£61.93
£54.25
£52.15
£37.86
£40.22
£34.55
£46.54
£41.39
£64.15
£71.72
£50.60
£60.17
£52.33
£44.46
£25.48
£53.54
£48.23
£50.52
£63.44
£51.05
£21.06
£32.59
£37.00
£32.63
£55.48
£38.38
£30.46
£31.37
£84.78
£44.86
£57.90
£42.90
£55.84
£66.99
£45.04
£49.61
£36.47
£45.21
£59.90
£89.68
£39.28
£25.12
£46.09
£49.40
£54.33
£60.47
£51.66
£57.32
£43.94
£43.23
£58.71
£44.41
£53.06
£53.52
£58.12
£1.46
£56.79
£59.59
£52.36
£67.40
£59.76
£48.41
£30.78
£58.95
£55.60
£64.28
£36.72
£54.15
£48.46
£34.31
£64.58
£47.07
£46.97
£42.89
£42.91
£29.26
£41.33
£35.73
£47.50
£63.16
£52.61
£30.40
£55.25
£47.92
£46.64
£54.94
£42.85
£41.34
£70.43
£52.02
£41.19
£67.44
£59.08
£42.62
£35.35
£35.88
£52.94
£24.66
£33.85
£88.59
£69.89
£17.10
£64.89
£56.76
£46.15
£60.35
£38.36
£56.30
£42.82
£48.96
£69.99
£46.46
£26.17
£61.67
£56.93
£63.41
£56.99
£57.09
£52.63
£39.79
£49.59
£42.10
£50.59
£35.08
£56.49
£51.15
£49.04
£45.95
£36.08
£47.14
£50.16
£42.93
£51.15
£36.22
£35.38
£54.20
£64.49
£54.02
£40.71
£57.69
£40.45
£58.76
£64.97
£56.28
£64.20
£63.60
£65.02
£34.38
£40.48
£38.62
£58.18
£49.85
£43.25
£42.80
£52.81
£68.49
£49.02
£54.61
£43.18
£48.11
£49.62
£60.49
£38.63
£45.95
£39.34
£47.97
£65.08
£61.30
£53.16
£35.55
£47.17
£51.70
£52.63
£42.58
£58.74
£62.45
£45.93
£45.01
£53.07
£42.42
£45.71
£61.69
£37.15
£51.86
£48.83
£67.50
£52.40
£57.53
£37.80
£14.27
£40.57
£62.46
£33.83
£37.30
£46.37
£54.92
£78.93
£68.36
£64.11
£40.28
£54.16
£39.70

1) Calculate the lower and the upper quartiles for the data. Hence, calculate the inner and outer fences to draw a box and whisker plot. 2) By looking at your box and whisker plot, are the data skewed? If so, how? Given the box-and-whisker plot, do you think the mean and standard deviation are appropriate summary statistics? (You should explain your answer briefly).

Linear Programming (20 marks)

							marks
Variables	V1	V2
Values							4
Objective
minimize							2
Constraints			Totals	symbol	RHS
							1
							1
							1
							1
Variables	V1	V2
Values							4
Objective
maximize							2
Constraints			Totals	symbol	RHS
space							2
budget							2
						total marks	20

Find the optimal solution to this linear programme: Minimise: 2X + Y subject to: X + Y ≤ 10 X − Y ≤ 2 X ≥ 4 Y ≥ 5 with X and Y greater than or equal to zero.

A political campaign wants to hire photocopiers to make leaflets for a local election. There are two suitable machines:  ACTO costs £120 a month to rent, occupies 2.5 square metres of floor space and can produce 15,000 copies a day.  ZENMAT costs £150 a month to rent, occupies 1.8 square metres of floor space and can produce 18,500 copies a day. The campaign has allowed up to £1,200 a month for copying machines which will be put in a room of 19.2 square metres. Find the optimal solution to this linear programming problem.

Finance (20 marks)

Put calculations/answers hereê

çanswer

Q1 Use Excel formulae or functions to calculate the following to the nearest pound: a) Investing £1,000 over 4 years at an interest rate of 10% (1 mark) b) Investing £1,000 over 4 years at an interest rate of 8% (1 mark) c) Investing £1,000 over 3 years at an interest rate of 11% (1 mark) Q2 We are investing £3,000 pounds today. If we want to accumulate £5,000: (a) what interest rate do we need if we wish to do this in 6 years? (1 mark) (b) If we can get 8%pa return how long will it take? (1 mark) Q3 a) A mortgage APR is 11%, what is the equivalent monthly rate? (1 mark) b) A credit card company charges 2.5% per month, what is the equivalent APR? (1 mark) Q4 Starting immediately, you intend to put £600 away each year for 8 years into an investment that gives a return of 7%. What will be the total amount at the end of the 8th year? (1 mark) Q5 Suppose a couple wishes to save £30,000 before trying to buy an apartment. They plan to start looking in 3 years. Starting now how much do they need to save per month into an account paying an effective 0.46% per month in order to achieve their target in 3 years? (1 mark) Q6 How much would you expect to pay for an annuity (regular annual payment) that gives you £750 at the end of each year for 6 years, at a discount rate of 11%? (1 mark) Q7 A loan of £100,000 to a small business for 10-years is to be repaid annually with an interest rate of 9% per year. a) What will be the annual payments? (1 mark) b) What about if the interest rate was 10%? (1 mark) Q8 If you were looking to invest £30,000 in a small business venture with promised returns of £8,000 over 5 years a) what would the present value be if the discount rate was 10%? (1 mark) b) what would the present value be if the discount rate was 6%? (1 mark) c) what would the internal rate of return be? (1 mark) The presentation and clarity should be of a ‘professional’ nature i.e. easily understood by someone unfamiliar with the task. Make sure your spreadsheet is laid out in a clear manner, is well structured, makes good use of space and has useful explanatory text/comments. You might also consider the use of colour to emphasize certain elements for example. (5 marks) Total marks (20 marks)