怎么样用Excel按年龄段分组统计数据
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">问题</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">有学员问，怎么快速按年龄段分组计算。<span style="color: black;">倘若</span>你会用函数，<span style="color: black;">能够</span>做出<span style="color: black;">各样</span>灵活的分组。其实更快的<span style="color: black;">办法</span>是用数据透视表，点几下鼠标就得到结果了。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/1bbe6b4ad1b14d0dacda3216418a42db~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727956496&x-signature=JroBENs%2B9asFTunckkj09cY3t00%3D" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">Excel示例文件</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">下面的表格是原数据，要把它按<span style="color: black;">要求</span>统计：每隔10岁划分一个年龄段，统计<span style="color: black;">区别</span>性别的人数。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/a458f07a0f8c4b4abbdcfff70ece55fd~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727956496&x-signature=c%2F1y0nUob1yDsz8hqV%2F3SPeQA0c%3D" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">插进</span>数据透视表</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">咱们</span>只要点【<span style="color: black;">插进</span>】-【数据透视表】，把年龄拖到行区域，把性别拖到列区域，把姓名拖到值区域，它就完<span style="color: black;">成为了</span><span style="color: black;">每一个</span>年龄下，男女的数量统计。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/dab4d56fef79492e8516d6130e5495e6~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727956496&x-signature=PKinq4FaAi6SUVtWU7iBUkxA0Hg%3D" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">按年龄分组</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">接下来，只要在年龄的数据中点右键，选【组合】，就能指定分组间隔了。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/53a2fa6755d647ddb94e55513e9a978d~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727956496&x-signature=GtbjL5%2B%2Ff56%2BGfAx8wtAulhMlcg%3D" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">得到下面的按年龄段分组统计结果，只需要点击不超过10次鼠标，还不需要<span style="color: black;">繁杂</span>的函数。只要是数值类型、日期类型，都能用这个方式分组。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://p26-sign.toutiaoimg.com/tos-cn-i-axegupay5k/1bbe6b4ad1b14d0dacda3216418a42db~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727956496&x-signature=fho8GCvFLDFL3RvQXPWcIWYo5EY%3D" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">大猫老师<span style="color: black;">已然</span>把每期内容的示例文件等学习材料都准备好了，单独找我<span style="color: black;">ExcelDaMao</span> 要吧。</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">深入思考</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1、<span style="color: black;">倘若</span>不是数值、日期格式的数据，能<span style="color: black;">不可</span>分组？</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">2、<span style="color: black;">倘若</span>分组间隔不是均匀的，例如：18岁以下、18-30岁、31-40岁，41-50岁、51岁以上，<span style="color: black;">此时</span>该怎么办？</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">大猫老师会在后面的系列内容中，继续给<span style="color: black;">大众</span>分享这些问题的<span style="color: black;">处理</span><span style="color: black;">办法</span>和学习材料。</strong></p>
外贸B2B平台有哪些？ 外链发布论坛学习网络优化SEO。
页:
[1]