1、首先打开excel,输入好我们的数据,记住数据要横排输入,
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b17eca8065380cd794acc280ae44ad3459828128?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、点击左上角的office图表,点击”excel选项 ”,
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c8ea15ce36d3d53940776fae3587e950352ab011?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、在弹框中,选择“ 加载项 ”,在下方的“ 管理 ”选项中,选择”excel加载项“,点击" 转到 "。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d6ca7bcb0a46f21f5e603e3ef9246b600c33ae03?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、在弹出的”加载宏“,界面里,勾选”分析工具库“,点击确定即可。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/bd3eb13533fa828bea66fd8ef21f4134970a5a11?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、这时候,我们在右上角就可以看到”数据分析“选项卡了。接下来,点击”数据分析“选项卡,在方差分析里面选择”无重复双因素分析“。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/908fa0ec08fa513debdf0cb3326d55fbb2fbd962?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、在”输入区域“将我们的数据包括分组名称全部选进去,在”输出区域“,点击文中空白位置即可。点击确定。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/5ab5c9ea15ce36d32035e35d35f33a87e950b1ae?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、弹框就是我们要的结果的分析。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b3b7d0a20cf431adc5a623544436acaf2edd9862?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)