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 Data Analysis Tools
In addition, you can also access a summary of standard Excel functions and data analysis tools as follows:
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