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.
#REGRESSION FOR EXCEL MAC 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.
#REGRESSION FOR EXCEL MAC 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)
