Statistical Quality Control

Excel Statistical Quality Control for Manufacturing and Engineering

Submit an Excel Solution
Submit Solution [Guide]

Recently Added:
Bezier Curve Fitting
Yellow Pages Data Mining
Multiple Workbook Control
Loan Amortization Calculator and Schedule
Geographical Data Mapping
More Resources:
Excel Help Forum




Follow Business Spreadsheets On:
 
Find Excel Solutions:
Select suggested text to load results or icon to view solution.
Browse Main Categories: Business Finance | Financial Markets | Operations Management | Excel Productivity
 

Statistical Quality Control
Rate this solution:
(3/5 from 1 vote)
Buy Now
Statistical Quality Control screenshot
Pin It
 Statistical Quality Control for Excel is a Microsoft Excel add-in program for developing Statistical Quality Control (SQC) and Statistical Process Control (SPC) calculations, reports and charts automatically.

Key Benefits include:
  • Adds a user friendly menu to the MS Excel menu.
  • Select data within MS Excel spreadsheet and analyze it automatically.
  • All calculations, reports and charts are developed using MS Excel formula and functions.
  • Utilize your knowledge of MS Excel in analyzing quality control problems.
  • Link your quality related results directly to your MS Word reports.
  • Communicate your results to the World Wide Web or Intranet directly.
  • Do sophisticated analysis such as Nested or Multivariate charts within MS Excel.
  • Connect your reports and charts to online data sources.

Key Features of Statistical Quality Control for Excel include:
  • An easy interface via the Excel menu (Choose SQC from Excel Menu).
  • X-bar, Range, Moving Range, Individual, S, X, Moving charts.
  • 2 or 3 sigma for x charts.
  • EWMA, CUSUM and Trend charts.
  • Chart selection wizard.
  • User definable Runs and Trend rules.
  • Dynamic link to the original data.
  • Color coded for A,B and C zone (1,2 and 3 Standard Deviations from center).
  • P, nP, u and c control charts.
  • Process Capability Cpu, Cpl and Cpk calculations based on LSL and USL.
  • Comprehensive reporting of all calculations.
  • Automatically checks the data for correlation.
  • Plots histogram, normal distribution, LSL and USL.
  • Comprehensive advanced statistic analysis done automatically.
  • Data point can be marked to be excluded from the calculation (Reconcile).
  • Dynamic updating of all charts and SQC limits.
  • Runs and Trends calculations.
  • Partial Component Analysis (PCA).
  • Multi variable SQC based on PCA results.
  • An easy interface via an Excel worksheet to communicate with external sources.
  • Definable history buffer (rolling buffer to capture the history).
  • Definable internal frequency (just type the sampling time and click on start).
  • Definable external trigger mechanism.
  • Updates all selected calculations and charts.
  • Definable Save and Report option.
  • Define and Save cases for future use.
  • Edit and Save all chart masters for your company look and feel.

Statistical Quality Control for Excel is available for Microsoft Excel 97 and higher.

Buy Now
(Pricing is available on the next page)

Related Excel Solutions:Statistical Analysis (Risk Analysis) | Advanced Statistics (Technical Analysis) | Engineering Calculations (Manufacturing and Engineering) | Process Quality Analysis (Process Management) | QFD, FMEA and Pugh Templates (Manufacturing and Engineering) | Six Sigma Templates (Process Management)

Share your thoughts with other users: Create your own review
 

Download Statistical Quality Control Reference
For iTunes & iOS Device


Popular Searches
1.
2.
3.
4.
5.
Add Economic Data to Excel Reports and Dashboards
See How Here

       
  © 2013 Business Spreadsheets. All Rights Reserved. Legal | About Us