Descriptive Statistics

The Statistics Project assignment has been broken down into multiple parts and you will complete these parts throughout the course. This week’s assignment allows you to become familiar with opening data and viewing it in Microsoft® Excel® and using the Analysis Toolpak. In research, the individual data points are entered into databases, but for the purpose of this course, the data is provided in a spreadsheet for you in the Happiness and Engagement Dataset.
Imagine you have been asked to enhance workplace happiness and engagement at your company. You have conducted a survey and gathered data on the gender, age, relationship with direct supervisor, telecommute schedule, relationship with coworkers, along with the ratings for workplace happiness and workplace engagement for 50 individuals in your department. You must determine what variables affect workplace happiness and engagement. The first step is to run descriptive statistics on each variable to learn more about the data you have collected.
Calculate descriptive statistics for the following variables in the provided Microsoft® Excel® dataset:

  • Gender
  • Age
  • Relationship with Direct Supervisor
  • Telecommute Schedule
  • Relationship with Coworkers
  • Workplace Happiness Rating
  • Workplace Engagement Rating

Write a 125- to 175-word summary of your interpretation of the descriptive results for each variable. Copy and paste the Microsoft® Excel® output below your summary.
Format your summary according to APA guidelines.

Statistics Project, Part 1: Opening Data in Microsoft® Excel® and Running Descriptive Statistics

Data

Gender Age Supervisor Telecommute Coworkers Happiness Engagement Overall Rating
1 29 1 1 2 7 8 15
2 32 4 1 3 9 10 19
1 39 1 1 1 4 5 8
1 25 2 1 2 5 8 13
1 27 1 1 1 5 4 9
2 33 3 1 2 7 8 15
2 36 3 1 2 8 7 15
1 28 3 1 3 9 8 17
1 34 3 2 3 8 8 16
2 32 2 1 2 6 8 14
2 31 1 1 1 7 5 12
2 38 1 1 1 6 8 14
2 27 3 1 2 7 9 16
2 29 4 1 2 8 9 17
1 26 4 1 2 8 8 16
1 39 4 1 3 9 8 17
1 40 1 1 1 6 8 14
2 37 2 1 1 7 9 16
2 37 3 1 2 9 7 16
1 29 3 2 2 7 8 15
1 29 3 1 2 9 7 16
1 30 2 1 1 6 7 13
2 36 3 1 3 9 9 18
1 30 3 1 2 7 7 14
2 30 2 1 2 8 7 15
2 35 4 1 2 8 8 16
1 27 3 2 3 9 9 18
2 31 2 1 3 8 8 16
2 38 1 1 2 6 8 14
2 38 3 1 2 8 8 16
1 34 2 1 1 5 6 11
2 28 3 1 2 9 9 18
1 29 2 2 2 7 8 15
1 32 4 2 2 8 8 16
1 35 2 2 3 9 9 18
1 35 3 1 2 7 7 14
2 37 2 1 2 8 9 17
2 29 3 1 2 8 8 16
1 40 4 1 2 9 8 17
2 27 4 1 1 8 7 15
1 27 2 1 1 4 6 10
1 34 1 1 2 8 7 15
2 34 1 2 1 7 5 12
2 25 2 2 2 9 8 17
2 25 1 1 1 5 6 11
2 29 2 1 2 8 8 16
1 30 3 1 2 9 9 18
1 30 3 1 2 7 8 15
2 35 2 2 1 6 6 12
2 34 4 1 3 9 9 18

Information

Variable Description of Values
Gender 1= Male, 2=Female
Age Chronological Age (in years)
Relationship With Direct Supervisor 1 = negative relationship, 2 = neutral relationship, 3 = positive relationship, 4 = great relationship
Telecommute Schedule 1= no ability to telecommute, 2 = able to telecommute at least 2 days per week
Relationship With Coworkers 1 = negative relationship, 2 = no relationship, 3 = positive relationship
Workplace Happiness Rating Scale 0-10, 0 = no happiness, 10 = completely happy
Workplace Engagement Rating Scale 0-10, 1 = no engagement, 10 = highly engaged
Overall Combined Rating Scale 0-20, 0 = not happy and not engaged, 20 = completely happy and highly engaged

We learned effective communication is essential in overcoming conflict, embracing our similarities and differences, and streamlining our work. On the basis of your learning, review the scenario given below and develop the ways to address any misunderstandings based on ineffective communication. You have been invited to be in charge of developing a team-building activity to improve collaboration, morale, and increased communication for your team members. Your department is closing for the day so you all can spend about four hours together in a team environment. The staff members will be placed into groups of three to run a maze, and the winning team will receive an extra four hours paid time off (PTO) time to use for a half vacation day. All members are excited about getting extra time off and, even though they have not participated in a maze-running event, they are happy to be out of the office. After the race is over, the group will be treated for lunch at a very nice restaurant. Review the following details of team members:
  • Rosamma and Mary are the two administrative staff members who do not get along. Rosamma keeps to herself, is quiet, wears traditional long dresses and cooks ethnic foods for lunch every day. Mary is outspoken, loud, hurries through assignments, and seems to be on her cell phone often talking about her personal life to friends. Mary is twenty and Rosamma is forty-six.
  • Cindy, thirty-five, and Lolita, forty, are the part-time staff members. They often bring their problems to work and are stressed due to the economy. They interact at work with the full time staff, but the full time staff think they complain too much and “what for, they only work part-time.”
  • Chip is a twenty-three-year-old maintenance worker who has two children and works a part-time job at night in addition to his full-time role. He is tired as he has been continuously working for many days.
  • Samir is fifty-five and works full-time, and cannot wait until he retires.
  • Sarah is the fifty-two-year-old negative department manager who complains about everyone else. However, she is a strong informal leader and has influence over the group.
  • Jerry is twenty-four and in graduate school. In fact, he is the president of his class and majors in business. He will likely leave in about one year when he graduates. He has a positive attitude and is currently a bit demotivated because no one likes to work together and there seems to be no direction at this point. He has made fun of Sarah just because she makes negative comments to him.
  • You are the manager (use your current age) and you are just promoted into this position as the leader of the group.
Your presentation should consist of 12–15 professional color Microsoft PowerPoint slides (not including the title and reference slide) along with detailed speaker notes to include examples to support each slide. You need to divide the teams into three groups. Remember this is a team-building activity.
  • Can you put Rosamma and Mary together on a team when they clearly have communication issues and Mary feels Rosamma is “slow and too quiet . . . besides, she prays all the time.” Should the two younger males in the department be put on the same team or divided up to run with the women, even though they make comments about how old Sarah is and how she wears old-fashioned clothes? Give reasons.
  • How will you make the determination which members to put together?
  • Should members, who have a negative attitude, be placed with team members who are excited about this event? Why or why not?
  • How will a negative manager affect the overall group dynamic as opposed to a positive leader who wants to see his or her team develop?
  • How influential can an informal leader be among the team members? Can an informal leader carry more power than the formal manager?
  • What barriers to effective teamwork can you anticipate and how will it be addressed?
  • What specific traits will make this team-building activity a success?
  • How can effective leaders demonstrate care and value the workgroup to improve collaboration, motivation, and low turnover in the workplace?
  • How do you think results can improve when effective communication is practiced in the healthcare field with peers, colleagues, and leadership teams?
Support your responses with examples. Cite any sources in APA format. Submission Details Present the additional information in the Notes section.
]]>