刘天, 吴杨, 童叶青, 陈琦, 漆莉, 姚梦雷, 黄继贵, 黄淑琼. 应用Excel软件实现基于MCS-P的空间扫描统计量最大空间扫描尺度筛选方法[J]. 疾病监测, 2019, 34(11): 1026-1030. DOI: 10.3784/j.issn.1003-9961.2019.11.016
引用本文: 刘天, 吴杨, 童叶青, 陈琦, 漆莉, 姚梦雷, 黄继贵, 黄淑琼. 应用Excel软件实现基于MCS-P的空间扫描统计量最大空间扫描尺度筛选方法[J]. 疾病监测, 2019, 34(11): 1026-1030. DOI: 10.3784/j.issn.1003-9961.2019.11.016
Tian Liu, Yang Wu, Yeqing Tong, Qi Chen, Li Qi, Menglei Yao, Jigui Huang, Shuqiong Huang. Application of Excel to realize maximum spatial scanning scale screening of spatial scan statistics based on MCS-P[J]. Disease Surveillance, 2019, 34(11): 1026-1030. DOI: 10.3784/j.issn.1003-9961.2019.11.016
Citation: Tian Liu, Yang Wu, Yeqing Tong, Qi Chen, Li Qi, Menglei Yao, Jigui Huang, Shuqiong Huang. Application of Excel to realize maximum spatial scanning scale screening of spatial scan statistics based on MCS-P[J]. Disease Surveillance, 2019, 34(11): 1026-1030. DOI: 10.3784/j.issn.1003-9961.2019.11.016

应用Excel软件实现基于MCS-P的空间扫描统计量最大空间扫描尺度筛选方法

Application of Excel to realize maximum spatial scanning scale screening of spatial scan statistics based on MCS-P

  • 摘要:
    目的探讨应用Excel软件实现基于MCS-P的空间扫描统计量最大空间扫描尺度筛选的可能性。
    方法基于2016年湖北省手足口病(HFMD)发病率数据,将最大空间扫描尺度参数依次设为湖北省总人口数的1%、2%、3%、···、50%,利用Excel软件编程计算各参数评价指标MCS-P,筛选出最大者对应参数为最优参数。 利用最优参数探测2016年湖北省HFMD的空间聚集性。
    结果2016年湖北省102个县(市、区)均有HFMD病例报告,发病率为17.92/10万~898.69/10万。 最大空间扫描尺度为湖北省总人口数的3%时,MCS-P取得最大值为0.869。 以该参数进行空间聚集性分析,共探测到29个聚集区,分布在41个县(市、区),主要分布在湖北省北部和东南部。
    结论利用Excel软件编程可以实现基于MCS-P的空间扫描统计量最大空间扫描尺度筛选,具有一定的推广价值。

     

    Abstract:
    ObjectiveTo evaluate the feasibility of application of Excel to realize the maximum spatial scanning scale screening of spatial scan statistics based on MCS-P.
    MethodsBased on the incidence data of hand foot and mouth disease (HFMD) in Hubei province in 2016, the parameters of the maximum spatial scan scale were set to 1%, 2%, 3%... 50% of the total population of Hubei. The parameter evaluation index MCS-P was calculated by Excel software. The optimal parameter was the largest MCS-P value, which was used to detect the spatial clustering of HFMD in Hubei in 2016.
    ResultsHFMD cases were reported in 102 counties (districts) in Hubei in 2016, with the incidence rates ranging from 17.92/100 000 to 898.69/100 000. When the maximum spatial scan scale was 3% of the total population of Hubei, MCS-P was 0.869, which was the maximum value in the results. Spatial clustering analysis was carried out with the optimal parameter. A total of 29 clusters were detected, which were distributed in 41 counties (districts) mainly in the northern and southeastern parts of Hubei.
    ConclusionExcel can be used to realize the maximum spatial scanning scale screening of spatial scan statistics based on MCS-P, which has some application value.

     

/

返回文章
返回