Real Statistics Resource Pack for Macintosh

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. This version of the software has only been tested with Excel 2011.

Download

If you accept the License Agreement, click here on Real Statistics Resource Pack for Mac to download the latest version of the resource pack that works with the Mac version of Excel (Release 3.5.3).

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.

  1. 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.
  2. Open Excel, but don’t try to open the realstats-2011.xlam file that you downloaded earlier.
  3. From the Tools menu choose Add-Ins.
  4. Check the Realstats option on the dialog box that appears and click the OK button.
  5. 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 4 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. There are some limitations in the Mac release of the software, namely ranges must be entered in the dialog boxes manually (i.e 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 do work. Also some of the data fields in the dialog boxes will be truncated. These issues will be fixed in the future.

Uninstalling the Real Statistics Resource Pack

  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. Uncheck the Realstats option on the dialog box that appears and click the OK button.

112 Responses to Real Statistics Resource Pack for Macintosh

  1. M. says:

    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

    • Charles says:

      Unfortunately, the Mac version of the software doesn’t yet contain all the capabilities that the Windows version has.
      Charles

  2. Steph says:

    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

  3. Nur H says:

    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!

    • Charles says:

      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

      • Nur H says:

        Command+M in Mac minimizes the window to the dock.
        Control+M gets the Real Stats to work 🙂

        • Charles says:

          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

  4. Alex says:

    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

  5. Elton says:

    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?

    • Charles says:

      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

      • Aaron Phillips says:

        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 🙂

        • Charles says:

          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

          • Aaron Phillips says:

            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 🙂

  6. Andrea says:

    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!

  7. paolo bernardis says:

    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

  8. Jeff Russell says:

    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!

  9. Rach says:

    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?

    • Charles says:

      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

  10. Harsh Hemani says:

    Hi Charles , Thank You for developing this software. Can this software be used with Excel 2016 for mac ?

    • Charles says:

      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

  11. Charles Smith says:

    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!

    • Charles Smith says:

      I wanted to also add that it asks me for a password as well.

      Thanks!

      • Charles says:

        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

    • Camilla says:

      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

      • Charles says:

        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

        • marco says:

          ho lo stesso problema, mi sta dando parecchio fastidio

          • Charles says:

            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

          • marco says:

            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

          • Charles says:

            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

          • marco says:

            si ho fatto così, comunque l’ho rifatto ed è sempre uguale, quando provo ad usarlo mi dice “errore di compilazione del modulo nascosto analysis”

          • marco says:

            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?

          • Charles says:

            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

  12. Kieron Salmon says:

    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.

    • Charles says:

      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

      • Milos says:

        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.

  13. POTDEVIN says:

    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

    • Charles says:

      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

  14. Alaa Abdel-Hamid says:

    How to get the command KSDIST(x,n) and run it

  15. Rebecca S. says:

    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

    • Charles says:

      Rebecca,
      I haven’t yet added Jenks to the Mac version of the software. It is currently only available in the Windows version.
      Charles

  16. Susan Polos says:

    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!

    • Charles says:

      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

      • Matt says:

        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!

        • Charles says:

          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

  17. Mike says:

    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.

    • Charles says:

      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

  18. Daniel Augusto says:

    Does this solve the problem of having no ActiveX on Mac? Does this replace the ActiveX?

    • Charles says:

      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

  19. Tony says:

    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.

  20. Lee says:

    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!

    • Charles says:

      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

  21. Garry says:

    Do you have a version for google sheets? I use a chromebook.

  22. Jonathan says:

    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

    • Charles says:

      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

  23. Cyndi says:

    All is well with the download and install but the menu is way too small, even for my good eyes.

    • Charles says:

      That seems to be the default size that Excel/Mac chose. I will try to make it larger in the next release.
      Charles

  24. Owen says:

    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.

    • Charles says:

      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

  25. AR says:

    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

    • Charles says:

      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

    • Charles says:

      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

  26. Dee Wu says:

    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

    • Charles says:

      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

    • Charles says:

      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

  27. Jeff Hovermill says:

    Requested Feedback:

    The Fill button does not work with Excel 2011 and OS X 10.10.2

    Thanks

    • Charles says:

      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

  28. Ed Costello says:

    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

    • Charles says:

      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

      • Ed Costello says:

        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

        • Charles says:

          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

  29. Ed Costello says:

    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.

  30. jim says:

    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

    • Charles says:

      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

  31. Richard Libby says:

    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.

  32. SLY says:

    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

  33. DG says:

    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

    • Charles says:

      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

      • Marielle says:

        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!

        • Charles says:

          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

          • barbara says:

            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?

          • Charles says:

            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

  34. Frank Branch says:

    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.

    • Charles says:

      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

  35. Alistair Cullum says:

    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

    • Charles says:

      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

      • Maryam says:

        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

        • Charles says:

          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

          • Ricardo says:

            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

          • Charles says:

            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

    • Charles says:

      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

  36. wayne minobe says:

    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

    • Charles says:

      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

  37. Mark says:

    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

    • Charles says:

      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

  38. Seth Vitrano-Wilson says:

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

    • Charles says:

      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

  39. Joe Lucyshyn says:

    Your statistical package with instructions looks very useful.

Leave a Reply

Your email address will not be published. Required fields are marked *