Exercises - Chapter 11 - Chi Square Testing 1_ 189 students were surveyed and asked the age of car usually driven and the student's political orientation. The car age was a numerical variable, which was converted into ordinal categories. Alpha = .10, are students political views independent of the age of car they usually drive? Age of Car Usually Driven Politics Under2 3 To 6 7 or More Row Total Liberal 19 12 13 44 Middle 33 31 28 92 Conservative 16 24 13 53 Column Total 68 67 54 189 Please calculate a table of expected values where: Cell 1A =Row 1 Total * Column 1 Total Cell 2A =Row 2 Total * Column 2 Total, etc. 2_ Based on the Expected values table from problem 1, please calculate the chi-square test statistic c by adding all the expected values for the table. Chi-Square Test Statistic: _________ 3_ On a state lottery, each of the three digits is supposed to have the same probability of occurrence (counting initial blanks as zeros, e.g., 32 is treated as 032). The table shows the frequency of occurrence of each digit for 90 consecutive daily three-digit drawings. Digit Frequency Digit Frequency 0 33 1 17 2 25 3 30 4 31 5 28 6 24 7 25 8 32 9 25 Total 270 Please transfer data to Excel worksheet and calculate a table with an additional column for (O - E) where O is the Frequency and 27 is the Expected value: 4_ Based on information given on question 3, add another column to the Excel table, with (O-E)^2/E results, then add them to come up with the Chi Square Value: Use the va