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 works well for developing analysis […]
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 Windows control so allowing any type of interface to be […]
I have for sometime used the statistical package R for the majority of data analysis tasks. Typically though data is sent as an Excel file, which is straight froward to import into R but often I want to have a quick look at the data to get a feel for what might be going on. […]
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 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).