View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Meadow Meadow is offline
external usenet poster
 
Posts: 7
Default HOW TO CREATE a BOXPLOT of DECILES?

Hullo all - after a bit of searching, I can't find any easy explanation of
how to do this - I'd like to create a boxplot from one column of Excel data,
where each box represents one decile (across the X-axis), and the Y-axis
represents the value of the data field. Each box should cover 1 SD on either
side of the mean value for that decile, and ideally also show the outlying
min and max values in that decile.

I hope Excel does boxplots - but I cant even find out how to do a simple
barchart of deciles - even that is a start!
Thanx for any help!