The Real Statistics capabilities are adjuncts to standard Excel and consist of supplemental Excel functions and data analysis tools. No separate user interface is required. These capabilities are provided by the Real Statistics Resource Pack, which can be downloaded at Free Downloads.
Although everything described on this website can be done with standard Excel capabilities, it is often easier to use the supplemental functions and data analysis tools provided in the Real Statistics Resource Pack.
Topics
- Real Statistics Worksheet Functions
- Using Real Statistics Worksheet Functions
- Distribution Functions
- Non-Parametric Test Functions
- Descriptive Statistics, Reformatting, and Misc. FunctionsÂ
- ANOVA and Regression Functions
- Correlation and Reliability Functions
- Multivariate Functions
- Time Series Analysis Functions
- Missing Data Functions
- Mathematics Functions
- Real Statistics Data Analysis Tools
- Basic Real Statistics Capabilities
- Downloading and Installing Real Statistics Resource Pack
- Real Statistics Worksheet Examples
- Using Real Statistics functions in macros and VBA programs
Hi,
I installed XRealStat as described and it worked beautifully. Then I closed all Excel-files. Next day, I wanted to start it again. Now neither Ctrl-m nor VER() works.
This happened in Windows 10 and in Windows 7 with Excel365.
What do I do?
Best regards
Wilhelm
Hello Wilhelm,
When you used XRealStat originally did you double-click on the file or did you install it as described on the website?
Charles
cTRL+M
Hi Gerardo,
What does this comment refer to?
Charles
Possibly John Ballard’s comment below.
Hi, Charles. How are you?
I am used to analyze Agronomic Field Trials and other statistical software have the option to choose “Randomized Block Design Trial” and also “Completely Randomized Design”. Is there a way to do that with RealStats?
Thank so much for your software, time and patience.
Congratulations.
Caio,
These will generally correspond to ANOVA with fixed factors (with or without repetition) or ANOVA with repeated measures.
Charles
I did the download and have used RealStats a couple of times—-a wonderful site !!!!
Unfortunately, in the 4 weeks or so since, I have forgotten how to open it in Excel.
Ctrl and ????
Regards,
JMB