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

Want create site? With you can do it easy.

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

Part 1: Opening Data in Microsoft® Excel® and Running 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 .

Struggling to find relevant content or pressed for time? – Don’t worry, we have a team of professionals to help you on
Part 1: Opening Data in Microsoft® Excel® and Running Descriptive Statistics
Get a 15% Discount on this Paper
Order Now

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.

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
Did you find apk for android? You can find new and apps.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with MyCoursebay
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Marketing
Yes and thank you
Customer 452701, October 25th, 2022
English 101
I'm glad i came to you guys
Customer 452519, May 11th, 2021
nursing
Thank you!
Customer 452707, April 2nd, 2022
Criminal Justice
Impressive! Will be using the service again.
Customer 452485, December 5th, 2021
ENVIRONMENT SCIENCE
great
Customer 452813, June 26th, 2022
Nursing
Everything was done thoroughly and with care. Awesome job!!!
Customer 452453, April 10th, 2021
Social Work and Human Services
Excellent Work!!!!
Customer 452587, November 29th, 2021
Nursing
Great paper!
Customer 452707, July 1st, 2022
Social Work and Human Services
Good Work!
Customer 452587, September 2nd, 2021
Criminal Justice
Great work! Followed directions to the latter.
Customer 452485, September 1st, 2021
Nursing
Great work. thank you again!
Customer 452707, August 7th, 2022
Other
GOOD
Customer 452813, July 5th, 2022
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat

Get your perfect essay with a 15% discount. Use DC15

NEW

Thank you for choosing MyCoursebay. Your presence is a motivation to us. All papers are written from scratch. Plagiarism is not tolerated. Order now for a 15% discount

Order Now