iSixSigma

Survey Analysis and Graphical Program? (easy to use)

Six Sigma – iSixSigma Forums Old Forums General Survey Analysis and Graphical Program? (easy to use)

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #37522

    KC
    Participant

    Recently, I deployed an on-line customer satisfaction survey with 56 questions with the vast majority being ratings or matrix questions.  I’d like to be able to filter answers based on occupations/markets listed, plus compile summary and averages info.  I have no formal training in statistics or research so it’s important it’s simple to use. 
    Can anyone recommend an easy to understand/use program that’s either an add-on to Excel or other?   I will be receiving the raw data in a .csv format.  I hope this gives a clear picture of the application and needs.
    Thanks for your assistance.

    0
    #110684

    KC
    Participant

    Any suggestions anyone could offer on this?

    0
    #110752

    Rajanga Sivakumar
    Participant

    KC
    If it could be converted to MS Access format, you could use the query feature to get the answers for the various combinations. I assume you are using a five point or some similar scale. This then can be converted to Excel for further analysis. Pardon me if my understanding of problem is wrong.
     

    0
    #110754

    KC
    Participant

    You understood my question perfectly, except I’d like you use a GUI type program and one that can provide filters, graphs, et al. 
    A program like SPSS or SigmaXL, are they difficult for the stastically-challenged to use?  My requirements are so basic and I unfortuately don’t have the time to learn many methodologies.
    Thanks again.

    0
    #110774

    KC
    Participant

    Which of these would be the easiest for a non-stats person (business owner) to understand with no knowledge of stats terms:  SPSS Base or Minitab or something else you might suggest?
    Again, this is a very basic survey project.

    0
    #110908

    P eng
    Participant

    KC,
    You should either use Access as previously posted or even just use excel.  Using excel you can create your graphs that you talk about and even filter the data based on the criteria you want to use either by using formulas in excel or even using pivot tables.  It all depends on what are you trying to get out of this data.  Understand your big Y and you’ll understand the x’s that you need to get your Y.
    I hope this helps.
    P eng
     

    0
    #111276

    KWalker
    Participant

    I’d suggest using an Excel Pivot table – it’s a great way to both summarize and graph your data. They’re pretty simple to create, and very flexible once you have them. You tell it where your data is, then drag and drop to create. Data can be shown as counts, sums, averages, etc., and cross-referenced between any of your headings. You don’t need to know any statistics at all, and no other software is needed – it’s built into Excel.

    0
Viewing 7 posts - 1 through 7 (of 7 total)

The forum ‘General’ is closed to new topics and replies.