box plot.xls

Group 1 Group 2 Group 3 Group 4Summary Range1,6642,6461,000657Group 1Group 2Group 3Group 41,0842,4651,1504,312Minimum:1443021,0005971,7809121,3004,75625th Percentile:1084553190014741442,3191,4503,370Median:1,7801,6452,8002,7579215531,6001,57575th Percentile:21012349370035252,4022,3491,7501,474Maximum:2,4582,6464,6004,7562,2532,5751,9004,3122,4585462,0503,395Chart Data1,0314442,2001,363Group 1Group 2Group 3Group 42,1012,5522,3502,670Series 11443021,0005971,3121,4722,500597Series 29402519008772,4222,5302,6503,822Series 36961,0929001,2831,3761,3172,8003,340Series 43217049007686672,3472,9502,757Series 53572979001,2316522,0513,1006511,3801,6453,2502,2441,9615453,4002,0411,7942,2433,5506562,0223853,7003,6442,0594323,8503,0405442,2654,0003,6562,2543024,1503,5252,1152,4334,3003,0231,9431,5014,4501,3061,0911,4084,6001,559Box PlotGroup 1Group 2Group 3Group 405001,0001,5002,0002,5003,0003,5004,0004,5005,000Box PlotGroup 1Group 2Group 3Group 45,0004,0003,0002,0001,0000Box PlotGroup 1Group 2Group 3Group 405001,0001,5002,0002,5003,0003,5004,0004,5005,000Group 1Group 2Group 3Group 4Group 1Group 21,6642,6461,00065725th Percentile1,0845531,0842,4651,1504,312Minimum1443021,7809121,3004,75650th Percentile1,7801,6451442,3191,4503,370Maximum2,4582,6469215531,6001,57575th Percentile2,1012,3492,4022,3491,7501,4742,2532,5751,9004,3122,4585462,0503,3951,0314442,2001,3632,1012,5522,3502,6701,3121,4722,5005972,4222,5302,6503,8221,3761,3172,8003,3406672,3472,9502,7576522,0513,1006511,3801,6453,2502,2441,9615453,4002,0411,7942,2433,5506562,0223853,7003,6442,0594323,8503,0405442,2654,0003,6562,2543024,1503,5252,1152,4334,3003,0231,9431,5014,4501,3061,0911,4084,6001,559Box PlotGroup 1Group 2Group 3Group 405001,0001,5002,0002,5003,0003,5004,0004,5005,000Group 3Group 41,9001,4741,0005972,8002,7574,6004,7563,7003,5251.Select the range F1:J6 and use the Chart Wizard to create a line chartwith markers.2.In Step 2 of the Chart Wizard,select the Rows option.Click Finish tocreate the chart.3.Select the Maximum series and access its Format Data Series dialogbox.In the Patterns tab,set the Line option to None.Set the Marker styleto a horizontal bar(about 12 points in size).Select the Options tab andplace a check mark next to High-low lines and Up/down bars.Adjust thecolors if desired.4.Remove the lines from the other series,and adjust the markers andcolors as desired.5.To avoid confusion,youll probably want to remove the legendbecause the order of the series does not correspond to the order of theitems in the chart.6 To make the Up/down bars thinner,select any series and access itsFormat Data Series dialog box.Select the Options tab and increase theGap width setting.Box PlotGroup 1Group 2Group 3Group 405001,0001,5002,0002,5003,0003,5004,0004,5005,0001.Select the range F1:J6 and use the Chart Wizard to create a line chartwith markers.2.In Step 2 of the Chart Wizard,select the Rows option.Click Finish tocreate the chart.3.Select the Maximum series and access its Format Data Series dialogbox.In the Patterns tab,set the Line option to None.Set the Marker styleto a horizontal bar(about 12 points in size).Select the Options tab andplace a check mark next to High-low lines and Up/down bars.Adjust thecolors if desired.4.Remove the lines from the other series,and adjust the markers andcolors as desired.5.To avoid confusion,youll probably want to remove the legendbecause the order of the series does not correspond to the order of theitems in the chart.6 To make the Up/down bars thinner,select any series and access itsFormat Data Series dialog box.Select the Options tab and increase theGap width setting.