Yesterday I issued a new bug fix release (Rel 5.3.2) of the Real Statistics software. This fixed an error in the F_DIST_RT function which made this function always output a value of zero. Unfortunately, this caused quite a few other Real Statistics capabilities to give incorrect results (MANOVA, ICC Power, Welch’s Test, Box Test, etc.).
This error is not present in the version of Real Statistics for Excel 2002 and 2003 users, nor for the old Rel 3.5.3 version for the Mac. I suggest that everyone else upgrade to Release 5.3.2.
I apologize for any inconvenience that I have caused you.
Charles
There is an error; either a typo with T9/S9 or in the formula T9/S9. T9/S9 = 0.0125, however the reported result is S9/T9 = 79.3977.
Thus, cell S9 contains the formula =K9+K10, cell T9 contains the formula =L9+L10 and cell U9 contains the formula T9/S9.
John,
Thanks for identifying an error. Please let me know which webpage you are referring to so that I can fix the error.
Charles