Columbian Coffee VARIABLE Observed Counts Expected Counts Total 50 82.07 a 10 Pvalue 3.40477E-32 91.55 10 103.24 10 ALPHA 0.05 101.79 10 99.14 10 reject null that OBS=EXP 96.01 10 92.45 10 STEPS 103.30 10 1 Copy & paste your data in column A, where the first row (cell Al) is the variable name or ID. 10 102.21 10 2 In column C, copy & paste or type in all variable categories (spelling and capitalization must match the data 11 97.20 10 exactly as used in column A). 12 92.38 10 3 In column E enter the null values, i.e the hypothesized counts for each of the categories entered in column C. 13 97.06 10 4 Enter your alpha or critical p-value in cell H4. 5 Cell H2 calculates the p-value and cell H6 indicates if the null is rejected or not. 14 91.55 m 10 15 94.21 n 10 The current spreadsheet is designed for a variable with up to 20 different categories, if you have less categories 16 99.36 10 simply leave the rows blank (in columns C, D and E) as the formulas in column H will adjust. 17 97.27 10 18 91.51 10 If your variable has more than 20 categories, you can type in the categories in cells C22 downwards along with 19 90.18 10 expected counts in the corresponding rows in column E. Drag or copy the formula in cell D21 down to your last 88.02 10 category. You will also have to adjust the formula in cell H2, =CHITEST(D2:D21,E2:E21), changing D21 and 20 21 B8.09 10 E21 to the appropriate rows---for example if you have 23 categories and add 3 rows of values the formula in H2 is adjusted to =CHITEST(D2:D24,E2:E24) 22 91.95 23 82.88 24 82.43 25 79.70 78.40