Question

Observation	Education (No. of years)	Length of tenure in current employment (No. of years)	Age (No. of years)	Annual income ($)
1	17	8	40	124,000
2	12	12	41	30,000
3	20	9	44	193,000
4	14	4	42	88,000
5	12	1	22	27,000
6	14	9	28	43,000
7	12	8	43	96,000
8	18	10	37	110,000
9	16	12	36	88,000
10	11	7	39	36,000
11	16	14	42	81,000
12	12	4	23	38,000
13	16	17	45	140,000
14	13	7	42	21,000
15	11	6	27	26,000
16	20	4	40	151,000
17	19	7	35	124,000
18	16	12	38	68,000
19	12	2	21	26,000
20	10	6	44	124,000
21	12	3	27	28,000
22	17	9	36	64,000
23	13	5	26	37,000
24	19	12	42	62,000
25	10	7	45	45,000

A survey conducted by a research team was to investigate how the education level, tenure in current employment, and age, are related to annual income. A sample of 25 employees is selected and the data are given above.

Construct a Pivot Table using the provided data, answer the following 3 questions (where necessary, answer in 2 decimal points): a. What is the average annual income for individuals who have had 17 years of education? b. What is the standard deviation of annual income for individuals who have been in the job for 12 years and had 16 years of education? c. How many individuals in the sample have a salary between $120,000 and $129,999? (Hint: use Group Selection).

Answer 1

a.)

Education	Annual Income
17	124000
17	64000

Average Annual Income = 94000

b.)

Education	Tenure in Current Employment	Annual Income
16	12	88000
16	12	68000

Standard deviation of Annual Income = 10000 ( if population formula is used)

Standard deviation of Annual Income = 14142.13 ( if sample formula is used, this should be the correct answer)

c.)

Total Individuals with salary between 120000 and 129999 are 3

Observation	Education	Length of tenure in current employment (No. of years)	Age (No. of years)	Annual income ($)
1	17	8	40	124,000
17	19	7	35	124,000
20	10	6	44	124,000