**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 the Mac:

- Click here on Real Statistics Resource Pack for Mac 2016 to download the latest version (Release 5.4.2 of the resource pack for Excel 2016 for the Mac
- Click here on Real Statistics Resource Pack for Mac 2011 to download the latest version (Release 5.4.2) of the resource pack for Excel 2011 for the Mac
- Click here on Real Statistics Resource Pack for Mac (old version) to download the previous version (Release 3.5.3) of the resource pack for Excel 2011 or 2016 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 realstats-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 (this step is not necessary for the Rel 3.5.3 version of the software). - Check the
**Realstats**option on the dialog box that appears and click the**OK**button. - If the
**Realstats**option doesn’t appear, click on**Browse**to find and choose the RealStats-Mac-2016.xlam, RealStats-Mac-2011.xlam or RealStats-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 Real Statistics Supplemental Functions and Real Statistics Multivariate Functions.

**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 RealStats-Mac-2016.xlam, RealStats-Mac-2011.xlam or RealStats-2011.xlam file that you downloaded earlier. - From the
**Tools**menu choose**Add-Ins.** - Uncheck the
**RealStats-Mac-2016, RealStats-Mac or RealStats-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.

Your statistical package with instructions looks very useful.

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

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

runthe Real Statistics Resource Pack. Instead you need toinstallit (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

Toolsmenu chooseAdd-Ins.2. On the dialog box that appears click on

Browseto locate and choose the realstats 2011.xlam file that you downloaded earlier3. Check the Realstats option on the dialog box that appears and click the

OKbutton.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

Toolsmenu?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

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

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,

Are you running the latest version of the software (Rel 3.1.2). You can get the release number by entering =VER() in any cell in a spreadsheet?

Just to confirm, are you able to run other data analysis tools (e.g. the Descriptive Statistics tool)?

Charles

Dear Charles,

I have the same problem as Alistair. I am running the latest version (3.1.2) and i could run other tools like as Chi-square test, …

but to run the t test and non parametric equivalents I found this error:

run time error 424

object required

Thank you for considering my problem.

Best,

Maryam

Maryam,

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.

You can download either of these versions from http://www.real-statistics.com/free-download/real-statistics-resource-pack/real-statistics-resource-pack-macintosh/

Charles

Charles,

Firsts of all I want to congratulate you for the excellent work on creating the Real Statistics Resource Pack.

I have the same problem described by Maryam and I already tried the two previous version and it persists.

Thanks

Ricardo

Riccardo,

Are you having a problem with the KAPPA function or some other issues with the Mac version of the software? Are you using Excel 2011 or an earlier version of Excel for the Mac?

Charles

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 http://www.real-statistics.com/free-download/real-statistics-resource-pack/real-statistics-resource-pack-macintosh/

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

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

RealStatsfrom the Add-in options. For the Mac I think this should be something likeRealStat 2011instead. You probably need to use theBrowsebutton 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

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

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 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

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”

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

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

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

Realstatsoption (or Realstats 2011, Realstats 2007, etc., depending on the version of Excel that you are using) and then click theOKbutton.4. If

Realstatsdoesn’t appear in the list, click on theBrowsebutton 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

Toolsmenu chooseAdd-Ins.3. Check the

Realstatsoption on the dialog box that appears and click theOKbutton.4. If Realstats doesn’t appear in the dialog box, click on

Browseto locate the realstats 2011.xlam file that you downloaded earlier. Then complete step 3 as described above.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

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

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

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

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

downloaded your package, installed the xlam, ran simple descriptive analysis, and locked up excel entirely.

Now the dialog boxes will not remove themselves after execution or upon cancellation. All dialog box options are greyed out and unavailable.

Must force quit to remedy…

Uninstalling package as soon as I get free of your trap!

Sorry Lee that this happened to you. There is no trap. Lots of people are currently using the Mac version of the software without having these sorts of problems. Are you using Excel 2011 or some other version of Excel?

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

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

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

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

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

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

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

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,

I am using Excel 2016 for Mac as well. I managed to install RealStats add-in according to your previous instructions.

After installation, I can see RealStats checked box in Add-ins menu under Tools.

VER() typed in any cell provides “4.6 Excel 2010/2013/2016”.

I can run RealStats by using CTRL-M.

The Solver add-in is installed in my version of Excel.

But, when I try to run some of the analysis, I end up with the message “Compile error in hidden module: xxx”. After terminating the frozen macro with red control window button, a new blank sheet with no results appears. When I run Frequency Table, I get “Compile error in hidden module: frmFreq1”, for Chi-Square Tests for Independence the result is “Compile error in hidden module: ChiSquare” and for Descriptive Statistics and Normality the message is “Compile error in hidden module: Analysis”.

Could you possibly guess what could be wrong? Thank you for any idea.

Milos,

Unfortunately, Rel 4.6 of the software is not available for the Mac, even a Mac running Excel 2016.

Currently the only release for the Mac is Rel 3.5.3, which you can download from

http://www.real-statistics.com/free-download/real-statistics-resource-pack/real-statistics-resource-pack-macintosh/

This release was designed for Excel 2011 (Mac), but it should run on Excel 2016 for the Mac.

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

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 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

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!

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

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.

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 🙂

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

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”

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’m trying to calculate Jenks natural breaks using the instructions found here: http://www.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

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 –

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

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

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

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

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

Pingback: Real Statistics Mac Rel 5.0 | Real Statistics Using Excel

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 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?

Tom,

Let me ask some questions to try to resolve this problem.

1. Are you running both the Excel 2016 version and Excel 2011 version of the software at the same time? You should avoid doing this.

2. Are you using the old version for Excel 2011 or the old version?

3. When you enter the formula =VER() what is the result?

4. Are you getting the error message when you run the Logistic Regression data analysis tool (as Valerie did) or some other data analysis tool?

5. Do you get this error message when run the Descriptive data analysis tool?

6. When you select the Add-Ins option from the Tools menu do you see Solver on the list of add-ins with a check mark next to it? Which version(s) of Real Statistics do you see on the list with a check mark next to it?

Charles

Hi Charles

Thanks for getting back to me. I’ll answer those in turn.

I’m just running the 2016 version now, on the Office 365 version of Excel.

If I type ver() I get 5.0 Mac 2016

I got the error message on Logistical Regression and nothing else.

However, having now uninstalled the older version completely, I no longer get the error message. What happens instead is that the workbook sort of ‘hangs’ – the background turns white and nothing happens. If I close the dialog box, I get a results page of sorts, but there are no results in it. It has the data replicated, but all the calculation fields are 0 and the r squares are, as a result, errors. There are none of the other calculations in the sheet.

I thought maybe it was an issue of time, so I’ve left it for several minutes but still get this problem. It’s not the size of the dataset either – even if I run it with only 100 rows of data, the same thing happens. Grateful for any advice

Tom

Tom,

I don’t know what is causing these errors. It is important to make sure that you don’t have two or more versions of Real Statistics running at the same time. This will likely cause problems.

If you send me an Excel file with the data that you are using, I can run Logistic regression on my Mac and see whether it runs correctly.

Charles

Charles – sorry I can’t seem to reply to your comment below.

I unistalled everything and it started to work. Deleting the files in their entirety seemed to do the trick.

The problem was the data – two of the variables were (in error) identical so the calculation didn’t work. Apologies for wasting your time.

But can I ask one more question. In the 2011 version, the Logistic Regression package drew a graph and calculated the number of successful estimates from using the model. The 2016 version doesn’t seem to do that. Is that right? The predictions, in particular, were very useful

Thanks again

Tom

Tom,

The 2016 version is identical and should also have the graph and the table with the number of successful estimates from the model.

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

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

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

Hi Charles,

I apologize for writing again but I could not find my previous post.

I have Excel 2011 on a Mac. I have repeated the installation instructions several times but to no avail. When I am in the Add-Ins dialog box, I check the Real-Stats box, and then after I click “OK”, I get the pop-up that states “Can’t find project or library”. When I click OK again, I get prompted for a RealStats password. Other than downloading the Add-In and moving it to the desired location, is there anything else I need to do before including it in the installed Add-Ins in Excel?

Thanks again.

Same here… unfortunately

Pavel,

I found that when I used Real Statistics on my Mac today I also got an error message when I tried to use the Descriptive Statistics data analysis tool. This worked fine the last time I tried it a few weeks ago.

In any case, the following approach resolved the problem for me. I suggest that you try it.

1. I opened a new Excel workbook and selected Add-Ins from the Tools menu and unchecked RealStats

2. Next I closed Excel and then reopened Excel (on a new workbook)

3. I selected Add-Ins from the Tools menu and then checked RealStats.

When I tried to use the Descriptive Statistics data analysis tool this time, it worked fine.

Charles

I had the same issue.

I then decided to install the previous version (Release 3.5.3).

This seems to work fine.

Hi I just installed the pack and it appears when I press Control M but I cannot see any Real statistics Menu in any Menu Bar. Where can I find it pls?

Uwe,

It should be accessible from the AddIns ribbon, but I am not sure whether this feature is working on the Mac. In any case, it is always available by pressing Ctrl-m.

Charles

Dear Charles,

i followed all the instructions and also all the comments you gave to the other..

however I’m having problems in using the add-in.

I created a folder into the office folder in my mac.

Then I installed the add-in as described.

I was trying using it with the same example you posted in the page.

And then I realised I have some problem.. (still don’t know if i’m just not able in using it or if it’s not properly installed).

When I open a blank Excel spreadsheet and then I select Addins from the Tools ribbon, RealStats 2011 does appear on the list with a check mark next to it

If i enter =VER() the outcome is: 5.0 Mac 2016

If i’m working on an excel sheet and I press “ctrl+m” the realista windows appears.. but when i select the input range the message in italian is:

“Errore di compilazione nel modulo nascosto: ‘Analysis’. Questo errore si verifica in genere quando il codice è incompatibile con la versione, la piattaforma o l’architettura dell’applicazione.”

Do you know how to help me?

I would appreciate.

Maby thanks and best regards.

Marco B.

p.s. I’m also reading messages like: can’t find… in the library.. and then a password is required..

Marco,

Please see the following webpage:

Password Prompt

Charles

Marco,

Based on the results from the formula =VER() you have installed the version of Real Statistics designed for Excel 2016 on the Mac. Are you using Excel 2011? If so, you need to install the Excel 2011 version of Real Statistics instead of the 2016 version.

When you select AddIns from the Tools menu, do you see RealStats-2016 on the list with a check mark next to it? Do you see Solver on the list with a check mark next to it?

Charles

Dear Charles,

I have downloaded and followed the steps exactly as listed but excel will not let me use your real statistics resource pack. I have tried to uninstall it too, by unchecking the box closing excel and deleting the files, but then when I open excel and go to tools>add-ins the real stat packs are still listed there, just unchecked. I am not sure if that is a problem or not.

Anyways, I then try to reinstall them and follow the instructions word for word. I have the realstats pack selected, the data analysis selected and the excel solver selected as add ins under the tool tab, but only the latter two show up in the upper corner of excel to be used.

Sorry, I scrolled through all these comments and I realize this is a sort of repeat question, but I am hoping to get some specific advice. let me know if I can provide you with any more information. Also, thanks for making this, I’m sure once I get it going it is going to be fantastic.

-Max

Max,

1. You say that Excel won’t let you use the Real Statistics Resource Pack. How is this communicated to you? If it is an error message, what does the message say?

2. When you install Real Statistics, are you able to press the key sequence Ctrl-m ? If so what do you see? What do you see when you enter the formula =VER() ? What version of Real Statistics are you using? The one for Excel 2011 or Excel 2016?

3. When you unintall Real Statistics, you say that the real stat packs are still listed among the addins. You use the plural word packs; are you trying to install more than one version? If so, what happens when you install only one of the versions?

4. When you uninstall any Excel addin by removing the check mark, it doesn’t go away from the list of addins (since you may want to reactivate it later by replacing the check mark). If you then delete the file containing the addin, when you try to check the corresponding addin you will receive an error message prompting you as to whether you want to delete the addin from the list. If you say yes, then the addin will be removed from the list of addins.

Charles

Good Afternoon,

I am quite excited to run a logistic but am unable to access the software. I am using a 2016 Mac version and after spending countless hours downloading and installing, I have given up. I had the Solver running/checked, downloaded the compatible version, and just do not see it as an “Add In” anywhere. I expected a tab to pop-up and tried to find it under the standard data analysis pack.

Please help if you can.

Best, Derek

fyi, “Can’t find projects or libraries ” is the error message.

Derek,

When you select AddIns from the Tools menu do you see Solver and RealStats Mac 2016 on the list of addins? If so, then make sure there is a check mark next to both of these and press OK. If RealStats Mac 2016 is not on the list of addins, then click on the Browse button to locate the file containing RealStats Mac 2016. After completing this process make sure that Solver and RealStats Mac 2016 are on the list of addins with check marks next to them.

You can now use the software by pressing Ctrl-m.

You will know that things are working properly when a dialog box appears after pressing Ctrl-m.

If this doesn’t work, please tell at which step in the process you get an error message.

Charles

Hello,

I’ve been using this software for a class and have had no problems until recently. I had to turn on the add-on again and now whenever I attempt to run any tests I get an error message that reads, “Compile error in hidden module: Analysis”

Any ideas as to why this is happening and how to fix it?

Thanks!

Becca,

I don’t know why this is happening, but let me ask you a couple of questions to try to identify what is causing this.

Which version of the Mac software are you using: Excel 2011 or Excel 2016? What do you see when you enter the following formula? =VER()

Charles

Hi Charles,

When entering the formula it says 5.4.2 Mac Excel 2016

I’ve redownloaded the software and everything seems to be working fine now! Thank you for your help!

– Becca