The Real Statistics Resource Pack is an Excel add-in that provides a number of supplemental statistical functions and data analysis tools. For a list of these capabilities, click on any of the following:
- Real Statistics Distribution Functions
- Real Statistics Non-parametric Test Functions
- Real Statistics Descriptive Statistics, Reformatting, and Misc Functions
- Real Statistics Regression and ANOVA Functions
- Real Statistics Multivariate Functions
- Real Statistics Time Series Analysis Functions
- Real Statistics Advanced Missing Data Functions
- Real Statistics Bayesian Analysis Functions
- Real Statistics Data Analysis Tools
In addition, you can also access a summary of standard Excel functions and data analysis tools as follows:
I also had the “Error 424 Object required” message when trying to start a test from the main menu (accessed via Ctrl-M). Version is 9.5.5 in Office 2024 on LTSC.
I followed Charles’ suggestion to enable ActiveX controls, but that didn’t help. What did the trick was to go into Trust Center – Macro Settings and check “Enable VBA” macros AND ALSO check “Trust access to the VBA project object model” below “Developer macro settings”
Hurling,
Thanks for sharing this information.
It seems that sometimes changing the trust setting resolves this problem and sometimes changing the ActiveX setting does the trick.
Charles
Dear Charles,
we are using your tool in high education, and now in new istallation Win11 and Office 2024 LTSC, there is a problem. If I would like to run any tool there is an error: “Microsoft Visual Basic Run-time error 424: Object required.
Could you help us please? Thank you very much.
Dear Marek,
What do you see when you enter the formula =VER() in any cell?
Charles
Sir, I have the same issue, and my version is 9.4.5
Hello Puneet,
Which issue are you referring to?
If you are receiving a run time error, can you email me the spreadsheet that is producing the error?
Charles
Sir
I am referring to Microsoft Visual Basic run-time error 424, object required
I have Office 2024 LTSC version installed on my Laptop
I emailed the snapshots of error
Hello Puneet,
Thanks for the clarification. I got your email yesterday and responded.
Charles
Hi Charles,
I am having the same issue … Run-time error ‘424’: Object required when attempting to run any of the real-statistics functions. I’m on a Windows 11 machine with LTSC 2024 Excel ver. 9.5.5. I have checked to make sure the installation followed all the instructions … trusted directory, unblocked, etc.. The error occurs using any spreadsheet, including a blank workbook. Can you provide any guidance on how to resolve this?
Thanks!
Hi Dick,
Quite a few people have encountered similar error messages lately. You can find a resolution at
https://real-statistics.com/appendix/faqs/Resolve%20error%20when%20choosing%20any%20option%20from%20main%20dialog%20box
Charles
I would very much like to use your real statistics software to analyze trends in streamflow using the Mann-Kendall and Sen slope applications. However, I am frustrated by my Microsoft 365 version of office. I can find no way to even find out if Solver can be downloaded. All the help files don’t seem to go beyond Office 2019, and I don’t know how to proceed. Thanks for any help you can provide!
Charles (but I usually go by Chuck!)
Hello Chuck,
Most likely any help you get for Excel 2019 will also apply to Excel 365. In any case, here is a source for how to load Solver for Excel 365.
https://support.microsoft.com/en-us/office/load-the-solver-add-in-in-excel-612926fc-d53b-46b4-872c-e24772f078ca
Charles
I have Excel 2019, the XRealStats.xlam is disappearing from the customized menu, adjacent to the Developer menu item. The Ctrl-m is not functioning either. The AddIn remains ‘checked’ in the Alt-TI area. I was unsure how to include the AddIn in the Quick Access Toolbar, in Excel 2019.
Happy Holidays.
Stay Safe.
Kind Regards.
I resolved it.
1. Go to the Folder where XRealStats.xlam is stored
2. Right-Click and select -> Properties
3. Tick the UNBLOCK box
4. Click ‘OK’
Rob,
Glad to see that you got it to work. Happy Holidays to you as well.
Charles
Hello, thank you for providing this amazing tool. Alas, I have encountered an unfortunate problem:
When I try to calculate a One factor ANOVA combined with a post hoc Tukey test I get negative p-values for some pairs. This only occurs for ANOVA with k=6 (I want to compare 6 groups). ANOVA with k=3 gives excellent results.
Is their a limit value for k?
Thank you very much for your help,
yours sincerely.
Hello Anna,
You shouldn’t get any negative p-values unless they are like -1.35E-15. Although this value is negative, it really should be treated as zero. If you email me an Excel file with your data and test results I will try to figure out why you are getting negative values.
Charles
Hello Charles,
thank you for your quick response! My negative p-values are always around -4E-14. Should this treated as zero, too? Are negative p-values in the dimension of -1.35E-15 a ‘normal’ occurrence?
Yours sincerely
Anna
Anna,
Yes, you should treat this as zero. It is common to have very small negative (and positive) values that can be treated as zero.
Charles
Dear Charles,
thank you very much! This has helped me a lot.
Yours sincerely
Anna.
Charles:
Can your files be read via open documents formats?
Happy holidays,
Daniel
Daniel,
You should be able to open the documents using open document formats, but the calls to Real Statistics capabilities are probably not supported.
Charles