治疗前后两组病人血压原始数据表(治疗组) sex age sbp b dbp b sbp 0 dbp 0 dbp 10 sbp 10 dbp 20 sbp 20 dbp 30 sbp 30 group 258160.0100.0150.094.0150.090.0146.090.0150.092.01 251146.090.0130.080.0118.070.0110.070.0110.070.01 247150.090.0145.075.0135.075.0130.060.0130.060.01 170160.0100.0146.090.0140.090.0140.090.0140.090.0 72150.096.0140.090.0140.090.0140.090.0140.090.01 60170.0100.0148.076.0140.074.0136.072.0136.072.0 252148.090.0120.080.0120.080.0120.080.0120.080.0 255155.080.0140.085.0130.080.0130.085.0130.080.01 177160.0100.0140.090.0140.090.0140.090.0140.090.0 155150.094.0145.080.0140.080.0135.075.0135.075.01 277165090.0160.082.0155.080.0151.072.0140.070.0 266150.0100.0130.090.0120.080.0120.080.0120.080.0 262150.090.0140.086.0140.096.0140.082.0140.082.01 263160.095.0150.085.0155.075.0140.070.0136.070.01 267165.090.0145.080.0140.080.0135.075.0135.075.01 说明:sex=性别,age=年龄,sbpb=治疗前收缩压,dbpb治疗 舒张压,sbp0=治疗后0分钟收缩压,dbp0洽疗后0 分钟舒张压,….,goup=分组
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 dbp o dbp 10 sbp 10 dbp 20 sbp 20 dbp 30 sbp 30 group 265150.080.0150.080.0150.080.0150.080.0150.08002 269180.080.0180.080.0184.080.0184.080.0184.080.02 263150.092.0146.090.0146090.0146.090.0150.090.02 265160.0100.0160.0100.0162.0100.0160.098.0160.098.02 177170.095.0170.095.0170.095.0170.095.0170.095.02 251150.090.0142.080.0142.080.0146.080.0146.08002 269170.0110.01660108.0170.0110.0170.0110.0170.0110.02 160160.0100.0150.0100.0158.0100.0158.0100.0160.0100.02 64170.0100.0168.098.0168.098.0170.0100.0170.0100.02 258160.095.0160.095.0160.095.0160.095.0160.095.02 160180.096.0180.096.0182.096.0182.096.0182.096.02 253150.096.0150.096.0150.096.0150.096.0150.096.02 267170.0100.0170.0100.0170.0100.0170.0100.0170.0100.02 166150.090.0150.090.0154.092.0154.092.0154.092.02 170160.0100.0158.096.0160.0100.0160.0100.0160.0100.02 262155.094.0152.094.0155.092.0155.094.0155.094.02 167164.098.0160.095.0160.095.0164.098.0164.098.02
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 OLAP Cube P争年龄age Summary Variable(s」 治疗后10分钟收缩压sb 治疗前收缩压|sbpb 治疗后10分钟舒张压b 参治疗前舒张压[dbpb] Paste 统计学内容 治疗后20分钟收缩压sb 治疗后0分钟收缩压Isbp 参治疗后20分钟舒张压b 参治疗后0分钟舒张压[dbp Reset >治疗后30分钟收缩压sb >治疗后30分钟舒张压[d OLAP Cubes: Statistics Help Grouping Variable[s Statistics Cell Statistics 带分组[ Igroup 命程别|sex Standard deviation Statistics Variance Kurtosis Title Std. Error of kurtosis Skewness Std. Error of skewness Harmonic mean Geometric Mean Percent of Sum in[group] Percent of N in[group] 分组变量 Sum Number of cases Percent of Total Sum 拟统计内容 Cancel Help
实时分析处理立体表 (Online Analytic Processing Cubs) Analyze / Reports / OLAP Cubs… 综合统计变量 分组变量 拟统计内容 统计学内容
求均值和标准偏差(立体报表) 刂+回Q E Output 白 OLAP Cubes ◆ OLAP Cubes L OLAP Cubes Case Processing Summary Cases Included 分组*性别 32100.0% 0 32100% 治疗前舒张压 治疗后0分钟收缩 压*分组*性别 32100% 治疗后0分钟舒张 1000 1000 OLAP Cubes 分组:Tot Mean Std Deviation 治疗前舒张压 94.406 6628 治疗后0分钟收缩压151.281 13,761 治疗后0分钟舒张压|89250 8.301 9 sPsS Processor is ready
求均值和标准偏差(立体报表)
求均值和标准偏差(立体表不同层统计结果) OLAP Cubes oLAP Cubes 分组:1 分组:Tota 性别: Total 性别:1 Mean Std Deviation MeanStdDeviation 治疗前收缩压 155.933 7,401 治疗前收缩压 162.000 9.381 治疗前舒张压 93.667 5.827 治疗前舒张压 3.260 治疗后0分钟收缩压141933 9.706 治疗后0分钟收缩压154583 12.724 治疗后0分钟舒张压91.333 7.139 治疗后0分钟舒张压84.200 5.747 治疗组(1) 男性组(整体) oLAP Cubes oLAP Cubes 分组:2 分组: Total 性别: Total 性别:2 Mean Std Deviation Mean Std Deviation 台疗前收缩压 161.706 10.282 治疗前收缩压 157.200 9.128 治疗前舒张压 95.059 7.378 治疗前舒张压 92.600 7.507 治疗后0分钟收缩压159529 11413 治疗后0分钟收缩压149.300 14.291 8.862 治疗后0分钟舒张压93,706 治疗后0分钟舒张压|88.000 7.720 对照组(2) 女性组(整体)
求均值和标准偏差(立体表不同层统计结果) OLAP Cubes 分 组: 1 性 别: Total 155.933 7.401 93.667 5.827 141.933 9.706 84.200 5.747 治疗前收 缩压 治疗前舒 张压 治疗后0分钟收缩 压 治疗后0分钟舒张 压 Mean Std. Deviation OLAP Cubes 分 组: 2 性 别: Total 161.706 10.282 95.059 7.378 159.529 11.413 93.706 7.720 治疗前收 缩压 治疗前舒 张压 治疗后0分钟收缩 压 治疗后0分钟舒张 压 Mean Std. Deviation 治疗组(1) 对照组(2) OLAP Cubes 分 组: Total 性 别: 1 162.000 9.381 97.417 3.260 154.583 12.724 91.333 7.139 治疗前收 缩压 治疗前舒 张压 治疗后0分钟收缩 压 治疗后0分钟舒张 压 Mean Std. Deviation 男性组(整体) OLAP Cubes 分 组: Total 性 别: 2 157.200 9.128 92.600 7.507 149.300 14.291 88.000 8.862 治疗前收 缩压 治疗前舒 张压 治疗后0分钟收缩 压 治疗后0分钟舒张 压 Mean Std. Deviation 女性组(整体)