Segmentation
Scenario 1
Segmentation with question answers is multiplied by a specific coefficient for each segment, then a constant is added to calculate the total segment score and then punching the segment that has the max segment score as the final segment.
Let's take a look at an example for this:
Question type for each of the questions are mentioned below:
Q1 = Radio question with column
Q2 = Radio question with column
Q3 = Number question
Q4 = Number question
Segment calculation logic:
Question
Likert scale answer (1 to 5)
Segment 1:
"Uninterested"
Segment 2:
"Passively interested"
Segment 3:
"Actively interested"
Q1: How important do you think it is for citizens to volunteer or donate to protect endangered species?
-0.561135188
0.045301485
2.023393358
Q2: To what extent do you agree that wildlife conservation should be a priority for governments?
-0.351733944
2.31670683
0.156779107
Q3: How concerned are you about the impact of human activities on wildlife habitats?
-0.65961061
0.278996417
0.467290048
Q4: How supportive are you of initiatives to reintroduce native species to their original habitats?
-0.559083482
0.488902614
0.141627905
Constant
1
9.802423437
-0.39186368
-0.959236738
Total segment score
-
-
-
-
Scenario 2
Segmentation with variable recording before multiplying it with co-efficient and adding it to a constant.
Let's take a look at an example for this:
Question type for each of the questions are mentioned below:
Q1 = Radio question with column
Q2 = Radio question with column
Q3 = Checkbox question rows
Q4 = Radio question what rows and columns
Q5 = Radio question with columns
Q6 = Checkbox question with rows
Q7 = Radio question with rows
​
Recoding logic:
Variable
Recoding Logic
Q1_1
If Q1 = 1, code as 1; else code as 0
Q1_2
If Q1 = 2, code as 1; else code as 0
Q1_3
If Q1 = 3, code as 1; else code as 0
Q2_1
If Q2 = 1, code as 1; else code as 0
Q2_2
If Q2 = 2, code as 1; else code as 0
Q2_3
If Q2 = 3, code as 1; else code as 0
Q2_4
If Q2 = 4, code as 1; else code as 0
Q2_5
If Q2 = 5, code as 1; else code as 0
Q3r1
No recode necessary; 1 = selected & 0 = unselected
Q3r2
No recode necessary; 1 = selected & 0 = unselected
Q3r3
No recode necessary; 1 = selected & 0 = unselected
Q3r4
No recode necessary; 1 = selected & 0 = unselected
Q3r5
No recode necessary; 1 = selected & 0 = unselected
Q3r6
No recode necessary; 1 = selected & 0 = unselected
Q3r7
No recode necessary; 1 = selected & 0 = unselected
Q3r8
No recode necessary; 1 = selected & 0 = unselected
Q3r9
No recode necessary; 1 = selected & 0 = unselected
Q4r1_1
If Q4r1 = 1, code as 1; else code as 0
Q4r1_2
If Q4r1 = 2, code as 1; else code as 0
Q4r1_3
If Q4r1 = 3, code as 1; else code as 0
Q4r1_4
If Q4r1 = 4, code as 1; else code as 0
Q4r2_1
If Q4r2 = 1, code as 1; else code as 0
Q4r2_2
If Q4r2 = 2, code as 1; else code as 0
Q4r2_3
If Q4r2 = 3, code as 1; else code as 0
Q4r2_4
If Q4r2 = 4, code as 1; else code as 0
Q4r3_1
If Q4r3 = 1, code as 1; else code as 0
Q4r3_2
If Q4r3 = 2, code as 1; else code as 0
Q4r3_3
If Q4r3 = 3, code as 1; else code as 0
Q4r3_4
If Q4r3 = 4, code as 1; else code as 0
Q4r4_1
If Q4r4 = 1, code as 1; else code as 0
Q4r4_2
If Q4r4 = 2, code as 1; else code as 0
Q4r4_3
If Q4r4 = 3, code as 1; else code as 0
Q4r4_4
If Q4r4 = 4, code as 1; else code as 0
Q4r5_1
If Q4r5 = 1, code as 1; else code as 0
Q4r5_2
If Q4r5 = 2, code as 1; else code as 0
Q4r5_3
If Q4r5 = 3, code as 1; else code as 0
Q4r5_4
If Q4r5 = 4, code as 1; else code as 0
Q4r6_1
If Q4r6 = 1, code as 1; else code as 0
Q4r6_2
If Q4r6 = 2, code as 1; else code as 0
Q4r6_3
If Q4r6 = 3, code as 1; else code as 0
Q4r6_4
If Q4r6 = 4, code as 1; else code as 0
Q4r7_1
If Q4r7 = 1, code as 1; else code as 0
Q4r7_2
If Q4r7 = 2, code as 1; else code as 0
Q4r7_3
If Q4r7 = 3, code as 1; else code as 0
Q4r7_4
If Q4r7 = 4, code as 1; else code as 0
Q4r8_1
If Q4r8 = 1, code as 1; else code as 0
Q4r8_2
If Q4r8 = 2, code as 1; else code as 0
Q4r8_3
If Q4r8 = 3, code as 1; else code as 0
Q4r8_4
If Q4r8 = 4, code as 1; else code as 0
Q5_1
If Q5 = 1, code as 1; else code as 0
Q5_2
If Q5 = 2, code as 1; else code as 0
Q6r1
No recode necessary; 1 = selected & 0 = unselected
Q6r2
No recode necessary; 1 = selected & 0 = unselected
Q6r3
No recode necessary; 1 = selected & 0 = unselected
Q6r4
No recode necessary; 1 = selected & 0 = unselected
Q6r5
No recode necessary; 1 = selected & 0 = unselected
Q6r6
No recode necessary; 1 = selected & 0 = unselected
Q6r7
No recode necessary; 1 = selected & 0 = unselected
Q6r8
No recode necessary; 1 = selected & 0 = unselected
Q7_1
If Q7 = 1, code as 1; else code as 0
Q7_2
If Q7 = 2, code as 1; else code as 0
Q7_3
If Q7 = 3, code as 1; else code as 0
Q7_4
If Q7 = 4, code as 1; else code as 0
Q7_5
If Q7 = 5, code as 1; else code as 0
Q7_6
If Q7 = 6, code as 1; else code as 0
Q7_7
If Q7 = 7, code as 1; else code as 0
Q7_8
If Q7 = 8, code as 1; else code as 0
Q7_9
If Q7 = 9, code as 1; else code as 0
Q7_10
If Q7 = 10, code as 1; else code as 0
Q7_11
If Q7 = 11, code as 1; else code as 0
Q7_12
If Q7 = 12, code as 1; else code as 0
Segment calculation logic:
Variable
Segment 1
Segment 2
Segment 3
Segment 4
Segment 5
Segment 6
Q1_1
18.0767
22.05169
20.87446
23.62055
22.4346
25.46154
Q1_2
16.23301
19.74055
18.7242
19.15496
19.43095
18.33225
Q1_3
16.65306
18.43816
18.337
17.75301
18.48681
17.79924
Q2_1
83.41005
85.85887
86.66188
86.7295
85.37157
87.98126
Q2_2
82.32566
85.62216
86.43268
87.50796
85.54803
84.26265
Q2_3
81.92598
84.89426
85.45443
85.48974
84.77049
83.23104
Q2_4
82.56818
84.15394
84.70123
84.55268
84.40516
82.70466
Q2_5
87.15362
87.85616
88.06397
88.73812
88.32302
86.75745
Q3r1
3.147795
3.090329
4.353368
2.848069
1.99812
3.646036
Q3r2
4.677952
4.955191
3.788802
4.228256
4.025644
4.977211
Q3r3
5.277959
5.71047
5.98173
9.81709
7.764079
7.357867
Q3r4
4.633902
4.279482
6.428023
7.21813
5.677258
5.480364
Q3r5
3.248075
3.804778
2.684756
2.658239
3.440625
3.508464
Q3r6
6.786563
7.052425
8.045186
6.642545
6.904374
7.129207
Q3r7
4.568831
5.420923
5.042387
4.022642
4.473734
4.183822
Q3r8
3.08382
3.016078
3.184092
3.530534
3.558504
3.509536
Q3r9
4.416722
4.270809
6.645938
5.226696
5.451685
4.804677
Q4r1_1
4.074502
4.376876
4.541224
4.253495
2.181111
6.402298
Q4r1_2
2.747891
2.880356
4.007702
4.041661
1.681463
5.514703
Q4r1_3
4.698259
4.897728
5.382919
5.464882
3.381889
6.065176
Q4r1_4
2.969259
3.042033
3.091767
3.46961
1.859063
3.953858
Q4r2_1
9.176468
8.853241
9.174171
9.725798
8.647695
6.892554
Q4r2_2
2.741122
4.048006
2.974923
3.679902
3.63364
3.420566
Q4r2_3
0.949125
1.992864
1.882977
2.386896
1.747279
2.486078
Q4r2_4
2.909757
3.735983
3.713474
4.247346
3.739991
4.63123
Q4r3_1
12.96681
11.83703
13.52748
9.971731
9.433446
3.878918
Q4r3_2
9.775593
9.239915
9.612797
6.330269
6.18632
2.118337
Q4r3_3
9.837698
9.722221
9.459752
7.67869
7.553319
3.287871
Q4r3_4
8.288795
8.76809
7.933279
7.030374
6.749627
3.61705
Q4r4_1
14.64703
14.21732
10.66585
13.72305
12.36433
18.54302
Q4r4_2
10.26099
10.22452
6.757315
10.26178
8.72929
11.04825
Q4r4_3
10.61078
10.04199
7.315017
10.30968
8.844427
11.03538
Q4r4_4
10.27566
10.11727
8.635031
9.90983
8.761242
10.32051
Q4r5_1
8.411017
9.005973
10.9419
10.32382
6.520635
4.905538
Q4r5_2
5.120288
6.092087
6.693918
6.442216
4.932918
3.089617
Q4r5_3
5.247238
5.636732
6.209737
5.828761
4.379031
2.518693
Q4r5_4
4.883993
5.349388
4.890349
5.185007
4.305264
2.662467
Q4r6_1
3.396115
4.4294
4.216994
4.758163
4.291015
6.92498
Q4r6_2
4.521206
6.259241
5.800834
6.444499
6.001652
7.507017
Q4r6_3
3.690594
4.590393
5.168465
4.83102
5.483137
5.693942
Q4r6_4
3.416975
3.977436
3.92668
4.068796
4.499687
4.707107
Q4r7_1
25.71216
24.40168
25.56321
25.73595
22.95961
27.91159
Q4r7_2
25.1666
23.44218
25.85547
25.4982
23.08291
27.08061
Q4r7_3
25.31247
24.79049
26.11898
26.60817
24.31205
27.9498
Q4r7_4
26.49405
25.6245
27.31551
27.58989
26.14568
28.70935
Q4r8_1
15.74686
13.16973
13.42637
13.56773
13.70189
19.11445
Q4r8_2
12.56457
10.59526
11.07122
11.02795
11.13873
13.42709
Q4r8_3
13.52893
12.46739
12.50857
13.09962
12.44144
13.51688
Q4r8_4
11.01671
10.48131
10.86398
11.37414
10.85244
11.19533
Q5_1
51.39918
51.68872
49.17817
49.88453
49.6692
51.68193
Q5_2
50.76572
50.95601
50.08092
51.19722
50.79166
51.55262
Q6r1
-0.53618
1.087943
0.186941
1.304234
0.634862
0.98776
Q6r2
-0.86776
1.275798
-0.1099
1.716545
1.205292
0.677908
Q6r3
-0.34912
1.476012
-0.11424
0.288967
-0.14202
0.242393
Q6r4
0.199466
-0.31854
0.445499
-0.10014
0.303727
-0.70099
Q6r5
0.744699
0.811145
2.221832
0.924717
1.816574
0.888146
Q6r6
2.533852
3.151418
2.994294
3.831478
2.709637
2.898771
Q6r7
-0.8026
-0.74654
0.536385
1.582484
1.608436
0.779205
Q6r8
1.614077
2.471479
1.703095
3.434642
3.35924
2.119073
Q7_1
4.355944
2.841651
2.892291
2.701459
8.635566
3.029478
Q7_2
5.192119
3.852713
6.747642
4.150208
7.229909
6.292859
Q7_3
6.484115
3.834943
5.194257
3.909137
7.336505
6.230936
Q7_4
10.10111
8.389435
8.793659
8.273802
11.76445
9.247538
Q7_5
7.233676
4.839024
5.790385
4.935673
7.286002
6.962825
Q7_6
4.139474
2.521358
2.951169
2.419919
4.412424
3.515856
Q7_7
7.100123
5.871531
6.371467
5.694119
8.189354
6.602987
Q7_8
3.507806
1.942855
2.75205
1.609356
4.081044
2.854012
Q7_9
5.909435
5.221959
5.524882
5.058041
5.911755
5.456515
Q7_10
4.395043
4.220313
5.296106
4.197766
5.1035
4.479072
Q7_11
5.677674
5.359456
5.462184
5.800696
5.998446
5.321294
Q7_12
3.522429
3.848249
3.210613
4.142624
3.987704
4.057838
Variable
Segment 1
Segment 2
Segment 3
Segment 4
Segment 5
Segment 6
Constant
-116.299
-123.014
-121.593
-125.905
-117.135
-126.279
Last updated
Was this helpful?