sex age sbp_b dbp_b sbp_0 dbp_0 dbp_10 sbp_10 dbp_20 sbp_20 dbp_30 sbp_30 group
2 58 160.0 100.0 150.0 94.0 150.0 90.0 146.0 90.0 150.0 92.0 1
2 51 146.0 90.0 130.0 80.0 118.0 70.0 110.0 70.0 110.0 70.0 1
2 47 150.0 90.0 145.0 75.0 135.0 75.0 130.0 60.0 130.0 60.0 1
1 70 160.0 100.0 146.0 90.0 140.0 90.0 140.0 90.0 140.0 90.0 1
1 72 150.0 96.0 140.0 90.0 140.0 90.0 140.0 90.0 140.0 90.0 1
1 60 170.0 100.0 148.0 76.0 140.0 74.0 136.0 72.0 136.0 72.0 1
2 52 148.0 90.0 120.0 80.0 120.0 80.0 120.0 80.0 120.0 80.0 1
2 55 155.0 80.0 140.0 85.0 130.0 80.0 130.0 85.0 130.0 80.0 1
1 77 160.0 100.0 140.0 90.0 140.0 90.0 140.0 90.0 140.0 90.0 1
1 55 150.0 94.0 145.0 80.0 140.0 80.0 135.0 75.0 135.0 75.0 1
2 77 165.0 90.0 160.0 82.0 155.0 80.0 151.0 72.0 140.0 70.0 1
2 66 150.0 100.0 130.0 90.0 120.0 80.0 120.0 80.0 120.0 80.0 1
2 62 150.0 90.0 140.0 86.0 140.0 96.0 140.0 82.0 140.0 82.0 1
2 63 160.0 95.0 150.0 85.0 155.0 75.0 140.0 70.0 136.0 70.0 1
2 67 165.0 90.0 145.0 80.0 140.0 80.0 135.0 75.0 135.0 75.0 1
治疗前后两组病人血压原始数据表 (治疗组):
说明,sex=性别,age=年龄,sbp_b=治疗前收缩压,dbp_b治疗
前舒张压,sbp_0=治疗后 0分钟收缩压,dbp_0治疗后 0
分钟舒张压,…, group=分组
sex age sbp_b dbp_b sbp_0 dbp_0 dbp_10 sbp_10 dbp_20 sbp_20 dbp_30 sbp_30 group
2 65 150.0 80.0 150.0 80.0 150.0 80.0 150.0 80.0 150.0 80.0 2
2 69 180.0 80.0 180.0 80.0 184.0 80.0 184.0 80.0 184.0 80.0 2
2 63 150.0 92.0 146.0 90.0 146.0 90.0 146.0 90.0 150.0 90.0 2
2 65 160.0 100.0 160.0 100.0 162.0 100.0 160.0 98.0 160.0 98.0 2
1 77 170.0 95.0 170.0 95.0 170.0 95.0 170.0 95.0 170.0 95.0 2
2 51 150.0 90.0 142.0 80.0 142.0 80.0 146.0 80.0 146.0 80.0 2
2 69 170.0 110.0 166.0 108.0 170.0 110.0 170.0 110.0 170.0 110.0 2
1 60 160.0 100.0 150.0 100.0 158.0 100.0 158.0 100.0 160.0 100.0 2
1 64 170.0 100.0 168.0 98.0 168.0 98.0 170.0 100.0 170.0 100.0 2
2 58 160.0 95.0 160.0 95.0 160.0 95.0 160.0 95.0 160.0 95.0 2
1 60 180.0 96.0 180.0 96.0 182.0 96.0 182.0 96.0 182.0 96.0 2
2 53 150.0 96.0 150.0 96.0 150.0 96.0 150.0 96.0 150.0 96.0 2
2 67 170.0 100.0 170.0 100.0 170.0 100.0 170.0 100.0 170.0 100.0 2
1 66 150.0 90.0 150.0 90.0 154.0 92.0 154.0 92.0 154.0 92.0 2
1 70 160.0 100.0 158.0 96.0 160.0 100.0 160.0 100.0 160.0 100.0 2
2 62 155.0 94.0 152.0 94.0 155.0 92.0 155.0 94.0 155.0 94.0 2
1 67 164.0 98.0 160.0 95.0 160.0 95.0 164.0 98.0 164.0 98.0 2
续前表 (对照组)
实时分析处理立体表
(Online Analytic Processing Cubs)
Analyze / Reports / OLAP Cubs… 综合统计变量
分组变量
拟统计内容
统计学内容
求均值和标准偏差(立体报表)
求均值和标准偏差(立体表不同层统计结果)
OL A P C u b e s
分组, 1
性别, T ot a l
1 5 5, 9 3 3 7, 4 0 1
9 3, 6 6 7 5, 8 2 7
1 4 1, 9 3 3 9, 7 0 6
8 4, 2 0 0 5, 7 4 7
治疗 前收缩 压
治疗 前舒张 压
治疗 后 0 分钟 收缩压
治疗 后 0 分钟 舒张压
Me a n S t d, D e v ia t io n
OL A P C u b e s
分组, 2
性别, T ot a l
1 6 1, 7 0 6 1 0, 2 8 2
9 5, 0 5 9 7, 3 7 8
1 5 9, 5 2 9 1 1, 4 1 3
9 3, 7 0 6 7, 7 2 0
治疗 前收缩 压
治疗 前舒张 压
治疗 后 0 分钟 收缩压
治疗 后 0 分钟 舒张压
Me a n S t d, D e v ia t io n
治疗组( 1)
对照组( 2)
OL A P C u b e s
分组, T ot a l
性别, 1
1 6 2, 0 0 0 9, 3 8 1
9 7, 4 1 7 3, 2 6 0
1 5 4, 5 8 3 1 2, 7 2 4
9 1, 3 3 3 7, 1 3 9
治疗 前收缩 压
治疗 前舒张 压
治疗 后 0 分钟 收缩压
治疗 后 0 分钟 舒张压
Me a n S t d, D e v ia t io n
男性组(整体)
OL A P C u b e s
分组, T ot a l
性别, 2
1 5 7, 2 0 0 9, 1 2 8
9 2, 6 0 0 7, 5 0 7
1 4 9, 3 0 0 1 4, 2 9 1
8 8, 0 0 0 8, 8 6 2
治疗 前收缩 压
治疗 前舒张 压
治疗 后 0 分钟 收缩压
治疗 后 0 分钟 舒张压
Me a n S t d, D e v ia t io n
女性组(整体)
取消层合并为平面报表
双击 OLAP Cubs表
Pivot / Move Layer to Rows
Pivot / Move Layer to Rows

