SPC for Excel contains two chi square tests: for goodness of fit (output shown above) and the test for association. In both cases, the null and alternate hypotheses are given. The output includes the conclusion. If the p value is less than 0.05, it is in red.
Chi Square Test for Association
Our SPC software, SPC for Excel, provides an easy way to perform statistical analysis in Microsoft Excel. This SPC software is very cost effective and user-friendly.
At the same time, it is a very powerful statistical package that meets the needs of most professionals - green belts, black belts, quality professionals, quality assurance, front-line personnel, supervisors, quality control, controllers, engineers, and laboratory personnel - anyone who wants to improve their data analysis.
At only $189 for a single user, SPC for Excel is an attractive alternative for many organizations. It is the perfect tool to use for statistical analysis, process improvement, problem solving and statistical training. Our SPC software is used internationally in over 60 countries. You also receive regular revisions to your version with no maintenance fees! And we have great discounts for multiple users!
The software includes control charts, Pareto diagrams, histograms, scatter diagrams, fishbone diagrams, process capability analysis, measurement systems analysis, regression, experimental design, hyptoheses testing, nonparametric analysis and much more. The software works with Excel 2000 through Excel 2010.
The links below provide more details on the SPC for Excel software.