QI Macros for Excel - Free download and software reviews - CNET Download.com

QI Macros for Excel

CNET 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

All User Reviews
  • All versions:

    4.0 stars

    out of 3 votes

    • 5 star: 2
    • 4 star: 0
    • 3 star: 0
    • 2 star: 1
    • 1 star: 0
  • Current version:

    3.5 stars

    out of 2 votes

    • 5 star: 1
    • 4 star: 0
    • 3 star: 0
    • 2 star: 1
    • 1 star: 0
  • My rating:

    0 stars

    Write review

Results 1-2 of 2

  • 5.0 stars

    "QI Macros is easy to use"

    February 19, 2014  |   By smarthu

    Version: QI Macros for Excel 3013.06

    Pros

    The product is easy to install and to use; it's a good alternative to Minitab and uses Excel and your own data. You can redo the charts as many times as needed. There are Control Charts, Histograms and other Capability Analysis tools, Anova and other statistical tools. It has a couple of wizards.
    And, the website has tons of information (do a search for whatever chart or information you need) and a support page.

    Cons

    The product may contain more charts/templates than you need, but you can pick-and-choose which ones you need and which you don't.

    Summary

    There is a free trial if you go to the website.

    Reply to this review

    Was this review helpful? (0) (0)

  • 2.0 stars

    "Lots of tools, much too complicated and no support"

    December 20, 2013  |   By sking114

    Version: QI Macros for Excel 3013.06

    Pros

    There are pros to this excel add-in. There are tons of statistical tools that can you can use on your data sets and it makes things like correlation analysis a breeze.

    Cons

    Where to begin...
    1 - First off there is no instruction manual. They include a 2 page description of some of the tools on their website but that is about it. With over 50 tools in the package it is very difficult to find which one you need. Additionally, if you have any concerns about how the calculations need to be set up or are taking place there is no way to check (add-in encrypted in VBA).
    2 - No support: Since there was no manual I had to call QIMacros multiple times to ask a simple question (Are blank cells counted as zeros or not included), and was told "THEY AREN'T SURE BECAUSE THEY AREN'T STATISTICIANS", WHAT??
    3 - Not a great output: once you do figure out how to use the product (without any help from QIMacros), the organization and output of the macro is rough at best.

    Summary

    Overpriced, under explained, no support because staff doesn't understand product.

    Overall QIMacros is a nice stat package for excel but at $229 it is overpriced due to the fact that you won't be able to use 90% of the tools in a business setting (without knowing any of the underlying calculation/assumptions) and while there is tech support the staff do not have enough technical training or knowledge to help.

    Also, most people will probably only use QIMacros for one or two of the tools (I usually just use the correlation function) and the macros they have programmed are nothing special. My advice is, unless you are a statistician and plans on investing lots of time on the phone trying to understand the product, make you own table or spreadsheet. It'll save you $230, allow you to be confident in your calculations, allow you to have a cleaner output, and you may learn useful information for the future.

    Reply to this review Read reply (1)

    Was this review helpful? (0) (0)

Add Your Review

Log in or create an account to post a review.
You are logged in as . Please submit your review for QI Macros for Excel 3013.06
Add Your Review

The posting of advertisements, profanity, or personal attacks is prohibited.
Click here to review our site terms of use.

Submit your reply

Submit

The posting of advertisements, profanity, or personal attacks is prohibited.
Click here to review our site terms of use.

cancel

E-mail this review

Submit cancel

Report offensive content

If you believe this comment is offensive or violates the CNET's Site Terms of Use, you can report it below (this will not automatically remove the comment). Once reported, our staff will be notified and the comment will be reviewed.

Select type of offense:

Offensive: Sexually explicit or offensive language
Spam: Advertisements or commercial links
Disruptive posting: Flaming or offending other users
Illegal activities: Promote cracked software, or other illegal content
Submit cancel

See more CNET content tagged:

Previous Versions:

Error

close

ERROR MESSAGE

If you think this is an error, please contact CNET TechTracker Support for further assistance.

Ok

Running Request

close

loading

Smart Install Software

close

CNET TechTracker will now automatically install software without requiring further action by you. (Note: This feature automatically accepts associated EULAs and third party applications on your behalf.)

You have selected the following software to Smart Install:

CNET TechTracker will attempt to install this software without interrupting you again. If an application requires manual installation, CNET TechTracker will download the installer and prompt you to take further action.

Proceed with Smart Install?

Confirm Standard Install Cancel

Submit a problem report for QI Macros for Excel

close

Please describe the problem you have with this software. This information will be sent to our editors for review.

Problem:

The CNET Installer isn't working as expected

The download link does not work

The software has a newer version

The software contains malware

Other

Description:

Please select a feedback type.

Please enter a description.

Submit Problem Report

Problem Report submitted

close

Thank you for submitting a problem report! The Download team is committed to providing you with accurate software information.

OK

Installed

Smart Install

About CNET Installer

The CNET Download.com Installer is a tiny ad-supported stub installer or "download manager" that helps securely deliver your downloads from Download.com's servers. We also include offers for carefully screened software that complies with Download.com Software Policies as part of our Installer process. Learn more

QI Macros for Excel