Pivot / Reset Pivot Defaults
还原表
综合表
Analyze / Reports / Case Summaries…
C a s e S u m m a r i e s
a
1 6 0, 0 1 0 0, 0 1 5 0, 0 9 4, 0
1 4 6, 0 9 0, 0 1 3 0, 0 8 0, 0
1 5 0, 0 9 0, 0 1 4 5, 0 7 5, 0
1 6 0, 0 1 0 0, 0 1 4 6, 0 9 0, 0
1 5 0, 0 9 6, 0 1 4 0, 0 9 0, 0
1 7 0, 0 1 0 0, 0 1 4 8, 0 7 6, 0
1 4 8, 0 9 0, 0 1 2 0, 0 8 0, 0
1 5 5, 0 8 0, 0 1 4 0, 0 8 5, 0
1 6 0, 0 1 0 0, 0 1 4 0, 0 9 0, 0
1 5 0, 0 9 4, 0 1 4 5, 0 8 0, 0
1 6 5, 0 9 0, 0 1 6 0, 0 8 2, 0
1 5 0, 0 1 0 0, 0 1 3 0, 0 9 0, 0
1 5 0, 0 9 0, 0 1 4 0, 0 8 6, 0
1 6 0, 0 9 5, 0 1 5 0, 0 8 5, 0
1 6 5, 0 9 0, 0 1 4 5, 0 8 0, 0
1 5 0, 0 8 0, 0 1 5 0, 0 8 0, 0
1 8 0, 0 8 0, 0 1 8 0, 0 8 0, 0
1 5 0, 0 9 2, 0 1 4 6, 0 9 0, 0
1 6 0, 0 1 0 0, 0 1 6 0, 0 1 0 0, 0
1 7 0, 0 9 5, 0 1 7 0, 0 9 5, 0
1 5 0, 0 9 0, 0 1 4 2, 0 8 0, 0
1 7 0, 0 1 1 0, 0 1 6 6, 0 1 0 8, 0
1 6 0, 0 1 0 0, 0 1 5 0, 0 1 0 0, 0
1 7 0, 0 1 0 0, 0 1 6 8, 0 9 8, 0
1 6 0, 0 9 5, 0 1 6 0, 0 9 5, 0
1 8 0, 0 9 6, 0 1 8 0, 0 9 6, 0
1 5 0, 0 9 6, 0 1 5 0, 0 9 6, 0
1 7 0, 0 1 0 0, 0 1 7 0, 0 1 0 0, 0
1 5 0, 0 9 0, 0 1 5 0, 0 9 0, 0
1 6 0, 0 1 0 0, 0 1 5 8, 0 9 6, 0
1 5 5, 0 9 4, 0 1 5 2, 0 9 4, 0
1 6 4, 0 9 8, 0 1 6 0, 0 9 5, 0
32 32 32 32
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
NT ot a l
治疗 前
收缩 压
治疗 前
舒张 压
治疗 后 0 分
钟收 缩压
治疗 后 0 分
钟舒 张压
L i m i t e d t o f ir s t 1 0 0 c a s e s,a,
样本综合表(无分组)
C a s e S u m m a r i e s
a
1 6 0, 0 1 0 0, 0 1 4 6, 0 9 0, 0
1 5 0, 0 9 6, 0 1 4 0, 0 9 0, 0
1 7 0, 0 1 0 0, 0 1 4 8, 0 7 6, 0
1 6 0, 0 1 0 0, 0 1 4 0, 0 9 0, 0
1 5 0, 0 9 4, 0 1 4 5, 0 8 0, 0
5 5 5 5
1 6 0, 0 1 0 0, 0 1 5 0, 0 9 4, 0
1 4 6, 0 9 0, 0 1 3 0, 0 8 0, 0
1 5 0, 0 9 0, 0 1 4 5, 0 7 5, 0
1 4 8, 0 9 0, 0 1 2 0, 0 8 0, 0
1 5 5, 0 8 0, 0 1 4 0, 0 8 5, 0
1 6 5, 0 9 0, 0 1 6 0, 0 8 2, 0
1 5 0, 0 1 0 0, 0 1 3 0, 0 9 0, 0
1 5 0, 0 9 0, 0 1 4 0, 0 8 6, 0
1 6 0, 0 9 5, 0 1 5 0, 0 8 5, 0
1 6 5, 0 9 0, 0 1 4 5, 0 8 0, 0
10 10 10 10
15 15 15 15
1 5 0, 0 8 0, 0 1 5 0, 0 8 0, 0
1 8 0, 0 8 0, 0 1 8 0, 0 8 0, 0
1 5 0, 0 9 2, 0 1 4 6, 0 9 0, 0
1 6 0, 0 1 0 0, 0 1 6 0, 0 1 0 0, 0
1 5 0, 0 9 0, 0 1 4 2, 0 8 0, 0
1 7 0, 0 1 1 0, 0 1 6 6, 0 1 0 8, 0
1 6 0, 0 9 5, 0 1 6 0, 0 9 5, 0
1 5 0, 0 9 6, 0 1 5 0, 0 9 6, 0
1 7 0, 0 1 0 0, 0 1 7 0, 0 1 0 0, 0
1 5 5, 0 9 4, 0 1 5 2, 0 9 4, 0
10 10 10 10
1 7 0, 0 9 5, 0 1 7 0, 0 9 5, 0
1 6 0, 0 1 0 0, 0 1 5 0, 0 1 0 0, 0
1 7 0, 0 1 0 0, 0 1 6 8, 0 9 8, 0
1 8 0, 0 9 6, 0 1 8 0, 0 9 6, 0
1 5 0, 0 9 0, 0 1 5 0, 0 9 0, 0
1 6 0, 0 1 0 0, 0 1 5 8, 0 9 6, 0
1 6 4, 0 9 8, 0 1 6 0, 0 9 5, 0
7 7 7 7
17 17 17 17
32 32 32 32
1
2
3
4
5
NT o t a l
1
1
2
3
4
5
6
7
8
9
10
NT o t a l
2
NT o t a l
性别1
1
2
3
4
5
6
7
8
9
10
NT o t a l
2
1
2
3
4
5
6
7
NT o t a l
1
NT o t a l
性别2
NT o t a l
分组
治疗 前
收缩 压
治疗 前
舒张 压
治疗 后 0 分
钟收 缩压
治疗 后 0 分
钟舒 张压
L im it e d t o f ir s t 1 0 0 c a s e s,a,
样本分组综合表
样本综合表(分类统计)
不显示个体
可进行分类
统计