Excel 2016/2019/2021/365 for Mac
The user interface for the Mac version of the Real Statistics data analysis tools is identical to the Windows version (see Using the Real Statistics Analysis Tools) with one important difference. When inserting a range into an input field, in Windows you can simply highlight the range of cells and the field will automatically contain the address of the highlighted range (see Figure 1).
Figure 1 – Inserting a Range in Windows
In the latest versions of Real Statistics for the Mac to accomplish the same thing, you need to click on the + button, as shown in Figure 2.
Figure 2 – Inserting a Range on the Mac (step 1)
This will display the dialog box shown on the right side of Figure 3. You can now highlight the desired data range (M3:M7 in this example) and when you press the OK button, the Input Range field will automatically be filled with the appropriate cell range address.
Figure 3 – Inserting a Range in the Mac (step 2)
The situation is the same for the Output Range, except that now you should only highlight one cell.
Excel 2011 for Mac
Note that the approach described above is not available for the older version of Real Statistics for the Mac. In the releases prior to Rel 5.0, you need to manually enter the ranges into the input and output range fields (e.g. if you choose an Input Range of say A5:F9 you need to type the characters A5:F9 in the Input Range instead of highlighting the range), although the Fill buttons will work.
Excel 365 for Mac
The XRealStatsX.xlam version of the Real Statistics software can be used by Excel 365 users for the Mac as well as Windows users. The Mac user interface is identical to the Windows user interface for this version of the Real Statistics software.
Hello,
Is there a way to add the FReal Statistics tools permanently to the add-idd ribbon, or any other Excel ribbon, instead of having to press ctrol+m?
Hello Vanina,
You can do this in the Windows version, but I don’t know how to implement it in the Mac version.
If someone can tell me how to do this in the Mac version I would gladly implement it.
Charles
Hi. I am using a mac and can’t find the 2 way repeated measures ANOVA. Any help, please?
Ami,
This capability is part of the free Real Statistics add-in. You need to download and install Real Statistics to use this capability.
Charles
Hello Charles,
I’ve downloaded the XRealStats pack and have added it along with the Solve and Analysis Toolpak from the Add-ins dialog box. However, when I then click on Data Analysis to follow the next suggested step (press control and m) it only highlights ‘moving average’ and when I scroll through the list of options I do not see Real Statistics as an option. Wondering if you could advise on what I might have done wrong?
I tried unchecking, deleting the xlam doc and downloading again, saving in a different location but no luck. Any help would be greatly appreciated. Also, your website has been so incredibly helpful so far in helping me with statistics. Thank you.
KJ,
The Real Statistics data analysis tools are not integrated into the Data Analysis dialog box (which is part of the standard Excel Analysis Toolpak). When you press the key sequence Ctrl-m the Real Statistics dialog box should appear. If it doesn’t then there is a problem. In this case, enter the formula =VER() in any cell. If you get an error value then Real Statistics wasn’t installed properly. Otherwise, unless you are using an old version of Excel or there is some interference with another add-in, you should see the Real Statistics dialog box.
Charles
Hi Charles,
Thank you very much for your quick reply. The =VER() showed no error so I tried unchecking the Analysis Tookpak from the Add-ins options and I now am able to successfully see the Real Statistics dialog box. Thank you!
KJ
KJ,
That is strange, but I am glad that it works.
Charles
Dear Dr Zaiontz,
I installed properly RealStatistic om my Mac. But I don’t know how to access it. I am using cmd and m but it minimalizes only the window. Can you prompt how to assess function to count ICC.
The another question is if I did measermnent twice and I need to count intra-rater variability, should I report it as ICC (1,2) since I was the only one who was rater and I did it twice?
I would appreciate you answers.
Kind regards,
Paul
Paul,
I believe that you need to use the ctrl button, not the cmd button.
If you have one rater with two ratings, then you have a test-retest situation. See
ICC for test/retest reliability
Charles
What a stunning find, your Real-Statistics Tool Box. As one who actually taught biostatistics at university level in the ’70s, I was overjoyed to google my way into your wonderful statisystem. I’ve taken on the task of analysing a 74-year time series of rainfall data for our NGO’s forest (www.karurafriends.org, #KaruraForest), so I wearily dug out my mouldering copies of Bailey, Siegle, Sokal&Rohlf… And thought, do I really at my age have to work through all the formulae again in Excel? But, lo! I chanced on your treasure trove, downloaded & installed, and have just run a Shapiro-Wilk with no loss of blood, sweat nor tears. You shall be mentioned in dispatches! Heartfelt thanks!
Thank you Harvey for your kind remarks.
I understand your hesitancy. As a mathematician who spent most of my career in marketing and management, I was pleased when I started this project a few years ago that I was till able to do the type of mathematics necessary to create this website and software.
Charles
Hey I have installed Real Stats on my Mac however it is asking me for a password before i can use it in excel… did i miss something?
See Password Prompt.
Charles
Hi Dr. Zaiontz. I am encountering problems trying to use the Real Stats data analysis tool to calculate Gwet’s AC2 in Excel. I highlighted the entire range of data (2 raters in 2 columns x 36 rows), then checked all three boxes on the first dialog box, Analysis Tool Pak, Real stats-Mac-2018 and Solver Add-in, checked Gwet’s AC in the second dialog box, unchecked “column headings included with data.” The correct input range was displayed the dialog box. When I run this it supplies a listing for Alpha (0.05), Subj Factor (0), Rater factor (0) but nothing for Gwet’s AC2.
Am I inputting this data incorrectly? Do I need to supply range data for Ratings range, Weights range and Output range as well? I am not sure how to do this and couldn’t find any information on the Real Stats site. I have about 14 different data sets I would like to rate, some of them nominal, some ratio. I would be very grateful for any help you can offer.
Thank you so much.
Hi Tony,
The values for the Ratings range and the Weights range are described on the following webpage:
https://real-statistics.com/reliability/gwets-ac2/gwets-ac2-basic-concepts/
If you leave the Output range blank then the output is directed to a new worksheet. Alternatively, you can insert the cell address (e.g. D1) where you want the output to begin on the current worksheet.
Charles
Hello,
I have successfully installed the software and I am able to open it in excel 2011. I have my data set and I have followed all your suggestions. When I enter the first data set, I continuously get the response of “run time error ‘424’ object required”. I googled the code and it has something to do with the “product missing”. Is the issue with real statistics or excel?
Yvonne,
What do you see when you enter the formula =VER() in any cell?
When you select the AddIns option from the Tools menu, do you see RealStats-2011 and Solver on the list of addins with a check mark next to each of them?
Charles
I installed the add-in on a Mac using Excel 2016. Seems to have installed ok and works properly. I wonder if there is some other way to get to the Real Statistics dialog other than CTRL-m–because I have a very short memory. The install directions say to click on the Real Statistic Menu, but I cannot find such a menu. Is there a charge for this software and your directions?
Dan,
Not sure why using another approach to Ctrl-m helps with memory shortage, but you should be able to select Real Statistics from the AddIns menu/ribbon.
There is no charge for the software or my directions, although if you are getting value a donation would be appreciated.
Charles
Hi Charles,
I’m using Excel 2016 for Mac, and I have the same problem showing a compilation error hidden: “Analysis error”, after inserting a range (step 2).
After I entered the formula =VER(), it showed 5.5 MAC Excel 2016.
What should I try next?
Thank you!
Melody,
Which data analysis tool did you choose?
When you select Addins from the Tools menu do you see Solver on the list of addins with a check mark next to it?
Charles
I always get a message saying: Compile error in hidden module: Analysis after I input the range
Jamal,
What version of Excel are you using?
What do you see when you enter the formula =VER()
When you choose the AddIns option from the Tools menu do you see RealStats-2016 or RealStats-2011 in the list with a check mark next to it? So you also see Solver in the list with a check mark next to it?
Charles
Hello Charles,
I recently downloaded RealStatistics for my Mac, Excel 2011 (Realstats-2011) and I’m trying to use the Ancova function.
I also get this message “Compile error in hidden module: Analysis”. I entered the formula “=ver()” into the input and I get the message “Compile error in hidden module: frmAncova”.
What should I try next?
Thanks!
Ting Tang,
The usual reason for getting this type of error is that Excel’s Solver has not been installed. To check this, choose Addins from the Tools menu and make sure that Solver is on the list of addins with a check mark next to it.
Since I don’t have a Mac that runs Excel 2011, I am forced to test the Excel 2011 version by making sure that it runs under Excel 2016 for the Mac and Excel 2007 for Windows. This should be sufficient, but I am not 100% certain.
In any case, the older Rel 3.5.3 version for the Mac was tested with Excel 2011 and should work (although it lacks newer features).
I suggest that you either (1) use Excel 2016 for the Mac or one of the Windows versions or (2) install the Rel 3.5.3 version for the Mac and see whether it runs or not.
Charles
Hi Charles,
Let me tell you, I followed all the necessary steps on my Mac, but Fleiss Kappa doesn’t work.
A dialog message appears, a compilation error hidden: “Analysis error”, after inserting a range (step 2).
Can you help me please.
If the pack for mac has fleiss Kappa? I couldnt find
Diana,
On the latest version of Real Statistics (Rel 5.0), you will find it on the Interrater Consistency data analysis tool (click on the Corr tab). On the previous version, I believe that it was located on the Reliability data analysis tool.
Charles