重庆理工大学学报：自然科学
重慶理工大學學報：自然科學
중경리공대학학보：자연과학
Journal of Chongqing Institute of Technology
2012年
5期
62-65
,共4页
CCD%弹性模量%最小二乘法
CCD%彈性模量%最小二乘法
CCD%탄성모량%최소이승법
CCD%Young modulus%least square method
介绍了一种CCD弹性模量测定装置，给出了这种装置的测量原理及测定方法，分析说明了使用这种装置测定弹性模量的益处。结合具体实验测量数据，说明如何运用Excel的“插入函数”功能进行最小二乘法等运算，给出了相应的弹性模量及测量不确定度。
介紹瞭一種CCD彈性模量測定裝置，給齣瞭這種裝置的測量原理及測定方法，分析說明瞭使用這種裝置測定彈性模量的益處。結閤具體實驗測量數據，說明如何運用Excel的“插入函數”功能進行最小二乘法等運算，給齣瞭相應的彈性模量及測量不確定度。
개소료일충CCD탄성모량측정장치，급출료저충장치적측량원리급측정방법，분석설명료사용저충장치측정탄성모량적익처。결합구체실험측량수거，설명여하운용Excel적“삽입함수”공능진행최소이승법등운산，급출료상응적탄성모량급측량불학정도。
An installation of measuring Young modulus by CCD is introduced, the measurement prin- ciple and determination method are given, and the advantage of determining Young modulus by using this experiment equipment is analyzed and described. By using the insert function of Excel, the con- crete experiment data is calculated by least square method in Excel Worksheet. The relevant Young modulus and its measurement uncertainty are given, so the students can know the superiority of calcu- lating experimental data by making use of the insert function of Excel.
