利用Excel处理稳态法测定导热系数的实验数据

The Experimental Data of Thermal Conductivity Measurement by Steady State Method were Processed by Excel

基于稳态法测定导热系数实验,为了求得更为精确的散热铜盘在稳态点的冷却率,用Excel软件处理实验数据,拟合出散热铜盘温度和时间的高阶曲线,并得出稳态点的切线方程,从而求得冷却率及导热系数。减少了手工作图求解切线方程所带来的误差,提高了数据处理的效率和实验结果的准确性。

Based on the experiment of measuring thermal conductivity by steady-state method,in order to obtain more accurate cooling rate of heat-dissipating copper disc at steady-state point,the higher-order curve of temperature and time of heat-dissipating copper disc is fitted by Excel software,and the tangent equation of steady-state point is obtained,so as to obtain cooling rate and thermal conductivity.The error caused by solving tangent equation by manual drawing is reduced,and the efficiency of data processing and the accuracy of experimental results are improved.