QUESTION:Following is the data set for a study done among employees in five selectedorganizations in Copperbelt, Zambia. The research was aimed to study the interrelationship between caffeine intake and Emotional Quotient (EQ), IntelligenceQuotient (IQ) and level of alacrity. Level of alacrity, Emotional Quotient (EQ), andIntelligence Quotient (IQ) were measured using a rating scale that generated a scoreout of 100. The number of teaspoons of coffee consumed per day measured theintake of caffeine among the employees.Gender AgeEducationalQualificationYears ofServiceIncomeperannumCaffeineIntakeLevel ofAlacrityIQScoreEQScoreFemale28Diploma57200011 -15 tsp828173Female23Bachelors3960006-10 tsp679878Male27Diploma71680006-10 tsp736884Female38Bachelors12720000-5 tsp697382Male28Masters116700016-20 tsp817869Male27Bachelors722000011-15 tsp728472Male39Bachelors133000000-5 tsp568263Male26Bachelors92800000-5 tsp546963Female40Bachelors121980006-10 tsp717263Male42Bachelors10960006-10 tsp786381Female30Masters1016800011-15 tsp866398Female32Masters77200016-20 tsp836368Male21Masters36700016-20 tsp848169Female28Masters722000021-25 tsp629872Female32Diploma1230000011-15 tsp676863Male52Bachelors207200016-20 tsp747363Male50Certificate239600016-20 tsp787863Female45Diploma1816800021-25 tsp648481Male32Bachelors127200011-15 tsp588298Male33Bachelors8670006-10 tsp566968Male30Bachelors112200000-5 tsp817273Male51Masters213000006-10 tsp866378Male57Masters2328000011-15 tsp836384Male58Bachelors1819800011-15 tsp846382Female49Bachelors169600016-20 tsp628269Female29Bachelors1116800021-25 tsp676372Female39Masters13720000-5 tsp748164Male34Masters12670000-5 tsp789858Male53Masters192200006-10 tsp646856Male38Bachelors173000006-10 tsp537381Instructions:You are required to enter the data set into SPSS and generate output for thefollowing statistical measurements:-Generate the descriptive statistics for the demographic variables in the study.- Calculate the standard deviation for the variables of income, caffeine intake,Emotional Quotient (EQ), Intelligence Quotient (IQ) and level of alacrity.- Generate the explore statistics for the variables of income, caffeine intake, levelof alacrity, Intelligence Quotient (IQ) score and Emotional Quotient (EQ) scorefor the male and female employees.-. Calculate independent samples T-test for caffeine intake among male and femaleemployees.-. Calculate the correlation between the following variables:• Caffeine intake and Alacrity level• Alacrity and Intelligence Quotient (IQ)• Caffeine intake and Emotional Quotient (EQ)• Emotional Quotient (EQ) and Alacrity level

Question

Accepted Answer

As per the guidelines, the answer to the first three subparts is provided.The given variables in…

Gender	Age	Educational Qualification	Years of Service	Income per annum	Caffeine Intake	Level of Alacrity	IQ Score	EQ Score
Female	28	Diploma	5	72000	11 -15 tsp	82	81	73
Female	23	Bachelors	3	96000	6-10 tsp	67	98	78
Male	27	Diploma	7	168000	6-10 tsp	73	68	84
Female	38	Bachelors	12	72000	0-5 tsp	69	73	82
Male	28	Masters	11	67000	16-20 tsp	81	78	69
Male	27	Bachelors	7	220000	11-15 tsp	72	84	72
Male	39	Bachelors	13	300000	0-5 tsp	56	82	63
Male	26	Bachelors	9	280000	0-5 tsp	54	69	63
Female	40	Bachelors	12	198000	6-10 tsp	71	72	63
Male	42	Bachelors	10	96000	6-10 tsp	78	63	81
Female	30	Masters	10	168000	11-15 tsp	86	63	98
Female	32	Masters	7	72000	16-20 tsp	83	63	68
Male	21	Masters	3	67000	16-20 tsp	84	81	69
Female	28	Masters	7	220000	21-25 tsp	62	98	72
Female	32	Diploma	12	300000	11-15 tsp	67	68	63
Male	52	Bachelors	20	72000	16-20 tsp	74	73	63
Male	50	Certificate	23	96000	16-20 tsp	78	78	63
Female	45	Diploma	18	168000	21-25 tsp	64	84	81
Male	32	Bachelors	12	72000	11-15 tsp	58	82	98
Male	33	Bachelors	8	67000	6-10 tsp	56	69	68
Male	30	Bachelors	11	220000	0-5 tsp	81	72	73
Male	51	Masters	21	300000	6-10 tsp	86	63	78
Male	57	Masters	23	280000	11-15 tsp	83	63	84
Male	58	Bachelors	18	198000	11-15 tsp	84	63	82
Female	49	Bachelors	16	96000	16-20 tsp	62	82	69
Female	29	Bachelors	11	168000	21-25 tsp	67	63	72
Female	39	Masters	13	72000	0-5 tsp	74	81	64
Male	34	Masters	12	67000	0-5 tsp	78	98	58
Male	53	Masters	19	220000	6-10 tsp	64	68	56
Male	38	Bachelors	17	300000	6-10 tsp	53	73	81