blog:boxplots_using_excel
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
blog:boxplots_using_excel [2009-11-10 08:06] – created brb | blog:boxplots_using_excel [2009-11-10 08:07] (current) – brb | ||
---|---|---|---|
Line 2: | Line 2: | ||
Statistical boxplots can be made by hand, by calculating median, max, min, etc. and formatting a diagram with it. This is _tedious_ but possible. I found this solution (see Source), which works very nicely. It consists of two simple components: | Statistical boxplots can be made by hand, by calculating median, max, min, etc. and formatting a diagram with it. This is _tedious_ but possible. I found this solution (see Source), which works very nicely. It consists of two simple components: | ||
* Custom diagram type for boxplots | * Custom diagram type for boxplots | ||
- | * A helper function fill in the values needed for the boxplot | + | * A helper function |
How to install: | How to install: | ||
Line 8: | Line 8: | ||
- Add it as a user defined diagram type | - Add it as a user defined diagram type | ||
- Select the box plot diagram | - Select the box plot diagram | ||
- | - Right-click on it an choose " | + | - Right-click on it and choose " |
- Select "User defined" | - Select "User defined" | ||
- " | - " |
blog/boxplots_using_excel.1257836776.txt.gz · Last modified: 2009-11-10 08:06 by brb