Statistics Project Part 1 CAS PDF

Preview

Summary

Project Part 1...

Description

1

Statistics Project, Part 1: Opening Data in Microsoft Excel and Running Descriptive Statistics Christina Smith PSYCH 625: Statistics for the Behavioral Sciences

2 Statistics Project, Part 1: Opening Data in Microsoft Excel and Running Descriptive Statistics Statistics is defined as a theory and method of gathering, arranging and organizing, presenting and analyzing data. In this scenario, the data gathered is derived from 50 participants. The data consist of age, relationship with director supervisor, telecommute schedule, relationship with coworkers, workplace happiness rating, and workplace engagement rating. I will determine which variables affect workplace happiness and engagement. The following evaluation is made by running the descriptive statistics on each variable to learn and collect data. Gender By evaluating the information after running the descriptive statistics we can see that our gender information is as follows. We have 24 males and 26 females out of the 50 individuals on this data research. If we interpret in percentage terms, we can conclude that we have 48% of males and 52% females. According to Jackson, (2017). “Bias of gender disparity should be examined to ensure a data-informed approach. As we can see in this data, we have a diversity of genders which makes the information more valid and not bias. Gender Mean

1.52 0.07137

Standard Error Median Mode Standard

1 2 2 0.50467

Deviation

2 0.25469

Sample Variance Kurtosis Skewness

4 -2.07801 -0.08256

3 Range Minimum Maximum Sum Count

1 1 2 76 50

Age We also gather data from different ages which ranged from age 25 years old to 40 years old. As we analyze the data, we see that this variable has a mean of 32.02, a median of 31.5 and a mode of 29. By this information, we can conclude that the most frequent age sample is 29 years old. The range of the population is 15 years. The data shows a high sample variance of 18.83633 and the standard deviation shows of 4.340084. This can be one of the reasons to conclude that is can be a factor in this sample. If more young people are happy, the workplace can be more eager for younger workers. Or we can also represent younger workers to bring happiness to the workplace. Age Mean

32.02 0.61378

Standard Error Median Mode Standard

1 31.5 29 4.34008

Deviation

4 18.8363

Sample Variance Kurtosis Skewness Range Minimum Maximum Sum

3 -1.08642 0.18869 15 25 40 1601

4 Count

50

Supervisors. Other collected data evaluated included the relationship with one’s direct supervisor. In this case, we have a mean of 2.5, a median of 3 and a mode of 3. The standard deviation is 1.015191 and the sample variance is 1.030612. In this sample, the range of population is 3. Having a low sample variance can show that people are not having a comfortable relationship with the supervisor. This can be a problem if you do not feel that you are able to bring your concerns to the supervisor directly. Supervisor Mean Standard Error Median Mode Standard

2.5 0.14357 3 3 1.01519

Deviation

1 1.03061

Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count

2 -1.06177 -0.06096 3 1 4 125 50

Telecommute. Another factor included Telecommute schedules. Some places have telecommuted, which helps people that work at a long distance from the office to work from home. We show a mean of 1.18, a median of 1 and a mode of 1. This tells us that maybe only one person is able to work from home, and this can be a case where the person might have been

5 injured or have disabilities. The standard deviation is 0.388088 and sample variance of 0.150612. Telecommute Mean

1.18 0.05488

Standard Error Median Mode Standard

4 1 1 0.38808

Deviation Sample

8 0.15061

Variance

2 0.98887

Kurtosis

2 1.71782

Skewness Range Minimum Maximum Sum Count

4 1 1 2 59 50

Relationship with Coworkers. Some people are very sociable and like to have a close relationship with coworkers outside the job. Some others are not as sociable, but they participate in any ideas in the office. By analyzing the data, we can conclude that this is not the case in this scenario. The evaluation shows a mean of 1.92, a median of 2, and a mode of 2. It shows a low standard deviation and sample variance as well.

6 Coworkers Mean

1.92 0.09406

Standard Error Median Mode Standard

9 2 2 0.66516

Deviation

8 0.44244

Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count

9 -0.65243 0.08876 2 1 3 96 50

Happiness. Happiness is important in our everyday life. Some people say that if you love what you work for, you never feel that you worked a single day. You enjoy what you do whether it is a field in psychology, or whether is a field in business administration. As we evaluate the information, we can conclude that the mean and the median are about the same, they are at the center of the data. We show a mean of 7.4, a median of 8 and a mode of 8. The sample variance is 2 and the standard deviation is 1.414214. We can say that the workplace is not so high. Happiness Mean Standard Error Median Mode Standard

7.4 0.2 8 8 1.41421

7 Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count

4 2 -0.24984 -0.71252 5 4 9 370 50

Engagement. If we are happy at our work of place, we have better engagement in providing more limited and concentrated benefits. Per our data, we have a mean of 7.74, median of 8 and a mode of 8. The standard deviation is 1.241461 and the sample variance 1.541224. Engagement Mean

7.64 0.17556

Standard Error Median Mode Standard

9 8 8 1.24146

Deviation

1 1.54122

Sample Variance

4 0.85989

Kurtosis Skewness Range Minimum Maximum Sum Count

8 -0.93446 6 4 10 382 50

Overall Rating

8 By analyzing the overall rating, including all the information provided, age, gender, engagement, supervisors, the happiness we can conclude is a balanced place. We have a mean of 15.02, median 15.5 and mode of 16. We have a standard deviation of 2.428487 and a sample variance of 5.897551. We have a range of a population of 11. Overall Rating Mean Standard Error Median Mode Standard

15.02 0.34344 15.5 16 2.42848

Deviation

7 5.89755

Sample Variance

1 0.79715

Kurtosis Skewness Range Minimum Maximum Sum Count

8 -0.95937 11 8 19 751 50

Conclusion Overall, analyzing all information, we can conclude that variables affecting the workplace and engagement of the coworkers will be not having a balanced and open door with a direct supervisor to talk about concerns. As we all know, motivation is key for employees to do their best at work. Another variable affecting happiness and engagement is not being able to work from home. People dealing with long hours of commute may get frustrated and by the time

9 they get home or work, they are upset. Having a diverse age range and gender helped balance the happiness and engagement of the workplace.

Re f e r e nc e s Jackson, S. L. (2017). Statistics plain and simple. (4th ed.). Boston, MA: Cengage Learning. Happiness and Engagement Database....