This all works nicely but again it would be useful if the StatPlus:mac dialog box included options to include labels for the axes etc. The advanced options in the StatPlus:mac dialog box allow you to add a histogram and a normal curve. Also if you have multiple worksheets it might not be easy to work out which analysis refers to which data set, it would be nice if there was an option in the StatPlus:mac dialog box to add your own title to the worksheet, or at least include it in the default lable "Descriptive Statistics (Data1)".
If you look closely at the image a couple of points appear, it would be nice if the labels on the worksheet "Series #1 (Var1)" actually included the label from the datatable "Control". A new worksheet is created that contains the statitical analysis.Īs you can see in the image below, the analysis includes a variety of statistical information. You then switch to Excel select the relevant data and then switch back to StatPlus:mac and press OK. You will be provided with a dialog box asking you to select the data range in the Excel workbook, pleasingly this includes the option for the first row of the spreadsheet to be column labels. From within StatPlus:mac select "Statisctic:Basic Statistics and Tables:Decripttive Statistics" from the menu bar. It also means that if you don't have a workbook open everytime you switch to StatPlus:mac it opens a new blank workbook which you need to close after replying to the excel dialog box asking if you want to save it, slightly annoying.Ī very Simple ExampleThis is one of the provided examples, two columns of data that you want to compare. This is fine but since you probably have a workbook with data it would be nice to have the option to choose the workbook to open. After starting StatPlus:mac one of the menu options is "Launch Microsoft Excel", this opens a blank workbook. At first the need to switch between applications seems rather clunky but after a while using "Apple+tab" becomes second nature. There is no added set of menu items in Excel, instead you need to switch between an open Excel workbook and StatPlus:mac. Actually it is a great demonstration of what is possible with Applescript. StatPlus:mac is not a plugin for Excel but is an indepedent application that can work on Excel files, it is written in AppleScript + optimized for Intel or PPC math core, with all interactions written in AppleScript. The Help system is excellent and gives detailed information.
STATPLUS HISTOGRAM SERIES
Download and installation works smoothly and the application comes with a series of simple tutorials, in html format, and example files. For this review I'm using a Dual 2.5 Ghz PPC G5 and Microsoft Excel 2004. StatPlus:mac is available for both PPC and Intel machines and works with Microsoft Excel 20. Use different methods from contingency tables analysis to rank correlations, Probit and Latin squares, Kruskal-Wallis ANOVA and Cochran Q test, without compromising ease of use. Adding the ability to perform complex calculations and analysis tasks such as normality tests, Pagurova Criterion, correlation coefficients, GLM ANOVA and non-parametric statistical analysis. This is where AnalystSoft hope to take advantage, StatPlus:mac is claimed to turn your copy of excel into a powerful statistical tool.
STATPLUS HISTOGRAM MAC
There are a large number of data analysis tools available on the Mac platform but many are expensive and/or not particularly user friendly. Whilst these limitations may not be an issue for financial or accountancy uses they are a significant obstacle towards scientific use. Whilst Excel has been around on the Mac platform since 1985 and is probably the leading spreadsheet application, the data analysis capabilities and statistical analysis is still rather limited.
0 kommentar(er)
