The LINEST technique, the regression tool and chart tool built in the EXCEL were used to generate a best-fit line and calculate relevant parameters as well as uncertainty.
用EXCEL提供的函数LINEST和回归分析工具进行线性回归分析,并利用EXCEL的插入图表功能做线性回归拟合图。也示例说明了线性回归产生的测量不确定度的计算。