{"blog_url":"https://arakan-pgm-ai.hatenablog.com/","provider_url":"https://hatena.blog","description":"\u76ee\u6b21 \u6761\u4ef6\u306b\u4e00\u81f4\u3057\u305f\u7bc4\u56f2\u306e\u6700\u983b\u5024\u306a\u3069\u3067\u6ce8\u610f\u304c\u5fc5\u8981\u306aEXCEL\u914d\u5217\u6570\u5f0f \u5168\u4f53\u306e\u6700\u983b\u5024\u30fb\u4e2d\u592e\u5024\u3092\u6c42\u3081\u308b\u3060\u3051\u306a\u3089\u7c21\u5358 \u6761\u4ef6\u306b\u4e00\u81f4\u3057\u305f\u3082\u306e\u306e\u4e2d\u3067\u306e\u6700\u983b\u5024\u30fb\u4e2d\u592e\u5024 EXCEL\u306e\u300c\u914d\u5217\u6570\u5f0f\u300d \u304a\u307e\u3051\uff1aMODE.MULTI\u306b\u3064\u3044\u3066 \u6761\u4ef6\u306b\u4e00\u81f4\u3057\u305f\u7bc4\u56f2\u306e\u6700\u983b\u5024\u306a\u3069\u3067\u6ce8\u610f\u304c\u5fc5\u8981\u306aEXCEL\u914d\u5217\u6570\u5f0f EXCEL\u3067\u3088\u304f\u4f7f\u3046\u3001MODE\uff08\u6700\u983b\u5024\uff09\u3001MEDIAN\uff08\u4e2d\u592e\u5024\uff09\u306a\u3069\u306e\u95a2\u6570\u3067\u3059\u304c\u3001\u610f\u5916\u306b\u96e3\u3057\u304f\u843d\u3068\u3057\u7a74\u304c\u3042\u308b\u306e\u304c\u300c\u6761\u4ef6\u306b\u4e00\u81f4\u3057\u305f\u5024\u306e\u7bc4\u56f2\u3067\u306e\u307f\u6c42\u3081\u308b\u300d\u30b1\u30fc\u30b9\u3067\u3059\u3002 AVERAGE(\u5e73\u5747\uff09\u3060\u3068\u3001AVERAGEIF\u3001AVERAGEIFS\u306a\u3069\u306e\u6761\u4ef6\u4ed8\u304d\u8a08\u7b97\u306e\u95a2\u6570\u3082\u3042\u308b\u306e\u3067\u3059\u304c\u3001\u4eca\u56de\u306f\u3001\u305d\u308c\u3089\u306e\u306a\u3044\u3082\u306e\u306b\u3064\u3044\u3066\u66f8\u304d\u307e\u3059\u3002 \u5168\u2026","version":"1.0","width":"100%","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/a/arakan_no_boku/20220405/20220405013815.png","height":"190","categories":["archive(EXCEL)"],"blog_title":"BOKU\u306e\u30d6\u30ed\u30b0","published":"2022-10-11 00:00:00","author_name":"arakan_no_boku","type":"rich","url":"https://arakan-pgm-ai.hatenablog.com/entry/2022/10/11/000000","author_url":"https://blog.hatena.ne.jp/arakan_no_boku/","provider_name":"Hatena Blog","title":"\u6761\u4ef6\u306b\u4e00\u81f4\u3057\u305f\u7bc4\u56f2\u306e\u6700\u983b\u5024\u306a\u3069\u3067\u6ce8\u610f\u304c\u5fc5\u8981\u306aEXCEL\u914d\u5217\u6570\u5f0f","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Farakan-pgm-ai.hatenablog.com%2Fentry%2F2022%2F10%2F11%2F000000\" title=\"\u6761\u4ef6\u306b\u4e00\u81f4\u3057\u305f\u7bc4\u56f2\u306e\u6700\u983b\u5024\u306a\u3069\u3067\u6ce8\u610f\u304c\u5fc5\u8981\u306aEXCEL\u914d\u5217\u6570\u5f0f - BOKU\u306e\u30d6\u30ed\u30b0\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>"}