Unlike previous releases of the Real Statistics Resource Pack, the latest release, Release 4.6, uses Excel’s Solver capability. This means that you must make sure that the Solver addin is loaded on your computer You do this by pressing Alt-TI (i.e. hold the Alt key down and press T and I) and making sure that there is … Read More
I am pleased to announce Release 4.6 of the Real Statistics Resource Pack. The new release is now available for free download (Download Resource Pack) for Excel 2010, 2013 and 2016 (Windows version) environments. It will be available tomorrow for Excel 2007 users. The spreadsheets for all the examples used on the Real Statistics website, including … Read More
I am pleased to announce Release 4.5 of the Real Statistics Resource Pack. The new release is now available for free download (Download Resource Pack) for Excel 2007, 2010, 2013 and 2016 (Windows version) environments. The spreadsheets for all the examples used on the Real Statistics website, including those related to the new Release 4.5 features) … Read More
A number of Excel 2007 users have run into various problems when installing or running Real Statistics. Here is a suggestion from Cyberpreneur which may be helpful to you “to correct the password problem requires installing the Real Stat addin in proper manner. Copy the downloaded file to /Microsoft Office/Office12/Library/Analysis , then restart excel. Then … Read More
There is a new release of the Real Statistics Resource Pack, Rel 4.4.3 for Excel 2007, 2010, 2013 and 2016 environments, which corrects the following bugs: Three Factor ANOVA data analysis tool: Fixes an incorrect p-value. Thanbks to Aaron for identifying this problem FISHERTEST function: Fixes a bug which gave an incorrect p-value in certain situations. … Read More
I have just issued a new bug fix release for the Real Statistics Resource Pack, Release 4.4.2. This release fixes a bug in the Multiple Linear Regression data analysis tool when the without intercept option is chosen. The revised version changes the standard errors of the coefficients and the value of R-square (along with any … Read More
I am pleased to announce Release 4.4 of the Real Statistics Resource Pack. The new release is now available for free download (Download Resource Pack) for Excel 2007, 2010 and 2013 environments. The spreadsheets for all the examples used on the Real Statistics website, including those related to the new Release 4.4 features) are available for … Read More
You may have noticed that I have made a few minor changes to the main/home menu of the website. These consist of the following: The Correlation menu has been relabeled the Miscellaneous menu. In addition to the Correlation and Reliability sub-menus, the Survival Analysis sub-menu has been added, and the Non-parametric Tests and Dealing with Missing … Read More
I am pleased to announce Release 4.3 of the Real Statistics Resource Pack. The new release is now available for free download (Download Resource Pack) for Excel 2007, 2010 and 2013 environments. The spreadsheets for all the examples used on the Real Statistics website, including those related to the new Release 4.3 features) are available for … Read More
Quick Update I have completed the updating of the website for compatibility with Release 4.2. I have also issued an update to the Examples Workbook. One thing that I left out of the Rel 4.2 release announcement is that an argument has now been added to various table lookup functions which enables you to specify whether … Read More