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

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.