Excel回归分析拟合河流水位-流量关系

Excel集数据分析、数据计算、图文处理功能为一身,包含了大量的与多变量回归分析相关的函数和工具。利用Excel回归分析拟合河流水位-流量关系的方法比Origin、 MATLAB等专业数据分析软件更为简单实用。文章依据某水文站水位-流量实测数据,以Excel提供的5种趋势预测类型,分别阐述河流水位-流量关系Excel回归分析的方法和步骤,并利用拟合优度参数对拟合结果进行了检验和分析。     

基于YUV颜色空间的脸部区域特征点定位方法

为了实现面部主要特征点的精确定位,提出了一种融合YUV颜色空间与差分投影技术的人脸区域主要特征点定位方法。利用直方图拟合技术,实现了人脸区域的定位;在YUV颜色空间内,利用红色调像素点集的相位分布完成了嘴部区域的定位;利用差分投影技术求取脸部区域的横、纵向灰度差之和,并结合嘴唇区域的定位结果完成眼部区域的垂直定位与水平定位,为进行面部姿态识别奠定基础。试验结果表明,该方法可以有效地实现面部主要特征点地定位,具有准确率高,鲁棒性好,简单易行的特点。     

基于RAGA的水稻敏感指数累积函数研究

水稻敏感指数累积函数的提出,解决了水分敏感指数研究过程中理论研究与实际应用相矛盾的问题,使水分生产函数的应用更为方便。但敏感指数累积函数的拟合过程十分繁琐,应用存在一定难度。针对上述问题,利用实码加速遗传算法直接拟合敏感指数累积函数,研究结果表明,该方法思路清晰,不需要任何公式转化,计算简便,精度比传统方法高,为敏感指数累积函数的应用提供了有效的方法。     

基于优化拟合的梯形明渠临界水深简化算法

针对现有梯形断面,临界水深计算方法的公式表达形式不简捷、计算精度不高等问题,采用优化拟合方法,提出一种更加简捷实用的简化算法。实例计算分析及比较结果表明,该算法在工程实用参数范围内,可获得较高的计算精度,最大拟合误差小于0．556％,平均相对误差仅为．0．001％,相对误差小于0．5％的点占总比较点数的89．3％,完全能够满足实际工程的设计精度要求。     

A review of the methodology and applications of anthropometry in ergonomics and product design

Abstract

Anthropometry is a key element of ergonomic studies for addressing the problem of fitting the tasks/products to user characteristics, but there is a gap between anthropometric data and their application for designing ergonomic products and environments. This research was conducted to review the literature on the methodology and applications of anthropometry for the ergonomic design of products and environments, and to identify where further research is needed to improve its application and evaluation protocols. One hundred and sixteen papers meeting the inclusion criteria were reviewed. Although a number of anthropometric investigations have been conducted to improve the design of products/environments for different users, further research seems to be necessary, particularly for special groups, such as children, the elderly and people with disabilities. Different anthropometric measurement methods/techniques and fitting criteria are discussed regarding their applicability for various design applications. This review also highlights methodological issues (sampling considerations and prototype evaluation and testing) that should be considered in future research to ensure a user-centred approach of the design process.

Practitioner Summary: A literature review was conducted on the methodology and applications of anthropometry for the ergonomic design of products/environments. This review emphasises the need for anthropometric research to design for special groups, such as children, the elderly and people with disabilities, and methodological issues that should be considered in future research.

Abbreviations: 1D: one-dimensional; 2D: two-dimensional; 3D: three-dimensional; HF/E: Human Factors/Ergonomics; PCA: Principal Components Analysis; CA: Cluster Analysis; DHM: Digital Human Modelling     

基于全站仪组网测量系统的测量方法研究

全站仪测量系统是由一台计算机和数台全站仪组成的一种测量系统。可以完成在工业测量中的单点坐标的测量,特别是大尺寸结构件的测量。根据坐标拟合测量原理,使多台全站仪更精确地统一到同一用户坐标系下进行测量,消除大型结构件单站测量的盲点,提高测量精度,实现大型结构件的加工及装配的在线检测。     

一种模拟传感器非线性校正电路设计

该文针对模拟型传感器存在的非线性问题,设计了一种函数变换电路,用硬件方式实现非线性校正。由传感器的传输特性推导校正函数,利用模拟集成器件进行电路设计。校正电路以传感器的输出电压作为输入量,输出电压值与被测物理量成线性关系。通过simulink仿真软件对设计方案进行仿真分析。     

Multisim和Excel在二极管特性研究中的应用

在二极管的特性研究中,同时引入了Multisim和Excel软件,应用Muhisim对二极管的特性进行测试仿真,应用Excel对测试结果进行曲线拟合、显示,相比传统的实物电路测试更加方便和快捷,相比传统的手绘特性曲线更加精确和直观,通过对仿真数据进行曲线拟合,对其进行分析和研究,可以更加深入的认识二极管的特性．     

Logistic模型在工资增长预测中的应用

针对工资增长规律和Logistic模型的特点和适用性,利用Maple软件预测出了从2011年至2035年山东省职工的年平均工资,并计算出了山东省某企业职工在各种情况下的养老金替代率及职工缴存的养老保险基金与领取的养老金之间达到收支平衡时其领取养老金的年限.