survey database

survey database

Post by James K. Tinsley, J » Thu, 17 Oct 1996 04:00:00



I have a table in which each record is a survey with a response from 1 to 5.  
For example:

Field Names:    Q_1     Q_2     Q_3     Q_4     Q_5
---------------------------------------------------
Record 1:       3       5       2       3       4
Record 2:       5               4               4
Record 3:       3       5       4       2       5
Record 4:       2       1               5       2

Note that some fields are empty.  What I need to do is design a report that
consists of totals and percentages for each of the questions (Q_1, Q_2, Q_3,
etc.).  For example:

                    1           2           3           4           5
                ----------------------------------------------------------
Question 1:     0 (0.00%)   1 (25.00%)  2 (50.00%)  0 (0.00%)   1 (25.00%)
Question 2:     1 (33.33%)  0 (0.00%)   0 (0.00%)   0 (0.00%)   2 (66.67%)
Question 3:     0 (0.00%)   1 (33.33%)  0 (0.00%)   2 (66.67%)  0 (0.00%)
Question 4:     0 (0.00%)   1 (33.33%)  1 (33.33%)  0 (0.00%)   1 (33.33%)
Question 5:     0 (0.00%)   1 (25.00%)  0 (0.00%)   2 (50.00%)  1 (25.00%)

How can I do this and where do I put the formula for the percentage?

******************************************************************************

* Information Systems Coordinator         *       SysOp: The Chill Factor-y! *
* Tennessee Association for Home Care        *        Number: (615) 227-5223 *
* Nashville, TN                                 *          FidoNet: 1:116/50 *
******************************************************************************

 
 
 

1. Building A Survey Database

Does anyone have a good idea on hoew to structure a survey database.

EXAMPLE QESTION:  What operating systems have you used? (multiple
choice)
                  [ ]   Windows
                  [ ]   UNIX
                  [ ]   DOS

What type of table structure would I use to store the answers for many
question.

Please help!!!!!


Kim Cattenhead

2. Select Question

3. Survey : Database size

4. Trouble with a forum system

5. Problem designing survey database

6. ingres on nt, any patches ??

7. Survey: Database Statistics Maintenance

8. Evaluation/Survey database

9. Survey databases

10. Survey Database

11. Design question - survey database

12. Survey: Database Statistics Maintenance