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 of the other values that depend on these).
In addition, the AdjRSquare(R1, R2, con) function has been corrected in the case where con = FALSE (i.e. in the no intercept case).
Finally, I have also changed the Jenks Natural Breaks data analysis tool to use the term “Class” instead of “Break” or “Category”.
Only the version for Excel 2010 and 2013 has been released. I expect to issue the version for Excel 2007 shortly. The Real Statistics Examples Part 2 and Real Statistics Multivariate Examples files will also be updated shortly.
I expect that the Real Statistics software also functions with Excel 2016 (which was released a week ago), but it has not been tested yet. If you have used the Real Statistics Resource Pack with Excel 2016, I would appreciate your feedback.
Charles
I have been using the Real Statistics Using Excel for several months.
Now I encountered a problem in Normality test – Shapiro-Wilk test.
I get results like:Shapiro-Wilk Test
I II III IV V VI
W #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
p-value #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
alpha 0.05 0.05 0.05 0.05 0.05 0.05
normal #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
Can you help me resolve this problem? Is it possible to reinstall the package? Should I download it again?
It sounds like you have moved the file containing the Real Statistics add-in to a new location and so the spreadsheet that you are using is not finding it. If this is the case, then you can resolve the problem by following the approach described on the webpage
Examples Installation
If this doesn’t work, then you should download and install the Real Statistics package.
Charles