The Real Statistics Resource Pack contains a variety of supplemental functions and data analysis tools not provided by Excel. These complement the standard Excel capabilities and make it easier for you to perform the statistical analyses described in the rest of this website.
On this webpage, we describe how to download and install the Real Statistics Resource Pack for the Mac.
Download
If you accept the License Agreement, click on one of the following options to download the appropriate version of the Real Statistics resource pack for Excel on the Mac:
- Click here on Real Statistics Resource Pack for Mac 2016/2019/2021/365 to download the latest version (Release 9.3) of the resource pack for Excel 2016, 2019, 2021, or 365 for the Mac.
- Click here on Real Statistics Resource Pack for Mac 2011 to download the latest version (Release 5.11) of the resource pack for Excel 2011 for the Mac.
Downloading this resource pack means that you accept the License Agreement.
Installation
Once you have downloaded the Resource Pack, you need to install it using the following steps.
- Move the Resource Pack to where you want it located on your computer. Caution: Once you install the resource pack at a particular location it will be more difficult to move it later.
- Open Excel, but don’t try to open the xrealstats-mac.xlam or realstats-mac-2011.xlam file that you downloaded earlier.
- From the Tools menu choose Add-Ins.
- Make sure that the Solver option is checked on the dialog box that appears.
- Check the XRealstats-Mac (or Realstats-Mac-2011) option on the dialog box that appears and click the OK button.
- If the XRealstats-Mac (or Realstats-Mac-2011) option doesn’t appear, click on Browse to find and choose the XRealStats-Mac.xlam (or RealStats-Mac-2011.xlam) file that you downloaded earlier. Then complete step 5 as described above.
Real Statistics Functions
Once you have installed the Real Statistics Resource Pack you can use the supplemental functions in the same way as you use the built-in worksheet functions supplied with Excel. These functions are described throughout the rest of this website. A complete list of these functions can be found in the Tools menu of the website.
Real Statistics Data Analysis Tools
To use the data analysis tools enter Control-m (i.e. control key + m) or click on the Real Statistics menu.
The descriptions of how to use the Real Statistics functions and data analysis tools apply to the Mac version of the software, although sometimes with minor modifications especially as described in Mac User Interface.
Uninstalling the Real Statistics Resource Pack
- Open Excel, but don’t try to open the XRealStats-Mac.xlam or RealStats-Mac-2011.xlam file that you downloaded earlier.
- From the Tools menu choose Add-Ins.
- Uncheck the XRealStats-Mac or RealStats-Mac-2011 option on the dialog box that appears and click the OK button.
- Close Excel and delete the file that contains the Real Statistics Resource Pack.
Hello Charles,
I have attempted to install this software several times and I tested it using the =VER() formula but it is not working. I have no idea where I went wrong… I followed each step exactly. I’d appreciate your help! Thanks!
Hello Chelsea,
When you choose the Add-Ins option from the Tools menu, do you see RealStats-2011 or RealStats-Mac in the list of addins with a check mark next to it ? Do you see Solver on the list of addins with a check mark next to it?
Charles
Hello!
Is there anyway to test that I have successfully added it to my Excel? I know that there is a way to with Dell and PC but I don’t know how to check with a Mac. Any help is useful, thank you!
Jackie N
Jackie,
You can check whether it was installed correctly, by entering the formula =VER() and see if you get an error. If not, it is installed.
Charles
Thank you for the response. When I typed in the formula, I got 5.0 Excel Mac. I am assuming that means it is functional?
Jackie,
Yes, this is a good sign.If you have Solver installed, the data analysis tools should also work.
Charles
Charles,
How does Real-Stats differ from regular Excel? Is there additional functions added from Real-Stats? How will I know when I am using Real-Stats versus Excel?
Jackie,
Real Statistics adds functions to Excel as well as data analysis tools.
The data analysis tools are accessed via the Addins ribbon or by pressing Ctrl-m, while the Excel data analysis tools are accessed from the Data ribbon.
Real Statistics functions are a type of Excel function (called user-defined functions).
When you enter an Excel function you are given additional information about its arguments that are not available from Real Statistics functions. E.g. when you type in Excel’s COUNT function, you will be prompted by =COUNT(value1, [value2], …), while when you type in the Real Statistics function =COUNTU you won’t see this type of information about the arguments. You need to press Ctrl-A to get similar information, i.e. =COUNTU(array1). Otherwise, there really isn’t much difference between Excel and Real Statistics functions.
Charles
Hi, please help… Ive installed twice and still no luck? The first message i kept getting was ‘compile error in hidden module:analysis’?? when i uninstalled and reinstalled it was asking me for a password? I’m using mac 2011? please help I have course work to complete. thank you so much.
Jason,
See Password Prompt
Note that two version of the software for Excel 2011 are available from the website.
Charles
I need HELP, this is the error message i get.
Compile error in hidden module: ‘LogisticRegression’. This error commonly occurs when code is incompatible with the version, platform, or architecture of this application.
Valerie,
Which version of the Real Statistics software are you using? (1) version (Rel 5.0) for Excel 2016, (2) new version (Rel 5.0) for Excel 2011, (3) old version (Rel 3.5.3) for Excel 2011. Have you installed Solver?
Charles
Hi Charles
I’m having the same problem as Valerie. I’ve used the new version for Excel 2016 and the version for 2011. I have installed Solver too. But I get the very same message she gets. Do you know what I need to do?
Hello,
I am trying to download and run realstats for mac 2011. I am able to download the file. I am unable to run data files for tests. I have tried both versions for Excel 2011. I get a compile error sometimes and other times a “can’t find library error”.. There seems to be something wrong with the version. Any help would be greatly appreciated.
hank you
Ann,
The Rel 3.5.3 version has been tested and has been used by many users. You need to follow the installation instructions on the webpage from which you downloaded the software.
Probably the Rel 5.0 version also works, but it has not been tested.
Charles
I’m working on some cluster analysis. I installed your tool but can’t find the “Multivariate Analysis” option after pressing CTRL+M. That seems to be the key to accessing the Cluster analysis tool. I don’t see any other path that will lead to cluster analysis. I’m using Windows 10 and Excel 2016 (part of Office 365 – most current release). Any thoughts on why some menu options may not be available?
James,
If you are using the latest release of the Real Statistics software (Rel 5.0), then after pressing Ctrl-m, you will be presented with the original interface of the newer multipage interface. In the original interface, Multivariate Analysis is the 12th option on the list. In the multipage interface, you need to click on the MultiVar page.
Charles
Hello…. Looks like a great software…. By error i happened to click on the downloaded app and disable macros…. nothing works now… wt do i do?
Shruthi,
Sorry, but I don’t really understand what you did. It is important that you don’t try to open the file that you downloaded from the Real Statistics website. Instead you must install the software and then use it on a new Excel file. See website for details.
Charles
Dear Charles:
In response to one of your latest posts regarding updating your program for MS Office 2016:
[My problem is that I don’t have a Mac computer and so I need to find someone who will lend me their Mac so that I can test the latest version of the Real Statistics software on the Mac. As soon as I can get a Mac for testing I will release a new version of the software.]
If you will provide me with the information on where to send you a loaner MacBook to test and update your Real Statistics software, I will arrange to have one delivered. Simply return the MacBook when you are finished…having the updated software will be sufficient compensation since you provide it for free to others.
Ben
Ben,
Thank you very much for your offer, but since I wrote that message I have purchased a Mac. I am in the process of creating a new Mac release. It is taking me some time to do this since I need to rewrite some of the code since it doesn’t work on the Mac in its present form (esp. selecting ranges in a spreadsheet). I expect to issue the new release in the next couple of weeks.
Charles
Dear Charles,
Do you have plan to have a new version to support Microsoft Office 2016 For Mac?
or have an version can enhance Apple Numbers?
James,
My problem is that I don’t have a Mac computer and so I need to find someone who will lend me their Mac so that I can test the latest version of the Real Statistics software on the Mac. As soon as I can get a Mac for testing I will release a new version of the software.
Charles
This would be fantastic!
I’d like to uninstall and reinstall my Real Statistics for Mac, How do I do ths.
Thanks.
Joel
Joel,
To uninstalls Real Statistics:
1. Delete the file that contains Real Statistics
2. Open Excel and go to the Tools menu and select Addins.
3. Uncheck RealStats (probably called RealStats-2011 or RealStats-Mac). You will be prompted to remove the reference to Real Statistics. Respond OK.
To reinstall it (presumably with a different copy of the Real Statistics file):
1. Download the Real Statistics file from the website
2. Open Excel and go to the Tools menu and select Addins.
3. Find the file that contains Real Statistics and check RealStats (probably called RealStats-2011 or RealStats-Mac) entry in the dialog box. Press OK.
Charles
Hi –
I really like using RealStatistics – it’s a lifesaver, but I’ve hit a snag and I hope there’s a quick fix.
I’m working with data that has both negative and positive values (means range from around -0.5 to +1.8); when I do a box plot, the output is adjusted so that all of the values are positive (including the whiskers – the scale on the output chart is 0-10). Is it possible to cancel this adjustment? I really need the actual values represented.
It seems like it should be a relatively simple thing to correct, but I’m not sure how to go about doing it. Any help would be enormously appreciated.
Cheers,
Evan
Evan,
Unfortunately, it is not an easy thing to fix. I made the adjustment to keep everything positive because there seems to be no other way to program the boxplots using Excel’s VBA programming language.
You can create the boxplots manually without running into this problem as described on the following webpage:
Creating Simple Boxplots in Excel
Charles
Hi Charles –
Thanks for the info. That’s a bummer – I’ll have a go at doing it manually, but may have to find a different programme to do this in, in the end.
Cheers,
Evan
Does Mood’s Median Test work on a Mac? Does it work for unbalanced sample sizes? I get #value! errors when I try this test even though the command comes up… =ver() gives 3.5.3 so I think I’ve installed things correctly.
Amadna,
Sorry, but it probably isn’t included in the Mac version, only Windows. It should work with unbalanced models.
Charles
Hi Charles,
I’m trying to calculate Jenks natural breaks using the instructions found here: https://real-statistics.com/multivariate-statistics/cluster-analysis/jenks-natural-breaks/. I’ve downloaded and installed the package for Mac users and I am able to access the Control M menu. Unfortunately, however, there is no “multivariate analysis” option. Any insight would be appreciated
Unfortunately, the Mac version of the software doesn’t yet contain all the capabilities that the Windows version has.
Charles
Hi Charles,
I have installed the add in in my 2011 excel on a mac, but when I go to input the data range for any of the analyses (t-tests and anova’s), nothing happens when I click on the input range button. My colleagues with macs are all having the same issue.
Many thanks,
Steph
Steph,
Unfortunately, this capability does not work on the Mac. You need to manually insert the data range (e.g. A4:D9).
Charles
Thank you so much for your quick response! It works fine when I manually input the data range in.
How do you do it for anova? aka is it (A4:A10, B4:B10)???
Hi Charles,
I just want to say thank you so much for making this add-on available for Excel for Mac. I’m still learning statistics, and your blog tremendously helps.
I can access the addon using Ctrl+M fine.
Thanks again!
Nur,
Thank you for your comment. I am pleased that you are getting value from the website and software.
I thought that the addon works with Command-m. Does it also work with Ctrl-m?
Charles
Command+M in Mac minimizes the window to the dock.
Control+M gets the Real Stats to work 🙂
Nur,
Thanks very much for your comment. I had understood that Command+m was the correct key combination. I had also seen documentation that Option-Command-m was the correct key combination, but now I hear from you that Control-m is the correct key combination.
Is it different for different versions of the Mac? (e.g. Excel 2011 vs. Excel 2016?)
Charles
I don’t know about Excel 2011 for Mac, but I can confirm that in Excel 2016 for Mac, the correct combination is “control+m”
Hello,
I’ve downloaded what I believe to be the correct version of Real Stats for Excel 2016 on a Mac (the file is called RealStats-2011.xlam, and I got it by clicking the download link above, “Real Statistics Resource Pack for Mac”). When I open the Add-ins window from the Tools menu RealStats is not on the list of available Add-ins, so I click Browse and select the file that way. As soon as I select the file, Excel crashes and the Microsoft Excel Error Report dialogue comes up. When I click More Information in the error dialogue, this is the message:
Microsoft Error Reporting log version: 2.0
Error Signature:
Exception: EXC_BAD_ACCESS
Exception Code: KERN_INVALID_ADDRESS (0x0000000000000004)
Date/Time: 2016-07-25 00:03:17 +0000
Application Name: Microsoft Excel
Application Bundle ID: com.microsoft.Excel
Application Signature: XCEL
Application Bitness: x64
Application Version: 15.24.0.160707
Crashed Module Name: libobjc.A.dylib
Crashed Module Version: 1.0.0.0
Crashed Module Offset: 0x00000000000010d7
Blame Module Name: MicrosoftOffice
Blame Module Version: 15.24.0.160707
Blame Module TimeStamp: 0x577e3fc4
Blame Module Offset: 0x000000000058e71f
StackHash: 276b
Application LCID: 1033
Extra app info: Reg=en Loc=0x0409
Crashed thread: 0
…followed by several hundred lines that look this:
# 1 0x00007fff84c890d7 in _objc_msgSend + 0x00000017 (libobjc.A.dylib + 0x00000000000010d7) 0x0000000000000000
(If that’s meaningful to you, I could provide the rest of the text.)
I see that other people have gotten RealStats working with Excel 2016 on a Mac and I haven’t seen anyone report an error like this, so I am not really sure what to do at this point.
Any ideas?
Regards,
Alex
Alex,
Sorry, but I really don’t know why you would get this message.
Charles
When i install real statistics on my MAC(excel 2016), it doesn’t show on tool bar, and i cannot find it, could you help me with that?
Elton,
If you press Cmd-m do you get access to the Real Statistics data analysis tools? What do you see if you enter the formula =VER()
Charles
Hey Charles,
I’m having the same issue as Elton. Cmd-m only minimises the page, and typing in =VER() yields the result: 3.5.3
Any pointers would be much appreciated. Having no access to your brilliant program is driving me up the wall haha
Thanks,
Aaron 🙂
Aaron,
It is surprising to me that pressing the m key while holding the Command key down doesn’t work.
It is possible that the Command button is not working properly. See the following webpage regarding this:
https://discussions.apple.com/thread/3067628?start=0&tstart=0
In any case, you can access the Real Statistics data analysis tools by selecting Macros from the Tools menu and entering InitStats on the dialog box that appears and clicking the Run button. Not the best, but it should work. You can, of course, access any of the Real Statistics worksheet functions in the usual way.
Charles
Hey Charles,
Thanks for alerting me to the keyboard issue. It turns out that Control-m is what I need to press in order to pull up the data analysis tools in excel.
Thank you for you help,
Aaron 🙂
Can you do the weighted multiple regression with the mac version of Real Statistics? I have excel 2016. When following the instructions only to perform a weighted multiple regression, I do not get the “regression” option in the menu. The only close options I have are linear regression or logistic regression. Thanks for you help!
Andrea,
Sorry, but the Mac version doesn’t yet support this test. I hope to add it shortly.
Charles
Thanks Charles.
dear Charles,
in the past I used you package with excel 2011 for mac.
today I installed the toolbox on my new mac with excel 2016 for mac. I followed your instructions but at the end the real statistics manu does not appear.
entering =VER() in a cell the answer is 3.5.3.
any suggestion?
thank you very much
paolo
Dear Paolo,
Are you still able to access the Real Statistic menu by pressing Ctrl-m ?
Charles
Wow! This is brilliant! I am SO glad I found this as I have some data with unequal variances among groups, so I needed to run a Levene’s and Welch’s ANOVA. Your software did both like a champ.
I’m very interested in your upcoming new Mac version for Excel 2016 that you mentioned.
Best wishes!
Hi Charles
I cannot seem to find the weighted linear regression function in the real stat resource pack. I’m on a Mac. Is this function currently unavailable for Mac?
Sorry Rach, but this capability is currently only available on the Windows version of the software. I hope to create a new Mac version shortly.
Charles
Hi Charles , Thank You for developing this software. Can this software be used with Excel 2016 for mac ?
The software can be used for Excel 2016 for Mac. You need to download the version on the referenced webpage (and not the version for Excel 2016 for Windows). This version of the software will not contain some of the newer Real Statistics capabilities, which are currently only available on the Windows version. I hope to provide an update for Mac soon.
Charles
Hi Charles,
I download the RealStats add-in for the Excel Mac 2011. I followed your instructions for installing it in Excel. However, I got a weird error message that said “Can’t find project or library”. Do you know how I can fix it?
Thanks!
I wanted to also add that it asks me for a password as well.
Thanks!
Charles
You should never need to supply a password. Let me ask you a few questions to try to determine what is going on. First open up a blank Excel workbook.
1. When you insert =VER() in any cell, what do you see?
2. When you go to the Tools menu and choose Add-Ins, do you see RealStats 2011 on the list with a check mark next to it?
Charles
Hi,
I am having the same problem. I would appreciate your help
Hi Leslie,
Which problem are you referring to?
Charles
Hi Charles!
I download the RealStats add-in for the Excel Mac 2011. I followed your instructions for installing it in Excel. However, I got a weird error message that said “Can’t find project or library”. Do you know how I can fix it?
Thanks,
Camilla
Camilla,
What do you see if you type the formula =VER() in any cell?
When you open a blank Excel spreadsheet and then select Addins from the Tools ribbon, does RealStats 2011 appear on the list with a check mark next to it?
Charles
ho lo stesso problema, mi sta dando parecchio fastidio
Marco,
I am not sure which problem you are referring to. If you are getting a message like “Can’t find project or library”, then I need to ask a few questions so that I can figure out what the problem is. Usually the problem is that you haven’t installed the software properly (as described on the referenced webpage).
1. What do you see if you enter the formula =VER() in any cell?
2. When you go to the Tools menu and choose Add-Ins, do you see RealStats 2011 on the list with a check mark next to it?
Charles
allora scarico il file ed eseguo tutto secondo le istruzioni, una volta spuntato realstat , clicco ok, poi compare “impossibile trovare il progetto o lalibreria”, subito dopo mi chiede una password. chiusa anche quella finestra vado su realstat, provo a selezionare le caselle, faccio ok e mi dice “errore di compilazione nel modulo nascosto analysis”.
vorrei una soluzione sono parecchio stufo, grazie
Marco,
If you are being asked for a password then you have not installed the software correctly. You don’t need to have a password. In order to use the software on a Mac running Excel 2011 or Excel 2016 you must follow the following steps:
1. Open Excel, but don’t try to open the realstats-2011.xlam file that you downloaded earlier.
2. From the Tools menu choose Add-Ins.
3. Check the Realstats option on the dialog box that appears and click the OK button.
4. If this option doesn’t appear, click on Browse to find and choose the realstats 2011.xlam file that you downloaded earlier. Then complete step 3 as described above.
Hundreds of people (probably thousands) are using the Mac version of the software without problems.
Charles
si ho fatto così, comunque l’ho rifatto ed è sempre uguale, quando provo ad usarlo mi dice “errore di compilazione del modulo nascosto analysis”
ci sono riuscito, ho inserito realstat.xmla nella cartella di office dove è installato, comunque grazie charles. per caso cè un modo di selezionare le caselle con il trascinamento anziche farlo manualmente sul mac?
Marco,
I am very pleased that you got it to work.
The approach used to select ranges in Windows dialog boxes doesn’t work on the Mac. I therefore implemented a different approach, which unfortunately also didn’t work.
The big problem I have is that I don’t own a Mac and so I can only work on these issues when I am able to borrow a Mac from someone. I see that you are writing in Italian and so perhaps you can help me here since I live in northern Italy about one hour from Milan, and perhaps you know some way for me to get access to a Mac.
Charles
Hello,
I have been using Real-Statistics for Mac 2011 (ver 3.5.3) successfully. However I have recently upgraded to Office 2016 for Mac. Which version of Real-Statistics should I be using?
Many thanks,
Kieron.
Hello Kieron,
I have not tested the Real Statistics software with Excel 2016 for the Mac. I would suggest that you try using the same version that you are using now (3.5.3). Please let me know whether it works.
Charles
Dear Charles,
Thanks a lot for your work.
I downloaded and used your software for mac succesfully with the version release 3-5-3.
But i really need to use the Scheirer Ray Hare test, but i can’t find it in the box of the two way ANOVA…
Can you help me?
François
Th
Sorry, but this capability has not yet been added to the mac version of the software. It is currently only available on the Windows version.
Charles
How to get the command KSDIST(x,n) and run it
KSDIST is a function. You use it in the same manner as you use any other Excel function.
Charles
Hi Charles,
I found your site when looking into how to calculate Jenks breaks – thanks for all of your work to make Excel more statistically advanced!
I did not see a Multivariable Analyses option in the Excel version — am I missing something?
Best,
Rebecca
Rebecca,
I haven’t yet added Jenks to the Mac version of the software. It is currently only available in the Windows version.
Charles
I have downloaded RealStats2011 for my MAC. I am running Excel 2011 version 14.5.8. I tried to install it as instructed by going to Tools, Add-ins and browsing for the file. When I choose the file, I receive an error message “Error in loading DLL”. My OS is El Capitan, version 10.11.1.
Any help is greatly appreciated!
Susan,
I have not heard from any other Mac user that received this message. I don-t know what is causing this problem.
Perhaps someone another Mac user can help you.
Charles
Hi Charles and Susan,
I have also come across the message “Error in loading DLL”. Was there any assistance that other Mac users were able to provide with what this means? I have identified that there may be an issue with the use of the Solver Add-in, but have not been able to confirm this problem.
I appreciate your help!
Hi Matt,
The Mac version of the Real Statistics Resource Pack doesn’t require the use of Solver.
Other users of Excel 2016 for the Mac have successfully used the Real Statistics Resource Pack (Mac version, not Excel 2010/2013/2016 version). Can you tell me anything else that might be different about your setup?
Charles
I am using Excel 2011. I am trying to do weighted linear regressions, but I am not sure if this resource pack can perform the operation or not. The current resource pack for the windows version has that option. Will Excel 2011 for Mac be receiving an upgrade soon? Thank you so much.
Mike,
The current Mac version does not perform weighted linear regression. The delay is issuing a new release for the Mac is that I don’t own a Mac. I am hoping to get access to a Mac soon so that I can issue a new release.
Charles
Does this solve the problem of having no ActiveX on Mac? Does this replace the ActiveX?
Sorry Daniel, but I don’t know what you are referring to. I am not using ActiveX on the Mac or Windows versions of the software.
Charles
Sorry, but I tried to download the Real Statistics Resource Pack by the normal method for Mac. I did not see your directions until after downloading (suggestion put the download button after the installation instructions). My system uses Yosemite 10.10.4 and Microsoft Office 365. How do I uninstall the Pack and then get it to work in Excel. Thanks.
Tony,
I have added instructions for uninstalling the Real Statistics Resource Pack at the end of the webpage
Real Statistics Resource Pack for the Mac.
Once you have done this you just need to follow the installation instructions that appear on the same webpage.
Charles
Do you have a version for google sheets? I use a chromebook.
Garry,
Sorry but I don’t have a version for Google Sheets.
Charles
hi does anyone know how to remove add-ins from the mac excel add-ins menu? i accidentally installed the windows version and would like to have it removed but there doesn’t seem to be a remove button and most of the instructions online are for Windows
Jonathan,
1. From the Tools menu choose Add-Ins.
2. Uncheck the Realstats option on the dialog box that appears and click the OK button.
Charles
All is well with the download and install but the menu is way too small, even for my good eyes.
That seems to be the default size that Excel/Mac chose. I will try to make it larger in the next release.
Charles
FYI: On this page you say, “Move the Resource Pack to where you want it located on your computer (see our recommendation below).” But there is no recommendation below, or on any other page I could find (for Mac). Similarly, other mentions of the recommended location say only “see recommendation on this website”. Replacing some of these sentences with an actual recommended location would be helpful.
I saved the Resource Pack to Applications — Microsoft Office 2011 — Office — Add-Ins, and it seems to have worked, (it appears as an option on the Excel toolbar) but I haven’t yet tried to use the tools.
Owen,
Since I don’t have a recommendation for where to place the Real Statistics add-in on a Mac, I have removed that reference.
You said there are other mentions of a recommended location (“see recommendation on this website”). Where did you find these, so that I can make this clearer.
Thanks for bringing this issue up.
Charles
Hi, I tried to get the eigen values and vector using the add ins, but it didn’t work. The only thing that appeared was #VALUE!. Can you please tell me what went wrong? Thanks
This will happen if the matrix is not invertible (i.e. if the determinant is 0). If you like you can send me an Excel spreadsheet with the matrix that you are trying to find the eigenvalues/vectors for and I will try to figure out what has gone wrong.
Charles
Please send me a spreadsheet with the data you are using and the results you received, and I will try to figure out what went wrong.
Charles
Hi Dr. Zaiontz
I tried to install the software , created the googledoc of the issues… (this happened to me on PC and on MAC with both pathways)
https://docs.google.com/document/d/1GRcqqx0h2ttUUrbqqykJPuomUh5lW483HcwDsalJDLs/edit?usp=sharing
Hi Dee,
The key steps for installing the Windows version of the software are:
1. Open Excel, but don’t try to open the realstats.xlam file that you downloaded earlier.
2. Press Alt-TI (i.e. hold the Alt key down and simultaneously press T followed by I)
3. In the dialog box that appears check the Realstats option (or Realstats 2011, Realstats 2007, etc., depending on the version of Excel that you are using) and then click the OK button.
4. If Realstats doesn’t appear in the list, click on the Browse button to locate the Real Statistics file that you downloaded. Then complete step 3 as described above.
Charles
Dee,
The key steps for installing the Mac version of the Real Statistics Resource Pack are:
1. Open Excel, but don’t try to open the realstats-2011.xlam file that you downloaded earlier.
2. From the Tools menu choose Add-Ins.
3. Check the Realstats option on the dialog box that appears and click the OK button.
4. If Realstats doesn’t appear in the dialog box, click on Browse to locate the realstats 2011.xlam file that you downloaded earlier. Then complete step 3 as described above.
Charles
Requested Feedback:
The Fill button does not work with Excel 2011 and OS X 10.10.2
Thanks
Jeff,
Thanks for telling me this. I will try to fix it in the next release.
Is everything else working in the Mac version of the software? As I have mentioned elsewhere I don’t own a Mac and so have limited time to test the software on a friend’s Mac.
Charles
As for the pop-up box and ‘hard-to-read’ issue, my Mac also shows this behavior. It looks like it might be font-related? A screen shot is available here:
http://www.million-monkeys.com/RealStats/RealStatsMenuMac.png
Cheers,
Ed
Ed,
I hope to have a new Mac release of the Real Statistics software available this week. Although the dialog boxes will still be small I have tried to improve the readability. If you would like to test the release I can put it online later today as a beta version.
Charles
Hi Charles,
Happy to beta test for you. Let me know how to get it and what you want me to focus on.
Cheers,
Ed
Ed,
Thank you very much for volunteering to help with the beta testing of the latest Mac version of the Real Statistics software.
I have just made Release 3.5.3 beta for the Mac available for download at Real Statistics Resource Pack for Mac Download
I have just tested it, but not as extensively as I would have liked since I only had access to a Mac computer for a few hours. I would appreciate your checking to see whether it can be used on a different Mac besides mine. Mostly I want to make sure that the Mac doesn’t crash or get hung up when any of the Real Statistics functions are used and especially when the various data analysis tools are used.
The mathematical part of the software is identical to the Windows version, but some of the interface has been rewritten for the Mac. Some features are not working. In particular, ranges must be inserted manually in Input Range fields (you can’t highlight the range) and I am not sure whether the Fill buttons work.
I appreciate any help you can give in identifying problems with the interface for the Mac.
Charles
For Mac users, I have had success copying the RealStats-2011.xlam file to the following location:
Applications–>Microsoft Office 2011–>Office–>Add-Ins
Then, open Excel, click on Tools–>Addins. RealStats will appear on the list. Check the box, then click the Select button.
..Correction. Should say “…then click the OK button”
Hi,
I installed the Real Statistics resource pack on my Mac, under Excel 2011, without any problems. But, when I go to Data Analysis Tools under the Real Statistics menu, the Real Statistics pop-up box is quite small, and the text is difficult to decipher. Is there an option available to expand the size of the pop-up box? [There’s no handle on the box to enlarge it.]
Thanks!
Jim
Jim,
On the Mac that I used the pop-up box was smaller than the pop-up box on the Windows version of Excel, but I didn’t have any trouble reading it. In any case, I will look into making the size of this dialog box adjustable in a future release.
Charles
Happy to say it installed correctly on my Mac running Excel 2011. Under add-ins I chose “select” (“Browse” being unavailable) which brought up the directory menu, and I was able to select it from where I’d moved it. I immediately did a PCA analysis on a covariance matrix I had recently constructed from equity price histories: it performed flawlessly. Thank you for all the hard work that went into creating this add-in.
Hi,
I have Excel 2008 for MAC. Which version of your RealStats should I use? I tried all three packages as per your instructions using add-ins and it won’t let me do it because of the macros issue.
Thanks
The software probably doesn’t work for versions of Mac before Excel 2011. Sorry for that.
Charles
This looks like it could be really nice, but I’m getting various errors (running Excel 2011 on Mac). First, when I select the RealStats from the Add-Ins options, I get the error:
“Can’t find project or library”
When I click OK, I’m prompted for a “RealStats Password”
When hit Cancel and choose Data Analysis Tools from the RealStatistics menu, the menu comes up, but when I choose any function, a window comes up and I get beeps every time I click anywhere in Excel. I’m left with no choice but to force quit Excel.
Is there a passwd that I should be entering?
Thanks
You do not need to provide a password to use the software. The usual reason for getting this message is that the installation process has not been completed (as described on the referenced webpage).You said that you selected RealStats from the Add-in options. For the Mac I think this should be something like RealStat 2011 instead. You probably need to use the Browse button to find the correct file.
If you have followed the Installation instructions then I suggest that you download an earlier version of the software. This can be obtained from the referenced webpage. Try using Release 3.1 (instead of Release 3.1.2). You will need to follow the Installation instructions. This time you will need to use something like RealStats 2011 1 Oct 2011 from the Add-in options.
Charles
Hi Charles,
I’m trying to install the latest package on my Excel (Mac) but it keeps prompting for a password. I am most definitely selecting the correct one. I can’t seem to find the link to download the other releases. Do you still have them?
Thank you!
Marielle,
You don’t need a password. You will receive this message if you try to open the file. You don’t need to do this.
Just follow the instruction on the referenced webpage, namely
1.Open Excel, but don’t try to open the realstats-2011.xlam file that you downloaded earlier.
2. From the Tools menu choose Add-Ins.
3. Check the Realstats option on the dialog box that appears and click the OK button.
4. If this option doesn’t appear, click on Browse to find and choose the realstats 2011.xlam file that you downloaded earlier. Then complete step 3 as described above.
Charles
Hi, I am experiencing the exact symptom. I downloaded the package and it is called RealStats.xlam in the download. I open excel and choose it as an add-in (not opening the file) and I get the exact same errors and prompts for a password. Was this issue ever resolved?
Barbara,
Please confirm that when you select Add-Ins on the Tools menu that you see the Realstats 2011 option on the dialog box that appears with a check mark next to it.
Charles
I have installed realstats-2011.xlsm per the instructions and the solver stuff works using the ctrl-m. However, I can’t access and any real statistics custom functions. They are all coming up #name.
I have enable macros on the spreadsheets to no avail.
Frank,
It sounds like you have installed the software on your mac, but you still need to have Excel recognize the software. You do this by accessing the Tools menu and selecting the Add-ins choice. Next click on the Browse button in the dialog box that appears and choose the realstats 2011.xlam file that you downloaded. Press the Close button. Finally check the Realstats option on the dialog box. This is described on the referenced webpage.
If you have done all this already what happens when you enter the formula =VER() in any cell?
Charles
Charles-
This add-in set is really nice. But I am seeing a bug in the t-test routine. It’s generating error 424 (“object required”) on startup, before showing the input window. Everything else starts fine. I’m running Excel 2011 (14.4.4) on the current Yosemite release candidate. If more information would be helpful, let me know.
-Alistair
Alistair,
Unfortunately I currently don’t have access to a Mac to fix the problem that you have raised. Instead I am providing access to the previous two versions of the Real Statistics Resource Pack for Mac (Release 3.1 and Release 2.10).
Release 3.1 was created only one week before the latest release (on Oct 1). The main differences are that there is an error in the p-value for the KAPPA function (one-tail value instead of two-tail value) and the dialog boxes for the data analysis tools are not so nicely formatted. Please let me know whether this version works properly.
I have also provided an older version of the software from February 2014 in case the Oct 1 version doesn’t work correctly.
You can download either of these versions from https://real-statistics.com/free-download/real-statistics-resource-pack/real-statistics-resource-pack-macintosh/
Charles
Hi Charles,
I just downloaded the RealStats-2011.xlam for use with Excel 2011 on my Mac. I followed your instructions you sent to “Mark” on July 2.
I am wondering, should I have moved the .xlam file somewhere else other than the “Downloads” file before starting Excel ? Seems to work OK, but must I leave the file in the Downloads file ?
>>Also, my eyes aren’t what they used to be…how do I enlarge the RealStats dialog box size ? I assume the fonts will scale-up too ?
Thanks.
Wayne
Hi Wayne,
If you want to move the file you probably need to uncheck the the file from the list of Excel add-ins (Tools > Add-Ins dialog box) and then move the file to a new location and repeat the installation process by selecting Tools > Add-Ins and then clicking on Browse to locate the Real Statistics Resource Pack file. I have not tried this and so don’t know if it works.
If this doesn’t work then the following approach should work. Make a copy of the Real Statistics Resource Pack file and give it a new name. Move it to where you want to put it and then repeat the installation process.
Unfortunately you can’t enlarge the RealStats dialog box (at least I don’t know of any way to do this). I will add this to the list of potential enhancements for a future release.
Charles
Hi Charles
Maybe you can confirm if this should be working for me or have I overlooked something?
I downloaded the file, ran it. I was prompted to 1/ enable macros 2/ don’t install 3/ run and disable macros.
Choosing 1 Excel appeared to accept it. Going into Add Ins within Excel Real stats did not appear.
I restarted the machine and tried it a couple times. Each result the same
I am using Mac 2011, and installed the xlam file in my Excel App folder.
Thanks
Hi Mark,
You shouldn’t try to run the Real Statistics Resource Pack. Instead you need to install it (i.e. instruct Excel that the file contains an add-in). For the Mac environment follow the following steps:
0. Open Excel (but not by clicking on the file containing the Real Statistics Resource Pack)
1. From the Tools menu choose Add-Ins.
2. On the dialog box that appears click on Browse to locate and choose the realstats 2011.xlam file that you downloaded earlier
3. Check the Realstats option on the dialog box that appears and click the OK button.
You only need to install the Real Statistics Resource Pack one time. After that any time you open Excel you will automatically have access to the resource pack.
Charles
I have this same problem with Excel 2011. When I click on Add-ins, the pop-up window shows me that Solver is checked, but there is nothing that says Browse. I click ok, but nothing happens and I can’t find Browse anywhere
Rusty,
Are you sure that you have chosen Add/Ins from the Tools menu?
If you don’t see the Browse button then either you have brought up the wrong pop-up window or there is a problem with Excel.
Charles
Thank you, Charles, for developing this! FYI, I tried it on my Mac using Office 2004, and it didn’t recognize it as a valid add-in. No problem for me; I’ll just use my newer Windows machine. But I thought you might like to know that version’s definitely too old (and I doubt worth troubling about for you).
Hi Seth,
The current version of Real Statistics for the Mac has only been tested with Excel 2011. There are still some people using the Real Statistics software with a pre-2007 version of Excel, but, as you have pointed out, I don’t think the audience is big enough to support earlier versions of the Mac. I am pleased that you were able to use the software on a newer Window computer.
Charles
Your statistical package with instructions looks very useful.