Scan & Fix 50 registry issues FREECNET Editors' review
QI Macros SPC Software for Excel allows you to analyze data in a variety of formats, including histograms with Cp and Cpk, Pareto charts, scatter plots, box whisker plots, and all variable and attribute control charts.
Since this program integrates itself into Microsoft Excel's interface, you should have no problem using it. It appears as an extra tab at the top of your Excel window. The tab itself is broken into seven categories: Statistical Tools, Fill-in-the-Blanks Templates, Data Transformation, Capability Charts, Control Charts, Improvement Charts, and Other Charts. Each transforms your inputted data for the best analysis. We entered random numbers into the cells of our spreadsheet and tested the macros by clicking through the options. The g chart function quickly placed our random numbers into a chart, complete with built-in macros and a graph that changed with our data. We then took those same numbers and clicked the Box Whisker chart option. Again, the program placed our numbers into an attractive chart that graphed our entered data. The program doesn't include a Help feature through its interface, but it does offer assistance through its Web site, should you need it. Despite not being too familiar with some of the chart concepts, we were still able to quickly jump in and see our data come to life.
QI Macros SPC Software for Excel installs and uninstalls cleanly. We highly recommend this handy macros program for anyone in need of a way to display and analyze data.
Publisher's Description
From KnowWare:
The QI Macros SPC Software for Excel draws pareto charts, control charts, histograms, box and whisker plots, scatter plots and more. Just select your data and then select the chart you want from the QI Macros menu.
The QI Macros contains over 90 fill in the blank templates including QFD, Gage R&R, DOE, PPAP, FMEA and templates for control charts, histograms, pareto and other charts. This Excel add-in is easy to use and delivers immediate results using Grab-It-And-Go Simplicity and mistake-proof selection of data. Your data can be connected or separated or in rows or columns. The QI Macros will clean up non-numeric data, fix any misalignments and use your data as you selected it.
The QI Macros wizards contain functionality not included in any other six sigma or statistical process control software. The Chart Wizard selects and runs possible charts for you. The Control Chart Wizard selects and runs the right control chart for you. The Control Chart Dashboards simplify monthly reporting. The PivotTable Wizard simplifies analyzing complex transaction files. The Statistical Wizard selects and runs the right statistical tests and even interprets the results for you (e.g. reject or accept the null hypothesis, mean / variances are the same or different). Mistake-proof your six sigma data analysis and statistical calculations using this powerful tool.
What's new in this version: Version 2012.1 includes the following enhancements:
- Add Target Line, Spec Limits etc to chart using the QI Macros chart menu
- Ability to refresh stability analysis after adding new data to control chart dashboards
- Delta Chart Template
- Various performance enhancements
- Westgard Rules added to Control Chart Rules for Levey Jennings Charts.
- Skyline limits added to XbarR and XbarS charts. See all new features
More Products to Consider
-
Measure, analyze, and control your service, transactional, and ...DownloadInstalled
Smart Install -
Take an open-source approach to office productivity.DownloadInstalled
Smart Install -
Convert Adobe PDF file to MS Word file format.DownloadInstalled
Smart Install -
View, navigate, and print PDF files.Visit SiteThis download is served from an external site
closeNOTICE: This link will open a connection to a third-party site. CNET cannot ensure the security of software that is hosted on external sites.
Sponsored Products
-
Open, edit, and save files using the new file formats in 2007 v...DownloadInstalled
Smart Install -
Create and share content with the help of a comprehensive set o...Visit SiteThis download is served from an external site
closeNOTICE: This link will open a connection to a third-party site. CNET cannot ensure the security of software that is hosted on external sites.
Sponsored Products
-
Convert PDF files to Microsoft Word format.DownloadInstalled
Smart Install -
Keep track of how you use your PC.DownloadInstalled
Smart Install -
Manage all your notes and web pages in the form of a tree.DownloadInstalled
Smart Install -
Manage all your notes and web pages in the form of a tree.DownloadInstalled
Smart Install -
Create, view, edit and share word, spreadsheet and presentation...DownloadInstalled
Smart Install -
Open, edit, and create CSV files or data tables on your Windows...DownloadInstalled
Smart Install -
Plan and display projects using a tree-style diagram.DownloadInstalled
Smart Install -
Create, manage, and collaborate with others on presentations.Visit SiteThis download is served from an external site
closeNOTICE: This link will open a connection to a third-party site. CNET cannot ensure the security of software that is hosted on external sites.
Sponsored Products
-
Read PDF files with this lightweight PDF viewer.DownloadInstalled
Smart Install -
Manipulate, calculate, and graphically display data.DownloadInstalled
Smart Install -
Develop your own custom solutions visualizing various data.DownloadThis download is served from an external site
closeNOTICE: This link will open a connection to a third-party site. CNET cannot ensure the security of software that is hosted on external sites.
Sponsored Products
Installed
Smart Install -
Compute and manage your customers incomes and outcomes.DownloadInstalled
Smart Install -
Make your Excel works easier and faster with over 300 extra too...DownloadInstalled
Smart Install -
Create formatted worksheets, charts, pivottables, drill workshe...DownloadInstalled
Smart Install - Simplify the development of your Mysql database design.Download
Installed
Smart Install -
Convert JPG, BMP, TIFF, PNG images to PDF files.DownloadInstalled
Smart Install - Create project schedules using Gantt chart.Download
Installed
Smart Install - Share your Excel data via Internet.Download
Installed
Smart Install
-
All versions:
5.0 starsout of 1 votes
-
Current version:
0 stars Be the first to review this product -
My rating:
Write review
Results 1-1 of 1
-
"10 out of 10"
Version: QI Macros for Excel 2010.9
Pros
Just awesome.Can't compare any other excel templates with this.
Cons
None..except for.........
Summary
I am using this product since 4 years and am loving its easy interface.
