1508
Comment:

1760

Deletions are marked like this.  Additions are marked like this. 
Line 3:  Line 3: 
You can't produce boxplots directly in EXCEL but there is a rather convoluted work around described [http://support.microsoft.com/kb/155130 here.] I also reproduce Microsoft's solution below.  You can't produce boxplots directly in EXCEL but there is a rather convoluted work around described [http://support.microsoft.com/kb/155130 here.] I also reproduce Microsoft's solution below form some example data. 
Line 7:  Line 7: 
A1: Statistic B1: a C1: b D1: c A2: median B2: 40 C2: 45 D2: 50 A3: q1 B3: 20 C3: 22 D3: 30 A4: min B4: 10 C4: 15 D4: 18 A5: max B5: 100 C5: 110 D5: 90 A6: q3 B6: 70 C6: 75 D6: 57 
<style="TEXTALIGN: center"> A1: Statistic  B1: a  C1: b  D1: c  <style="TEXTALIGN: center"> A2: median  B2: 40  C2: 45  D2: 50  <style="TEXTALIGN: center"> A3: q1  B3: 20  C3: 22  D3: 30  <style="TEXTALIGN: center"> A4: min  B4: 10  C4: 15  D4: 18  <style="TEXTALIGN: center"> A5: max  B5: 100  C5: 110  D5: 90  <style="TEXTALIGN: center"> A6: q3  B6: 70  C6: 75  D6: 57  
Describe FAQ/ExcelErrorBarPlot here.
You can't produce boxplots directly in EXCEL but there is a rather convoluted work around described [http://support.microsoft.com/kb/155130 here.] I also reproduce Microsoft's solution below form some example data.
1. In a new worksheet, type the following data:
A1: Statistic 
B1: a 
C1: b 
D1: c 

A2: median 
B2: 40 
C2: 45 
D2: 50 

A3: q1 
B3: 20 
C3: 22 
D3: 30 

A4: min 
B4: 10 
C4: 15 
D4: 18 

A5: max 
B5: 100 
C5: 110 
D5: 90 

A6: q3 
B6: 70 
C6: 75 
D6: 57 
2. Select cells A1:D6. On the Insert menu, click Chart.
3. On the Standard types tab, click Stock under Chart type, and then click the fourth chart subtype.
The following explanation appears below the chart subtype: VolumeOpenHighLowClose. Requires five series of values in this order.
4. Click Next.
5. On the Data Range tab, click Rows under Series in, and then click Next.
6. On the Legend tab, click to clear the Show legend check box.
7. On the Axes tab, click to clear the Value (Y) Axis check box under Secondary axis, and then click Finish.
8. Click once on any one of the colored columns to select the series. Do not click one of the white columns.
9. On the Chart menu, click Chart Type. Under Chart type, click Line, and then click OK.
A line that connects the three white columns appears in the chart.
10. Click once on the line, and then click Selected Data Series on the Format menu.