{"id":4438,"date":"2016-03-07T08:06:00","date_gmt":"2016-03-07T00:06:00","guid":{"rendered":"\/\/m.letratesoro.com\/?p=4438"},"modified":"2016-03-07T09:14:07","modified_gmt":"2016-03-07T01:14:07","slug":"histogram","status":"publish","type":"post","link":"\/\/m.letratesoro.com\/2016\/03\/histogram\/","title":{"rendered":"\u54c1\u7ba1\u4e03\u5927\u5de5\u5177\uff0d\u76f4\u65b9\u5716(Histogram)\u4ecb\u7d39"},"content":{"rendered":"<p align=\"justify\"><font size=\"4\"><img loading=\"lazy\" decoding=\"async\" title=\"\u54c1\u7ba1\u4e03\u5927\u5de5\u5177\uff0d\u76f4\u65b9\u5716(Histogram)\u4ecb\u7d39\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; float: left; padding-top: 0px; padding-left: 0px; margin: 0px 25px 0px 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"\u54c1\u7ba1\u4e03\u5927\u5de5\u5177\uff0d\u76f4\u65b9\u5716(Histogram)\u4ecb\u7d39\" src=\"\/\/m.letratesoro.com\/wp-content\/uploads\/04.png\" width=\"297\" align=\"left\" height=\"192\" \/><\/font><\/p>\n<p align=\"justify\"><strong><font color=\"#0000ff\" size=\"4\">\u76f4\u65b9\u5716\uff08Histogram\uff09<\/font><\/strong><font size=\"4\">\u7684\u6700\u4e3b\u8981\u7528\u9014\u5728\u63a8\u6e2c\u88fd\u7a0b\u80fd\u529b\u3001\u8a08\u7b97\u4e0d\u826f\u7387\u3001\u8abf\u67e5\u662f\u5426\u6709\u6df7\u5165\u5169\u7a2e\u4ee5\u4e0a\u4e0d\u540c\u7fa4\u9ad4\uff0c\u4e5f\u53ef\u4ee5\u7528\u4f86\u6e2c\u77e5\u6709\u7121\u5047\u6578\u64da\u3001\u8a2d\u8a08\u7684\u7ba1\u5236\u754c\u7dda\u662f\u5426\u9069\u7528\u65bc\u5be6\u969b\u88fd\u7a0b\u7ba1\u5236\uff0c\u4e26\u85c9\u4ee5\u8a02\u5b9a\u898f\u683c\u8207\u898f\u683c\u754c\u9650\u6216\u8868\u6e96\u503c\u6bd4\u8f03\u3002<\/font><\/p>\n<p align=\"justify\"><font size=\"4\">\u76f4\u65b9\u5716\u57fa\u672c\u4e0a\u662f\u4e00\u7a2e<\/font><font style=\"background-color: #ffff00\" size=\"4\"><strong>\u6b21\u6578\u5206\u914d\u8868<\/strong><\/font><font size=\"4\">\uff0c\u6cbf\u8457\u6a6b\u8ef8\u4ee5\u5404\u7d44\u7d44\u754c\u70ba\u5206\u754c\uff0c\u7d44\u8ddd\u70ba\u5e95\u908a\uff0c\u4ee5\u5404\u7d44\u7684\u6b21\u6578\u70ba\u9ad8\u5ea6\uff0c\u4f9d\u5e8f\u5728\u56fa\u5b9a\u7684\u9593\u8ddd\u4e0a\u756b\u51fa\u77e9\u5f62\u9ad8\u5ea6\u6240\u7e6a\u88fd\u800c\u6210\u4e4b\u5716\u5f62\u3002<\/font><\/p>\n<p align=\"justify\"><font size=\"4\">\u65e9\u671f\u6c92\u6709\u96fb\u8166\u7684\u6642\u5019\uff0c\u88fd\u4f5c\u76f4\u65b9\u5716\u662f\u6709\u9ede\u9ebb\u7169\uff0c\u56e0\u70ba\u62ff\u5230\u624b\u7684\u539f\u59cb\u8cc7\u6599\u901a\u5e38\u975e\u5e38\u5730\u51cc\u4e82\uff0c\u751a\u81f3\u6c92\u6709\u9806\u5e8f\uff0c\u5fc5\u9808\u8981\u81ea\u5df1\u5148\u7d71\u8a08\u7136\u5f8c\u518d\u624b\u52d5\u8a08\u7b97\u5176\u9593\u8ddd\u8207\u5404\u7d44\u6578\u64da\u7684\u6578\u91cf\uff0c\u4e0d\u5c0f\u5fc3\u7684\u8a71\u9084\u5f88\u5bb9\u6613\u51fa\u932f\u3002\u73fe\u5728\u6709\u4e86\u96fb\u8166\u7684\u8f14\u52a9\uff0c\u53ef\u4ee5\u4f7f\u7528Excel\u4e4b\u985e\u7684\u8edf\u9ad4\u4f86\u5206\u7d44\u4e26\u81ea\u52d5\u7d71\u8a08\u5404\u5206\u7d44\u7684\u6578\u91cf\uff0c\u4e5f\u5bb9\u6613\u5fae\u8abf\u5404\u7d44\u7684\u8a08\u6578\u4f4d\u7f6e\u3002<\/font><\/p>\n<p><!--more--><\/p>\n<p><font color=\"#0000ff\" size=\"5\"><strong>\u9577\u689d\u5716\u8207\u76f4\u65b9\u5716\u7684\u5dee\u7570<\/strong><\/font><\/p>\n<p align=\"justify\"><font size=\"4\">\u96d6\u7136\u6709\u4eba\u5c07<strong><font color=\"#0000ff\">\u9577\u689d\u5716<\/font><\/strong>\uff08Bar Chart\uff0c\u5404\u9577\u689d\u4e2d\u9593\u4e0d\u76f8\u9023\u63a5\uff09\u8207<strong><font color=\"#0000ff\">\u76f4\u65b9\u5716<\/font><\/strong>\uff08Histogram\uff0c\u5404\u76f8\u9130\u9577\u689d\u4e2d\u9593\u5f7c\u6b64\u76f8\u9023\u63a5\uff09\u5169\u8005\u5206\u5f97\u975e\u5e38\u6e05\u695a\uff0c\u4f46\u500b\u4eba\u89ba\u5f97\u5176\u5be6\u76f8\u9130\u9577\u689d\u4e4b\u9593\u6709\u7121\u9593\u9694\u61c9\u8a72\u7121\u50b7\u5927\u96c5\u3002<\/font><\/p>\n<p align=\"justify\"><font size=\"4\">\u6301\u6b64\u8ad6\u8005\u8a8d\u70ba\u9019\u5169\u8005\u6700\u5927\u7684\u5dee\u7570\u61c9\u8a72\u662f<strong><font color=\"#0000ff\">\u9577\u689d\u5716<\/font><\/strong>\u7684<font style=\"background-color: #ffff00\">\u9577\u689d\u985e\u5225\u53ef\u4ee5\u4efb\u610f\u8abf\u63db\u4f4d\u7f6e<\/font>\uff0c\u6bd4\u5982\u8aaa\u5c45\u4f4f\u5730\u5340\u7684\u4eba\u53e3\u6578\u3001\u6027\u5225\u8cc7\u6599\u7b49\u5c6c\u65bc<font style=\"background-color: #ffff00\">\u4e0d\u9023\u7e8c<\/font>\u7684\u8cc7\u6599\u3002\u800c<strong><font color=\"#0000ff\">\u76f4\u65b9\u5716<\/font><\/strong>\u7684<font style=\"background-color: #ffff00\">\u9577\u689d\u5247\u5fc5\u9808\u4f9d\u7167\u539f\u4f86\u7684\u9806\u5e8f\u6392\u5217<\/font>\uff0c\u901a\u5e38\u4ee3\u8868<font style=\"background-color: #ffff00\">\u9023\u7e8c<\/font>\u7684\u8cc7\u6599\uff0c\u6bd4\u5982\u73ed\u7d1a\u5167\u7684\u8eab\u9ad8\u7d71\u8a08\u5c6c\u65bc\u9023\u7e8c\u7684\u8cc7\u6599\u3002<\/font><\/p>\n<p align=\"justify\"><font size=\"4\">\u4e0d\u904e\u771f\u7684\u6709\u5e7e\u4eba\u53ef\u4ee5\u5982\u6b64\u5206\u5f97\u6e05\u695a\u5462\uff1f\u90a3\u92b7\u552e\u696d\u7e3e\u3001\u71df\u696d\u7e3e\u6548\u61c9\u8a72\u5c6c\u65bc\u689d\u5716\u6216\u76f4\u65b9\u5716\u5462\uff1f\u9023\u7e8c\u7684\u8cc7\u6599\u61c9\u8a72\u662f\u76f4\u65b9\u5716\u56c9\uff01\u53ef\u662f\u53c8\u4e0d\u662f\u5f88\u50cf\uff1f\u7b97\u4e86\u5427\uff01\u66f4\u6b63\u5de5\u4f5c\u718a\u5982\u679c\u4f60\u6709\u6bd4\u8f03\u597d\u7684\u770b\u6cd5\u3002<\/font><\/p>\n<p><font color=\"#0000ff\" size=\"5\"><strong>\u76f4\u65b9\u5716\u7684\u7e6a\u88fd\u6280\u5de7<\/strong><\/font><\/p>\n<p align=\"justify\"><font size=\"4\">\u8001\u5be6\u8aaa\uff0c\u76f4\u65b9\u5716\u7b97\u662f\u6700\u5e38\u51fa\u73fe\u5728\u4f60\u6211\u751f\u6d3b\u4e2d\u7684\u7d71\u8a08\u5716\u8868\u4e4b\u4e00\u4e86\uff0c\u8209\u51e1\u73ed\u7d1a\u6210\u7e3e\u5206\u4f48\u3001\u8003\u8a66\u6210\u7e3e\u5206\u4f48\u3001\u5e74\u9f61\u5206\u4f48\u7b49\u5e7e\u4e4e\u90fd\u662f\u4ee5\u76f4\u65b9\u5716\u4f86\u8868\u793a\u7684\u3002\u4e0d\u904e\u7d71\u8a08\u4e2d\u7684\u76f4\u65b9\u5716\u56e0\u70ba\u7d71\u8a08\u7684\u662f\u67d0\u500b\u898f\u5b9a\u5c3a\u5bf8\u6216\u67d0\u500b\u898f\u5b9a\u91cd\u91cf\uff0c\u53ea\u8981\u7d71\u8a08\u7684\u6578\u91cf\u5920\u591a\uff0c\u5c31\u6703\u51fa\u73fe\u6240\u8b02\u7684<strong><font color=\"#0000ff\">\u5e38\u614b\u5206\u4f48<\/font><\/strong>\u3002<\/font><\/p>\n<p align=\"justify\"><font size=\"4\">\u73fe\u5728\u6211\u5011\u5c31\u4f86\u770b\u770b\u5982\u4f55\u7531\u6578\u64da\u88fd\u4f5c\u76f4\u65b9\u5716\u5427\u3002<\/font><\/p>\n<p><font size=\"4\">\u300a\u4f8b\u5b50\u300b\u5047\u8a2d\u6709\u4e00\u9435\u677f\u7684\u539a\u5ea6\u6e2c\u5f97200\u7d44\u6578\u64da\u5982\u4e0b\uff0c\u55ae\u4f4d\u70bamm\u3002<\/font><\/p>\n<style type=\"text\/css\">\n<p>.style1 {\n\t\t\t\tcolor: black;\n\t\t\t\tfont-size: 11.0pt;\n\t\t\t\tfont-weight: 400;\n\t\t\t\tfont-style: normal;\n\t\t\t\ttext-decoration: none;\n\t\t\t\tfont-family: calibri, sans-serif;\n\t\t\t\ttext-align: center;\n\t\t\t\tvertical-align: middle;\n\t\t\t\twhite-space: nowrap;\n\t\t\t\tborder: .5pt solid windowtext;\n\t\t\t\tpadding-left: 1px;\n\t\t\t\tpadding-right: 1px;\n\t\t\t\tpadding-top: 1px;\n}<\/style>\n<p align=\"center\">\n<table style=\"width: 300pt; border-collapse: collapse\" cellspacing=\"0\" cellpadding=\"0\" width=\"400\" border=\"0\">\n<colgroup>\n<col style=\"width: 30pt; mso-width-source: userset; mso-width-alt: 1462\" width=\"40\" \/><\/colgroup>\n<tbody>\n<tr style=\"height: 15pt\" height=\"20\">\n<td class=\"style1\" style=\"height: 15pt; width: 30pt\" height=\"20\" width=\"40\">8.8<\/td>\n<td class=\"style1\" style=\"width: 30pt\" width=\"40\">8.8<\/td>\n<td class=\"style1\" style=\"width: 30pt\" width=\"40\">8.4<\/td>\n<td class=\"style1\" style=\"width: 30pt\" width=\"40\">8.2<\/td>\n<td class=\"style1\" style=\"width: 30pt\" width=\"40\">8.3<\/td>\n<td class=\"style1\" style=\"width: 30pt\" width=\"40\">9.3<\/td>\n<td class=\"style1\" style=\"width: 30pt\" width=\"40\">8.6<\/td>\n<td class=\"style1\" style=\"width: 30pt\" width=\"40\">8.4<\/td>\n<td class=\"style1\" style=\"width: 30pt\" width=\"40\">9.0<\/td>\n<td class=\"style1\" style=\"width: 30pt\" width=\"40\">9.7<\/td>\n<\/tr>\n<tr style=\"height: 15pt\" height=\"20\">\n<td class=\"style1\" style=\"height: 15pt\" height=\"20\">8.4<\/td>\n<td class=\"style1\">8.5<\/td>\n<td class=\"style1\">9.0<\/td>\n<td class=\"style1\">8.7<\/td>\n<td class=\"style1\">9.4<\/td>\n<td class=\"style1\">8.9<\/td>\n<td class=\"style1\">8.7<\/td>\n<td class=\"style1\">8.7<\/td>\n<td class=\"style1\">8.6<\/td>\n<td class=\"style1\">8.7<\/td>\n<\/tr>\n<tr style=\"height: 15pt\" height=\"20\">\n<td class=\"style1\" style=\"height: 15pt\" height=\"20\">8.4<\/td>\n<td class=\"style1\">8.4<\/td>\n<td class=\"style1\">8.5<\/td>\n<td class=\"style1\">8.8<\/td>\n<td class=\"style1\">8.9<\/td>\n<td class=\"style1\">9.6<\/td>\n<td class=\"style1\">8.4<\/td>\n<td class=\"style1\">7.9<\/td>\n<td class=\"style1\">8.1<\/td>\n<td class=\"style1\">8.4<\/td>\n<\/tr>\n<tr style=\"height: 15pt\" height=\"20\">\n<td class=\"style1\" style=\"height: 15pt\" height=\"20\">8.8<\/td>\n<td class=\"style1\">8.3<\/td>\n<td class=\"style1\">8.4<\/td>\n<td class=\"style1\">8.5<\/td>\n<td class=\"style1\">9.3<\/td>\n<td class=\"style1\">8.1<\/td>\n<td class=\"style1\">8.7<\/td>\n<td class=\"style1\">8.3<\/td>\n<td class=\"style1\">8.9<\/td>\n<td class=\"style1\">8.7<\/td>\n<\/tr>\n<tr style=\"height: 15pt\" height=\"20\">\n<td class=\"style1\" style=\"height: 15pt\" height=\"20\">8.1<\/td>\n<td class=\"style1\">9.1<\/td>\n<td class=\"style1\">9.0<\/td>\n<td class=\"style1\">8.6<\/td>\n<td class=\"style1\">8.3<\/td>\n<td class=\"style1\">9.0<\/td>\n<td class=\"style1\">8.7<\/td>\n<td class=\"style1\">9.0<\/td>\n<td class=\"style1\">8.6<\/td>\n<td class=\"style1\">8.6<\/td>\n<\/tr>\n<tr style=\"height: 15pt\" height=\"20\">\n<td class=\"style1\" style=\"height: 15pt\" height=\"20\">7.8<\/td>\n<td class=\"style1\">9.2<\/td>\n<td class=\"style1\">9.8<\/td>\n<td class=\"style1\">7.4<\/td>\n<td class=\"style1\">8.8<\/td>\n<td class=\"style1\">8.1<\/td>\n<td class=\"style1\">9.0<\/td>\n<td class=\"style1\">7.8<\/td>\n<td class=\"style1\">8.6<\/td>\n<td class=\"style1\">8.7<\/td>\n<\/tr>\n<tr style=\"height: 15pt\" height=\"20\">\n<td class=\"style1\" style=\"height: 15pt\" height=\"20\">8.8<\/td>\n<td class=\"style1\">9.4<\/td>\n<td class=\"style1\">9.0<\/td>\n<td class=\"style1\">8.8<\/td>\n<td class=\"style1\">8.5<\/td>\n<td class=\"style1\">8.7<\/td>\n<td class=\"style1\">9.0<\/td>\n<td class=\"style1\">7.8<\/td>\n<td class=\"style1\">9.2<\/td>\n<td class=\"style1\">8.7<\/td>\n<\/tr>\n<tr style=\"height: 15pt\" height=\"20\">\n<td class=\"style1\" style=\"height: 15pt\" height=\"20\">8.8<\/td>\n<td class=\"style1\">7.9<\/td>\n<td class=\"style1\">8.0<\/td>\n<td class=\"style1\">8.0<\/td>\n<td class=\"style1\">7.9<\/td>\n<td class=\"style1\">8.2<\/td>\n<td class=\"style1\">8.6<\/td>\n<td class=\"style1\">8.4<\/td>\n<td class=\"style1\">8.6<\/td>\n<td class=\"style1\">8.3<\/td>\n<\/tr>\n<tr style=\"height: 15pt\" height=\"20\">\n<td class=\"style1\" style=\"height: 15pt\" height=\"20\">9.0<\/td>\n<td class=\"style1\">9.0<\/td>\n<td class=\"style1\">8.3<\/td>\n<td class=\"style1\">8.4<\/td>\n<td class=\"style1\">9.5<\/td>\n<td class=\"style1\">8.4<\/td>\n<td class=\"style1\">9.7<\/td>\n<td class=\"style1\">8.9<\/td>\n<td class=\"style1\">9.2<\/td>\n<td class=\"style1\">9.0<\/td>\n<\/tr>\n<tr style=\"height: 15pt\" height=\"20\">\n<td class=\"style1\" style=\"height: 15pt\" height=\"20\">8.4<\/td>\n<td class=\"style1\">8.1<\/td>\n<td class=\"style1\">8.4<\/td>\n<td class=\"style1\">9.9<\/td>\n<td class=\"style1\">9.9<\/td>\n<td class=\"style1\">8.6<\/td>\n<td class=\"style1\">8.5<\/td>\n<td class=\"style1\">7.9<\/td>\n<td class=\"style1\">8.7<\/td>\n<td class=\"style1\">7.8<\/td>\n<\/tr>\n<tr style=\"height: 15pt\" height=\"20\">\n<td class=\"style1\" style=\"height: 15pt\" height=\"20\">9.3<\/td>\n<td class=\"style1\">8.4<\/td>\n<td class=\"style1\">8.8<\/td>\n<td class=\"style1\">8.5<\/td>\n<td class=\"style1\">9.1<\/td>\n<td class=\"style1\">8.9<\/td>\n<td class=\"style1\">8.4<\/td>\n<td class=\"style1\">8.8<\/td>\n<td class=\"style1\">8.9<\/td>\n<td class=\"style1\">9.7<\/td>\n<\/tr>\n<tr style=\"height: 15pt\" height=\"20\">\n<td class=\"style1\" style=\"height: 15pt\" height=\"20\">8.3<\/td>\n<td class=\"style1\">9.0<\/td>\n<td class=\"style1\">9.3<\/td>\n<td class=\"style1\">8.7<\/td>\n<td class=\"style1\">9.0<\/td>\n<td class=\"style1\">9.2<\/td>\n<td class=\"style1\">9.1<\/td>\n<td class=\"style1\">7.0<\/td>\n<td class=\"style1\">7.9<\/td>\n<td class=\"style1\">7.3<\/td>\n<\/tr>\n<tr style=\"height: 15pt\" height=\"20\">\n<td class=\"style1\" style=\"height: 15pt\" height=\"20\">9.7<\/td>\n<td class=\"style1\">8.9<\/td>\n<td class=\"style1\">7.8<\/td>\n<td class=\"style1\">8.3<\/td>\n<td class=\"style1\">8.7<\/td>\n<td class=\"style1\">9.0<\/td>\n<td class=\"style1\">8.4<\/td>\n<td class=\"style1\">7.6<\/td>\n<td class=\"style1\">8.1<\/td>\n<td class=\"style1\">8.2<\/td>\n<\/tr>\n<tr style=\"height: 15pt\" height=\"20\">\n<td class=\"style1\" style=\"height: 15pt\" height=\"20\">8.5<\/td>\n<td class=\"style1\">8.5<\/td>\n<td class=\"style1\">8.1<\/td>\n<td class=\"style1\">8.3<\/td>\n<td class=\"style1\">7.6<\/td>\n<td class=\"style1\">7.7<\/td>\n<td class=\"style1\">9.0<\/td>\n<td class=\"style1\">7.9<\/td>\n<td class=\"style1\">8.3<\/td>\n<td class=\"style1\">9.0<\/td>\n<\/tr>\n<tr style=\"height: 15pt\" height=\"20\">\n<td class=\"style1\" style=\"height: 15pt\" height=\"20\">8.9<\/td>\n<td class=\"style1\">8.6<\/td>\n<td class=\"style1\">8.4<\/td>\n<td class=\"style1\">8.9<\/td>\n<td class=\"style1\">8.3<\/td>\n<td class=\"style1\">8.0<\/td>\n<td class=\"style1\">8.0<\/td>\n<td class=\"style1\">8.0<\/td>\n<td class=\"style1\">8.9<\/td>\n<td class=\"style1\">8.3<\/td>\n<\/tr>\n<tr style=\"height: 15pt\" height=\"20\">\n<td class=\"style1\" style=\"height: 15pt\" height=\"20\">9.0<\/td>\n<td class=\"style1\">7.7<\/td>\n<td class=\"style1\">7.9<\/td>\n<td class=\"style1\">8.3<\/td>\n<td class=\"style1\">8.5<\/td>\n<td class=\"style1\">8.5<\/td>\n<td class=\"style1\">8.9<\/td>\n<td class=\"style1\">8.4<\/td>\n<td class=\"style1\">8.3<\/td>\n<td class=\"style1\">9.5<\/td>\n<\/tr>\n<tr style=\"height: 15pt\" height=\"20\">\n<td class=\"style1\" style=\"height: 15pt\" height=\"20\">8.8<\/td>\n<td class=\"style1\">8.7<\/td>\n<td class=\"style1\">8.1<\/td>\n<td class=\"style1\">9.1<\/td>\n<td class=\"style1\">8.9<\/td>\n<td class=\"style1\">8.4<\/td>\n<td class=\"style1\">7.9<\/td>\n<td class=\"style1\">8.6<\/td>\n<td class=\"style1\">7.8<\/td>\n<td class=\"style1\">8.9<\/td>\n<\/tr>\n<tr style=\"height: 15pt\" height=\"20\">\n<td class=\"style1\" style=\"height: 15pt\" height=\"20\">8.1<\/td>\n<td class=\"style1\">7.7<\/td>\n<td class=\"style1\">7.3<\/td>\n<td class=\"style1\">8.5<\/td>\n<td class=\"style1\">8.0<\/td>\n<td class=\"style1\">7.7<\/td>\n<td class=\"style1\">7.8<\/td>\n<td class=\"style1\">8.3<\/td>\n<td class=\"style1\">7.5<\/td>\n<td class=\"style1\">8.3<\/td>\n<\/tr>\n<tr style=\"height: 15pt\" height=\"20\">\n<td class=\"style1\" style=\"height: 15pt\" height=\"20\">9.4<\/td>\n<td class=\"style1\">7.0<\/td>\n<td class=\"style1\">7.5<\/td>\n<td class=\"style1\">7.7<\/td>\n<td class=\"style1\">8.3<\/td>\n<td class=\"style1\">7.9<\/td>\n<td class=\"style1\">8.6<\/td>\n<td class=\"style1\">8.9<\/td>\n<td class=\"style1\">8.4<\/td>\n<td class=\"style1\">9.9<\/td>\n<\/tr>\n<tr style=\"height: 15pt\" height=\"20\">\n<td class=\"style1\" style=\"height: 15pt\" height=\"20\">8.3<\/td>\n<td class=\"style1\">9.4<\/td>\n<td class=\"style1\">8.4<\/td>\n<td class=\"style1\">9.3<\/td>\n<td class=\"style1\">8.5<\/td>\n<td class=\"style1\">7.9<\/td>\n<td class=\"style1\">8.4<\/td>\n<td class=\"style1\">8.8<\/td>\n<td class=\"style1\">8.3<\/td>\n<td class=\"style1\">8.0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><font size=\"4\"><\/font><\/p>\n<p><strong><font color=\"#0000ff\" size=\"5\">\u4f7f\u7528Excel\u8a08\u7b97\u53ca\u7e6a\u5716\u76f4\u65b9\u5716<\/font><\/strong><\/p>\n<ol>\n<li><font size=\"4\">\u4f7f\u7528Min()\u51fd\u6578\u8a08\u7b97\u6700\u5c0f\u503c=7.0 <\/font><\/li>\n<li><font size=\"4\">\u4f7f\u7528Max()\u51fd\u6578\u8a08\u7b97\u6700\u5927\u503c=9.9\u3002 <\/font><\/li>\n<li><font size=\"4\">\u4e00\u822c\u5efa\u8b70\u5206\u621010\u7d44\u5de6\u53f3\u3002\u6240\u4ee5\u9593\u8ddd\u5c31\u662f\u5c07\uff08\u6700\u5927\u503c-\u6700\u5c0f\u503c \uff09\/ 10\uff0c\u6700\u5f8c\u5f97\u51fa\u9593\u8ddd\u70ba(9.9-7.0)\/9=0.29\uff0c\u56db\u6368\u4e94\u5165\u7684\u7d50\u679c\uff0c\u6240\u4ee5\u9593\u8ddd\u53d60.3\u3002 <\/font><\/li>\n<li><font size=\"4\">\u5404\u7d44\u4e2d\u5fc3\u503c\u70ba7.15, 7.45, 7.75, 8.05, 8.35, 8.65, 8.95, 9.25, 9.55, 9.85\u3002 <\/font><\/li>\n<li><font size=\"4\">\u4f7f\u7528COUNTIFS()\u51fd\u6578\u8a08\u7b97\u4e26\u7d71\u8a08\u5404\u7d44\u7684\u6b21\u6578\u5206\u914d\u53ef\u5f97\u4e0b\u8868 <\/font><br \/>\n<table cellspacing=\"0\" cellpadding=\"2\" width=\"541\" border=\"1\">\n<tbody>\n<tr>\n<td valign=\"top\" width=\"49\"><font size=\"4\">\u9593\u8ddd<\/font><\/td>\n<td valign=\"top\" width=\"49\" align=\"center\"><font size=\"4\">7.15<\/font><\/td>\n<td valign=\"top\" width=\"49\" align=\"center\"><font size=\"4\">7.45<\/font><\/td>\n<td valign=\"top\" width=\"49\" align=\"center\"><font size=\"4\">7.75<\/font><\/td>\n<td valign=\"top\" width=\"49\" align=\"center\"><font size=\"4\">8.05<\/font><\/td>\n<td valign=\"top\" width=\"49\" align=\"center\"><font size=\"4\">8.35<\/font><\/td>\n<td valign=\"top\" width=\"49\" align=\"center\"><font size=\"4\">8.65<\/font><\/td>\n<td valign=\"top\" width=\"49\" align=\"center\"><font size=\"4\">8.95<\/font><\/td>\n<td valign=\"top\" width=\"49\" align=\"center\"><font size=\"4\">9.25<\/font><\/td>\n<td valign=\"top\" width=\"49\" align=\"center\"><font size=\"4\">9.55<\/font><\/td>\n<td valign=\"top\" width=\"49\" align=\"center\"><font size=\"4\">9.85<\/font><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"49\"><font size=\"4\">\u6578\u91cf<\/font><\/td>\n<td valign=\"top\" width=\"49\" align=\"center\"><font size=\"4\">2<\/font><\/td>\n<td valign=\"top\" width=\"49\" align=\"center\"><font size=\"4\">5<\/font><\/td>\n<td valign=\"top\" width=\"49\" align=\"center\"><font size=\"4\">14<\/font><\/td>\n<td valign=\"top\" width=\"49\" align=\"center\"><font size=\"4\">26<\/font><\/td>\n<td valign=\"top\" width=\"49\" align=\"center\"><font size=\"4\">44<\/font><\/td>\n<td valign=\"top\" width=\"49\" align=\"center\"><font size=\"4\">38<\/font><\/td>\n<td valign=\"top\" width=\"49\" align=\"center\"><font size=\"4\">43<\/font><\/td>\n<td valign=\"top\" width=\"49\" align=\"center\"><font size=\"4\">13<\/font><\/td>\n<td valign=\"top\" width=\"49\" align=\"center\"><font size=\"4\">7<\/font><\/td>\n<td valign=\"top\" width=\"49\" align=\"center\"><font size=\"4\">8<\/font><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/li>\n<li><font size=\"4\">\u5c07\u4ee5\u4e0a\u6578\u503c\u7e6a\u88fd\u6210Excel\u5716\u8868\u5982\u4e0b\uff1a<img loading=\"lazy\" decoding=\"async\" title=\"Histogram01\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"Histogram01\" src=\"\/\/m.letratesoro.com\/wp-content\/uploads\/Histogram01.png\" width=\"415\" height=\"295\" \/> <\/font><\/li>\n<\/ol>\n<p><font size=\"4\">\u4e0a\u9762\u5716\u8868\u770b\u8d77\u4f86\u4f3c\u4e4e\u602a\u602a\u7684\uff0c\u4e26\u4e0d\u662f\u6211\u5011\u4e00\u822c\u719f\u77e5\u7684<strong><font color=\"#0000ff\">\u5e38\u614b\u5206\u4f48\u66f2\u7dda<\/font><\/strong>\u7684\u6b63\u5e38\u5f62\u72c0\uff0c\u9019\u662f\u56e0\u70ba\u53d6\u9593\u8ddd\u53ca\u523b\u5ea6\u7684\u95dc\u4fc2\u6240\u9020\u6210\u7684\uff0c\u6211\u5011\u7a0d\u5fae\u79fb\u52d5\u4e00\u4e0b\u9593\u8ddd\u7684\u4e2d\u5fc3\u9ede\u4f4d\u7f6e\uff0c\u7d44\u6578\u5f9e10\u7d44\u8b8a\u70ba11\u7d44\uff0c\u91cd\u65b0\u8a08\u7b97\u5176\u7d71\u8a08\u7684\u6578\u64da\u5982\u4e0b\uff1a<\/font><\/p>\n<table cellspacing=\"0\" cellpadding=\"2\" width=\"556\" border=\"1\">\n<tbody>\n<tr>\n<td valign=\"top\" width=\"50\"><font size=\"4\">\u9593\u8ddd<\/font><\/td>\n<td valign=\"top\" width=\"47\" align=\"center\"><font size=\"4\">7.05<\/font><\/td>\n<td valign=\"top\" width=\"47\" align=\"center\"><font size=\"4\">7.35<\/font><\/td>\n<td valign=\"top\" width=\"47\" align=\"center\"><font size=\"4\">7.65<\/font><\/td>\n<td valign=\"top\" width=\"47\" align=\"center\"><font size=\"4\">7.95<\/font><\/td>\n<td valign=\"top\" width=\"47\" align=\"center\"><font size=\"4\">8.25<\/font><\/td>\n<td valign=\"top\" width=\"47\" align=\"center\"><font size=\"4\">8.55<\/font><\/td>\n<td valign=\"top\" width=\"47\" align=\"center\"><font size=\"4\">8.85<\/font><\/td>\n<td valign=\"top\" width=\"47\" align=\"center\"><font size=\"4\">9.15<\/font><\/td>\n<td valign=\"top\" width=\"47\" align=\"center\"><font size=\"4\">9.45<\/font><\/td>\n<td valign=\"top\" width=\"47\" align=\"center\"><font size=\"4\">9.75<\/font><\/td>\n<td valign=\"top\" width=\"34\" align=\"center\">10.05<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"50\"><font size=\"4\">\u6578\u91cf<\/font><\/td>\n<td valign=\"top\" width=\"48\" align=\"center\"><font size=\"4\">2<\/font><\/td>\n<td valign=\"top\" width=\"48\" align=\"center\"><font size=\"4\">3<\/font><\/td>\n<td valign=\"top\" width=\"47\" align=\"center\"><font size=\"4\">9<\/font><\/td>\n<td valign=\"top\" width=\"47\" align=\"center\"><font size=\"4\">24<\/font><\/td>\n<td valign=\"top\" width=\"47\" align=\"center\"><font size=\"4\">31<\/font><\/td>\n<td valign=\"top\" width=\"47\" align=\"center\"><font size=\"4\">46<\/font><\/td>\n<td valign=\"top\" width=\"47\" align=\"center\"><font size=\"4\">40<\/font><\/td>\n<td valign=\"top\" width=\"47\" align=\"center\"><font size=\"4\">25<\/font><\/td>\n<td valign=\"top\" width=\"47\" align=\"center\"><font size=\"4\">11<\/font><\/td>\n<td valign=\"top\" width=\"47\" align=\"center\"><font size=\"4\">6<\/font><\/td>\n<td valign=\"top\" width=\"34\" align=\"center\">3<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><font size=\"4\"><\/font><\/p>\n<p><font size=\"4\">\u518d\u7528Excel\u7e6a\u88fd\u4e00\u6b21\u76f4\u65b9\u5716\u8868\u5f8c\u5c31\u8b8a\u6210\u4e0b\u9762\u7684\u5206\u4f48\u66f2\u7dda\u7684\u6a23\u5b50\uff0c\u662f\u4e0d\u662f\u6bd4\u8f03\u50cf\u5e38\u614b\u5206\u4f48\u7684\u5716\u5f62\u4e86\u5462\u3002      <br \/><img loading=\"lazy\" decoding=\"async\" title=\"Histogram02\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"Histogram02\" src=\"\/\/m.letratesoro.com\/wp-content\/uploads\/Histogram02.png\" width=\"415\" height=\"295\" \/><\/font><\/p>\n<p><font size=\"4\">\u6240\u4ee5\uff0c\u53d6\u9593\u8ddd\u53ca\u4e2d\u5fc3\u503c\u7684\u6642\u5019\u5c31\u986f\u5f97\u975e\u5e38\u91cd\u8981\uff0c\u6709\u6642\u5019\u53ef\u80fd\u5f97\u7a0d\u5fae\u632a\u79fb\u4e00\u4e0b\uff0c\u4ee5\u5f97\u5230\u8f03\u6b63\u78ba\u7684\u5716\u5f62\u3002<\/font><\/p>\n<hr \/>\n<p><font size=\"4\">\u56de\u300b<\/font><a href=\"\/\/m.letratesoro.com\/2016\/01\/spccpk\/\"><font size=\"4\">SPC\u3001Cpk\u3001\u88fd\u7a0b\u80fd\u529b\u4e4b\u89e3\u8aaa\u8207\u6574\u7406<\/font><\/a><\/p>\n<p><font size=\"4\">\u5ef6\u4f38\u95b1\u8b80\uff1a<\/font>     <br \/><a href=\"\/\/m.letratesoro.com\/2012\/03\/cause-effect-analysis\/\"><font size=\"4\">\u7279\u6027\u8981\u56e0\u5206\u6790\u5716(Cause &amp; effect Analysis)\u4ecb\u7d39<\/font><\/a>     <br \/><a href=\"\/\/m.letratesoro.com\/2012\/02\/pareto-chart\/\"><font size=\"4\">\u67cf\u62c9\u5716\u5206\u6790 (Pareto Chart)\u4ecb\u7d39<\/font><\/a>     <br \/><a href=\"\/\/m.letratesoro.com\/2012\/02\/excel-pareto\/\"><font size=\"4\">\u5982\u4f55\u4f7f\u7528Excel2007\u88fd\u4f5c\u67cf\u62c9\u5716(Pareto chart)<\/font><\/a>     <br \/><a href=\"\/\/m.letratesoro.com\/2011\/08\/six-sigma-iv\/\"><font size=\"4\">\u6a19\u6e96\u5dee\u8207\u5e38\u614b\u5206\u4f48\u7684\u95dc\u4fc2(six sigma)<\/font><\/a>     <br \/><a href=\"\/\/m.letratesoro.com\/2014\/05\/excel-2007-normal-distribution-chart\/\"><font size=\"4\">\u5982\u4f55\u4f7f\u7528Excel2007\u5efa\u7acb\u5e38\u614b\u5206\u5e03\u66f2\u7dda\u5716\u8868<\/font><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u76f4\u65b9\u5716\uff08Histogram\uff09\u7684\u6700\u4e3b\u8981\u7528\u9014\u5728\u63a8\u6e2c\u88fd &#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,116,142],"tags":[81],"aioseo_notices":[],"views":35549,"_links":{"self":[{"href":"\/\/m.letratesoro.com\/wp-json\/wp\/v2\/posts\/4438"}],"collection":[{"href":"\/\/m.letratesoro.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"\/\/m.letratesoro.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"\/\/m.letratesoro.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"\/\/m.letratesoro.com\/wp-json\/wp\/v2\/comments?post=4438"}],"version-history":[{"count":0,"href":"\/\/m.letratesoro.com\/wp-json\/wp\/v2\/posts\/4438\/revisions"}],"wp:attachment":[{"href":"\/\/m.letratesoro.com\/wp-json\/wp\/v2\/media?parent=4438"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"\/\/m.letratesoro.com\/wp-json\/wp\/v2\/categories?post=4438"},{"taxonomy":"post_tag","embeddable":true,"href":"\/\/m.letratesoro.com\/wp-json\/wp\/v2\/tags?post=4438"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}