Yes/No Question Analysis
Yes/No Question Analysis can be calculated when you need more than the simple frequency counts and frequency percentages. In our opinion the following is the most common and easiest analysis available. Other analysis exist and may better apply to varying test assumptions and expectations.
Chi-Square Goodness-of-Fit Test with Equal Expected Frequencies
Sensory Computer Systems Excel File Available:
YesNo_Test_Analysis_Using_Chi-Square.xls (or right click and 'Save Target As')
Example, Chi-Square Analysis:
Newer Excel function CHISQ.TEST (actual_range,expected_range) is same as CHITEST(actual_range,expected_range)
Reference: The Excel 2007 Data & Statistics Cookbook.pdf, Chapter 10, Chi-Square. File
Questionnaire Example:
Questionnaire Example Technician Setup: