blog:boxplots_using_excel
| 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