No guarantees these will work, but they are offered here for your reference!
Generally, the tips are for Excel 2007, but they should work similarly for
other versions.
Links
Boxplots
Some add-ons (e.g., PHStat, which supposedly comes with the textbook) will have boxplots.
Here is a trick by
BloggPro
using barcharts; for examples, see
02-SportsShoes:
- Calculate the median, Q1, and Q3.
- Calculate and put in three cells next to each other: Q1, Median-Q1, and Q3-Median.
- Calculate 1.5*IQR.
- Insert → Bar → Stacked (you could also use Column if you like)
- Select Data: select the three cells with Q1, Median-Q1, and Q3-Median.
- Select the first bar (usually blue):
- Chart Tools → Layout → Error Bars → More Error Bars Options...
- Under "Direction", select "Minus"
- Under "Error Amount", select "Custom..." and "Specify Value", select the cell with 1.5*IQR.
- Close the Format Error Bars dialog.
- Select the last bar (usually green):
- Chart Tools → Layout → Error Bars → More Error Bars Options...
- Under "Direction", select "Plus"
- Under "Error Amount", select "Custom..." and "Specify Value", select the cell with 1.5*IQR.
- Close the Format Error Bars dialog.
- Select the first bar (usually blue):
- Chart Tools → Format → Fill
- Select No Fill (this turns it invisible)