Search results

  1. Johwilire01

    Trend Data from Survey

    I found a picture of what I want it to look like that was taken from a graph that someone did last year (Who is no longer with the company), but it isn't linked to an Excel graph, unfortunately.
  2. Johwilire01

    Trend Data from Survey

    Can anyone assist me with how to build a trend data graph in excel, please? I have survey data from the past three years using Likert scales of (Exceeds, Meets, Does Not Meet) and I'd like to display this in a horizontal graph somehow. I have 7 categories (alignment with goals, professional...
  3. Johwilire01

    Qualitative Analysis

    It’s ~500 (+/-10) per question. I agree that reviewing and reading each comment to ensure and know with confidence what category the comments should go in but I just wanted to see what other input people have regarding break down in excel if there is another option/solution.
  4. Johwilire01

    Qualitative Analysis

    Hi everyone! I am working on a study from a survey done in Survey Monkey that has 5 questions that were open answer with approximately 500 respondents who provided comments to those answers. I now have to look at each question and review the qualitative data from those questions and break them...
  5. Johwilire01

    Analyzing grades

    Thank you...I've been playing around with that. I think I got it figured out now... Wish there was a way I could send you my data to show me the best way to go about this.
  6. Johwilire01

    Analyzing grades

    Thank you for your response! Sorry for not showing my data...I am trying to audit a class to see if there are any cheating situations going on. In multiple classes, students are given unlimited attempts at the quiz within a week's time. There are multiple students taking the quiz up to 15x...
  7. Johwilire01

    Analyzing grades

    Not sure where to put this question but I seriously need help!! I was tasked to find out how many students out of roughly 200 took a quiz multiple times and how many times they took a particular quiz. I have this all in excel but is there an easy way to do this without having to manually count...