基于VBA与Excel的高校成绩统计分析模板设计

该文应用VBA(Visual Basic for Application)对Excel二次开发的功能,编程设计了成绩统计与分析模板,实现了学生考试成绩的自动统计和填写、自动完成了各分数段人数和重点观测指标的统计、自动生成了分析图表等。应用该模板,可以大大减轻教师进行学生考试成绩统计与分析工作带来的负担,对教学管理中的学生成绩统计与分析具有一定的推广使用价值。     

Real-time 2D–3D filtering using order statistics based algorithms

The paper presents a review of the author’s own results obtained in the last several years. Some examples of real-time processing of 2D and 3D images are described. In particular, we discuss the noise model and objective criteria that can be applied to characterize the performance of the processing algorithms. Several proposed algorithms based on RM approach are compared with other known ones, demonstrating the advantages in noise suppressing and preservation of fine image details and edges. A number of 2D and 3D image denoising filters are implemented on DSP, realizing real-time mode in the image processing. The performances of the proposed processing algorithms and the known ones are discussed and evaluated here.

Higher order spectral estimation for random fields

This paper is concerned with the nonparametric estimation of the higher order cumulant spectra of vector-valued stationary random fields onZ ^d by smoothing the periodograms, whereZ is the space of integers and the dimensiond1. We derive the asymptotic cumulant properties of the spectral estimates, and consider an application to multidimensional nonlinear systems identification. Numerical examples with simulated data are provided.     

ON THE PARTIAL SUMS OF RESIDUALS IN AUTOREGRESSIVE AND MOVING AVERAGE MODELS

Abstract. The limiting process of partial sums of residuals in stationary and invertible autoregressive moving-average models is studied. It is shown that the partial sums converge to a standard Brownian motion under the assumptions that estimators of unknown parameters are root- n consistent and that innovations are independent and identically distributed random variables with zero mean and finite variance or, more generally, are martingale differences with moment restrictions specified in Theorem 1. Applications for goodness-of-fit and change-point problems are considered. The use of residuals for constructing nonparametric density estimation is discussed.     

Strength Analysis of Yttria-Stabilized Tetragonal Zirconia Polycrystals

Tensile strength of Y₂O₃-stabilized ZrO₂ polycrystals (Y-TZP) was measured by a newly developed tensile testing method with a rectangular bar. The tensile strength of Y-TZP was lower than that of the three-point bend strength, and the shape of the tensile strength distribution was quite different from that of the three-point bend strength distribution. It was difficult to predict the distribution curve of the tensile strength using the data of the three-point bend strength by one-modal Weibull distribution. The distribution of the tensile strength was analyzed by two- or three-model Weibull distribution coupled with an analysis of fracture origins. The distribution curve of the three-point bend strength which was estimated by multimodal Weibull distribution agreed favorably with that of the measured three-point bend strength values. A two-modal Weibull distribution function was formulated approximately from the distributions of the tensile and three-point bend strengths, and the estimated two-modal Weibull distribution function for the four-point bend strength agreed well with the measured four-point bend strength.     

Systematic benchmarking of microarray data feature extraction and classification

A combination of microarrays with classification methods is a promising approach to supporting clinical management decisions in oncology. The aim of this paper is to systematically benchmark the role of classification models. Each classification model is a combination of one feature extraction method and one classification method. We consider four feature extraction methods and five classification methods, from which 20 classification models can be derived. The feature extraction methods are t-statistics, non-parametric Wilcoxon statistics, ad hoc signal-to-noise statistics, and principal component analysis (PCA), and the classification methods are Fisher linear discriminant analysis (FLDA), the support vector machine (SVM), the k nearest-neighbour classifier (kNN), diagonal linear discriminant analysis (DLDA), and diagonal quadratic discriminant analysis (DQDA). Twenty randomizations of each of three binary cancer classification problems derived from publicly available datasets are examined. PCA plus FLDA is found to be the optimal classification model.     

ACOMCD: A multiple cluster detection algorithm based on the spatial scan statistic and ant colony optimization

The spatial scan statistic (SaTScan) has become one of the most popular methods for detecting and evaluating spatial clusters. However, this method can only identify circular or elliptical clusters and is not a good fit for the detection of irregularly shaped clusters. Numerous methods have since been proposed to solve this problem. Nevertheless, if multiple clusters coexist, these methods may not identify the correct situation, because the interference between clusters can easily lead to a tree-like shaped cluster and cause confusion in the results. In this paper, we propose an Ant Colony Optimization based Multiple Cluster Detection (ACOMCD) algorithm, which combines classical SaTScan with the ant colony optimization (ACO) approach. In the initial stage, SaTScan is first used to mark the candidate cluster areas according to the significance of their maximum likelihood evaluations. Then ACO-based scan statistic is carried out separately on these candidate clusters to identify their natural shapes. The algorithm was designed for spatial regional count data only. Comparisons between ACOMCD, SaTScan, GaScan (genetic algorithm-based scan statistic), and FleXScan (flexibly shaped spatial scan statistic) on three kinds of simulated datasets show that ACOMCD performs the best in simultaneously determining the exact number of clusters and identifying multiple irregularly shaped clusters. A case study on esophageal cancer in eastern China further validates the correctness and effectiveness of ACOMCD.     

金沙江乌东德水库诱发地震统计预测研究

为了研究乌东德水库诱发地震的可能性,在选用国内外377座已建水库统计资料的基础上,对乌东德水库诱发地震进行预测分析。针对具体地质条件,共选出了10个影响因子,并将影响因子细化为3种不同状态,在此基础上建立了水库诱发地震预测统计模型。模型将诱震的10个概率因子表述为几个相应的地理位置可以完全叠加的矢量图层,然后进行GIS图层计算,实现了水库诱发地震的统计预测。研究结果表明,乌东德水库具备诱发地震的可能性。     

设计洪水估计值的抽样误差分析与应用

在设计洪水估计值的抽样误差分析中,采用B值诺模图方法估计均方误差简单易用。文章对在水电工程中经常采用的P-Ⅲ型经验适线法估计的设计洪水成果如何借助优化适线法参数来估算设计洪水值的抽样误差进行了分析说明。不同的优化适线法会得到不同的诺模系数B,估算设计洪水估计值的抽样误差时,选用某一准则的优化适线要使用相应的诺模系数B值。并分别对实测洪水的连序系列及含历史洪水的不连序系列资料进行了应用分析。     

基于Logistic模型的P2P资源流行程度分析

为了解决目标资源数量增多而带来的监管成本过高的问题,提出一种基于Logistic模型的资源流行程度分析方法.利用该方法估计目标资源的流行程度,剔除流行程度低的资源,以此缩小监控范围,减少节点的部署数量.在Kad中对不同资源进行追踪,统计资源的共享节点数量,估计Logistic模型的参数,并进行曲线拟合.通过决策树建模得出,资源的共享节点数量和资源大小是影响该方法准确性的关键因素.