{"id":2960,"date":"2014-05-07T08:28:00","date_gmt":"2014-05-07T00:28:00","guid":{"rendered":"\/\/m.letratesoro.com\/?p=2960"},"modified":"2023-06-02T09:41:14","modified_gmt":"2023-06-02T01:41:14","slug":"excel-2007-normal-distribution-chart","status":"publish","type":"post","link":"\/\/m.letratesoro.com\/2014\/05\/excel-2007-normal-distribution-chart\/","title":{"rendered":"\u5982\u4f55\u4f7f\u7528Excel2007\u5efa\u7acb\u5e38\u614b\u5206\u4f48\u66f2\u7dda\u5716\u8868"},"content":{"rendered":"<p align=\"justify\"><font size=\"3\"><img loading=\"lazy\" decoding=\"async\" title=\"\u5982\u4f55\u4f7f\u7528Excel2007\u5efa\u7acb\u5e38\u614b\u5206\u4f48\u66f2\u7dda\u5716\u8868\" style=\"border-width: 0px; padding-top: 0px; padding-right: 0px; padding-left: 0px; display: inline; background-image: none;\" border=\"0\" alt=\"\u5982\u4f55\u4f7f\u7528Excel2007\u5efa\u7acb\u5e38\u614b\u5206\u4f48\u66f2\u7dda\u5716\u8868\" src=\"\/\/m.letratesoro.com\/wp-content\/uploads\/images\/9b0723dd43c2_CEEC\/Excel00.png\" width=\"570\" height=\"255\" \/><\/font><font size=\"4\">\u300c<strong><font color=\"#0000ff\">\u5e38\u614b\u5206\u4f48\u66f2\u7dda(normal distribution)\u300d<\/font><\/strong>\u53c8\u540d\u300c\u6b63\u614b\u5206\u4f48(\u5927\u9678\u7528\u8a9e)\u300d\u4e5f\u7a31\u300c\u9ad8\u65af\u5206\u4f48(gaussian distribution)\u300d\u662f\u6211\u5011\u65e5\u5e38\u5de5\u4f5c\u4e2d\u5f88\u5e38\u4f7f\u7528\u5230\u7684\u4e00\u9805\u5de5\u5177\uff0c\u8209\u51e1\u73ed\u7d1a\u4e0a\u7684\u5b78\u79d1\u6210\u7e3e\u5206\u4f48\uff0c\u516c\u53f8\u5c0d\u54e1\u5de5\u7684\u7e3e\u6548\u8003\u6838\u8a55\u7b49\u5206\u4f48\uff0c\u6216\u662f\u7522\u54c1\u5c3a\u5bf8\u7684\u91cf\u6e2c\u5206\u4f48\uff0c\u9019\u4e9b\u90fd\u662f\u5e38\u614b\u5206\u4f48\u7684\u8868\u73fe\u4e4b\u4e00\u3002<\/font><\/p>\n<p align=\"justify\"><font size=\"4\">\u59d1\u4e14\u4e0d\u8ad6\u4f60\u5230\u5e95\u5c0d\u5e38\u614b\u66f2\u7dda\u61c2\u5f97\u591a\u5c11\uff0c\u5982\u679c\u4f60\u53ef\u4ee5\u5728\u65e5\u5e38\u7684\u7522\u54c1\u5206\u6790\u5831\u544a\u4e2d\u628a\u9019\u500b\u5e38\u614b\u5206\u4f48\u7d66\u5b83\u7528Excel\u7d66\u756b\u51fa\uff0c\u76f8\u4fe1\u53ef\u4ee5\u8b93\u4f60\u7684\u8001\u95c6\u5c0d\u4f60\u522e\u76ee\u76f8\u770b\uff0c\u7576\u7136\u5982\u679c\u53ef\u4ee5\u7684\u8a71\uff0c\u9084\u662f\u53bb\u77ad\u89e3\u4e00\u4e0b\u4f55\u8b02\u5e38\u614b\u5206\u4f48\u3002<\/font><\/p>\n<p align=\"justify\"><font size=\"4\">\u76f8\u95dc\u95b1\u8b80\uff1a<\/font><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><\/p>\n<p><!--more--><\/p>\n<h2 align=\"justify\"><font face=\"\u5fae\u8edf\u6b63\u9ed1\u9ad4\"><font style=\"font-weight: bold;\">YouTube\u5f71\u7247\uff1a\u5982\u4f55\u4f7f\u7528Excel\u756b\u51fa\u6a19\u6e96\u7684\u5e38\u614b\u5206\u4f48\u66f2\u7dda(normal distribution)\uff1f<\/font><\/font><\/h2>\n<p align=\"center\"><iframe loading=\"lazy\" title=\"YouTube video player\" height=\"315\" allowfullscreen=\"allowfullscreen\" src=\"https:\/\/www.youtube.com\/embed\/z-iTkRidPjI\" frameborder=\"0\" width=\"580\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\"><\/iframe><\/p>\n<p align=\"justify\"><font size=\"4\">\u5f71\u7247\u7684\u5167\u5bb9\u6bd4\u672c\u6587\u7684\u8aaa\u660e\u6709\u66f4\u591a\u7684\u8cc7\u8a0a\u8207\u5167\u5bb9\u66f4\u65b0\uff0c\u5982\u679c\u4f60\u662f\u4f7f\u7528Office365\u7684Excel\u5efa\u8b70\u89c0\u770b\u9019\u652fYouTube\u7684\u5f71\u7247\u4ee5\u4e86\u89e3\u66f4\u591a\u95dc\u65bc\u5982\u4f55\u4f7f\u7528Excel\u7e6a\u88fd\u5e38\u614b\u5206\u4f48\u5716\u7684\u8aaa\u660e\u3002<\/font><\/p>\n<h2>\n<p align=\"justify\"><font color=\"#0000ff\" size=\"5\" face=\"\u5fae\u8edf\u6b63\u9ed1\u9ad4\"><strong>\u5982\u4f55\u4f7f\u7528Excel2007\u5efa\u7acb\u5e38\u614b\u5206\u4f48\u66f2\u7dda\u5716\u8868<\/strong><\/font><\/p>\n<\/h2>\n<p align=\"justify\"><font size=\"4\">\u4e0b\u5217\u7684\u7bc4\u4f8b\u4ee5Microsoft\u7684\u539f\u672c\u8aaa\u660e\u7576\u53c3\u8003\uff0c\u56e0\u70ba\u5de5\u4f5c\u718a\u7684Excel\u662f\u82f1\u6587\u7248\uff0c\u6240\u4ee5\u90e8\u4efd\u89e3\u91cb\u4e5f\u662f\u82f1\u6587\u3002<\/font><\/p>\n<p align=\"justify\"><font size=\"4\">\u7bc4\u4f8b\u57fa\u672c\u4e0a\u4f7f\u7528\u4e86Excel\u7684 [Data Analysis(\u5206\u6790\u5de5\u5177\u7bb1)] \u4e2d\u7684\u300cRandom Number Generation(\u4e82\u6578\u7522\u751f\u5668)\u300d\u5de5\u5177\u4f86\u7522\u751f\u8cc7\u6599\uff0c\u4e26\u4f7f\u7528\u300cXY Scatter(\u8272\u968e\u5206\u4f48\u5716)\u300d\u4f86\u7522\u751f\u9418\u578b\u66f2\u7dda\uff0c\u9084\u53ef\u4ee5\u518d\u52a0\u4e0a\u300cHistogram(\u76f4\u65b9\u9577\u689d\u5716)\u300d\u4e00\u8d77\u914d\u5408\u3002<\/font><\/p>\n<p align=\"justify\"><font size=\"4\">\u8acb\u6ce8\u610f\uff1a<span class=\"RED_UNDERLINE\">\u672c\u6587\u4e2d\u4f7f\u7528Excel\u756b\u51fa\u4f86\u7684\u5e38\u614b\u5206\u4f48\u66f2\u7dda\u5176\u5be6\u662f\u5229\u7528\u6211\u5011\u539f\u672c\u7684\u6578\u503c\u8cc7\u6599\u6240\u8a08\u7b97\u51fa\u4f86\u7684\u6a19\u6e96\u5dee\u8207\u4e2d\u5fc3\u503c\uff0c\u7136\u5f8c\u518d\u7528\u4e82\u6578\u6240\u6a21\u64ec\u7522\u751f\u51fa\u4f86\u7684\u66f2\u7dda<\/span>\uff0c\u5b83\u6709\u4e00\u500b\u5047\u8a2d\u524d\u63d0\uff0c\u5c31\u662f\u6578\u64da\u7684\u5206\u4f48\u5fc5\u9808\u70ba\u5e38\u614b\u5206\u4f48\uff0c\u5982\u679c\u4f60\u7121\u6cd5\u78ba\u5b9a\u8cc7\u6599\u70ba\u5e38\u614b\u5206\u4f48\uff0c\u90a3\u756b\u51fa\u4f86\u7684\u7d50\u679c\u5c31\u53ef\u80fd\u5931\u771f\uff0c\u6bd4\u5982\u8aaa\u751f\u7522\u51fa\u4f86\u7684\u7522\u54c1\u6709\u5148\u7d93\u904e\u4e0d\u826f\u54c1\u6311\u9078\uff0c\u90a3\u9ebc\u5b83\u7684\u5206\u4f48\u5c31\u6703\u662f\u524d\u5f8c\u88ab\u622a\u65b7\u7684\u5e38\u614b\u5206\u4f48\uff0c\u800c\u4e0d\u662f\u6b63\u5e38\u7684\u5e38\u614b\u5206\u4f48\u4e86\uff0c\u518d\u6bd4\u5982\u8aaa\u5982\u679c\u662f\u55ae\u908a\u898f\u683c\u7684\u7522\u54c1\uff0c\u4f8b\u5982\u96fb\u6c60\u96fb\u58d3\uff0c\u5176\u5206\u4f48\u5c31\u53ef\u80fd\u70ba\u504f\u614b\u5206\u4f48\u3002<\/font><\/p>\n<p align=\"justify\"><font size=\"4\"><strong>\u82e5\u8981\u5efa\u7acb\u7bc4\u4f8b\u9418\u578b\u66f2\u7dda\uff0c\u8acb\u4f9d\u7167\u4e0b\u5217\u6b65\u9a5f\u57f7\u884c\uff1a<\/strong><\/font><\/p>\n<h4>\n<p><strong><font color=\"#9b00d3\" size=\"5\">\u6b65\u9a5f1. \u4f7f\u7528Excel\u5efa\u7acb\u9418\u578b\u66f2\u7dda(\u5e38\u614b\u5206\u4f48\u66f2\u7dda)\u7684\u6e96\u5099\u5de5\u4f5c<\/font><\/strong><\/p>\n<\/h4>\n<ol>\n<li><font size=\"4\">\u555f\u52d5 Excel\u3002<\/font><\/li>\n<li><font size=\"4\">\u5728\u65b0\u7684\u5de5\u4f5c\u8868\u4e2d\u8f38\u5165\u4e0b\u5217\u8cc7\u6599\u884c\u6a19\u984c:<\/font><br \/>\n<table cellspacing=\"0\" cellpadding=\"2\" width=\"100%\" border=\"0\">\n<tbody>\n<tr>\n<td bgcolor=\"#e7e7e7\" valign=\"top\" width=\"540\"><font size=\"4\">A1:\u539f\u59cb\u8cc7\u6599\uff0cB1:\u5e73\u5747\u503c\uff0cC1:Bin\uff0cD1:\u4e82\u6578\uff0cE1:\u76f4\u65b9\u5716\uff0cG1:\u76f4\u65b9\u5716<\/font><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"\u5982\u4f55\u4f7f\u7528Excel2007\u5efa\u7acb\u5e38\u614b\u5206\u4f48\u66f2\u7dda\u5716\u8868\" style=\"border-width: 0px; padding-top: 0px; padding-right: 0px; padding-left: 0px; display: inline; background-image: none;\" border=\"0\" alt=\"\u5982\u4f55\u4f7f\u7528Excel2007\u5efa\u7acb\u5e38\u614b\u5206\u4f48\u66f2\u7dda\u5716\u8868\" src=\"\/\/m.letratesoro.com\/wp-content\/uploads\/images\/9b0723dd43c2_CEEC\/Excel01.png\" width=\"491\" height=\"78\" \/><\/p>\n<\/li>\n<li><font size=\"4\">\u5728\u76f8\u540c\u7684\u5de5\u4f5c\u8868\u4e2d\u8f38\u5165\u4e0b\u5217\u8cc7\u6599\uff1a <\/font>\n<pre><font face=\"\u5fae\u8edf\u6b63\u9ed1\u9ad4\" size=\"4\">  A1: \u539f\u59cb\u8cc7\u6599 B1: \u5e73\u5747\u503c\n  A2: 22      B2: =AVERAGE(A2:A9) \n  A3: 26      B3: \u6a19\u6e96\u5dee\n  A4: 11      B4: =STDEV(A2:A9) \n  A5: 25\n  A6: 28\n  A7: 58\n  A8: 44\n  A9: 20<\/font><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel\u5e38\u614b\u5206\u4f4802\" style=\"border-width: 0px; padding-top: 0px; padding-right: 0px; padding-left: 0px; display: inline; background-image: none;\" border=\"0\" alt=\"Excel\u5e38\u614b\u5206\u4f4802\" src=\"\/\/m.letratesoro.com\/wp-content\/uploads\/images\/9b0723dd43c2_CEEC\/Excel02.png\" width=\"491\" height=\"203\" \/><\/p>\n<p><font size=\"4\">AVERAGE\u516c\u5f0f\u6703\u7522\u751f\u7684\u5e73\u5747\u503c\u3002STDEV\u516c\u5f0f\u6703\u7522\u751f\u6a19\u6e96\u5dee\u3002 <\/font><\/p>\n<\/li>\n<li><font size=\"4\">\u63a5\u8457\u518d\u8f38\u5165\u4e0b\u5217\u516c\u5f0f\u4f86\u7522\u751f\u76f4\u65b9\u5716\u6216\u8272\u968e\u5206\u4f48\u5716\u7684\u7bc4\u570d: <\/font>\n<pre><font face=\"\u5fae\u8edf\u6b63\u9ed1\u9ad4\" size=\"4\">   C2: =$B$2-3*$B4<\/font><\/pre>\n<p><font size=\"4\">\u9019\u500b\u516c\u5f0f\u6703\u7522\u751f\u5340\u9593\u7bc4\u570d\u7684\u4e0b\u9650\u3002\u9019\u500b\u516c\u5f0f\u4ee3\u8868\u6211\u5011\u628a\u4e0b\u9650\u8a2d\u70ba\u4e09\u500b\u6a19\u6e96\u5dee\uff0c\u6240\u4ee5\u7528\u4e2d\u5fc3\u503c\u6e1b\u6389\u4e09\u500b\u8868\u6e96\u5dee\u3002<\/font><\/p>\n<p><font size=\"4\">\u518d\u8f38\u5165\u4e0b\u9762\u7684\u516c\u5f0f\uff1a<\/font><\/p>\n<pre><font face=\"\u5fae\u8edf\u6b63\u9ed1\u9ad4\" size=\"4\">   C3: =C2+<font color=\"#ff0000\">$<\/font>B<font color=\"#ff0000\">$<\/font>4<\/font><\/pre>\n<p><font size=\"3\"><\/font><\/p>\n<p>    <font size=\"3\"><\/p>\n<p align=\"justify\"><font size=\"3\"><font size=\"4\">\u8a18\u5f97\u8981\u52a0\u4e0a\u3010$\u3011\u865f\uff0c\u5426\u5247\u4e0b\u9762\u7684\u516c\u5f0f\u53ef\u80fd\u6703\u8dd1\u6389\u3002\u9019\u500b\u503c\u662f\u7528\u4f86\u8a08\u7b97\u6bcf\u500b\u6578\u503c\u8a08\u7b97\u7684\u523b\u5ea6\uff08\u9593\u8ddd\uff09\uff0c\u9019\u88e1\u6211\u5011\u628a\u6bcf\u500b\u523b\u5ea6\u7528\u4e00\u500b\u8868\u6e96\u5dee\u4f86\u8a08\u7b97\uff0c\u6240\u4ee5\u6bcf\u500b\u5132\u5b58\u683c\u90fd\u7d2f\u52a0\u4e0a\u4e00\u500b\u8868\u6e96\u5dee(<font color=\"#ff0000\">$<\/font>B<font color=\"#ff0000\">$<\/font>4 )\u7684\u503c\u3002<\/font><\/font><\/p>\n<p>    <\/font><\/p>\n<p><font size=\"3\"><\/font><\/p>\n<p align=\"justify\"><font size=\"4\">\u9078\u53d6\u5132\u5b58\u683c C3\uff0c\u6293\u53d6\u586b\u6eff\u63a7\u9ede\uff0c\u7136\u5f8c\u586b\u5165\u516c\u5f0f\u5411\u4e0b\u5f9e\u5132\u5b58\u683c C3 \u7684\u5132\u5b58\u683c C8\u3002<\/font><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel\u5e38\u614b\u5206\u4f4803\" style=\"border-width: 0px; padding-top: 0px; padding-right: 0px; padding-left: 0px; display: inline; background-image: none;\" border=\"0\" alt=\"Excel\u5e38\u614b\u5206\u4f4803\" src=\"\/\/m.letratesoro.com\/wp-content\/uploads\/images\/9b0723dd43c2_CEEC\/Excel03.png\" width=\"491\" height=\"202\" \/><\/p>\n<\/li>\n<\/ol>\n<h4>\n<p><strong><font color=\"#9b00d3\" size=\"5\">\u6b65\u9a5f2. \u7522\u751f\u9418\u578b\u66f2\u7dda(\u5e38\u614b\u5206\u4f48\u66f2\u7dda)\u7684\u4e82\u6578\u8cc7\u6599<\/font><\/strong><\/p>\n<\/h4>\n<p><font size=\"4\">\u63a5\u8457\u8981\u7522\u751f\u96a8\u6a5f\u6578\u503c\uff0c\u9019\u662f\u7528\u4f86\u5f62\u6210\u9418\u578b\u66f2\u7dda\uff08\u5e38\u614b\u5206\u4f48\u66f2\u7dda\uff09\u7684\u57fa\u790e\uff0c\u8acb\u4f9d\u7167\u4e0b\u5217\u6b65\u9a5f\u57f7\u884c\uff1a<\/font><\/p>\n<ol><font size=\"3\"><\/p>\n<li><font size=\"4\">\u6309\u4e00\u4e0b\u6c34\u5e73\u529f\u80fd\u8868\u7684 [<strong><font color=\"#0000ff\">Data(\u8cc7\u6599)<\/font><\/strong>]\uff0c\u7136\u5f8c\u9078\u53d6\u5e36\u72c0\u529f\u80fd\u8868\u4e0a\u7684[<strong><font color=\"#0000ff\">Data Analysis(\u8cc7\u6599\u5206\u6790)<\/font><\/strong>]\u3002<\/font>\n<p align=\"justify\"><img loading=\"lazy\" decoding=\"async\" title=\"Excel\u5e38\u614b\u5206\u4f4804\" style=\"border-width: 0px; padding-top: 0px; padding-right: 0px; padding-left: 0px; display: inline; background-image: none;\" border=\"0\" alt=\"Excel\u5e38\u614b\u5206\u4f4804\" src=\"\/\/m.letratesoro.com\/wp-content\/uploads\/images\/9b0723dd43c2_CEEC\/Excel04.png\" width=\"521\" height=\"235\" \/>&#160; <br \/><font size=\"4\">Excel 2013\u9810\u8a2d\u662f\u6c92\u6709\u958b\u555f[Data Analysis(\u8cc7\u6599\u5206\u6790)]\u529f\u80fd\u7684\uff0c\u4f60\u5fc5\u9808\u524d\u5f80 [\u6a94\u6848] \u300b[\u9078\u9805] \u300b[\u589e\u76ca\u96c6]\u3002\u5728 [\u7ba1\u7406] \u65b9\u584a\u4e2d\uff0c\u6309\u4e00\u4e0b [COM \u589e\u76ca\u96c6] \u300b[\u57f7\u884c]\u3002\u6aa2\u67e5 [ Microsoft Office Microsoft Excel 2013 \u4e2d\u7684[Power Pivot] \u65b9\u584a\u4e2d\uff0c\u7136\u5f8c\u6309\u4e00\u4e0b[\u78ba\u5b9a]\u3002<\/font><\/p>\n<\/li>\n<li>\u5728[Data Analysis(<b>\u5206\u6790\u5de5\u5177)<\/b>] \u65b9\u584a\u4e2d\uff0c\u6309\u4e00\u4e0b [Random Number Generation(<b>\u4e82\u6578\u7522\u751f\u5668)]<\/b>\uff0c\u7136\u5f8c\u6309\u4e00\u4e0b<b>[OK(\u78ba\u5b9a)]<\/b>\u3002<img loading=\"lazy\" decoding=\"async\" title=\"Excel\u5e38\u614b\u5206\u4f4805\" style=\"border-width: 0px; padding-top: 0px; padding-right: 0px; padding-left: 0px; display: inline; background-image: none;\" border=\"0\" alt=\"Excel\u5e38\u614b\u5206\u4f4805\" src=\"\/\/m.letratesoro.com\/wp-content\/uploads\/images\/9b0723dd43c2_CEEC\/Excel05.png\" width=\"403\" height=\"202\" \/> <\/li>\n<li>\n<div align=\"justify\"><font size=\"4\">\u5728[<strong><font color=\"#0000ff\">Number of Variables(\u8b8a\u6578\u6578\u5b57)]<\/font><\/strong> \u4e2d\uff0c\u9375\u51651\u3002 <\/font><\/div>\n<\/li>\n<li>\n<div align=\"justify\"><font size=\"4\">\u5728 <strong>[<font color=\"#0000ff\">Number of Random Numbers(\u6578\u5b57\u7684\u96a8\u6a5f\u6578\u5b57)<\/font>]<\/strong> \u65b9\u584a\u4e2d\uff0c\u8f38\u51652000\u3002 <\/font><\/div>\n<p align=\"justify\"><font size=\"4\"><strong>\u6ce8\u610f<\/strong>\uff1a \u9019\u500b\u6578\u5b57\u8868\u793a\u5c07\u7522\u751f\u7684\u4e82\u6578\u6578\u76ee\uff0c\u589e\u52a0\u6216\u6e1b\u5c11\u9019\u500b\u6578\u5b57\u5c07\u6703\u5f71\u97ff\u9418\u578b\u66f2\u7dda\u7684\u6b63\u78ba\u6027\u3002 <\/font><\/p>\n<\/li>\n<li>\n<div align=\"justify\"><font size=\"4\">\u5728[<strong><font color=\"#0000ff\">Distribution(\u767c\u4f48)<\/font>] \u65b9\u584a<\/strong>\u4e2d\uff0c\u9078\u53d6 [<strong><font color=\"#0000ff\">Normal(\u4e00\u822c)<\/font><\/strong>]\u3002 <\/font><\/div>\n<\/li>\n<li>\n<div align=\"justify\"><font size=\"4\">\u5728 [Parameters(<b>\u53c3\u6578)<\/b>] \u7a97\u683c\u4e2d\u7684[<strong><font color=\"#0000ff\">Mean(\u5e73\u5747\u503c)<\/font><\/strong>]\uff0c\u8f38\u5165\u5132\u5b58\u683c B2 \u4e2d\u8a08\u7b97\u51fa\u7684\u5e73\u5747\u503c (\u5728\u7bc4\u4f8b\u4e2d\u70ba(29.25)] \u3002 <\/font><\/div>\n<\/li>\n<li>\n<div align=\"justify\"><font size=\"4\">\u5728 [<strong><font color=\"#0000ff\">Standard deviation(\u6a19\u6e96\u5dee)<\/font><\/strong>] \u65b9\u584a\u4e2d\u8f38\u5165\u5132\u5b58\u683c B4 \u4e2d\u8a08\u7b97\u51fa\u7684\u6578\u503c (14.8589)\u3002 <\/font><\/div>\n<\/li>\n<li>\n<div align=\"justify\"><font size=\"4\"><b>[<font color=\"#0000ff\">Random Seed)\u96a8\u6a5f\u7a2e\u5b50<\/font>]<\/b>\u65b9\u584a\u4fdd\u7559\u7a7a\u767d\u3002 <\/font><\/div>\n<\/li>\n<li>\n<div align=\"justify\"><font size=\"4\">\u5728 [Output options(<b>\u8f38\u51fa\u9078\u9805)<\/b>] \u7a97\u683c\u4e2d\uff0c\u6309\u4e00\u4e0b [<strong><font color=\"#0000ff\">Output Range(\u8f38\u51fa\u7bc4\u570d)<\/font><\/strong>]\uff0c\u4e26\u8f38\u5165 <strong>D2 <\/strong>\u6216\u662f<strong> $D$2<\/strong>\u3002\u5982\u679c\u9ede\u9078\u5f8c\u9762\u7684\u9078\u53d6\u65b9\u584a\u5f9e\u8868\u683c\u8aaa\u9078\u53d6\u5c31\u6703\u51fa\u73fe<strong>$D$2<\/strong>\u7d55\u5c0d\u4f4d\u5740\u3002<\/font> <\/div>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel\u5e38\u614b\u5206\u4f4806\" style=\"border-width: 0px; padding-top: 0px; padding-right: 0px; padding-left: 0px; display: inline; background-image: none;\" border=\"0\" alt=\"Excel\u5e38\u614b\u5206\u4f4806\" src=\"\/\/m.letratesoro.com\/wp-content\/uploads\/images\/9b0723dd43c2_CEEC\/Excel06.png\" width=\"472\" height=\"469\" \/><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><font size=\"4\">\u6309\u4e00\u4e0b<strong>[OK(\u78ba\u5b9a)]<\/strong>\u5f8c\uff0c\u6703\u5728D2:D2001\u7684\u8f38\u51fa\u7bc4\u570d\u7522\u751f 2000 \u7d44\u5e38\u614b\u5206\u914d\u7684\u96a8\u6a5f\u6578\u5b57(\u5c31\u662f\u4f9d\u7167\u5e73\u5747\u503c\u8207\u6a19\u6e96\u5dee\u6240\u7522\u751f\u7684\u4e82\u6578\u5e38\u614b\u5206\u4f48\uff0c\u6240\u4ee5\u53ef\u4ee5\u7e6a\u88fd\u51fa\u8868\u8f03\u6f02\u4eae\u7684\u5e38\u614b\u9418\u64fa\u66f2\u7dda)\u3002<\/font><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel\u5e38\u614b\u5206\u4f4807\" style=\"border-width: 0px; padding-top: 0px; padding-right: 0px; padding-left: 0px; display: inline; background-image: none;\" border=\"0\" alt=\"Excel\u5e38\u614b\u5206\u4f4807\" src=\"\/\/m.letratesoro.com\/wp-content\/uploads\/images\/9b0723dd43c2_CEEC\/Excel07.png\" width=\"489\" height=\"405\" \/><\/p>\n<\/li>\n<p>  <\/font><\/p>\n<p><font size=\"3\"><\/font><\/p>\n<\/ol>\n<h4>\n<p><strong><font color=\"#9b00d3\" size=\"5\">\u6b65\u9a5f3. \u88fd\u4f5c\u7d71\u8a08\u76f4\u65b9\u5716\u8207\u9418\u578b\u66f2\u7dda(\u5e38\u614b\u5206\u4f48\u66f2\u7dda)\u7684\u4e82\u6578\u8cc7\u6599<\/font><\/strong><\/p>\n<\/h4>\n<p align=\"justify\"><font size=\"4\">\u63a5\u8457\u5efa\u7acb\u76f4\u65b9\u5716\u7684\u96a8\u6a5f\u8cc7\u6599\uff0c\u8acb\u4f9d\u7167\u4e0b\u5217\u6b65\u9a5f\u57f7\u884c\uff1a <\/font><\/p>\n<ol><font size=\"3\"><\/p>\n<li>\n<div align=\"justify\"><font size=\"4\">\u6309\u4e00\u4e0b\u6c34\u5e73\u529f\u80fd\u8868\u7684 [<strong><font color=\"#0000ff\">Data(\u8cc7\u6599)<\/font><\/strong>]\uff0c\u7136\u5f8c\u9078\u53d6\u5e36\u72c0\u529f\u80fd\u8868\u4e0a\u7684[<strong><font color=\"#0000ff\">Data Analysis(\u8cc7\u6599\u5206\u6790)<\/font><\/strong>]\u3002 <\/font><\/div>\n<\/li>\n<li>\n<div align=\"justify\"><font size=\"4\">\u5728[<strong><font color=\"#0000ff\">Data Analysis(\u5206\u6790\u5de5\u5177)<\/font><\/strong>] \u65b9\u584a\u4e2d\uff0c\u6309\u4e00\u4e0b [<strong><font color=\"#0000ff\">Histogram(\u76f4\u65b9\u5716)<\/font>]<\/strong>\uff0c\u7136\u5f8c\u6309\u4e00\u4e0b<b>[<font color=\"#0000ff\">OK(\u78ba\u5b9a)<\/font>]<\/b>\u3002<\/font> <\/div>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel\u5e38\u614b\u5206\u4f4808\" style=\"border-width: 0px; padding-top: 0px; padding-right: 0px; padding-left: 0px; display: inline; background-image: none;\" border=\"0\" alt=\"Excel\u5e38\u614b\u5206\u4f4808\" src=\"\/\/m.letratesoro.com\/wp-content\/uploads\/images\/9b0723dd43c2_CEEC\/Excel08.png\" width=\"403\" height=\"202\" \/><\/p>\n<\/li>\n<li>\n<div align=\"justify\"><font size=\"4\">\u5728[<strong><font color=\"#0000ff\">Input Range(\u8f38\u5165\u7bc4\u570d)<\/font><\/strong>]&#160; \u7a7a\u683c\u4e2d\uff0c\u8f38\u5165<strong>D2:D2001<\/strong> \u6216 <strong>$D$2:$D$2001<\/strong>\u3002 <\/font><\/div>\n<\/li>\n<li>\n<div align=\"justify\"><font size=\"4\">\u5728[<strong><font color=\"#0000ff\">Bin Range(\u5340\u9593\u7bc4\u570d)<\/font><\/strong>] \u65b9\u584a\u4e2d\uff0c\u8f38\u5165C2:C8 \u6216 $C$2:$C$8\u3002 <\/font><\/div>\n<\/li>\n<li>\n<div align=\"justify\"><font size=\"4\">\u5728 [Output options(<b>\u8f38\u51fa\u9078\u9805)<\/b>] \u7a97\u683c\u4e2d\uff0c\u6309\u4e00\u4e0b [<strong><font color=\"#0000ff\">Output Range(\u8f38\u51fa\u7bc4\u570d)<\/font><\/strong>]\uff0c\u4e26\u5728\u5176\u7a7a\u683c\u4e2d\u8f38\u5165<b>E2<\/b> \u6216 <strong>$E$2<\/strong>\u3002<\/font> <\/div>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel\u5e38\u614b\u5206\u4f4809\" style=\"border-width: 0px; padding-top: 0px; padding-right: 0px; padding-left: 0px; display: inline; background-image: none;\" border=\"0\" alt=\"Excel\u5e38\u614b\u5206\u4f4809\" src=\"\/\/m.letratesoro.com\/wp-content\/uploads\/images\/9b0723dd43c2_CEEC\/Excel09.png\" width=\"409\" height=\"300\" \/>&#160;<\/p>\n<\/li>\n<li>\n<p align=\"justify\"><font size=\"4\">\u6309\u4e00\u4e0b<b>[<font color=\"#0000ff\">OK(\u78ba\u5b9a)<\/font>]<\/b>\u5f8c\uff0c\u6703\u5728E2:F10\u7684\u8f38\u51fa\u7bc4\u570d\u7522\u751f 7 \u7d44\u7d71\u8a08\u4e82\u6578\u5f8c\u7684\u9593\u8ddd\u8207\u6578\u91cf\u3002<\/font><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"\u5982\u4f55\u4f7f\u7528Excel2007\u5efa\u7acb\u5e38\u614b\u5206\u4f48\u66f2\u7dda\u5716\u8868\" style=\"border-width: 0px; padding-top: 0px; padding-right: 0px; padding-left: 0px; display: inline; background-image: none;\" border=\"0\" alt=\"\u5982\u4f55\u4f7f\u7528Excel2007\u5efa\u7acb\u5e38\u614b\u5206\u4f48\u66f2\u7dda\u5716\u8868\" src=\"\/\/m.letratesoro.com\/wp-content\/uploads\/images\/9b0723dd43c2_CEEC\/Excel10.png\" width=\"493\" height=\"230\" \/><\/p>\n<\/li>\n<p>  <\/font><\/p>\n<p><font size=\"3\"><\/font><\/p>\n<\/ol>\n<h4>\n<p><strong><font color=\"#9b00d3\" size=\"5\">\u6b65\u9a5f4. \u5efa\u7acb\u539f\u59cb\u6578\u64da\u7684\u9577\u689d\u5716\u7d71\u8a08\u8cc7\u6599<\/font><\/strong><\/p>\n<\/h4>\n<p align=\"justify\"><font size=\"4\">\u82e5\u8981\u5efa\u7acb\u539f\u59cb\u8cc7\u6599\u9577\u689d\u5716\uff0c\u8acb\u4f9d\u7167\u4e0b\u5217\u6b65\u9a5f\u57f7\u884c\uff1a <\/font><\/p>\n<ol><font size=\"3\"><\/p>\n<li>\n<div align=\"justify\"><font size=\"4\">\u6309\u4e00\u4e0b\u6c34\u5e73\u529f\u80fd\u8868\u7684 [<strong><font color=\"#0000ff\">Data(\u8cc7\u6599)<\/font><\/strong>]\uff0c\u7136\u5f8c\u9078\u53d6\u5e36\u72c0\u529f\u80fd\u8868\u4e0a\u7684[<strong><font color=\"#0000ff\">Data Analysis(\u8cc7\u6599\u5206\u6790)<\/font><\/strong>]\u3002 <\/font><\/div>\n<\/li>\n<li>\n<div align=\"justify\"><font size=\"4\">\u5728[<strong><font color=\"#0000ff\">Data Analysis(\u5206\u6790\u5de5\u5177)<\/font><\/strong>] \u65b9\u584a\u4e2d\uff0c\u6309\u4e00\u4e0b [<strong><font color=\"#0000ff\">Histogram(\u76f4\u65b9\u5716)<\/font>]<\/strong>\uff0c\u7136\u5f8c\u6309\u4e00\u4e0b<b>[<font color=\"#0000ff\">OK(\u78ba\u5b9a)<\/font>]<\/b>\u3002 <\/font><\/div>\n<\/li>\n<li>\n<div align=\"justify\"><font size=\"4\">\u5728[<strong><font color=\"#0000ff\">Input Range(\u8f38\u5165\u7bc4\u570d)<\/font><\/strong>]&#160; \u7a7a\u683c\u4e2d\uff0c\u8f38\u5165<strong>A2:A9<\/strong> \u6216 <strong>$A$2:$A$9<\/strong>\u3002 <\/font><\/div>\n<\/li>\n<li>\n<div align=\"justify\"><font size=\"4\">\u5728[<strong><font color=\"#0000ff\">Bin Range(\u5340\u9593\u7bc4\u570d)<\/font><\/strong>] \u65b9\u584a\u4e2d\uff0c\u8f38\u5165C2:C8 \u6216 $C$2:$C$8\u3002 <\/font><\/div>\n<\/li>\n<li>\n<div align=\"justify\"><font size=\"4\">\u5728 [Output options(<b>\u8f38\u51fa\u9078\u9805)<\/b>] \u7a97\u683c\u4e2d\uff0c\u6309\u4e00\u4e0b [<strong><font color=\"#0000ff\">Output Range(\u8f38\u51fa\u7bc4\u570d)<\/font><\/strong>]\uff0c\u4e26\u5728\u5176\u7a7a\u683c\u4e2d\u8f38\u5165<strong>G2<\/strong> \u6216 <strong>$G$2<\/strong>\u3002<\/font> <\/div>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel\u5e38\u614b\u5206\u4f4811\" style=\"border-width: 0px; padding-top: 0px; padding-right: 0px; padding-left: 0px; display: inline; background-image: none;\" border=\"0\" alt=\"Excel\u5e38\u614b\u5206\u4f4811\" src=\"\/\/m.letratesoro.com\/wp-content\/uploads\/images\/9b0723dd43c2_CEEC\/Excel11.png\" width=\"409\" height=\"300\" \/><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><font size=\"4\">\u6309\u4e00\u4e0b<b>[<font color=\"#0000ff\">OK(\u78ba\u5b9a)<\/font>]<\/b>\u5f8c\uff0c\u6703\u53e6\u5916\u5728E2:F10\u7684\u8f38\u51fa\u7bc4\u570d\u7522\u751f 7 \u7d44\u7d71\u8a08\u4e82\u6578\u5f8c\u7684\u9593\u8ddd\u8207\u6578\u91cf\u3002<\/font><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel\u5e38\u614b\u5206\u4f4812\" style=\"border-width: 0px; padding-top: 0px; padding-right: 0px; padding-left: 0px; display: inline; background-image: none;\" border=\"0\" alt=\"Excel\u5e38\u614b\u5206\u4f4812\" src=\"\/\/m.letratesoro.com\/wp-content\/uploads\/images\/9b0723dd43c2_CEEC\/Excel12.png\" width=\"492\" height=\"226\" \/><\/p>\n<p align=\"justify\"><font size=\"4\">\u5efa\u8b70\u53ef\u4ee5\u628aBin\u7684\u683c\u5f0f\u53bb\u6389\u5c0f\u6578\u9ede\uff0c\u9019\u6a23\u6578\u5b57\u6703\u6bd4\u8f03\u6f02\u4eae\u3002<\/font><\/p>\n<\/li>\n<p>  <\/font><\/p>\n<p><font size=\"3\"><\/font><\/p>\n<\/ol>\n<h4>\n<p><strong><font color=\"#9b00d3\" size=\"5\">\u6b65\u9a5f5. \u7e6a\u88fd\u76f4\u65b9\u5716\u5e38\u614b\u5206\u4f48<\/font> <\/strong><\/p>\n<\/h4>\n<ol><font size=\"3\"><\/p>\n<li>\n<div align=\"justify\"><font size=\"4\">\u9078\u53d6\u5de5\u4f5c\u8868\u4e0a\u7684 E2:F10 \u7bc4\u570d\u7684\u5132\u5b58\u683c\u3002 <\/font><\/div>\n<\/li>\n<li>\n<div align=\"justify\"><font size=\"4\">\u6309\u4e00\u4e0b\u6c34\u5e73\u9078\u55ae [<strong><font color=\"#0000ff\">Insert(\u63d2\u5165)<\/font><\/strong>] \uff0c\u7136\u5f8c\u9078\u53d6\u5e36\u72c0\u529f\u80fd\u8868\u7684[<strong><font color=\"#0000ff\">Column(\u76f4\u689d\u5716)<\/font><\/strong>]\u7684\u7b2c\u4e00\u500b [2-D Column]\u3002<\/font><img loading=\"lazy\" decoding=\"async\" title=\"Excel\u5e38\u614b\u5206\u4f4813\" style=\"border-width: 0px; padding-top: 0px; padding-right: 0px; padding-left: 0px; display: inline; background-image: none;\" border=\"0\" alt=\"Excel\u5e38\u614b\u5206\u4f4813\" src=\"\/\/m.letratesoro.com\/wp-content\/uploads\/images\/9b0723dd43c2_CEEC\/Excel13.png\" width=\"530\" height=\"390\" \/> <\/div>\n<\/li>\n<li><font size=\"4\">Excel\u6703\u81ea\u52d5\u51fa\u73fe\u76f4\u65b9\u5716\u7684\u7d50\u679c\u5982\u4e0b\u5716\u3002 <\/font>\n<p><font size=\"4\"><\/font><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"\u5982\u4f55\u4f7f\u7528Excel2007\u5efa\u7acb\u5e38\u614b\u5206\u4f48\u66f2\u7dda\u5716\u8868\" style=\"border-width: 0px; padding-top: 0px; padding-right: 0px; padding-left: 0px; display: inline; background-image: none;\" border=\"0\" alt=\"\u5982\u4f55\u4f7f\u7528Excel2007\u5efa\u7acb\u5e38\u614b\u5206\u4f48\u66f2\u7dda\u5716\u8868\" src=\"\/\/m.letratesoro.com\/wp-content\/uploads\/images\/9b0723dd43c2_CEEC\/Excel14.png\" width=\"437\" height=\"264\" \/><\/p>\n<\/li>\n<p>  <\/font><\/p>\n<p><font size=\"3\"><\/font><\/p>\n<\/ol>\n<h4><strong><font color=\"#9b00d3\" size=\"5\">\u6b65\u9a5f6. \u7e6a\u88fdXY(\u6563\u4f48)\u7684\u5e38\u614b\u5206\u4f48\u5716<\/font><\/strong> <\/h4>\n<ol>\n<li>\n<div align=\"justify\"><font size=\"4\">\u5728\u5df2\u7d93\u5efa\u7acb\u597d\u7684\u76f4\u65b9\u5716\u4e0a\u9ede\u6ed1\u9f20\u53f3\u9375\uff0c\u5f9e\u5feb\u986f\u529f\u80fd\u8868\u4e2d\u9078\u53d6 [Select Data(\u9078\u64c7\u4f86\u6e90\u8cc7\u6599)]\u3002<\/font> <\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"\u5982\u4f55\u4f7f\u7528Excel2007\u5efa\u7acb\u5e38\u614b\u5206\u4f48\u66f2\u7dda\u5716\u8868\" style=\"border-width: 0px; padding-top: 0px; padding-right: 0px; padding-left: 0px; display: inline; background-image: none;\" border=\"0\" alt=\"\u5982\u4f55\u4f7f\u7528Excel2007\u5efa\u7acb\u5e38\u614b\u5206\u4f48\u66f2\u7dda\u5716\u8868\" src=\"\/\/m.letratesoro.com\/wp-content\/uploads\/images\/9b0723dd43c2_CEEC\/Excel15.png\" width=\"446\" height=\"275\" \/><\/p>\n<\/p><\/div>\n<\/li>\n<li>\n<div align=\"justify\"><font size=\"4\">\u51fa\u73fe[Select data Source]\u5c0d\u8a71\u6846\uff0c\u9ede\u9078 [Add]\u6309\u9215\u65b0\u589e\u4e00\u7d44\u8cc7\u6599\u3002<\/font> <\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel\u5e38\u614b\u5206\u4f4816\" style=\"border-width: 0px; padding-top: 0px; padding-right: 0px; padding-left: 0px; display: inline; background-image: none;\" border=\"0\" alt=\"Excel\u5e38\u614b\u5206\u4f4816\" src=\"\/\/m.letratesoro.com\/wp-content\/uploads\/images\/9b0723dd43c2_CEEC\/Excel16.png\" width=\"480\" height=\"326\" \/><\/p>\n<\/p><\/div>\n<\/li>\n<li>\n<div align=\"justify\"><font size=\"4\">\u5728[Edit Series]\u5c0d\u8a71\u6846\uff0c[Series name]\u8868\u7559\u7a7a\u767d\u5c31\u53ef\u4ee5\u4e86\uff0c[Series Values]\u7684\u5730\u65b9\u8f38\u5165 F3:F10\uff0c\u4e5f\u53ef\u4ee5\u9ede\u9078\u7a7a\u767d\u6846\u7684\u5f8c\u65b9\u9078\u64c7\u9215\u5f9e\u5de5\u4f5c\u8868\u4e0a\u9078\u64c7\uff0c\u9019\u6642\u5f8c\u6703\u51fa\u73fe\u5de5\u4f5c\u8868\u7684\u540d\u7a31\u524d\u7db4\uff0c\u56e0\u70ba\u6211\u7684\u7bc4\u4f8b\u5728Sheet2\uff0c\u6240\u4ee5\u5c31\u51fa\u73fe\u5728\u524d\u7db4\uff0c\u5927\u90e8\u5206\u7684\u670b\u53cb\u5de5\u4f5c\u8868\u793a\u90fd\u6703\u662fSheet1\u624d\u5c0d\u3002\u8f38\u5165\u5b8c\u7562\u5f8c\u6309 [OK(\u78ba\u8a8d)]<\/font> \u3002 <\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel\u5e38\u614b\u5206\u4f4817\" style=\"border-width: 0px; padding-top: 0px; padding-right: 0px; padding-left: 0px; display: inline; background-image: none;\" border=\"0\" alt=\"Excel\u5e38\u614b\u5206\u4f4817\" src=\"\/\/m.letratesoro.com\/wp-content\/uploads\/images\/9b0723dd43c2_CEEC\/Excel17.png\" width=\"436\" height=\"262\" \/><\/p>\n<\/p><\/div>\n<\/li>\n<li>\n<p align=\"justify\"><font size=\"4\">\u56de\u5230 [Select Data Source(\u9078\u64c7\u8cc7\u6599\u4f86\u6e90)] \u5c0d\u8a71\u6846\uff0c\u76f4\u63a5\u9ede\u64ca<strong>[<font color=\"#0000ff\">OK(\u78ba\u5b9a)<\/font>]<\/strong>\u5c31\u53ef\u4ee5\u4e86\u3002<\/font><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel\u5e38\u614b\u5206\u4f4818\" style=\"border-width: 0px; padding-top: 0px; padding-right: 0px; padding-left: 0px; display: inline; background-image: none;\" border=\"0\" alt=\"Excel\u5e38\u614b\u5206\u4f4818\" src=\"\/\/m.letratesoro.com\/wp-content\/uploads\/images\/9b0723dd43c2_CEEC\/Excel18.png\" width=\"480\" height=\"326\" \/><\/p>\n<\/li>\n<li>\n<p align=\"justify\"><font size=\"4\">\u51fa\u73fe\u5169\u7d44\u9577\u689d\u5716\u4e86\u3002\u7528\u6ed1\u9f20\u5de6\u9375\u9078\u53d6\u5fc3\u589e\u52a0\u7684\u7d05\u8272\u76f4\u689d\u5716\uff0c\u7136\u5f8c\u6309\u6ed1\u9f20\u53f3\u9375\uff0c\u958b\u555f\u5feb\u986f\u529f\u80fd\u8868\uff0c\u9ede\u9078 [<strong><font color=\"#0000ff\">Change Series Chart Type(\u8b8a\u66f4\u5716\u8868\u985e\u578b)<\/font><\/strong>]\u3002<\/font><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"\u5982\u4f55\u4f7f\u7528Excel2007\u5efa\u7acb\u5e38\u614b\u5206\u4f48\u66f2\u7dda\u5716\u8868\" style=\"border-width: 0px; padding-top: 0px; padding-right: 0px; padding-left: 0px; display: inline; background-image: none;\" border=\"0\" alt=\"\u5982\u4f55\u4f7f\u7528Excel2007\u5efa\u7acb\u5e38\u614b\u5206\u4f48\u66f2\u7dda\u5716\u8868\" src=\"\/\/m.letratesoro.com\/wp-content\/uploads\/images\/9b0723dd43c2_CEEC\/Excel19.png\" width=\"448\" height=\"295\" \/><\/p>\n<\/li>\n<li><font size=\"4\">\u9078\u64c7[ <b><font color=\"#0000ff\">XY (scatter) \u6563\u4f48<\/font><\/b>]\u7684\u7b2c\u4e09\u500b\u5716\u5f62\u3002<\/font><img loading=\"lazy\" decoding=\"async\" title=\"\u5982\u4f55\u4f7f\u7528Excel2007\u5efa\u7acb\u5e38\u614b\u5206\u4f48\u66f2\u7dda\u5716\u8868\" style=\"border-width: 0px; padding-top: 0px; padding-right: 0px; padding-left: 0px; display: inline; background-image: none;\" border=\"0\" alt=\"\u5982\u4f55\u4f7f\u7528Excel2007\u5efa\u7acb\u5e38\u614b\u5206\u4f48\u66f2\u7dda\u5716\u8868\" src=\"\/\/m.letratesoro.com\/wp-content\/uploads\/images\/9b0723dd43c2_CEEC\/Excel20.png\" width=\"570\" height=\"387\" \/> <\/li>\n<li><strong><font color=\"#0000ff\" size=\"4\">\u5e38\u614b\u5206\u4f48\u66f2\u7dda\u5916\u52a0\u76f4\u689d\u5716\u5c31\u521d\u6b65\u5b8c\u6210\u56c9\uff01<\/font><\/strong>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"\u5982\u4f55\u4f7f\u7528Excel2007\u5efa\u7acb\u5e38\u614b\u5206\u4f48\u66f2\u7dda\u5716\u8868\" style=\"border-width: 0px; padding-top: 0px; padding-right: 0px; padding-left: 0px; display: inline; background-image: none;\" border=\"0\" alt=\"\u5982\u4f55\u4f7f\u7528Excel2007\u5efa\u7acb\u5e38\u614b\u5206\u4f48\u66f2\u7dda\u5716\u8868\" src=\"\/\/m.letratesoro.com\/wp-content\/uploads\/images\/9b0723dd43c2_CEEC\/Excel21.png\" width=\"437\" height=\"263\" \/><\/p>\n<\/li>\n<li>\n<div align=\"justify\"><font size=\"4\">\u5269\u4e0b\u7684\u53ef\u4ee5\u81ea\u884c\u8abf\u6574\u9577\u689d\u5f62\u7684\u9593\u9699\u5927\u5c0f\u767e\u5206\u6bd4\uff0c\u4ee5\u53ca\u5176\u5b83\u7684\u8a2d\u5b9a\uff0c\u505a\u51fa\u66f4\u6f02\u4eae\u7684\u5206\u4f48\u66f2\u7dda\u3002<\/font> <\/div>\n<\/li>\n<\/ol>\n<h4><strong><font color=\"#9b00d3\" size=\"5\">\u6b65\u9a5f7. \u7e6a\u88fd\u539f\u59cb\u8cc7\u6599\u7684\u5e38\u614b\u5206\u4f48\u8207\u76f4\u689d\u5716<\/font> <\/strong><\/h4>\n<ol><font size=\"3\"><\/p>\n<li>\n<div align=\"justify\"><font size=\"4\">\u63a5\u4e0b\u4f86\u53ef\u4ee5\u4f9d\u7167[\u6b65\u9a5f5]\u53ca[\u6b65\u9a5f6]\u7684\u65b9\u6cd5\u91cd\u65b0\u7e6a\u88fd\u65b0\u7684\u76f4\u689d\u5716\u8207\u5e38\u614b\u5206\u4f48\u5716\u3002 <\/font><\/div>\n<\/li>\n<li>\n<div align=\"justify\"><font size=\"4\">\u9019\u6b21\u7684\u8cc7\u6599\u4f86\u6e90\u8981\u9078\u53d6\u5de5\u4f5c\u8868\u4e0a\u7684 G2:H10 \u7bc4\u570d\u7684\u5132\u5b58\u683c\u3002(\u539f\u59cb\u8cc7\u6599\u7684\u5206\u4f48)\u3002 <\/font><\/div>\n<\/li>\n<li>\n<div align=\"justify\"><font size=\"4\">\u6700\u7d42\u7d50\u679c\u6703\u5982\u4e0b\u5716\u3002<\/font> <img loading=\"lazy\" decoding=\"async\" title=\"\u5982\u4f55\u4f7f\u7528Excel2007\u5efa\u7acb\u5e38\u614b\u5206\u4f48\u66f2\u7dda\u5716\u8868\" style=\"border-width: 0px; padding-top: 0px; padding-right: 0px; padding-left: 0px; display: inline; background-image: none;\" border=\"0\" alt=\"\u5982\u4f55\u4f7f\u7528Excel2007\u5efa\u7acb\u5e38\u614b\u5206\u4f48\u66f2\u7dda\u5716\u8868\" src=\"\/\/m.letratesoro.com\/wp-content\/uploads\/images\/9b0723dd43c2_CEEC\/Excel22.png\" width=\"437\" height=\"378\" \/> <\/div>\n<\/li>\n<p>  <\/font><\/p>\n<p><font size=\"3\"><\/font><\/p>\n<\/ol>\n<p align=\"justify\"><font size=\"4\">\u9019\u88e1\u6211\u628a\u5169\u7d44\u5716\u8868\u653e\u5728\u9019\u88e1\u7576\u6bd4\u8f03\uff0c\u6709\u6c92\u6709\u767c\u73fe\u4f7f\u7528\u3010\u4e82\u6578\u3011\u6240\u505a\u51fa\u4f86\u7684\u5716\u8868\u6bd4\u8f03\u63a5\u8fd1\u5e38\u614b\u5206\u4f48\uff0c\u800c\u4f7f\u7528\u539f\u59cb\u8cc7\u6599\u4f5c\u51fa\u4f86\u7684\u5716\u8868\u9019\u5448\u73fe\u51fa\u96d9\u5cf0\u7684\u7d50\u679c\uff0c\u9019\u662f\u56e0\u70ba\u539f\u59cb\u8cc7\u6599\u7684\u6578\u91cf\u4e0d\u5920\u591a\u6240\u81f3\uff0c\u53ea\u6709\u516b\u7d44\u8cc7\u6599\uff0c\u6240\u4ee5\u624d\u6703\u6709\u5931\u771f\u7684\u60c5\u5f62\uff0c\u4e00\u822c\u5efa\u8b70\u7d71\u8a08\u7684\u8cc7\u6599\u6700\u5c11\u8981\u670925\u621630\u7d44\u4ee5\u4e0a\u624d\u80fd\u7a0d\u5fae\u8868\u73fe\u51fa\u4ee3\u8868\u6027\u3002<\/font><\/p>\n<hr \/>\n<h4><font color=\"#ff0000\" size=\"4\"><strong>Excel\u5e38\u614b\u5206\u4f48\u7684\u6ce8\u610f\u4e8b\u9805\uff1a<\/strong><\/font><\/h4>\n<ul>\n<li>\n<div align=\"justify\"><font size=\"4\">\u4f7f\u7528\u4e82\u6578\u7522\u751f2000\u7b46\u5e38\u614b\u5206\u4f48\u7684\u76ee\u7684\u662f\u70ba\u4e86\u8b93\u5e38\u614b\u5206\u4f48\u66f2\u7dda\u5283\u51fa\u4f86\u66f4\u6f02\u4eae\uff0c\u4f46\u662f\u9019\u6a23\u5b50\u4e5f\u53ef\u80fd\u626d\u66f2\u4e86\u539f\u4f86\u7684\u6578\u64da\uff0c\u56e0\u70ba\u9019\u88e1\u6211\u5011\u5047\u8a2d\u6578\u64da\u4e00\u5b9a\u662f\u5e38\u614b\u5206\u4f48\uff0c\u6240\u4ee5\u5176\u7d50\u679c\u5c31\u662f\u5e38\u614b\u5206\u4f48\u3002 <\/font><\/div>\n<\/li>\n<li>\n<div align=\"justify\"><font size=\"4\">\u5982\u679c\u6578\u64da\u5c6c\u65bc\u55ae\u908a\u898f\u683c\uff0c\u500b\u4eba\u4e0d\u5efa\u8b70\u4f7f\u7528\u9019\u500b\u4e82\u6578\u4f86\u7522\u751f\u6578\u64da\uff0c\u56e0\u70ba\u5176\u7d50\u679c\u6703\u5f37\u8feb\u8d85\u51fa\u55ae\u908a\u898f\u683c\uff0c\u9020\u6210\u8aa4\u5224\u3002\u6bd4\u5982\u8aaa\u9215\u6263\u96fb\u6c60\u7684\u96fb\u58d3\uff0c\u4e0b\u9762\u5de6\u5716\u7684\u66f2\u7dda\u4f86\u81ea\u539f\u59cb\u7684\u6578\u64da\uff08\u534a\u908a\u7684\u5e38\u614b\u5206\u4f48\u66f2\u7dda\uff09\uff0c\u53f3\u5716\u5247\u4f86\u81ea\u4e82\u6578\u7522\u751f\u7684\u66f2\u7dda\uff0c\u4e00\u822c\u4f86\u8aaa\u9215\u6263\u96fb\u6c60\u7684\u898f\u683c\u4e0a\u754c\u53ea\u67093.0V\uff0c\u4f46\u4f7f\u7528\u4e86\u5e38\u614b\u5206\u4f48\u4e82\u6578\u7684\u7d50\u679c\u5c31\u6703\u6709\u8d85\u51fa3.0V\u7684\u60c5\u5f62\u51fa\u73fe\uff0c\u9019\u6a23\u5c31\u8b8a\u6210\u7570\u5e38\u4e86\u3002<\/font><img loading=\"lazy\" decoding=\"async\" title=\"\u932f\u8aa4\u7684\u5e38\u614b\u5206\u4f48\u66f2\u7dda\" style=\"border-width: 0px; padding-top: 0px; padding-right: 0px; padding-left: 0px; display: inline; background-image: none;\" border=\"0\" alt=\"\u932f\u8aa4\u7684\u5e38\u614b\u5206\u4f48\u66f2\u7dda\" src=\"\/\/m.letratesoro.com\/wp-content\/uploads\/images\/9b0723dd43c2_CEEC\/c67bbd4838a1.png\" width=\"540\" height=\"162\" \/> <\/div>\n<\/li>\n<li>\n<div align=\"justify\"><font size=\"4\">\u5982\u679c\u6578\u5177\u5df2\u7d93\u8d85\u904e\u4e8625\u500b\u4ee5\u4e0a\uff0c\u500b\u4eba\u5f37\u70c8\u5efa\u8b70\u4f7f\u7528\u539f\u4f86\u7684\u6578\u64da\u4f86\u5283\u5206\u4f48\u5716\u5c31\u53ef\u4ee5\u4e86\uff0c\u901a\u5e3825\u500b\u4ee5\u4e0a(\u6709\u4eba\u5efa\u8b7030\u500b)\u7684\u6a23\u54c1\u6578\u64da\u5c31\u53ef\u4ee5\u521d\u6b65\u4ee3\u8868\u6bcd\u9ad4\u3002<\/font> <\/div>\n<\/li>\n<\/ul>\n<hr \/>\n<p><font size=\"4\">\u5ef6\u4f38\u95b1\u8b80\uff1a <\/font><\/p>\n<ul>\n<li><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><\/li>\n<li><a href=\"\/\/m.letratesoro.com\/2011\/07\/six-sigma-i\"><font size=\"4\">\u516d\u500b\u6a19\u6e96\u5dee\u4e4b\u6211\u898b(six sigma)<\/font><\/a><\/li>\n<li><a href=\"\/\/m.letratesoro.com\/2011\/07\/six-sigma-ii\"><font size=\"4\">\u516d\u500b\u6a19\u6e96\u5dee\u7684\u5be6\u4f8b\u63a2\u8a0e(six sigma)<\/font><\/a><\/li>\n<li><a href=\"\/\/m.letratesoro.com\/2011\/07\/six-sigma-iii\"><font size=\"4\">\u5982\u4f55\u9054\u6210\u516d\u500b\u6a19\u6e96\u5dee(six sigma)<\/font><\/a><\/li>\n<\/ul>\n<p><font size=\"4\">\u95dc\u65bc\u7d71\u8a08\u88fd\u7a0bSPC\uff1a<\/font><\/p>\n<ul>\n<li><a href=\"\/\/m.letratesoro.com\/2010\/10\/spc-introduction-ck-cp-cpk\/\"><font size=\"4\">\u88fd\u7a0b\u80fd\u529b\u4ecb\u7d39\u2500\u88fd\u7a0b\u80fd\u529b\u7684\u4e09\u7a2e\u8868\u793a\u6cd5<\/font><\/a><\/li>\n<li><a href=\"\/\/m.letratesoro.com\/2010\/10\/spc-introduction-cp\/\"><font size=\"4\">\u88fd\u7a0b\u80fd\u529b\u4ecb\u7d39 \u2500 Cp\u4e4b\u88fd\u7a0b\u80fd\u529b\u89e3\u91cb<\/font><\/a><\/li>\n<li><a href=\"\/\/m.letratesoro.com\/2010\/10\/spc-introduction-ck\/\"><font size=\"4\">\u88fd\u7a0b\u80fd\u529b\u4ecb\u7d39 \u2500 Ck\u4e4b\u88fd\u7a0b\u80fd\u529b\u89e3\u91cb<\/font><\/a><\/li>\n<li><font size=\"4\"><a href=\"\/\/m.letratesoro.com\/2010\/10\/spc-introduction-cpk\/\">\u88fd\u7a0b\u80fd\u529b\u4ecb\u7d39 \u2500 Cpk\u4e4b\u88fd\u7a0b\u80fd\u529b\u89e3\u91cb<\/a><\/font><\/li>\n<li><font size=\"4\"><a href=\"\/\/m.letratesoro.com\/2010\/10\/process-evaluation\/\">\u88fd\u7a0b\u80fd\u529b\u4ecb\u7d39 \u2500 \u88fd\u7a0b\u80fd\u529b\u7684\u8a55\u4f30\u8207\u6539\u5584\u5c0d\u7b56<\/a><\/font> <\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u300c\u5e38\u614b\u5206\u4f48\u66f2\u7dda(normal distribut &#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],"tags":[147,148],"aioseo_notices":[],"views":160567,"_links":{"self":[{"href":"\/\/m.letratesoro.com\/wp-json\/wp\/v2\/posts\/2960"}],"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=2960"}],"version-history":[{"count":25,"href":"\/\/m.letratesoro.com\/wp-json\/wp\/v2\/posts\/2960\/revisions"}],"predecessor-version":[{"id":10740,"href":"\/\/m.letratesoro.com\/wp-json\/wp\/v2\/posts\/2960\/revisions\/10740"}],"wp:attachment":[{"href":"\/\/m.letratesoro.com\/wp-json\/wp\/v2\/media?parent=2960"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"\/\/m.letratesoro.com\/wp-json\/wp\/v2\/categories?post=2960"},{"taxonomy":"post_tag","embeddable":true,"href":"\/\/m.letratesoro.com\/wp-json\/wp\/v2\/tags?post=2960"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}