• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Recipe 5. Survey Builder > Administrator Recipe: Survey Statistics

Administrator Recipe: Survey Statistics

Analysis of a survey’s results is key to its success. The whole point of taking a survey is to find out what people think and, more precisely, what percentage of people surveyed think a particular way. The Survey Statistics page described here offers one way to visualize a survey’s results. When executed—by selecting the entry in the View Results column of the Survey Manager page—the Survey Statistics application displays each of the answers to the questions broken down by percentages. If, for example, 50 out of 200 people surveyed chose yellow as their favorite color, the Survey Statistics page would show that yellow was chosen 25% of the time.

Generating the percentage calculations is the major objective of any statistics application and a chore best handled by SQL. We’ve provided a SQL view that draws data from three primary tables (Surveys, SurveyQuestions, and SurveyResults). After the view is used to create a recordset, implementation in Dreamweaver is a drag-and-drop affair.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint