Sample Size Calculator in Excel for Variable and Attribute Data

Title:
Sample Size Calculator in Excel for Variable and Attribute Data


Video:


Description:To calculate a sample size you need to know: 1. The confidence level required (90%, 95%, 99%) 2. The desired width of the confidence interval (+5%) 3. The variability of the characteristic (eg, mean) The QI Macros Sample Size Calculator is designed to work with both variable (measured) and attribute (counted) data. For examples and more info see qimacros.com Download 30 day trial at www.qimacros.com This video shows you how to calculate sample size in Excel using the QI Macros

Published:
08/Oct/2010

How to Create a Levey Jennings Chart in Excel

Title:
How to Create a Levey Jennings Chart in Excel


Video:


Description:Healthcare labs use the Levey Jennings charts to monitor key measures of health like cholesterol and glucose. The Levey Jennings chart, unlike other SPC charts, uses standard deviation as a way of calculating control limits. You can create a Levey Jennings chart in Excel using the QI Macros SPC Software. For more info see qimacros.com Download 30 day trial at www.qimacros.com This video shows you how to create a Levey Jennings chart in Excel using the QI Macros

Published:
08/Oct/2010

Create a Control Chart in Excel

Title:
Create a Control Chart in Excel


Video:


Description:Use a control chart to tell you whether your process is out of control, unstable, or not predictable. A stable process produces predictable results consistently. Processes that are "out of control" need to be investigated and stabilized before they can be improved. The QI Macros Control Chart Software for Excel creates p charts, u charts, np charts, c charts, XmR charts, XbarR charts, XandS charts and more. For more info see qimacros.com Download 30 day trial at www.qimacros.com This video shows you how to create a control charts in Excel using the QI Macros

Published:
07/Oct/2010

How to Perform Design of Experiments in a DOE Template in Excel

Title:
How to Perform Design of Experiments in a DOE Template in Excel


Video:


Description:Without DOE, you're stuck with the world's slowest method for success-trial and error. With Design of Experiments, you just have to test at the high (+) and low (-) values for any particular "design factor" (eg, pressure, temperature, time, etc.) from your QFD House of Quality, not every increment in between. And you can test more than one factor at a time. For more info see www.qimacros.com Download 30 day trial at www.qimacros.com This video shows you how to perform DOE analysis in Excel using the QI Macros

Published:
07/Oct/2010

Excel Macro Tutorial -

Title:
Excel Macro Tutorial -


Video:


Description:www.ascentcomputertraining.ie Excel Macro Tutorial - Microsoft Platinum Learning Partner - Contact us today for more information on our training courses.

Published:
07/Oct/2010

Ishikawa Fishbone Diagram in Excel to Perform Root Cause Analysis

Title:
Ishikawa Fishbone Diagram in Excel to Perform Root Cause Analysis


Video:


Description:Use the Ishikawa fishbone diagram (aka cause and effect diagram) to identify the special root causes of delay, waste, rework or cost. You can use Excel's drawing tools (View-Toolbars-Drawing) to create a fishbone diagram. This video is an example of how to use the Ishikawa template in the QI Macros for Excel SPC software. For more info see www.qimacros.com Download 30 day trial at www.qimacros.com

Published:
07/Oct/2010

FMEA Template in Excel to Perform Failure Modes and Effects Analysis

Title:
FMEA Template in Excel to Perform Failure Modes and Effects Analysis


Video:


Description:FMEA - Failure Modes and Effects Analysis is a tool used to analyze and prevent disasters. You can use it to analyze a product (car, x-ray, MRI), part (car door), or process (part stamping process or elective surgery). Designing a product or part uses a DFMEA. Analyzing a process uses a PFMEA. For more info see www.qimacros.com Download 30 day trial at www.qimacros.com This video shows you how to perform an FMEA analysis in Excel using the QI Macros FMEA template

Published:
07/Oct/2010