CopyofX-BAR&~1

X-barandRChartInstructionsInstructions:1.Thenextsheetisanexampleproblem.Itwascreatedfromthesheetcalledtemplate.Selectthecellsatthetopofthecolumnstoseetheformulas.2a.Thefollowingsheet,calledtemplate,shouldbecopiedbeforeusingtheprogram.ThisactivityisaccomplishedbyselectingEDIT,selectingMOVEORCOPYSHEET,selectingCREATEACOPY,andlocatingthenewsheetcalled,template(2),inthedialogbox.2b.Thetemplateisdesignedfortherecommendedminimumof25subgroups;however35arepossiblewithoutchangingtheformulas.Theprocedureistocopytheformulastotheadditionalsubgroups.Thenclickonthetemplatecharttogetthecharticon.SelectCHARTWIZARDandobtainstep1.Changetherangetoincludeadditionalrowsfortheappropriatecolumns.Thisactivityisaccomplishedbyeitherchangingtherangeinthedialogboxordraggingthemouseandusingthecontrolkey.2c.Thecontrollimitsandcentrallineareautomaticallycalculatedanddisplayedwiththeplottedpointsasdataareentered.2d.Thechartisdesignedforamaximumof35points.Ifmorearedesired,addadditionaloneswiththeappropriateformulas.2e.Itissometimesnecessarytoadjustthescalestohaveapleasingchartappearance.2f.Itisusuallynecessarytochangethedecimalpointfordifferentdata.2g.Whenspaceisavailableanditisdesired,thechartcanbelocatedonthesheetwiththedataandthenprintedfullsize.Page1of11X-barandRChartExampleProblemIDNumberSubgroupX1X2X3X4X-barUCL-X-barX-DbarLCL-X-barRUCL-RR-barLCL-R###########16.356.46.326.376.366.476.416.350.080.200.0876011:3026.466.376.366.416.46.476.416.350.10.200.0876013:4536.346.46.346.366.366.476.416.350.060.200.0876015:4546.696.646.686.596.656.476.416.350.10.200.0876016:2056.386.346.446.46.396.476.416.350.10.200.08760###########66.426.416.436.346.46.476.416.350.090.200.087609:0076.446.416.416.466.436.476.416.350.050.200.087609:4086.336.416.386.366.376.476.416.350.080.200.0876013:3096.486.446.476.456.466.476.416.350.040.200.0876014:50106.476.436.366.426.426.476.416.350.110.200.08760###########116.386.416.396.386.396.476.416.350.030.200.0876013:35126.376.376.416.376.386.476.416.350.040.200.0876014:25136.46.386.476.356.46.476.416.350.120.200.0876014:35146.386.396.456.426.416.476.416.350.070.200.0876015:55156.56.426.436.456.456.476.416.350.080.200.08760###########166.336.356.296.396.346.476.416.350.10.200.087609:25176.416.46.296.346.366.476.416.350.120.200.0876011:00186.386.446.286.586.426.476.416.350.30.200.0876014:35196.356.416.376.386.386.476.416.350.060.200.0876015:15206.566.556.456.486.516.476.416.350.110.200.08760###########216.386.46.456.376.46.476.416.350.080.200.0876010:20226.396.426.356.46.396.476.416.350.070.200.0876011:35236.426.396.396.366.396.476.416.350.060.200.0876014:00246.436.366.356.386.386.476.416.350.080.200.0876016:25256.396.386.436.446.416.476.416.350.060.200.0876026272829303132333435Sum160.252.19Page2of11X-barandRChartExampleProblem6.256.36.356.46.456.56.556.66.656.712345678910111213141516171819202122232425Average-mmSubgroupNumberX-barChartX-barUCL-X-barX-DbarLCL-X-bar00.050.10.150.20.250.30.3512345678910111213141516171819202122232425Range-mmSubgroupNumberR-ChartRUCL-RR-barLCL-RPage3of11X-barandRChartTemplaten=2IDNumberSubgroupX1X2X-barUCL-X-barX-DbarLCL-X-barRUCLRR-barLCLR1#DIV/0!#DIV/0!#DIV/0!#DIV/0!00002#DIV/0!#DIV/0!#DIV/0!#DIV/0!00003#DIV/0!#DIV/0!#DIV/0!#DIV/0!00004#DIV/0!#DIV/0!#DIV/0!#DIV/0!00005#DIV/0!#DIV/0!#DIV/0!#DIV/0!00006#DIV/0!#DIV/0!#DIV/0!#DIV/0!00007#DIV/0!#DIV/0!#DIV/0!#DIV/0!00008#DIV/0!#DIV/0!#DIV/0!#DIV/0!00009#DIV/0!#DIV/0!#DIV/0!#DIV/0!000010#DIV/0!#DIV/0!#DIV/0!#DIV/0!000011#DIV/0!#DIV/0!#DIV/0!#DIV/0!000012#DIV/0!#DIV/0!#DIV/0!#DIV/0!000013#DIV/0!#DIV/0!#DIV/0!#DIV/0!000014#DIV/0!#DIV/0!#DIV/0!#DIV/0!000015#DIV/0!#DIV/0!#DIV/0!#DIV/0!000016#DIV/0!#DIV/0!#DIV/0!#DIV/0!000017#DIV/0!#DIV/0!#DIV/0!#DIV/0!000018#DIV/0!#DIV/0!#DIV/0!#DIV/0!000019#DIV/0!#DIV/0!#DIV/0!#DIV/0!000020#DIV/0!#DIV/0!#DIV/0!#DIV/0!000021#DIV/0!#DIV/0!#DIV/0!#DIV/0!000022#DIV/0!#DIV/0!#DIV/0!#DIV/0!000023#DIV/0!#DIV/0!#DIV/0!#DIV/0!000024#DIV/0!#DIV/0!#DIV/0!#DIV/0!000025#DIV/0!#DIV/0!#DIV/0!#DIV/0!000026272829303132333435Sum#DIV/0!0Page4of11X-barandRChartTemplaten=200.10.20.30.40.50.60.70.80.9112345678910111213141516171819202122232425AverageSubgroupNumberX-barChartX-barUCL-X-barX-DbarLCL-X-bar00.10.20.30.40.50.60.70.80.9112345678910111213141516171819202122232425RangeSubgroupNumberR-ChartRUCLRR-barLCLRPage5of11X-barandRChartTemplaten=3IDNumberSubgroupX1X2X3X-barUCL-X-barX-DbarLCL-X-barRUCLRR-barLCLR1#DIV/0!#DIV/0!#DIV/0!#DIV/0!00002#DIV/0!#DIV/0!#DIV/0!#DIV/0!00003#DIV/0!#DIV/0!#DIV/0!#DIV/0!00004#DIV/0!#DIV/0!#DIV/0!#DIV/0!00005#DIV/0!#DIV/0!#DIV/0!#DIV/0!00006#DIV/0!#DIV/0!#DIV/0!#DIV/0!00007#DIV/0!#DIV/0!#DIV/0!#DIV/0!00008#DIV/0!#DIV/0!#DIV/0!#DIV/0!00009#DIV/0!#DIV/0!#DIV/0!#DIV/0!000010#DIV/0!#DIV/0!#DIV/0!#DIV/0!000011#DIV/0!#DIV/0!#DIV/0!#DIV/0!000012#DIV/0!#DIV/0!#DIV/0!#DIV/0!000013#DIV/0!#DIV/0!#DIV/0!#DIV/0!000014#DIV/0!#DIV/0!#DIV/0!#DIV/0!000015#DIV/0!#DIV/0!#DIV/0!#DIV/0!000016#DIV/0!#DIV/0!#DIV/0!#DIV/0!000017#DIV/0!#DIV/0!#DIV/0!#DIV/0!000018#DIV/0!#DIV/0!#DIV/0!#DIV/0!000019#DIV/0!#DIV/0!#DIV/0!#DIV/0!000020#DIV/