Changes between Version 1 and Version 2 of BluePrint/SurveyTool/Statistics


Ignore:
Timestamp:
10/04/11 09:18:28 (10 years ago)
Author:
Michael Howden
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • BluePrint/SurveyTool/Statistics

    v1 v2  
    44Your data may look like:
    55
    6 Question A (4 Options) | Question B (3 Options)
     6|| Question A (4 Options) || Question B (3 Options) ||
    77
    88Answers:
    99
    10 Option A-1 | Option B-1
    11 Option A-2 | Option B-2
    12 Option A-1 | Option B-3
     10|| Option A-1 | Option B-1 ||
     11|| Option A-2 | Option B-2 ||
     12|| Option A-1 | Option B-3 ||
    1313...
    1414
    1515To display a diagram, you need a table like:
    1616
    17                    Option B-1 | Option B-2 | Option B-3
    18 Option A-1  <count>       <count>       <count>
    19 Option A-2  <count>       <count>       <count>
    20 Option A-3  <count>       <count>       <count>
    21 Option A-4  <count>       <count>       <count>
     17||                   ||  Option B-1 ||  Option B-2 || Option B-3||
     18|| Option A-1  || <count>       || <count>      ||  <count>||
     19|| Option A-2  || <count>       || <count>      ||  <count>||
     20|| Option A-3  || <count>       || <count>      || <count>||
     21|| Option A-4  || <count>       || <count>      ||  <count>||
    2222
    2323where <count> represents the "formula" here.
     
    2929value, like in:
    3030
    31 Family size (4 Options) | Family Income (numeric)
     31|| Family size (4 Options) ||  Family Income (numeric)||
    3232
    3333Answers:
    3434
    35 Single | 25000
    36 Single | 32000
    37 2 Persons | 38000
    38 Single | 92000
    39 3-5 Persons | 80000
    40 more than 5 Persons | 123000
     35|| Single ||  25000||
     36|| Single ||  32000||
     37|| 2 Persons ||  38000||
     38|| Single ||  92000||
     39|| 3-5 Persons ||  80000||
     40|| more than 5 Persons ||  123000||
    4141....and so forth
    4242
    4343Now the analysis could give a table like:
    4444
    45                                           Income
    46 Single                                <sum>
    47 2 Persons                         <sum>
    48 3-5 Persons                      <sum>
    49 more than five Persons    <sum>
     45 ||                                        ||   Income||
     46|| Single                      ||           <sum>||
     47|| 2 Persons             ||             <sum>||
     48|| 3-5 Persons             ||          <sum>||
     49|| more than five Persons ||    <sum>||
    5050
    5151...which can be displayed as a barchart.
     
    5555or <distribution> like:
    5656
    57                                           50% or less  average  150% or more
    58 Single                                <count>         <count>    <count>
    59 2 Persons                         <count>         <count>     <count>
    60 3-5 Persons                      <count>         <count>     <count>
    61 more than five Persons    <count>         <count>     <count>
     57||                                          ||  50% or less  || average  || 150% or more||
     58|| Single                                || <count>      ||    <count>   ||  <count>||
     59|| 2 Persons                         || <count>        ||  <count>    ||  <count>||
     60|| 3-5 Persons                      || <count>      ||    <count>   ||   <count>||
     61|| more than five Persons    || <count>        ||  <count>     || <count>||
    6262
    6363