材料/工具:Excel2007
1、打开excel,输入两个变量一个是数量、一个是质量,他们每个因素都有一列数值
![](https://iknow-pic.cdn.bcebos.com/f31fbe096b63f6245dd20f0e8944ebf81a4ca32b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、选中这两组数值,选择插入图表、所有图表类型。
![](https://iknow-pic.cdn.bcebos.com/023b5bb5c9ea15ce70f4d104b8003af33a87b2a0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、在插入图片对话框里面,选择xy散点图,并且选择散点图中的第一个,点击确定。
![](https://iknow-pic.cdn.bcebos.com/a6efce1b9d16fdfad264f7e3ba8f8c5494ee7bb6?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、这样会生成一个图表在该图表上可以看到分散的点,x代表数量,y轴代表质量。
![](https://iknow-pic.cdn.bcebos.com/b3119313b07eca80338f0fea9f2397dda1448330?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、对着其中的某个点点击右键,选择添加趋势线。
![](https://iknow-pic.cdn.bcebos.com/b90e7bec54e736d1404abd0595504fc2d5626965?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、顺序号越大,图表越接近于真实情况。
![](https://iknow-pic.cdn.bcebos.com/3ac79f3df8dcd1000bdfc92c7c8b4710b9122f7f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、选择显示公式和显示R平方值,由于截距不知道暂时空着选择关闭
![](https://iknow-pic.cdn.bcebos.com/dcc451da81cb39db7e93565bde160924ab18306f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
8、这样出来的图就如图所示。
![](https://iknow-pic.cdn.bcebos.com/d01373f082025aaf7a9b4fc6f5edab64034f1a15?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)