Version 1.2 of EasyER has now been released. The main change is the addition of a chart builder interface for interactively creating charts. The chart builder plugs into the popular ggplot2 package allowing ggplot2 charts in Excel. Some bugs have also ...
As an illustration of how Sharp-R can be used for Excel statistics this post is part 1 in a series that show how various analysis methods defined in R code can be easily applied to Excel data. We have now posted the second article which deals with time...
A recent post on R Bloggers, linked to an article on DataScience+ that details how to use R to plot error bars on bar charts to indicate the variability in a particular variable. There are many other articles that detail this type of chart, sometimes ...
From Data to Insight Where there are data, there is insight. However, insight needs know how – know how about …Continue reading →
Adding complex algorithms into Excel is one thing but the user needs to be able to control the algorithm settings. One way is to implement a Custom Task Pane, which adds a movable panel to the Excel interface that can be modified with any standard Wind...
As an illustration of how Sharp Statistics can integrate extra analysis tools into Excel there is now a demonstration Excel Add In that can be download and installed to produce some useful statistical plots of your data. It can produce 3 simple statist...
I was looking at a report the other day that was comparing the number of sub groups in several sets of data. The author had decided that the best way to show the quantity of each sub group was using a pie chart. All well and good but as there were 12 d...
I’ve just put up an updated version of my Excel 2007 add in CSAddIn that allows the production of some simple statistical plots in Excel including Box plots. In this version, 1.7 I’ve fixed a couple of errors when text … Continue read...
Here is part 2 of my guide to using ggplot2. Scales Following on directly from the previous notes you can manually adjust the colours and shapes used in the chart if you don’t like the defaults, as shown in figure 1. … Continue reading ...
