插入一个数据透视表,在筛选中筛选出当月,然后添加平均值即可计算出月平均失业人数,下面演示:
演示设备:联想 AIO520-22一体机、WIN7、Excel 2007 。
一、如下图,下图Excel中A列填充了两个月,B列为日失业人数,选中这两列,点击插入—数据透视表。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/4034970a304e251f2e833b69b586c9177f3e532f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
二、把数据透视表插入到当前工作表下。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/1e30e924b899a9016d4284a70f950a7b0208f528?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
三、字段列表窗口中勾选全部字段。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a2cc7cd98d1001e9464bcb9eaa0e7bec54e79728?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
四、把失业人数移动到数值。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/18d8bc3eb13533fa31c14cbfbad3fd1f41345b28?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
五、然后把失业人数字段设置为平均值。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7acb0a46f21fbe0922281c8579600c338744ad29?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
六、点击行标签筛选,按日期筛选。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9213b07eca806538609b7b8285dda144ad34822a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
七、点击期间所有日期,弹出菜单中点击要计算月平均失业人数的月份。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b21c8701a18b87d63e32748e150828381f30fd2b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
八、这时下方总计中就能够得出平均值。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/960a304e251f95ca6d854d27db177f3e6709522b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)