治疗前后两组病人血压原始数据表(治疗组) 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 女性组(整体)
分组性别 MeanStdDeviation 取消层合并为平面报表 治疗前舒张压 98000 治疗后0分钟收缩压143.800 治疗后0分钟舒张压 6723 前收缩压 154.900 7.109 双击 OLAP Cubs表 治疗前舒张压 5.798 治疗后0分钟收缩压 Pivot/Move Layer to Row! Tota! FaE EKE87005519 治疗后0分 7.401 治疗前 治疗后0分钟收缩压141.93 9706 治疗后0分钟舒张压 5.747 或 2 治疗前收缩玨 164857 9.582 治疗前舒张压 3697 治疗后0分钟收缩压162286 11.041 Pivot/Move Layer to Row 治疗后0分钟舒张压 714 j收缩压 159500 治疗前舒张压 9093 还原表 治疗后0分钟收缩压15760 11843 治疗后0分钟舒张压 Tota治疗前收缩 161.706 10282 Pivot/ Reset Pivot Default 治疗前舒张压 治疗后0分钟收缩压159.529 1 治疗后0分钟舒张压 Total 1 前收缩压 162000 381 治疗前舒张压 97417 3.260 治疗后0分钟收缩压154583 治疗后0分钟舒张压 91.333 7.139 前收缩 治疗前舒张压 92600 750 治疗后0分钟收缩压149.300 14.291 治疗后0分钟舒张压 8862 前收缩压 治疗前舒张压 94.406 6628 治疗后0分钟收缩压151281 13.761
取消层合并为平面报表 双击OLAP Cubs表 Pivot / Move Layer to Rows Pivot / Move Layer to Rows 或 Pivot / Reset Pivot Defaults 还原表
综合表 Analyze /Reports/ Case Summaries Summarize Cases 参年龄aqe Variables OK 参治疗后10分钟收缩压sb 秒治疗前收缩压sbpb 参治疗后10分钟舒张压db 参治疗前舒张压[dbpb Paste 参治疗后20分钟收缩压sb 秒治疗后0分钟收缩压lsbp 治疗后20钟舒张压b Reset 治疗后30分钟收缩压[sb 治疗后0分钟张压dtpE 治疗后30分钟舒张压[db Cancel Help Summary Report: Statistics Grouping Variable(s) Statistics Cell Statistics: 「分组[ group Number of case 性别lsex Median Grouped Median Std Error of Mean Sum v Display cases Minimum Maximum v Limit cases to first 100 Rai v Show only valid cases 厂 Show case numbers Statistics… Options Standard Deviation variance Kurtosis Std. Error of Kurtosis Skewness Continue Cancel Help
综合表 Analyze / Reports / Case Summaries…
Case summaries 治疗前治疗前治疗后0分治疗后0分 收缩压舒张压钟收缩压钟舒张压 样本综合表(无分组) 160.0 150.0 94.0 146.0 90.0 130.0 80.0 23456789 150.0 145.0 75.0 160.0 100.0 146.0 90.0 50.0 96.0 40.0 90.0 170.0 100.0 148.0 76.0 148.0 90.0 120.0 80.0 155.0 80.0 140.0 85.0 160.0 100.0 140.0 90.0 10 150.0 165.0 90.0 160.0 82.0 12345618 150.0 100.0 130.0 150.0 90.0 140.0 86.0 160.0 95.0 165.0 90.0 145.0 80.0 150.0 80.0 80.0 180.0 80.0 180.0 80.0 150.0 92.0 146.0 90.0 160.0 100.0 00.0 2 90123 170.0 150.0 90.0 80.0 110.0 108.0 00.0 000000 100.0 170.0100.0 160.0 95.0 160.0 95.0 180.0 150.0 96.0 150.0 96.0 170.0 100.0 00.0 29 150.0 90.0150.0 160.0 100.0 96.0 33T 00000 164.0 0 95.0 a. Limited to first 100 cases
Case Summariesa 160.0 100.0 150.0 94.0 146.0 90.0 130.0 80.0 150.0 90.0 145.0 75.0 160.0 100.0 146.0 90.0 150.0 96.0 140.0 90.0 170.0 100.0 148.0 76.0 148.0 90.0 120.0 80.0 155.0 80.0 140.0 85.0 160.0 100.0 140.0 90.0 150.0 94.0 145.0 80.0 165.0 90.0 160.0 82.0 150.0 100.0 130.0 90.0 150.0 90.0 140.0 86.0 160.0 95.0 150.0 85.0 165.0 90.0 145.0 80.0 150.0 80.0 150.0 80.0 180.0 80.0 180.0 80.0 150.0 92.0 146.0 90.0 160.0 100.0 160.0 100.0 170.0 95.0 170.0 95.0 150.0 90.0 142.0 80.0 170.0 110.0 166.0 108.0 160.0 100.0 150.0 100.0 170.0 100.0 168.0 98.0 160.0 95.0 160.0 95.0 180.0 96.0 180.0 96.0 150.0 96.0 150.0 96.0 170.0 100.0 170.0 100.0 150.0 90.0 150.0 90.0 160.0 100.0 158.0 96.0 155.0 94.0 152.0 94.0 164.0 98.0 160.0 95.0 3 2 3 2 3 2 3 2 1 2 3 4 5 6 7 8 9 1 0 1 1 1 2 1 3 1 4 1 5 1 6 1 7 1 8 1 9 2 0 2 1 2 2 2 3 2 4 2 5 2 6 2 7 2 8 2 9 3 0 3 1 3 2 Total N 治疗前 收缩压 治疗前 舒张压 治疗后 0分 钟收缩 压 治疗后 0分 钟舒张 压 a. Limited to first 100 cases. 样本综合表(无分组)
Case Summaries 样本分组综合表 治疗前治疗前治疗后0分治疗后0分 收缩压舒张压钟收缩 钟舒张压 性别1 146.0 90.0 140.0 90.0 0000 148.0 76.0 2 12345T12345678 005 140 005 160.01000 150.0 146.0 90.0 130.0 80.0 150.0 90.0 145.0 75.0 148.0 0.0 120.0 80.0 165.0 160.0 150.0 000 130.0 90.0 140.0 86.0 150.0 145.0 Total N 00005 10 10 15 性别2 150.0 80.0 150.0 80.0 180.0 180.0 80.0 150.0 146 160 000 100.0 150.0 90.0 142 80.0 70.01100 166.0 95.0 160 95.0 150.0 150.0 96.0 9 100 Total N 000000 000 000 170.0 95.0 170.0 50.0 100.0 170. 168.0 96.0 180.0 96.0 5 150.0 90.0 150.0 90.0 160.0100.0 158.0 96.0 95.0 Tota N 1 Total 772 a. Limited to first 100 cases
Case Summariesa 160.0 100.0 146.0 90.0 150.0 96.0 140.0 90.0 170.0 100.0 148.0 76.0 160.0 100.0 140.0 90.0 150.0 94.0 145.0 80.0 5 5 5 5 160.0 100.0 150.0 94.0 146.0 90.0 130.0 80.0 150.0 90.0 145.0 75.0 148.0 90.0 120.0 80.0 155.0 80.0 140.0 85.0 165.0 90.0 160.0 82.0 150.0 100.0 130.0 90.0 150.0 90.0 140.0 86.0 160.0 95.0 150.0 85.0 165.0 90.0 145.0 80.0 1 0 1 0 1 0 1 0 1 5 1 5 1 5 1 5 150.0 80.0 150.0 80.0 180.0 80.0 180.0 80.0 150.0 92.0 146.0 90.0 160.0 100.0 160.0 100.0 150.0 90.0 142.0 80.0 170.0 110.0 166.0 108.0 160.0 95.0 160.0 95.0 150.0 96.0 150.0 96.0 170.0 100.0 170.0 100.0 155.0 94.0 152.0 94.0 1 0 1 0 1 0 1 0 170.0 95.0 170.0 95.0 160.0 100.0 150.0 100.0 170.0 100.0 168.0 98.0 180.0 96.0 180.0 96.0 150.0 90.0 150.0 90.0 160.0 100.0 158.0 96.0 164.0 98.0 160.0 95.0 7 7 7 7 1 7 1 7 1 7 1 7 3 2 3 2 3 2 3 2 1 2 3 4 5 Total N 1 1 2 3 4 5 6 7 8 9 1 0 Total N 2 Total N 1 性 别 1 2 3 4 5 6 7 8 9 1 0 Total N 2 1 2 3 4 5 6 7 Total N 1 Total N 2 性 别 Total N 分 组 治疗前 收缩压 治疗前 舒张压 治疗后 0分 钟收缩 压 治疗后 0分 钟舒张 压 a. Limited to first 100 cases. 样本分组综合表
样本综合表(分类统计) 4 Summarize Cases 糁年龄lage Variables: OK 糁治疗后10分钟收缩压Isb 带治疗前收缩压sbpb 参治疗后10分钟舒张压[db 治疗前舒张压bpb ste 治疗后20分钟收缩压lsb 带治疗后0分钟收缩压bp 参治疗后20分钟舒张压[db 参治疗后0分钟舒张压[dbp Reset 参治疗后30分钟收缩压sb 治疗后30分钟舒张压[db Cancel :lp Grouping Variable[s] 带分组[ group 性别s 不显示个体 厂 Display cases 可进行分类 F Limit cases to first 100 统计 Show only valid cases 厂 Show case numbers Statistics Options
样本综合表(分类统计) 不显示个体 可进行分类 统计