A popular add-on for helping Excel users creating optimization models has made its return to Excel 2008. Solver for Excel had been among the casualties of Microsoft’s decision to drop Visual Basic for Applications (VBA) from Microsoft Office 2008. The add-on was particularly useful for making calculations and creating optimization schemes that are dependent on the allocation of scarce resources. However, due to the popularity of Solver, Microsoft’s Mac Business Unit worked together with Frontline Systems, Solver’s original developers,. Microsoft announced and delivered the finished product at the start of the Labor Day weekend.
Because Excel 2008 lacks VBA support, Frontline has redeveloped Solver using AppleScript. As a result, Solver now runs as a separate application outside of Excel, rather than as an add-on inside of it. According to Frontline, this may affect the program’s performance, making it slower for some calculations, but faster for others. Models created in Solver for Excel 2004 should work in Solver for Excel 2008, provided they don’t rely on any VBA macros. The application, which weighs in at less than 2MB, is and runs on both PowerPC- and Intel-based Macs running Mac OS X 10.4.11 or 10.5.4 or later. It also requires Microsoft Excel 12.1.2 or later.
Free statistics software for Macintosh computers (Macs) Updated What about cryptographic signing and error messages when you try to install free software? And, you can eliminate all other ads from MacStats.org and we will instead carry banners advertising your own business. Free and promising general statistics software (in no particular order) PSPP: Promising clone of SPSS Current Version: 1.01 Listing updated Last known software update: November 4, 2017 (Mac version); August 14, 2018 (source/beta) with a. Like SPSS, PSPP is aimed at social scientists, business people, and students, with a convenient, easy to learn interface.
The problem I find is that not all of the features of Excel for Windows are in Excel 2016 for Mac. I am an unpaid volunteer and do not work for Microsoft. 'Independent Advisors' work for contractors hired by Microsoft. Office 2008 combines Microsoft Word for Mac, Microsoft PowerPoint for Mac, Microsoft Excel for Mac, Microsoft Entourage for Mac, and Microsoft Messenger for Mac and lets you easily create high-impact documents and seamlessly share your ideas with others, whether they are on the Mac or Windows platform.
The installation trouble makes me reluctantly suggest you look elsewhere, unless you run Linux. The interface is similar to SPSS, though there are some oddities from the Linux background (including, like SPSS itself, putting menus into the windows and not in the menubar). It imports SPSS data files, long variable names, and variable and value labels. PSPP is much faster than SPSS itself; common options are included in some dialogue boxes without the need to dig deeper, another improvement over the original. Development seemed to accelerate in the last year or two. On the down side, there are fewer tests and functions, as you’d expect.
Also, while you can copy from the output window, you have to copy whole groups at a time (from the left-hand list, not from the main pane), and the output window copies plain-text, delimited by spaces and pipes, just as SPSS 4 did. That’s not ideal for importing to spreadsheets or word processors, unless you’re really, really good at using BBEdit’s GREP and macro features. There’s also no way to clear anything from the output window; you have to use control keys instead of command keys; the “recent files” feature doesn’t work; an error message comes up when you quit. Don’t try to compile from source. However, the capabilities are impressive, including (but not limited to) graphing, data transformation, crosstabs, tables, various t-tests, ANOVA, regressions, factor analysis, ROC curves, and nonparametric tests. Jamovi is fairly fast, but doesn’t fully use the Mac interface (for example, its menus are kept within its own window instead of at the top of the screen; more annoyingly, the open/save dialogue box is very different, though it does show shortcuts for the documents, downloads, desktop, and home folders.) You can, however, drag and drop data files onto it — saving time. Developer Jonathon Love pointed us to the of extra procedures.
The program is almost 700 megabytes in size, due largely to the integrated software — R, Electron, Mantle, Python, and ReactiveCoca. We haven’t yet run it with our large sample dataset to compare results with other software, but since it’s based on R, it should be accurate and in line with other packages.
JASP: making R more accessible Current Version: 0.9x (requires OS 10.11+) Listing updated: 10/2018; program updated 10/2018 was created as “a low fat alternative to SPSS, a delicious alternative to R,” and comes out of the University of Amsterdam (presumably at lower cost than buying SPSS). JASP is not yet at version 1 and may be used with caution; it also requires the free XQuartz window environment. It does use the native open/save dialogue box, surprisingly; and it’s easy to install, unlike, say, PSPP. The software looks and feels like SPSS; though it isn’t native Mac software, it feels more native than some of SPSS’ past versions. Calculations and screen drawing are far, far, far faster than in “real SPSS” — when you select the tests, they might actually be pumped out before your finger is fully off the mouse.
We loaded our test file instantly — and ran descriptives instantly. Survey researchers will be happy to know they can assign value labels — and unhappy to know they must be done variable by variable, without syntax. The labels are retroactively applied to whatever is in the output window, very rapidly. Other free general statistics software SageMath 64-bit compatible Current Version: 8.4 Listing updated: 10-19-18 Size: 3.5 GB (yes, GB) is not specifically for statistics; it’s general math software, but it has the ability to do numerous statistical processes, since it’s actually built on top of command-line statistics-program R, as well as plotting libraries and general math libraries. It can be used for just about any type of math, and can be used either with the command line or or from a web browser. You can install it onto a server if you want, and create embedded graphics, typset-style math expressions, and more; it also includes sharing. The program was designed for both education and research.
It is not a typical Mac program; it has a command line element and is accessed from browsers. MacAnova Configurations Available: Intel processors (10.6+) Current Version: 5.06/5 Signed but not 64-bit Listing updated: 10-18-18 is a free, noncommercial, interactive statistical analysis program developed by Gary Oehlert and Christopher Bingham of the University of Minnesota School of Statistics. Their web site notes: MacAnova has many capabilities but its strengths are analysis of variance and related models, matrix algebra, time series analysis (time and frequency domain), and (to a lesser extent) uni- and multi-variate exploratory statistics. MacAnova has a functional/command oriented interface. The Macintosh and Windows versions also have several window/menu/mouse type features. Although the language and syntax are S-like, MacAnova is not S or R. There are now numerous front ends for R, several of which are mentioned earlier on this page.
R has a massive range of tests, PDF and PostScript output, a function to expand zip archives, and numerous other unexpected features. For much more information about R, including advantages, drawbacks, resources, and tips, see our incredibly outdated page. R Studio Current Version: 1.1x Listing updated: 4/2018; program updated 3/2018 Signed by Apple R Studio is commercial open-source software, designed for creating and managing R applications rather than, say, doing exploratory research or testing the odd hypothesis.
With frills, it can get expensive, but without frills, it’s free. The Mac version seems to be developed at the same time as Linux and Windows versions. It’s a bit of a porker (500MB plus R itself at around 130MB) and requires a separate R download; R itself is updated regularly and has a signed Mac package. When you first load R Studio, it tells you to go back and install R.
Once you've done that and restarted, it finds R easily enough, and presents you with an integrated development environment (IDE). If you try to do something, such as importing SPSS data, that isn’t possible without further downloads, it automatically connects to the Internet and installs whatever you need. The user interface is Mac-standard in most ways — you get a menu at the top of the screen (as well as menus in the window itself), and the open/save dialogues are thankfully quite normal. Though you can manage your R installation from R Studio, it’s a tool for dealing directly with syntax, and for managing projects; it’s not a beginner’s tool (as, say, Jamovi can be).
R Studio never claims to be anything but an IDE, with many options and good operating-system integration. Specialty tools G.Power Current Version: 3.193 / requires OS 10.7-10.13 Older versions: 680x0; PowerPC; OS X (Universal Binary); Windows and DOS Listing updated: 11/2018 (program updated July 17, 2017) Signed, 64-bit; no mention of Mojave was developed by Axel Buchner to provide power analyses for the most common statistical tests in behavioral research: t-tests, F-tests (including ANOVA, regression, etc.), and Chi-squared tests.
G.Power computes power values for sample sizes, effect sizes, and alpha levels; sample sizes for given effect sizes, alpha levels, and power values; and alpha and beta values for given sample sizes, effect sizes, and beta/alpha ratios. It is a remarkably small program, just over 2 MB in size. Updates (for both Mac and Windows) are slow, with nothing but bug-fixes since March 10, 2014. Version 3.1 itself dates back to 2009, though there were numerous improvements from 2009 to 2014. Gretl gretl can do general statistical routines and many specialized ones; it is in our “” page.
GMT - The Generic Mapping Tools Current version: 5.43 Program updated: 1-1-18 Listing updated: 4-25-18 A collection of command-line tools that run on all Unix-like systems, including Mac OS X. See for details. Many of the main developers (including me) use Mac OS X.
(Description by Paul Wessel) Graphviz Configurations: PPC (older versions), 10.5+ (current) Current Version: 2.20.3 Listing updated: 7-7-13 Graphviz is the AT&T open source drawing package. The and the have their own web sites.
The OS X version now uses the Aqua user interface. Prepare for a steep learning curve but it may be worth it if you have graphs you do frequently; not what I'd suggest for the occasional one-off though. Gnuplot Configurations: PPC (older versions), Intel (current) Current Version: 4.6.3 Listing updated: 7-7-13 Program updated: 4-18-13 is open source scientific plotting software.
It is available online from many sources OpenEpi Current Version: 2.2.1 Last update: 4-6-2013 Listing updated: 4-24-2018 is available in four languages; unlike most software, it can be run from a web server or on a regular computer. The programs are written in Javascript and html and should be compatible with Macs and Linux and Windows machines. Test results are provided for each module to allow people to check reliability of their own setup. The software is set up for epidemiology and has numerous key statistics for that field, along with the usual means, medians, t-tests, ANOVAs, powers, etc.
StatCrunch is a freely available for web-based use, currently without advertisements, with a $5 per user fee for use on your own server, or $5/six months. It has the usual range of basic statistics, from t-tests to regression to ANOVA and nonparametric tests, with a wide range of graphs also available, and works from Excel or text files. StatCrunch will also store your data within reason.
For those with low budgets or infrequent needs, StatCrunch's fairly easy to use interface and price are extremely attractive (it also makes sharing data easy). Libraries Matplotlib Free - open source - for Mac OS X Current version: 1.2.1 Report updated: 7/2013 is a pure python plotting library with the goal of making publication quality plots using a syntax familiar to matlab users. The library uses Numeric for handling large data sets and supports a variety of output backend. On August 28 2012, John D. Hunter, the creator of matplotlib, died from complications arising from cancer treatment, after a brief but intense battle with this terrible illness. Please consider making a donation to the SciPy is a library of scientific tools for Python which supplements the Numeric module.
SciPy includes modules for graphics and plotting, optimization, integration, special functions, signal and image processing, genetic algorithms, ODE solvers, and others. VTK (Visualization Toolkit) May be compiled from source code for OS X, Linux, etc Latest version: 7.1 Listing updated 1/2017 The is a system for 3D computer graphics, image processing, and visualization with several interface layers. In VTK applications can be written directly in C, Tcl, Java, or Python. “VTK supports a wide variety of visualization algorithms including scalar, vector, tensor, texture, and volumetric methods; and advanced modeling techniques like implicit modelling, polygon reduction, mesh smoothing, cutting, contouring, and Delaunay triangulation. Moreover, we have directly integrated dozens of imaging algorithms into the system so you can mix 2D imaging / 3D graphics algorithms and data.” Also see:.
(including packages that do statistical routines, e.g. Aabel). About our test survey file Our test survey file: The “survey file” has 1,000 cases, with 40 questions on a five-point scale, two irrelevant variables (screen width and height), and a couple of demographics (shown here as “job type” and “new or old hire”). We are planning to run the same tests on each package as time goes on. Commercial Mac Stats Software MacStats home page created in 1996 by of the and currently edited by David Zatz, Ph.D., of.