弯沉值自动计算公式表格文件下载.xls
《弯沉值自动计算公式表格文件下载.xls》由会员分享,可在线阅读,更多相关《弯沉值自动计算公式表格文件下载.xls(1页珍藏版)》请在冰豆网上搜索。
K3+520K3+680K3+520K3+680段段弯弯沉沉测测量量序号初读数终读数单点弯沉值(x)平均值()(x-)2(x-)2标准差()代表弯沉值(L1)备注左右左右左右160.94左右左+右a1804598598710484484188228228160.94732.24364497.04365229.287270.13196276276.30707871.6452550562490474120176160.941676.0836226.80361902.88721.53378797797303697697150200200160.94119.68361525.68361645.3672245(设计)L04513513476476405405378378216216196196160.943031.60361229.20364260.80725692407622356140102160.94438.48363473.92363912.4072L1=+a*L06601400518350166100160.9425.60363713.68363739.2872=(x1+xn)/n771171161061461458019419460160.941092.963610188.883611281.8472=(x1.n-)2)/n)(1/2)8560388495297130182160.94957.2836443.52361400.80729540540206395395129290290154160.9416656.48448.163616704.647210631947947567836836128222222160.941085.04363728.32364813.367211770770476698698369144214160.94286.96362815.36363102.327212750411672347156128160.9424.40361085.04361109.44721366765758761216090160.940.88365032.48365033.367214384270270304168168160204204160.940.88361854.16361855.047215702702256607607189190190134160.94844.4836725.76361570.24721675243566640717256160.94122.323611012.403611134.727217