$$Excel-Macros$$ Re: Boxplots in Excel 2010

2013-01-10 Thread Adrian Teodorescu
Forgot to say: You need to select at least one column with at least 5 rows, excluding the title row (which also needs to be selected) On Thursday, January 10, 2013 12:57:01 PM UTC+1, Adrian Teodorescu wrote: > > This is a rudimentary (and not thoroughly checked) graphical > represen

$$Excel-Macros$$ Boxplots in Excel 2010

2013-01-10 Thread Adrian Teodorescu
This is a rudimentary (and not thoroughly checked) graphical representation of data as a boxplot. It does not check the outliers using Grubb's test however shows outliers that are farther than 1.5 IQR. Looking for ideas on improving it. Copy and paste the code into a new module and run the macr

$$Excel-Macros$$ Roman to Arabic

2013-01-10 Thread Adrian Teodorescu
This is a rather rudimentary conversion of Roman numerals into Arabic (inverse of ROMAN function in Excel 2010) Just copy the code and paste it into a new module. then in excel cell, type = Arabic("xxx") where xxx is the Roman numeral (e.g. MMDX) -- Join official Facebook page of this forum @