Browsing the archives for the Excel category
When facing chemical equilibrium problems of the type
it is often useful to construct logarithmic concentration versus pH diagrams to illustrate how the concentrations of the ions are dependant of the pH-value.
The theory behind the diagram is not too complicated and the construction is straightforward. However, generating nice looking diagrams can be time-consuming and tedious and [...]
Popularity: 3% [?]
After many requests I decided to make available a simple template for creating nice-looking histograms in Excel. I this downloadable file the user can easily paste his/her own data and instantly get a nicely formatted histogram, with correctly calculated bins (Scott’s choice).
No need to bother with complicated field formulas and tedious chart formatting – that [...]
Popularity: 3% [?]
Due to quite a few requests I have completed a template for Excel 2007 to quickly allow the user to create a nice looking box plot. The template can be downloaded and used right away, by simply pasting your values into the worksheet and everything else will be done for you.
Only edit cells with green [...]
Popularity: 3% [?]
Keywords: Excel, boxplot, box plot, stem and leaf plot, box and whiskers plot, negative values
Dowload:
Since my previous articles on boxplots in Excel, Improved advanced box-plot and whiskers chart in Excel and Box plot for Excel 2007, I have recieved a lot of questions on how to do boxplotswith negative values using Excel, since it [...]
Popularity: 10% [?]
Weather from Google™