K
Kurt
I am trying to create a report to show a frequency table
of survey data.
The data are from 16 survey questions which are answered
on a 5-point Likert scale (e.g., 1 = Strongly Agree, 2 =
Agree . . . 5 = Strongly Disagree).
For each survey question, I would like to show:
a) the number (i.e., count) of people who answered
Strongly Agree, the number of people who answered Agree,
and so forth
b) the total number of people who answered the question
c) the average/mean answer (e.g., an average answer of
1.5 would show that, on average, people Strongly Agreed
to Agreed with the statement)
The table might look like:
SD AG DG SG
Item 1 2 3 4 5 Totals Mean
---------------------------------------------------
Clean 5 3 1 2 0 11 ?
Nice 4 2 5 0 1 12 ?
Tasty 3 1 2 4 2 12 ?
.. . .
---------------------------------------------------
It would be even better if the table could also show
percents, as in:
SD AG DG SG
Item 1 2 3 4 5 Totals Mean
----------------------------------------------------
Clean 5 3 1 2 0 11 ?
45% 27% 9% 18% 0% 100%
Nice 4 2 5 0 1 12 ?
33% 17% 42% 0% 8% 100%
Tasty 3 1 2 4 2 12 ?
25% 8% 17% 33% 17% 100%
.. . .
----------------------------------------------------
The data is in the table, but I can't figure out how to
write the query and report so that the data is caculated
and presented to create a frequency table like the one
above. Any ideas on how to proceed? Crosstab query(s)?
Thank you.
Kurt
of survey data.
The data are from 16 survey questions which are answered
on a 5-point Likert scale (e.g., 1 = Strongly Agree, 2 =
Agree . . . 5 = Strongly Disagree).
For each survey question, I would like to show:
a) the number (i.e., count) of people who answered
Strongly Agree, the number of people who answered Agree,
and so forth
b) the total number of people who answered the question
c) the average/mean answer (e.g., an average answer of
1.5 would show that, on average, people Strongly Agreed
to Agreed with the statement)
The table might look like:
SD AG DG SG
Item 1 2 3 4 5 Totals Mean
---------------------------------------------------
Clean 5 3 1 2 0 11 ?
Nice 4 2 5 0 1 12 ?
Tasty 3 1 2 4 2 12 ?
.. . .
---------------------------------------------------
It would be even better if the table could also show
percents, as in:
SD AG DG SG
Item 1 2 3 4 5 Totals Mean
----------------------------------------------------
Clean 5 3 1 2 0 11 ?
45% 27% 9% 18% 0% 100%
Nice 4 2 5 0 1 12 ?
33% 17% 42% 0% 8% 100%
Tasty 3 1 2 4 2 12 ?
25% 8% 17% 33% 17% 100%
.. . .
----------------------------------------------------
The data is in the table, but I can't figure out how to
write the query and report so that the data is caculated
and presented to create a frequency table like the one
above. Any ideas on how to proceed? Crosstab query(s)?
Thank you.
Kurt