{"id":4553,"date":"2023-02-23T18:30:24","date_gmt":"2023-02-23T18:30:24","guid":{"rendered":"https:\/\/www.goodacademic.com\/blog\/questions\/statistics-project-part-1-opening-data-in-microsoft-excel-and-running-descriptive-statistics\/"},"modified":"2023-02-23T18:30:24","modified_gmt":"2023-02-23T18:30:24","slug":"statistics-project-part-1-opening-data-in-microsoft-excel-and-running-descriptive-statistics","status":"publish","type":"questions","link":"https:\/\/www.goodacademic.com\/blog\/questions\/statistics-project-part-1-opening-data-in-microsoft-excel-and-running-descriptive-statistics\/","title":{"rendered":"Statistics Project, Part 1: Opening Data in Microsoft\u00ae Excel\u00ae and Running Descriptive Statistics"},"content":{"rendered":"
\n Learning Goal: <\/b>I’m working on a psychology case study and need the explanation and answer to help me learn.<\/p>\n

Assignment Content<\/h2>\n
    \n
  1. \n <\/p>\n
    \n
    \n
    \n 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\u00c2\u00ae Excel\u00c2\u00ae 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
    \n Happiness and Engagement Dataset<\/a>.
    \n
    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.
    \n
    Calculate descriptive statistics for the following variables in the provided Microsoft\u00c2\u00ae Excel\u00c2\u00ae dataset:<\/p>\n