File format or File Extension is not Valid While the “file format or file extension is not valid” error is typical, some users have also reported the error “QuantumXLAddIn.xlam is not a valid add-in” which has the same root cause and workaround. Root Cause – Windows Defender security setting and misleading error reporting When Attack Surface […]
Support – File Format or Extension Not Valid Read More »
Step 1: Office Repair Microsoft has excellent instructions for how to repair Microsoft Office. They can be found at the url https://support.microsoft.com/en-us/office/repair-an-office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b or by clicking the button below. If these instructions resolve your issue, then there is no need to proceed further. Microsoft’s Instructions To Repair Office Step 2: Office Reinstall If repairing Office doesn’t
Excel Repair and Reinstall Read More »
Symptom: When using DOE Pro (all builds), Excel stops working or crashes when creating a design, running regression, optimizing or plotting. Cause: Office 365 version 2012 and 2102 are incompatible with some Excel 4 Macro code. Solution: Download latest installer of DOE Pro from the Update Page. v2101 build 13628.20274 Go To Updates Page Some
DOE Pro Stops Unexpectedly Read More »
I have had many requests to explain the math behind the statistics in the article Roger Clemens and a Hypothesis Test. The math is usually handled by software packages, but in the interest of completeness I will explain the calculation in more detail. A t-Test provides the probability of making a Type I error (getting
Calculating Type I Probability Read More »