surveys and pivot tables

[Guest]

I have reinvented the wheel by making a paper survey and then entering all
the answers into a spreadsheet. the format of the spreadsheet is; the first
column is the id of every person surveyed and the next 9 columns are their
response to each of the 9 questions (responses are numbered so each response
is a number from 1-8)each row is in reference to the answers that the person
gave. so a typical row would be: PCA 1 6 1 2 2 1 5 8 1. pca being the ID and
the other numbers being the response to the corresponding row's question.
The question is: how do i set up a pivot table to analyze the results.
please help me! (i can get the wizard started but i never end up with a
legible table)

 

[Ed Ferrero]

Hi,

Enter a row above the data with headings for each column. e.g.
ID Q1 Q2 Q3...

Then you will have something to Pivot.
In the PivotTable, drop Q1 and Q2 in the Data area. Then click on 'Sum of
Q1' and change it to average.

This seems a pretty trivial application for a Pivot Table. So perhaps you
should consider using worksheet formulas.
As in
=AVERAGE(B2:B40)
=STDEV(B2:B40)
etc.

Ed Ferrero
www.edferrero.com

 

[Guest]

Well Ed,
The survey is one where i'm trying to find and rate satisfaction of
employees with a service that we offer them. An example of the data table
that i am trying to set up is one that would tell me: how many people
answered choice 1 of question one, and so on for all 9 questions. But then i
would also like the pivot table to tell me how many people chose choice 1 to
question 1 AND chose choice 5 to question 7. I hope that gives you a better
idea of what i'm trying to do, i dont think standard deviation and average
would help me because the results are different per question. the only reason
for the numbers is so i can get data. but the info was helpful.