Compile Error in Hidden Module frmGetRange When using any tool in Quantum XL, SPC XL, or DOE Pro that uses Excel’s refEdit control, the user receives an error starting with “Compile error in hidden module: frmGetRange” Solution – Disable Safe Mode in ActiveX Settings Please consult your IT department before making these changes From Excel […] The post Support – Compile in Hidden Module frmGetRange appeared first on SigmaZone.| SigmaZone
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” or a Windows Security Popup “Action Blocked: Your administrator caused Windows Security to block this action. Contact your help desk” which has the […] The post Support – File Format or Extension Not Valid appeared first on SigmaZone.| SigmaZone
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 […] The post Excel Repair and Reinstall appe...| SigmaZone
First, select “File” from the main menu. The select “Account” from the left menu. The Excel version is displayed in the section called “About Excel”. In the example below the version is 2008. The post How Do I Determine Which Version of Excel I Have? appeared first on SigmaZone.| SigmaZone
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 […] The post DOE Pro Stops Unexpectedly appeared first on SigmaZone.| SigmaZone
Our Lens Simulator can be used to practice a number of statistical concepts including Cpk/Ppk analysis, control charts, hypothesis testing, and others. In this article I will show you how to do a simple t-Test and F-Test using Quantum XL using data from the simulator. If the simulator’s use isn’t obvious then go to this […] The post Hypothesis Testing with the Lens Placement Simulator appeared first on SigmaZone.| SigmaZone
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 […] The post Calculating Type I Probability appeared first on SigmaZone.| SigmaZone
Owners of Quantum XL 2013 recieve a discount when purchasing Quantum XL 2016. For more information contact sales@sigmazone.com. To use your discount code, go to the Quantum XL Purchase page and click “Buy Now”. You will be taken to our eCommerce Partner’s website MyCommerce (see the image below). First, adjust the quantity then click “Order Now”. […] The post Support – How To Use A Coupon Code When Purchasing Quantum XL appeared first on SigmaZone.| SigmaZone
How to launch Quantum XL, SPC XL, DOE Pro XL, or Snapsheets XL This support article explains how to start an Add-In independently from Excel. If you would like Quantum XL or SPC XL to start each time Excel starts, then please see these articles. – Auto-start Quantum XL– Auto-start SPC XL Instructions for Quantum […] The post Support – How to Start SigmaZone’s Excel Add-Ins appeared first on SigmaZone.| SigmaZone
A commonly asked question is “Where do I find my serial number”? Your serial number (also called a CD Key) is very important. We, like most software companies, keep track of legal users by using this key. Method #1: If you still have the software installed, select “About” from the product’s menu. The serial number […]| SigmaZone
Your data is in Excel. Why isn’t your Analysis? Statistical Software Stop copying your data into other applications. Analyze your data right in Excel. Training and Coaching Get up to speed quickly with our industry-leading instructors. Data Analytics Data too big for Excel? No problem, we can analyze data sets from Kilobytes to Petabytes. Software […]| SigmaZone
The Binomial Distribution is commonly used in statistics in a variety of applications. Binomial data and statistics are presented to us daily. For example, in the election of political officials we may be asked to choose between two candidates. Polling organizations often take samples of “likely voters” in an attempt to predict who will be […]| SigmaZone
