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 statistical charts, box, kernel density and normal quantile plot that are automated versions […]
When comparison of two sets of data is made, often only the mean and standard deviation is compared, with no reference to the actual spread of the values. This tends to manifest in the form of a bar chart showing the mean of each variable with an error bar attached that extends 1 standard deviation […]
Last week a preview of version 0.98 of R Studio was released, with lots of new features, including some useful debugging tools. Also part of the release was a new option for creating presentations, which looks like it will be very useful.
When explaining about the Excel automation work we do at Sharp Statistics often the initial response is ‘so you write VBA macros’. In fact we don’t use Visual Basic for Applications (VBA) macros to build our solutions but instead use something called Visual Studio Tools for Office (VSTO).
Building any large application always involves a considerable amount of planning and thought to how the infrastructure of the software is going to be implemented. Decisions on the number of windows and views as well as how all the components communicate can take considerable effort to design and implement. On top of this changes in […]