In the data set for this homework, you will find that the first six variables ho

In the data set for this homework, you will find that the first six variables hold data linked to the employees’ demographic profiles and the remaining variables provide employees responses on 1 ‘strongly disagree’ to 5 ‘strongly agree’ response scale to assess organizational citizenship behavior (OCB: employees’ voluntary actions that contribute positively to the organization beyond their job duties) and job satisfaction (JSat: positive state toward current job). The variables are as follows:
1.ID (unique employee identifier – categorical variable)
2.Gender (categorical variable)
3.Tenure (quantitative variable)
4.Ethnicity (categorical variable)
5.Department (categorical variable)
6.Salary (quantitative variable)
7.ocb1 (I work harder than my job requires; quantitative variable)
8.ocb2 (I put a huge amount of effort in my job; quantitative variable)
9.ocb3 (I help out my team mates; quantitative variable)
10.ocb4 (I go the extra mile; quantitative variable)
11.JobSat1 (I am satisfied in my job; quantitative variable)
12.JobSat2 (My job is good; quantitative variable)
1.Create a new variable in the dataset labeled “OCB” that is the average of ocb1, ocb2, ocb3, and ocb4.
2.Find the and interpret the Cronbach’s alpha for OCB.
3.Create a new variable in the dataset labeled JSat that is the sum of JSat1 and JSat2.
4.Find and interpret the Cronbach’s alpha for JSat.
5.How could you assess the validity of OCB and job satisfaction? (Note: you do not have to do any analyses, but you can if it is helpful).
6.Create a new variable in the dataset labeled as logSalary that represents the logarithm of salary.
7.Create a new variable in the dataset labeled as sqrtTenure that represents the square root of the Tenure variable.
8.Conduct a t-test to determine the difference in OCB between genders. Write up your results here:
9.Conduct a t-test to determine the difference in job satisfaction between genders. Write up your results here:
10.Conduct an analysis of variance (ANOVA) to determine the difference in job satisfaction among the five departments. Write up your results here:
11.Please submit both this filled in worksheet and your new excel file.
R Output: