The Real Statistics Resource Pack contains a variety of supplemental functions and data analysis tools not provided by Excel. These complement the standard Excel capabilities and make it easier for you to perform the statistical analyses described in the rest of this website.
On this webpage, we describe how to download and install the Real Statistics Resource Pack for the Mac.
Download
If you accept the License Agreement, click on one of the following options to download the appropriate version of the Real Statistics resource pack for Excel on the Mac:
- Click here on Real Statistics Resource Pack for Mac 2016/2019/2021/365 to download the latest version (Release 9.3) of the resource pack for Excel 2016, 2019, 2021, or 365 for the Mac.
- Click here on Real Statistics Resource Pack for Mac 2011 to download the latest version (Release 5.11) of the resource pack for Excel 2011 for the Mac.
Downloading this resource pack means that you accept the License Agreement.
Installation
Once you have downloaded the Resource Pack, you need to install it using the following steps.
- Move the Resource Pack to where you want it located on your computer. Caution: Once you install the resource pack at a particular location it will be more difficult to move it later.
- Open Excel, but don’t try to open the xrealstats-mac.xlam or realstats-mac-2011.xlam file that you downloaded earlier.
- From the Tools menu choose Add-Ins.
- Make sure that the Solver option is checked on the dialog box that appears.
- Check the XRealstats-Mac (or Realstats-Mac-2011) option on the dialog box that appears and click the OK button.
- If the XRealstats-Mac (or Realstats-Mac-2011) option doesn’t appear, click on Browse to find and choose the XRealStats-Mac.xlam (or RealStats-Mac-2011.xlam) file that you downloaded earlier. Then complete step 5 as described above.
Real Statistics Functions
Once you have installed the Real Statistics Resource Pack you can use the supplemental functions in the same way as you use the built-in worksheet functions supplied with Excel. These functions are described throughout the rest of this website. A complete list of these functions can be found in the Tools menu of the website.
Real Statistics Data Analysis Tools
To use the data analysis tools enter Control-m (i.e. control key + m) or click on the Real Statistics menu.
The descriptions of how to use the Real Statistics functions and data analysis tools apply to the Mac version of the software, although sometimes with minor modifications especially as described in Mac User Interface.
Uninstalling the Real Statistics Resource Pack
- Open Excel, but don’t try to open the XRealStats-Mac.xlam or RealStats-Mac-2011.xlam file that you downloaded earlier.
- From the Tools menu choose Add-Ins.
- Uncheck the XRealStats-Mac or RealStats-Mac-2011 option on the dialog box that appears and click the OK button.
- Close Excel and delete the file that contains the Real Statistics Resource Pack.
Have just downloaded Real Statistics Resource Pack but unable to successfully install because after the Add In in Excel Tools I cannot see the Solver check box! Am using Excel 2016. Any help?
Hi Jay,
See
https://youtu.be/HLqx1LF9LUE
https://www.howtoexcel.org/install-solver/
https://learnexcel.io/add-solver-excel/
Charles
Jay,
I see that you use a Mac. In that case, you need to use the Mac version of the approaches I sent you earlier. For example:
https://learnexcel.io/add-solver-excel-mac/
Charles
Hi Dr. Zaiontz,
I am using the RealStats package on a 2019 Intel Mac running Sonoma 14.5. I am using Excel from Mac Office 2019 (version 16.78 build 23100802). I have been using the control+m pop up window to do some tests on data and things were working very quickly at first but now, when I try non-parametric tests (Wilcoxon), it only worked once and now freezes Excel. I have to force quit Excel and, when I try to sign in again, the RealStats program is still hanging and won’t do any other tests. I can use Excel, but the spinning busy wheel comes up every few seconds and I can’t use Excel during those intermittent freeze times.
I have been using RealStats for years now, so this is most likely some Excel update issue. Thank you for going the extra mile to help us all out with statistics! We have R and access to SPSS but I do not have time to become a programmer or redo everything to make it easier in SPSS. Having RealStats is a lifesaver!
Hi Bryan,
I don’t know why you are having all these problems with the Mac version of the Real Statistics software. I have only seen these sorts of problems when I have a big Excel workbook open (e.g. some of the workbooks that you can download from https://real-statistics.com/free-download/real-statistics-examples-workbook/).
Since you are using one of the most recent versions of Mac Office, you may be able to use the Windows version of Real Statistics even on the Mac. I suggest that you try the Realstatsx.xlam version downloadable from https://real-statistics.com/free-download/real-statistics-resource-pack/). Perhaps this version won’t produce the same set of problems. I can’t say for sure, but it may be worth a try.
Charles
Hola.
No encuentro la función “Kappa de Fleiss”, solo kappa de Cohen. Me puedes ayudar, por favor?
Hello Marjorie,
Press Ctrl-m and then choose the Interrater Reliability option from the Corr tab. You will find both Fleiss’ Kappa and Cohen’s Kappa.
Also see https://real-statistics.com/reliability/interrater-reliability/fleiss-kappa/
Charles
I just downloaded the mac version, and when I try to open it using the command+m the page closes. Let me know if I am doing something wrong.
Hello Ana,
What do you see when you enter the formula =VER() in any cell?
Charles
9.0 Excel 2016/2019/2021/365 Mac
Hello Fernando,
Are you having problems with logistic regression?
Charles
Hi Carles, I have downloaded and tried to install RS_QAT, RealStatX and XRealStatx, but when I try according to the instructions you’ve made, in my excel a warning appears like this “This file type is not supported in protected view”. What should I do Charles?… and may I ask one question about dL and dU for my Autocorrelation test if N=294, k=3 and sig=0.05…. thanks for your answer it will be very helpful
Hi Fajri,
Did you get this error message after trying to open the Real Statistics file that you downloaded?
Charles
why is real statistics still coming up when I click control m if I deleted it?
I am not sure why this is happening, but I suggest that you follow the Uninstall instructions at the bottom of this webpage.
If this doesn’t solve the problem, restar t your computer.
Charles
Hey there, I am getting an error telling me that Microsoft office has blocked the content because of bad macros with known issues. I got this on my personal and work computer, so maybe something it going on. Any thoughts?
Hello Danny,
What is the message that you got blocking the content?
Have you consulted the TRoubleshooting section on the webpage from where you downloaded the Real Statistics software? This is especially important since you probably need to change the Trust setting for the Xrealstats-Mac.xlam file (as explained in the Troubleshooting section).
Charles
Hi Charles,
I’m using Excel 365 on my MacBook Air. I’ve downloaded the link multiple times and when the Add-ins dropdown populates the tool bar, where the real stats dropdown is supposed to be is blank and I can’t use it. I’m trying to do an assignment which requires this extension but it’s not working for me on Excel.
Do you have a solution for me?
Hi James,
To access the Real Statistics main menu on the Mac, you need to press the key sequence Ctrl-m.
I use the ribbon for the Windows version, but I never figured out how to get this to work on the Mac.
Charles
Maybe this would work? Seems it has to be done in Windows and then brought over?
https://macexcel.com/examples/ribbonpages/changetheribbon/
Don,
Thanks for the link. I will look into it to see whether I can use this approach.
Charles
Don,
This seems like something each user needs to do on their own computer. Do you know of a version that I can add to the Real Statistics software?
Charles
Hi Charles, I am attempting to install the package but when I drop down the tools, tha Add-ins is watermarked and hence not active, what can I do?
Thanks, Silverio
Hi Silverio,
I am not familiar with watermarking an add-in. What sort of message did you get (even if it was in a language that isn’t English)?
Charles
Thanks Charles, I managed to get it installed aftr I updated my Xcell version, btw, how do I choose the Stukey HSD calc option?
Silverio
Hello Silverio,
If you want to use Tukey’s HSD after a one-way ANOVA, then you should choose the One Factor Anova option from the Anova tab (after pressing the Ctrl-m key sequence). Tukey’s HSD is one of the options on the dialog box that appears.
Versions of Tukey’s HSD are also available after other versions of ANOVA (and other designs).
Charles
Hi Charles,
I just installed and sucessfully opened Xreal Stats on Mac (most recent version), but the window is very small. Is that normal? I can’t change the size of it…
Thanks!
Hi Germaine,
See https://www.real-statistics.com/appendix/faqs/enlarge-dialog-box-on-mac/
Charles
Hi Charles,
I have been using your amazing software for years now but my mac and its excel version, sadly were no longer supported. On my new mac (with the 16.60 excel version) I have kept on trying to install the Real-Stats file by following your instructions but didn’t get the Real-Stats option in my add-ins list, just the dreary dropdown arrow, until I came to this site and realized I wasn’t the only mac user experiencing this recurrent problem. Thanks for the very helpful answer you gave to Alan!! (And thanks Alan for asking!)
I pressed Ctrl-m and as if by magic all the old tricks were active again. I was able now to access the familiar data analysis tools!
Many, many thanks for this invaluable software! (And, “invaluable” is an understatement…)
Ernesto
Hi Ernesto,
Glad that it is still working for you. Thanks for your support over the years.
Charles
Hi, i did all the steps but when i start to generate the dat it pops out an error “Compile error in hidden module: LogisticRegression”. This error commonly occurs when coe is imcompatible with the version, platform, or architecture of this application.
Hello Veronica,
If you email me an Excel file with your data and tell me what you have entered into the dialog box, I will try to understad why you are seeing this error message.
What release of Real Statistics are you using? Also, what language is Excel using (English, Spanish, etc.)?
Charles
Hi Charles,
I am using Excel 365, and i used the first link to download Real Statistic. The language is English. Is there some error with my excel thus coming out this error message?
Veronica
Hello Veronica,
Thanks for the information.
If you email me an Excel file with your data and tell me what you have entered into the dialog box, I will try to understand why you are getting the error message.
Charles
Hi Charles, may i have your email so i can email it to you?
Veronica
See
Contact Us
Charles
Im having the same problem. with the same error message.
“Compile error in hidden module: ‘LogisticRegression’. This error commonly occurs when code is incompatible with the version, platform, or architecture of this application.”
Hello Patricio,
I am aware of a problem with the Logistic Regression data analysis tool on the Mac. I know that it works fine in the Windows version and the code is the same. As a result, I haven’t been able to track down the problem yet.
Charles
THANKS. YOU ARE DOING THE LORDS WORK
Hi, I am very frustrated right now and I need help because my assignment is coming and I have to answer it. I have already downloaded the Xrealstats for mac and I tried the steps above but sadly it says there was a problem and Microsoft excel was closed. Please apologize for the inconvenience. I just need the Megastat for my school I hope you can reply to me I’m looking forward to it. Thank you and God Bless
Hello Crystal,
What sort of error message did you receive? Which of the Troubleshooting steps did you try?
I don’t know what the Megstat is.
Charles
Hi Charles, I have tried to install for Mac but don’t get the Real-Stats option in my add-ins list, just an empty dropdown arrow (i.e. it thinks there’s something there but won’t show it).
Any ideas? Thanks. I’ve used the package successfully on Windows but prefer to use on Mac!
Hello Alan,
I have not added this support for the Mac version. You need to press the key sequence Ctrl-m to access the data analysis toolds.
Charles
i have the same problem, ctrl-m es for minimize….
solved, I used ctrl-m, thank you.
I downloaded and installed the Xrealstat for Mac just now – and seeing the same problem as Alan.
Pressing ctrl-m key – nothing happens. Can you please give a few more details of how to activate or start using your package. Am interested in doing some Survival analysis / kaplan-meier for the clinical trial I am supervising. You help and making this available is greatly appreciated. Thanks
Hello Gobi,
First of all, let’s make sure that Real Statistics is installed. Enter the formula =VER() in any cell. If you get an error value then Real Statistics is not installed. If you see a release number less than 8.0 then you are using an earlier release. This isn’t a problem unless the release is very old.
If you see that Real Statistics is installed, then you need to make sure that you are using the correct button on the Mac for Ctrl. On the Mac there are the Control, Option and Command buttons. I believe that you need to use the Control button (the leftmost of these three buttons). You need to hold this button down and then press the key for the letter m (lowercase). Make sure to keep the Ctrl button down while pressing m (pressing these keys in sequence won’t work).
Sorry if all of this is obvious, but I wanted to make sure that this is not the problem.
Otherwise, I don’t see why pressing Ctrl-m doesn’t bring up the initial Real Statistics dialog box.
Charles
Thanks，I get it and success！！！
Personally, I select the range in which I expect results and do an array formula (control+shift+enter)
Hi Charles,
My excel has been crashing anytime I’m trying to run a correlogram under the time-series tab. I’m reinstalled the addin a lot of times but I keep getting the same result. (excel crashing). I used a Mac.
Hi KJ,
Which version of the Real Statistics software are you using? Which version of Excel are you using on the Mac?
Charles
I installed the real stistic for mac, excell 2019. I did all the steps you said but when I tried to analize kappa results only showed “?NAME?”. Ii means that I don’t have the tool to analize kappa?
Thanks a lot
Hello Andrea,
Perhaps Real Statistics is not installed. What do you see when you insert the formula =VER() into any cell?
Charles
This works ok, but everytime MS365 updates on either Mac or on PC it deletes this programme and you have to go through the whole installation process again, which I find quite annoying :td:
Steve,
That is strange. I am using Excel 2016 on my Mac and so I can’t test this. I have not experienced this problem on my Mac.
I use Excel 365 on my Windows computer but don’t seem to have this problem.
Do you have any other Excel add-ins active?
Charles
Hi Charles,
I have been using the real statistics software for past few months and up until yesterday it was working great. However, starting yesterday we began to use the “One Repeated Measures Anova” and for some reason the real statistics (or excel) is not working correctly – I keep getting strange random symbols and incorrect functions in the output table. I have tried to do basic IT fixes such as: restart my computer, update computer, uninstall real Statistics, uninstall excel, reinstall excel and real statistics. Unfortunately, none of these have worked. For your reference I have the most current version of excel and a 2020 MacBook Pro.
Hello Jackson,
I just ran the Repeated Measures ANOVA on the Mac version of the software and it worked fine. I don’t know why you are getting strange results. Can you email me your input data so that I can check it out?
Charles
Just sent you an email with the file and screenshots of the process that I am going through. Thank you for your response and let me know if there are any issues with opening the email. Would like to get this resolved as quickly as possible.
I have just sent you a response.
Charles
Hi Charles,
I think I’m experiencing the same problem as Jackson (having random characters for F stats and p values when running ANOVA). Would there be a solution for that? Thanks!
Hello Jerry,
I just tried again to replicate the problem that Jackson identified. Unfortunately, I am running Excel 2016 and not Excel 365 on my Mac. I am not seeing the problem that you and Jackson raised. I don’t have a good way to duplicate the problem.
Are you seeing similar problems when running other data analysis tools?
Charles
Hi! I am trying to follow your video “Logistic Regression Using Excel” and I downloaded the pack but don’t see a Logistic Regression option. I only see Logistic and Probit Regression or Multinomial Logistic Regression. Which one do I use?
Logistic and Probit Regression
Charles
Hi Charles,
The Factor Analysis function in the latest version of the Excel Add-in produces negative values in the Factor Matrix (rotated varimax) instead of the positive values shown in the previous version. Please help. Many thanks in advance.
Best,
Monica
Monica,
If I understand your situation properly, this should not be a problem. You can use the negative of the matrix if you prefer. The sign of this matrix is arbitrary.
Charles
Great little add-in, although the real statistics pop-up menu when pressing Control+M is absolutely tiny on the iMac. I have a 27″ screen and the pop-up is a mere 3″ across and 2″ high – I need to strain and look closer to read the pop up.
Steve,
Thank you for your kind remarks.
I know that the pop-up menu is tiny on the Mac version. I have the same problem when I use my Mac.
Unfortunately, this is the size of the dialog boxes produced by VBA on the Mac. The only way I know of for increasing the size of the dialog boxes is to increase the size of everything on the Mac (configuration option at the Mac level)
Charles
Sorry for my earlier message on dowload issue. Found the right link on your site and got it installed in my Mac 365 version of excel. Will try it out and revert if I have any problems in using the Survival analysis function. Thanks very much for providing this free. Greatly appreciated.
warm regards
Bhuvanesh / India
Hi, I have already followed the 6 steps. However, upon checking on my Excel file under Add-ins, nothing appeared. Note: I am using Macbook Pro with the latest update.
Alex,
To open the Real Statistics main menu on the Mac you need to use the key sequence Ctrl-m. Access via the Add-ins ribbon only works currently on the Windows version. I will add this capability once I learn how to implement it on the Mac.
Charles
Dear Charles,
Thank you very much for providing us such a powerful set of tools. I truly appreciate your work!
I am also writing you beacuse I have an issue with the plug-in in excel 2016 for mac. I would like to use the BOXCOX function but I am not sure how to include the Lambda computed via BOXCOX Lamba function.
I found this video (in Spanish) showing how to use the function in a sort of dialog box—this allows the user to select the range and the lamba generated. Would you please advise on how to use this command as showed in the video, but using the mac interface. Cheers!!!
HERE’S THE VIDEO- SEE MIN 12
https://www.youtube.com/watch?v=0HsQSPvDyYk
Rafael.
Thanks for letting me know about this video.
Charles
Hello Rafael,
To fit normalized data, the BOXCOX(R1, λ) function can be used. If you omit the lambda parameter then the value of lambda that best normalizes the data is used based on the maximum log-likelihood function. This is explained at
https://www.real-statistics.com/correlation/box-cox-transformation/box-cox-normal-transformation/
Charles
Thank you for your prompt reply, Charles.
Now I feel silly for not finding the box cox page myself. Your website is a true font of fun and knowlede. Thanks againg for your gracious work, amigo. Best vibes from Mexico City!
No problem, Rafael. Good to speak with someone from Mexico City.
Charles
Whenever I try to download it says I need a password. The resources you provide for the password error only work for Windows.
Autumn,
When exactly do you receive the password prompt?
Do you receive the prompt when download the add-in or when you try to install it? What happens when you enter the formula =VER() in any cell? What happens when you press the key sequence Ctrl-m ?
Charles
Hi Charles,
I get the password prompt too. This is after the installation of real statistics add in.
Warm regards,
Divya
See Password Prompt
Charles
I am getting an error when I run a Logistic/Prob regression. It is an error 13 run time. Can I get some help trouble shooting this? I am on a MacBook Pro
Tim,
If you send me an email with an Excel file containing your data, I will try to figure out why you are getting this error message.
Charles
Sent. Thank you
Hey Tim,
I’m facing the same issue at the moment while trying to run a logistic/prob regression. Have you been able to resolve this issue yet?
Siddesh
Hello Siddesh,
I ran Tim’s example on my Mac running Excel 2016 and it worked perfectly.
Charles
Hello. I am getting a Run time error 13 : type mismatch when I am running a logistic/probit regression on a MacBook pro. Can I get some help with this issue please?
hi Charles,
After I instala it, I don’t know why it need password?
please help me figure it out,thanks so much!
See Password Prompt
Charles
Dear Charles,
Wonderful resource!
I have been able to make it work following your installation instructions. However, each time I close Excel I lose the CTRL-m functionality and Add-Ins is removed from the toolbar. If I go through the sequence again of Options> uncheck XRealstats > recheck XRealstats it works again. Is this by design or should CTRL-m remain available each time I re-open Excel?
Thanks for your help.
Luk
Sorry, forgot to mention: I am running Excel 365 on a PC.
Luk,
Glad that you like the Real Statistics software.
See Disappearing Ribbon
Charles
I agree
Hi there!
I am having issues with removing the constant from an ARIMA model.
It seems to be ignoring when I uncheck the checkbox.
I am using Excel 365 for Mac.
Thanks!
Jose,
Can you email me an Excel file with an example of this problem?
Charles
Hola lo descargue muchas veces y cuando presiono complementos me sale todo blanco me parece que no lo lee? mi Miscrosof es 365 e instale para ese
Melany,
It is not sufficient to download the add-in. You need to follow the installation instructions as well.
Charles
Hello Charles
Working with Realstats-2011 (ver 3.5.3) I never encountered problems (I work with Excel for Mac 2011). Now, when I uploaded and installed Realstats-Mac-2011, it does not work.
Solver.Xlam and Realstats-Mac-2011.Xlam are checked in Add-in window. VER() gives 5.11 Excel Mac 2011 »
When I tried to run this version for the first time I got a message : « Projet ou bibliotheque introuvable » (I use French version of Excel) and then « Mot de pass? » When I ignored, I could open Data Analysis Tool, select, for example, Multiple Linear Regression and enter input ranges. But when I press « OK » I got a message « Erreur de compilation dans le module caché: Regression » (or Analyse, or whatever I try).
Can you help?
Thank you
Janusz
Hello Janusz,
See the following webpage:
https://real-statistics.com/appendix/faqs/compile-error-in-hidden-module/
This addresses a similar problem for the Windows version of Real Statistics, but it should be helpful for the Mac as well.
Charles
Hello, I have downloaded a few times and redownloaded and am able to use Ctr+M although when I go to run the data into real stats I get the error message “Run-time error ‘1004’ Application-defined or object-defined error”. This is being used in a class so I know that I am plugging it in correctly. Any thoughts?
Hello Heather,
If you email me an EXcel file with your data and specify what test you are trying to run, I will see whether it works properly on my computer.
Charles
I’m having trouble using the Add-in. Ctrl-m is not responding and it does not appear on my ribbon. Do you know what I might be doing wrong?
Hello Alyssa,
What do you see when you enter the formula =VER() in any cell?
Charles
7.2 Excel 2016/2019/365Mac
Alyssa,
The Mac version of Real Statistics won’t appear on the ribbon, but Ctrl-m should work. Did you try Command-m ?
Charles
Hi Charles,
I have installed Real Statistics package in my Excel for Mac ver 16.39 with no problems. The ” =ver()” shows a “7.2 Excel 2016/2019/365 Mac” message successfully. However, when I try to use the function “=icc” in any array it shows three diferent values as the result. This does not happen when I use the package in an old version (16.21) excel for mac. Is there anything I can do to sort this out in the newer excel version?
Thanks.
The ICC function is an array function and so it returns multiple values. These are described at
https://real-statistics.com/reliability/interrater-reliability/intraclass-correlation/intraclass-correlation-continued/
The first value is the ICC and the other two describe a confidence interval. If you insert a formula using the ICC function into one cell then you will only get the ICC value.
Charles
Thanks! By the way, congrats for this wonderful tool!
Hi Charles, I am using Microsoft 365 for Mac Version 16.38. After I installed the add-in following your steps, it showed nothing but an empty down arrow in the “Add-in” tab, which does not contain any item under that arrow and there is nothing showed after I click to the arrow.
I have read your previous comment about pressing Ctrl-M, but it does not work for me. I also reinstalled the add-in for few times but the problem continue to exist.
Hello Jason,
For the Mac version, only the Ctrl-m option works. This is an uncapitalized “m”. I suggest that you try the Command button as well as the Control button.
I also suggest that you insert the formula =VER() in any cell on a blank spreadsheet. If you don’t get a suitable output then the software is probably not installed correctly.
Charles
Hi Charles,
I am just beginning to learn about logistic regression, and I am trying to practice with a data set I have. I have a Mac and downloaded the most recent stats resource pack.
I keep getting a compile error when I use the Logistic and Probit Regression menu option; however, I am able to generate an output that seems valid when I run the Multinomial Logistic Regression. This doesn’t seem correct though because my dependent variable is dichotomous. Any ideas on why this might be happening? Thanks!
If you email me an Excel file with your data, I will try to figure out what is going wrong.
Charles
I am facing the same issue! Any solution?
Shaili,
See Compile error in hidden module
If this doesn’t resolve the problem, you can email me an Excel file with your data and I will try to figure what has gone wrong.
Charles
Hey Charles, Microsoft excel 2016 and Mac. Whenever I try to browse real XRealStats-Mac. The excel stops working and message pops up Microsoft Excel is not responding. I tried uninstalling and reinstalling XRealStats-Mac but its not working in any case. Whenever I try to add in resource pack and select browse the excel shuts off
Hello Meshal Shahid,
You shouldn’t try to browse XRealStat-Mac. You need to install it as described on this webpage.
Charles
Sorry for the inconvenience. Install the pack on an Excel 365 for Mac, it accepts it, but I can’t see the add-in in complement. The window appears empty with only one down arrow. I installed and uninstalled it several times but the problem continues. What am I doing wrong and how is it solved? Thank you in advance for the answer. Regards.
Hello Rodolfo,
On the Mac version of the software, you need to press Ctrl-m. The Add-in approach only works in Windows. I will eventually add this capability to the Mac.
Charles
Thank you so much, It’s work
Best Regard
Rodolfo
HELLO Charles,
I downloaded de Max Excel 2011 version, but when i run, e.g. a chi-square analysis, the system sends a message “compile error”. DO you know what could be happening?
Gabriel
If you send me an Excel file with your data and output, I will try to figure out what is going wrong.
Charles
It is asking for a password from realstat… Any suggestions?
See Password PromptPassword Prompt
Charles
Hi Charles,
Is there a way to apply a box-cox transformation to forecasts that are returning negative values?
Thanks,
Henry
Henry,
One approach is to add a constant to all the data values so that none of the data or forecast values are negative.
Charles
Dear Charles,
I am using a mac and a 365 Excel version. I used to work on Real statistics ok, up to when the Office performed an update last week. Now I cannot use it any more, and when I try to re install, I do not get that window anymore to check the Add-in as you describe in the installation process. I am now prompted to follow this new Add-in platform that office has. Am I doing something wrong, or missing something?
Thank you!
Hello,
I am sure that Excel 365 for the Mac still supports add-ins and so I am sure that it is still possible to use the Real Statistics software on your computer. There is nothing special about the installation instructions for Real Statistics (except that Solver must also be installed). You just need to follow the installation instructions for using any Excel add-in.
What is the new Add-in platform for the Mac? I use Excel 2016 for the Mac and Excel 365 for Windows and am not aware of any changes.
Charles
Hi Charles, I’m using an Office 365 Abonnement License from my university. When I’m installing the package for my MacBook Air, I can search and find it for checking the box for the add-ins, but when it’s checked I cannot find it in the tools. There are 3 little arrows I can click on but it doesn’t work. I tried to deinstall it by unchecking the package and deleting it. But these 3 little arrows didn’t go away. I tried to download it again but it’s still the same and doesn’t work.
Do you have an idea what I did wrong?
Thank you and kind regards!
Liz
Hi Liz,
Just press the key sequence Ctrl-m
Charles
Hi Charles, thank you for your answer! It worked!
I have another question. I’m trying to do a logistic regression. Is there a chance you have some kind of “tutorial” on how to interpret the outcomes for the logistic regression with the Resource Pack.
Thank you again for your help!
Kind regards
Liz
Liz,
Yes, see Logistic Regression
Charles
Hi Charles,
What is the best one to download when using excel 2020?
I am having a problem where i can get the real stats menu to open in excel but it wont let me select any data to fill the ranges out. I have done everything from uninstalling and reinstalling, to shutting down excel, checking excel is up to date and restarting my computer and nothing helps.
Simone,
Can you enter the ranges manually, i.e. by entering something like A1:C20 ?
Do you see the + button next to the input range field? On the Mac you need to click on this button to select a range. You can also click on the Fill button to fill out a range. See https://real-statistics.com/real-statistics-environment/mac-user-interface/ for details.
Charles
Simone,
If you are referring to the latest version Excel that runs on the Mac, then this is the right place to download from.
Charles
Hi Charles,
I am using Microsoft Office 2019/365 for students. I have done the steps instructed but I am getting an error. “Microsoft Visual Basic Unexpected Error: 50001”. When I put in VER() I get #NAME?. I have tried to also uninstall the XRealStats-Mac add in and try the newest one but still no luck. Please Help!
Regards,
Matthew Le
Hi Matthew Le,
I suggest that you uninstall XRealStats-Mac again. Then reinstall the software, but first rename the file XRealStats-Mac1.
Charles
Hey Charles,
I tried the above and it still shows up as an error. Anything else you suggest? I tried to access the Visual BasicEditor but it says that it is out of memory and I am not sure what to do.
I can’t think of much else to try. You can try restarting your computer. You can try uninstalling and reinstalling the software.
Charles
Hi Charles,
Thank you for making this package available. I have assigned a homework for my students using the multiple regression function with HC standard errors. Most students are PC users and find that it works like a charm. Mac users have reported the following problems:
(1) The y range cannot be selected in the same way that the x range can. It has to be typed by hand. Not critical, but just an annoying bug.
(2) More problematically, the error message “Input Range X and Input Range Y must have the same number of rows” appears. The range selected is A1:A163 for x and B1:B163 for y, so there is no obvious reason for this message.
We are stumped. Can you help?
Thanks,
Zack
Hi Zack,
Thanks for bringing these bugs to my attention. I will be issuing a new release of the Real Statistics software later today that corrects these errors.
Charles