simple (?) Excel chart

[Toni Rosenberg]

Hi. I'm looking for help setting up some data in Excel --
basically, ten questions are asked 90 times of survey
respondents, who circle a number from 1 to 7 for each
question. I need to enter each response, come up with the
average for each set of 10 questions, and then the average
for all 90 surveys. I've got something elementary set up --
it involves repeating the 10 questions 90 times, not a very
good solution. I'm totally new to Excel. I'm using Excel
97. I'd like to have something more or less elegant to
show, something graphically economical. Can anyone help?
Thanks.

[Tushar Mehta]

If I understand the set up correctly, intuitively or otherwise, you have
hit the best possible layout!

Assume you have the data laid out with the column headings
Respondent Question Answer
1 1 5
1 2 7
...

Make sure you have the column headings. Now, use a PivotTable to
analyze the data. I found XL's help on the subject to be adequate. You
might also want to check an intro to PTs by Harald Staff. It is part of
Chip Pearson's web site. Check http://www.cpearson.com/excel/pivots.htm

PTs and charts based on PTs are quick and as elegant as XL's results can
be.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
--

In <f12e01c1265a$dadfb290$a4e62ecf@tkmsftngxa06>, Toni Rosenberg
<time...@ultranet.com> wrote

[S...@internet.org]

You may wish to explore Stephen Bullens example at:

http://www.bmsltd.co.uk/DLCount/DLCount.asp?file=ScoreFrq.zip
"This is a chart which uses stacked bars to display attitude data.
For example, if you want to show how many people chose which
score for a particular statement, and what was the weighted
average of them all, this chart does it all. It shows the scores,
average score and number of people who chose each one, all on
the one chart."

You will have to create the summary table upon which the chart
is based from your individual response database/table.

You will need to determine the appropriateness of the resulting
presentation for your target audience.

-- Sam

"Toni Rosenberg" <time...@ultranet.com> wrote in message news:f12e01c1265a$dadfb290$a4e62ecf@tkmsftngxa06...