C
Charles Deng
Hi All:
I have one table which contains the following variables:
Dept section q1 q2 q3 q4 q5
ACC 100 4 3 4 1 2
BUS 200 2 3 1 4 4
Each dept contains a number of sections and q1 to q5 are
surveyed questions. 4 reprents Very Satisfied, 3
Satisfied, 2 Dissatisfied, and 1 Very Dissatisfied.
Based the query from this table, I generated two reports.
One report is grouped by Dept and the other is grouped by
section. For each report, we reported percentage of each
scale level (Very Satisfied, Satisfied, Dissatisfied, and
Very Dissatisfied) as well as overal average accross q1 to
q5. The report looks like:
Dept ACC
VS, S, Ds, VDs Average
q1 30.0% 50.0% 15.0% 5.0% 3.10
q2 ... ... ... ... ...
And the format of section report looks like this, too.
Now I need to add one column after Average, which may be
called as Top 25% Percentile Value. This top 25%
percentile value should be generated like this:
Among all section averages for each question, such as q1,
within one dept, this value should be the top 25% or the
most close to 25%.
To accomplish this goal, I think we need to add one
variable to the query which produces Dept report. So the
query for the dept report should look like this:
Dept Section q1 q2 q3 q4 q5 SecAverage
I know the formula to calculate the average value for each
question, but how can I add these section averages to the
SecAverage in the querry which produces Dept report? Or
there is another way we can report SecAverage to the Dept
report?
Charles
I have two querries. One query contains
I have one table which contains the following variables:
Dept section q1 q2 q3 q4 q5
ACC 100 4 3 4 1 2
BUS 200 2 3 1 4 4
Each dept contains a number of sections and q1 to q5 are
surveyed questions. 4 reprents Very Satisfied, 3
Satisfied, 2 Dissatisfied, and 1 Very Dissatisfied.
Based the query from this table, I generated two reports.
One report is grouped by Dept and the other is grouped by
section. For each report, we reported percentage of each
scale level (Very Satisfied, Satisfied, Dissatisfied, and
Very Dissatisfied) as well as overal average accross q1 to
q5. The report looks like:
Dept ACC
VS, S, Ds, VDs Average
q1 30.0% 50.0% 15.0% 5.0% 3.10
q2 ... ... ... ... ...
And the format of section report looks like this, too.
Now I need to add one column after Average, which may be
called as Top 25% Percentile Value. This top 25%
percentile value should be generated like this:
Among all section averages for each question, such as q1,
within one dept, this value should be the top 25% or the
most close to 25%.
To accomplish this goal, I think we need to add one
variable to the query which produces Dept report. So the
query for the dept report should look like this:
Dept Section q1 q2 q3 q4 q5 SecAverage
I know the formula to calculate the average value for each
question, but how can I add these section averages to the
SecAverage in the querry which produces Dept report? Or
there is another way we can report SecAverage to the Dept
report?
Charles
I have two querries. One query contains