分析测试百科网

搜索

喜欢作者

微信支付微信支付
×

怎么在excel中计算标准曲线公式

2021.8.31
头像

超级艾蛋木啊

致力于为分析测试行业奉献终身

1、首先向Excel中输入氨氮标准浓度和相应的吸光值数据

9345d688d43f8794e83f0b7edc1b0ef41ad53a99?x-bce-process%3Dimage%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_jpg

2、对吸光值数据进行校正，使得零浓度对应的吸光值为零

a686c9177f3e6709f0d606af35c79f3df9dc558f?x-bce-process%3Dimage%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_jpg

3、以浓度值为横坐标校正吸光值为纵坐标作散点图

eac4b74543a98226b5df69778482b9014a90eb40?x-bce-process%3Dimage%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_jpg

4、选中散点标志，右键单击，从条形工具框中选择添加趋势线

f603918fa0ec08fafa0351f757ee3d6d55fbda5b?x-bce-process%3Dimage%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_jpg

5、在设置趋势线格式中，选中显示公式，显示R平方值

34fae6cd7b899e516ff678444ca7d933c8950d61?x-bce-process%3Dimage%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_jpg

6、最后氨氮标准曲线就完成了，由R平方为0.9995可知，本次做的标准曲线质量是可信的。

a044ad345982b2b73aec7b943fadcbef76099b6b?x-bce-process%3Dimage%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_jpg


标准曲线
互联网
仪器推荐
文章推荐