Skip to content

Instantly share code, notes, and snippets.

@hustKiwi
Last active May 8, 2017 09:01
Show Gist options
  • Save hustKiwi/76643cb7e313dbcaf5b93413408295ca to your computer and use it in GitHub Desktop.
Save hustKiwi/76643cb7e313dbcaf5b93413408295ca to your computer and use it in GitHub Desktop.
{
"scoreOfSatisfied": 7.48, // 根据第8题算得,10分满分,平均满意度得分7.48分
"maleScoreOfSatisfied": 7.15, // 男性用户平均满意度得分
"femaleScoreOfSatisfied": 7.83, // 女性用户平均满意度得分
"rankingDistribution": { // @Flora, 满意度 / 不满意度分布相关数据
"fs-location": [ // fs前缀的数据代表满意度因子相关的数据,fs是factors of satisfaction的缩写。fd是不满意因子的缩写。后同。
6, // 选not important的人数
21, // 选somewhat important的人数
42, // 选important的人数
31 // 选very important,后同,再次注意,fs前缀的是满意度,fd前缀的是不满意度
],
"fd-location": [
13,
25,
47,
15
],
"fs-security": [
1,
12,
43,
44
],
"fd-security": [
7,
20,
41,
32
],
"fs-cost": [
3,
16,
42,
39
],
"fd-cost": [
5,
19,
42,
34
],
"fs-private": [
2,
20,
38,
40
],
"fd-private": [
8,
13,
46,
33
],
"fs-facilities": [
2,
40,
41,
17
],
"fd-facilities": [
9,
35,
36,
20
],
"fs-relationship": [
8,
21,
40,
31
],
"fd-relationship": [
5,
21,
39,
35
],
"fs-lifestyle": [
23,
36,
29,
12
],
"fd-lifestyle": [
17,
44,
30,
9
],
"fs-cleanliness": [
5,
15,
52,
28
],
"fd-cleanliness": [
8,
23,
45,
24
],
"fs-distance": [
9,
26,
37,
28
],
"fd-distance": [
9,
21,
41,
29
]
},
"priceOfSatisfied-below_150": { // 价格与综合满意度(即第8题)的关系
"total": 66, // total代表总分(5分制,如需换算10分乘以2即可),所有收入在below 150等级下的受调查者给出的满意度评分之和
"itemNum": 16, // itemNum表示在该档价格区间下,有多少用户
"score": 8.25 // 该分类下用户的平均分,注意,这里是10分满分制,下同。'-'后是分类的标识。
},
"priceOfSatisfied-150_200": {
"total": 141,
"itemNum": 37,
"score": 7.62
},
"priceOfSatisfied-201_250": {
"total": 52,
"itemNum": 17,
"score": 6.12
},
"priceOfSatisfied-251_300": {
"total": 70,
"itemNum": 18,
"score": 7.78
},
"priceOfSatisfied-301_350": {
"total": 16,
"itemNum": 5,
"score": 6.4
},
"priceOfSatisfied-over_350": {
"total": 29,
"itemNum": 7,
"score": 8.29
},
"priceOfSatisfiedMale-below_150": { // Male受访者对价格与综合满意度的关系
"total": 32,
"itemNum": 8,
"score": 8
},
"priceOfSatisfiedMale-150_200": {
"total": 59,
"itemNum": 16,
"score": 7.38
},
"priceOfSatisfiedMale-201_250": {
"total": 30,
"itemNum": 10,
"score": 6
},
"priceOfSatisfiedMale-251_300": {
"total": 34,
"itemNum": 10,
"score": 6.8
},
"priceOfSatisfiedMale-301_350": {
"total": 13,
"itemNum": 4,
"score": 6.5
},
"priceOfSatisfiedMale-over_350": {
"total": 18,
"itemNum": 4,
"score": 9
},
"priceOfSatisfiedFemale-below_150": { // Female受访者对价格与综合满意度的关系
"total": 34,
"itemNum": 8,
"score": 8.5
},
"priceOfSatisfiedFemale-150_200": {
"total": 82,
"itemNum": 21,
"score": 7.81
},
"priceOfSatisfiedFemale-201_250": {
"total": 22,
"itemNum": 7,
"score": 6.29
},
"priceOfSatisfiedFemale-251_300": {
"total": 36,
"itemNum": 8,
"score": 9
},
"priceOfSatisfiedFemale-301_350": {
"total": 3,
"itemNum": 1,
"score": 6
},
"priceOfSatisfiedFemale-over_350": {
"total": 11,
"itemNum": 3,
"score": 7.33
},
"distanceOfSatisfied-less_than_15_minutes": { // 类似价格和满意度的分组,这里着重在距离和满意度的分组分析上
"total": 62,
"itemNum": 18,
"score": 6.89
},
"distanceOfSatisfied-15_30_minutes": {
"total": 106,
"itemNum": 30,
"score": 7.07
},
"distanceOfSatisfied-31_45_minutes": {
"total": 71,
"itemNum": 18,
"score": 7.89
},
"distanceOfSatisfied-46_60_minutes": {
"total": 68,
"itemNum": 17,
"score": 8
},
"distanceOfSatisfied-more_than_60_minutes": {
"total": 67,
"itemNum": 17,
"score": 7.88
},
"distanceOfSatisfiedMale-less_than_15_minutes": { // Male受访者对距离与综合满意度的关系
"total": 39,
"itemNum": 12,
"score": 6.5
},
"distanceOfSatisfiedMale-15_30_minutes": {
"total": 60,
"itemNum": 17,
"score": 7.06
},
"distanceOfSatisfiedMale-31_45_minutes": {
"total": 37,
"itemNum": 9,
"score": 8.22
},
"distanceOfSatisfiedMale-46_60_minutes": {
"total": 31,
"itemNum": 8,
"score": 7.75
},
"distanceOfSatisfiedMale-more_than_60_minutes": {
"total": 19,
"itemNum": 6,
"score": 6.33
},
"distanceOfSatisfiedFemale-less_than_15_minutes": { // Female受访者对距离与综合满意度的关系
"total": 23,
"itemNum": 6,
"score": 7.67
},
"distanceOfSatisfiedFemale-15_30_minutes": {
"total": 46,
"itemNum": 13,
"score": 7.08
},
"distanceOfSatisfiedFemale-31_45_minutes": {
"total": 34,
"itemNum": 9,
"score": 7.56
},
"distanceOfSatisfiedFemale-46_60_minutes": {
"total": 37,
"itemNum": 9,
"score": 8.22
},
"distanceOfSatisfiedFemale-more_than_60_minutes": {
"total": 48,
"itemNum": 11,
"score": 8.73
},
"fsA1": { // 这里重点分析满意度相关的因子影响,A1和后面的A2代表两种求和公式下的计算结果。A1认为:not important = 0, sometime important = 1, important = 2, very important = 3
"total": 1745, // total含义类似上述定义,代表各个影响因子的加权分值
"factors": { // 各个影响因子在的占分,如需做柱状图,建议按影响因子的最高得分作为满分值,其他按比例画图,比如,这里security的230是最高分,那么柱状图可以拟合为满分10分
"location": 198, // 此时,location为198,占198 / 230 ~= 8.6分(10分满分)
"security": 230,
"cost": 217,
"private": 216,
"facilities": 173,
"relationship": 194,
"lifestyle": 130,
"cleanliness": 203,
"distance": 184
}
},
"fdA1": { // fd为不满意度影响因子在A1算法下的计算结果(但个人建议用A2算法的结果,这里只是列举了全部计算结果,各取所需)
"total": 1648,
"factors": {
"location": 164,
"security": 198,
"cost": 205,
"private": 204,
"facilities": 167,
"relationship": 204,
"lifestyle": 131,
"cleanliness": 185,
"distance": 190
}
},
"fsA2": { // A2的计算公式拉大了影响因子的权重(我个人建议咱们统一用A2结果,突出影响因子的作用),not important = 0, sometime important = 1, important = 3, very important = 5
"total": 2649,
"factors": {
"location": 302,
"security": 361,
"cost": 337,
"private": 334,
"facilities": 248,
"relationship": 296,
"lifestyle": 183,
"cleanliness": 311,
"distance": 277
}
},
"fdA2": {
"total": 2477,
"factors": {
"location": 241,
"security": 303,
"cost": 315,
"private": 316,
"facilities": 243,
"relationship": 313,
"lifestyle": 179,
"cleanliness": 278,
"distance": 289
}
},
"fsA1-less_than_1_month": { // 与上面类似,按居住时长分组,这里是居住less than 1 month的受访者在A1公式下的满意度因子得分
"total": 410,
"factors": {
"location": 49,
"security": 54,
"cost": 50,
"private": 47,
"facilities": 38,
"relationship": 48,
"lifestyle": 30,
"cleanliness": 44,
"distance": 50
}
},
"fdA1-less_than_1_month": {
"total": 403,
"factors": {
"location": 45,
"security": 51,
"cost": 50,
"private": 43,
"facilities": 41,
"relationship": 48,
"lifestyle": 30,
"cleanliness": 43,
"distance": 52
}
},
"fsA2-less_than_1_month": {
"total": 612,
"factors": {
"location": 75,
"security": 83,
"cost": 76,
"private": 71,
"facilities": 52,
"relationship": 73,
"lifestyle": 41,
"cleanliness": 64,
"distance": 77
}
},
"fdA2-less_than_1_month": {
"total": 599,
"factors": {
"location": 67,
"security": 79,
"cost": 76,
"private": 64,
"facilities": 60,
"relationship": 73,
"lifestyle": 39,
"cleanliness": 62,
"distance": 79
}
},
"fsA1-1_6_months": {
"total": 633,
"factors": {
"location": 69,
"security": 79,
"cost": 80,
"private": 77,
"facilities": 67,
"relationship": 68,
"lifestyle": 43,
"cleanliness": 74,
"distance": 76
}
},
"fdA1-1_6_months": {
"total": 630,
"factors": {
"location": 63,
"security": 70,
"cost": 75,
"private": 76,
"facilities": 71,
"relationship": 72,
"lifestyle": 52,
"cleanliness": 76,
"distance": 75
}
},
"fsA2-1_6_months": {
"total": 970,
"factors": {
"location": 105,
"security": 124,
"cost": 125,
"private": 119,
"facilities": 99,
"relationship": 104,
"lifestyle": 61,
"cleanliness": 115,
"distance": 118
}
},
"fdA2-1_6_months": {
"total": 963,
"factors": {
"location": 94,
"security": 107,
"cost": 117,
"private": 118,
"facilities": 108,
"relationship": 110,
"lifestyle": 74,
"cleanliness": 118,
"distance": 117
}
},
"fsA1-7_12_months": {
"total": 333,
"factors": {
"location": 39,
"security": 47,
"cost": 43,
"private": 45,
"facilities": 32,
"relationship": 40,
"lifestyle": 25,
"cleanliness": 38,
"distance": 24
}
},
"fdA1-7_12_months": {
"total": 273,
"factors": {
"location": 21,
"security": 36,
"cost": 39,
"private": 39,
"facilities": 22,
"relationship": 42,
"lifestyle": 20,
"cleanliness": 28,
"distance": 26
}
},
"fsA2-7_12_months": {
"total": 507,
"factors": {
"location": 59,
"security": 75,
"cost": 67,
"private": 71,
"facilities": 46,
"relationship": 63,
"lifestyle": 34,
"cleanliness": 59,
"distance": 33
}
},
"fdA2-7_12_months": {
"total": 404,
"factors": {
"location": 29,
"security": 54,
"cost": 60,
"private": 61,
"facilities": 29,
"relationship": 66,
"lifestyle": 26,
"cleanliness": 41,
"distance": 38
}
},
"fsA1-more_than_12_months": {
"total": 369,
"factors": {
"location": 41,
"security": 50,
"cost": 44,
"private": 47,
"facilities": 36,
"relationship": 38,
"lifestyle": 32,
"cleanliness": 47,
"distance": 34
}
},
"fdA1-more_than_12_months": {
"total": 342,
"factors": {
"location": 35,
"security": 41,
"cost": 41,
"private": 46,
"facilities": 33,
"relationship": 42,
"lifestyle": 29,
"cleanliness": 38,
"distance": 37
}
},
"fsA2-more_than_12_months": {
"total": 560,
"factors": {
"location": 63,
"security": 79,
"cost": 69,
"private": 73,
"facilities": 51,
"relationship": 56,
"lifestyle": 47,
"cleanliness": 73,
"distance": 49
}
},
"fdA2-more_than_12_months": {
"total": 511,
"factors": {
"location": 51,
"security": 63,
"cost": 62,
"private": 73,
"facilities": 46,
"relationship": 64,
"lifestyle": 40,
"cleanliness": 57,
"distance": 55
}
},
"fsA1-male": { // 满意度与性别的关系
"total": 912,
"factors": {
"location": 105,
"security": 117,
"cost": 112,
"private": 118,
"facilities": 93,
"relationship": 106,
"lifestyle": 65,
"cleanliness": 101,
"distance": 95
}
},
"fdA1-male": {
"total": 850,
"factors": {
"location": 89,
"security": 102,
"cost": 110,
"private": 103,
"facilities": 87,
"relationship": 109,
"lifestyle": 64,
"cleanliness": 89,
"distance": 97
}
},
"fsA2-male": {
"total": 1388,
"factors": {
"location": 162,
"security": 183,
"cost": 174,
"private": 185,
"facilities": 135,
"relationship": 163,
"lifestyle": 91,
"cleanliness": 153,
"distance": 142
}
},
"fdA2-male": {
"total": 1278,
"factors": {
"location": 132,
"security": 157,
"cost": 170,
"private": 160,
"facilities": 126,
"relationship": 169,
"lifestyle": 85,
"cleanliness": 131,
"distance": 148
}
},
"fsA1-female": {
"total": 833,
"factors": {
"location": 93,
"security": 113,
"cost": 105,
"private": 98,
"facilities": 80,
"relationship": 88,
"lifestyle": 65,
"cleanliness": 102,
"distance": 89
}
},
"fdA1-female": {
"total": 798,
"factors": {
"location": 75,
"security": 96,
"cost": 95,
"private": 101,
"facilities": 80,
"relationship": 95,
"lifestyle": 67,
"cleanliness": 96,
"distance": 93
}
},
"fsA2-female": {
"total": 1261,
"factors": {
"location": 140,
"security": 178,
"cost": 163,
"private": 149,
"facilities": 113,
"relationship": 133,
"lifestyle": 92,
"cleanliness": 158,
"distance": 135
}
},
"fdA2-female": {
"total": 1199,
"factors": {
"location": 109,
"security": 146,
"cost": 145,
"private": 156,
"facilities": 117,
"relationship": 144,
"lifestyle": 94,
"cleanliness": 147,
"distance": 141
}
},
"fd-change": { // 14题选yes时,15题各因子的权重。例如,total为更换过的总人数36人,其中因为distance原因,有13个人更换了住宿
"total": 36,
"factors": {
"security": 11,
"private": 9,
"relationship": 8,
"cleanliness": 10,
"distance": 13,
"location": 14,
"cost": 17,
"facilities": 10,
"other": 2,
"lifestyle": 2
}
},
"fdA1-not_change": { // 14题选no时,13题各因子在A1权重算法下的潜在影响。该数据可以和作为假设,然后通过'fd-change'的实际数据去验证结论
"total": 1023,
"factors": {
"location": 100,
"security": 122,
"cost": 129,
"private": 130,
"facilities": 105,
"relationship": 127,
"lifestyle": 70,
"cleanliness": 116,
"distance": 124
}
},
"fdA2-not_change": { // 类似fdA1-not_change,不过换为A2算法。我个人建议用A2算法,突出影响因子的作用。
"total": 1528,
"factors": {
"location": 145,
"security": 185,
"cost": 198,
"private": 201,
"facilities": 152,
"relationship": 194,
"lifestyle": 91,
"cleanliness": 174,
"distance": 188
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment