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

February 23, 2023February 23, 2023 Discipline: Psychology
Learning Goal: I’m working on a psychology case study and need the explanation and answer to help me learn.

Assignment Content


  1. 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, and relationship with co-workers, 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 co-workers
    • 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.

    Submit your assignment.

    Note: Frequency tables are best used for nominal and ordinal variables. Other descriptive information (e.g., means and standard deviations) are best used with interval and ratio data.

    Resources


Are you struggling with your paper? Let us handle it - WE ARE EXPERTS!

Whatever paper you need - we will help you write it

Get started

Starts at $9 /page

Login Register Reset

How our paper writing service works

It's very simple!

  • Fill out the order form

    Complete the order form by providing as much information as possible, and then click the submit button.

  • Choose writer

    Select your preferred writer for the project, or let us assign the best writer for you.

  • Add funds

    Allocate funds to your wallet. You can release these funds to the writer incrementally, after each section is completed and meets your expected quality.

  • Ready

    Download the finished work. Review the paper and request free edits if needed. Optionally, rate the writer and leave a review.

Place order now