Sharp-R Data Update

Our free Excel Add In Sharp-R Data that connects Excel to a R workspace for easy data transfer has just been updated. The update has added the options to be able to send data from multiple excel sheets and workbooks. Now you can open a single file and select a […]

Ggplot bar chart and boxplot

Bar Charts, Error Bars and R

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 referred to as “dynamite plots” which […]

Excel R Add In

The statistical programming environment R is a fantastic tool for data analysis and has a huge range of add on packages that enable just about any statistical method to be implemented quickly. R is essentially a programming tool so is driven by typing in commands and running script files. This […]


Linear Regression and Matrix Operations in Excel

Linear regression is a very frequently required method and is implemented in many software packages using matrix calculations. Excel performs regression either directly through worksheet functions or on scatter plots, but it doesn’t allow the user to see the inner workings of how the calculations are made. Regression Overview Linear […]

The hat matrix


Excel Chart Demo

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 […]

Wily data analysis

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 […]

Box plot with outlier in group B

R Presentation

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.

More than macros

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) which we […]

Editing the Excel ribbon

Netbeans look up makes updating easy

Data analysis on the NetBeans Platform 3

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 […]