Students at multiple grade schools were asked what their personal goal (get good grades, be popular, be good at sports) was and how important having money were to them (1 very important and 4 least important). The data is in table #11.1.12 ("Popular kids datafile," 2013). Do the data provide enough evidence to show that goal attainment and importance of money are independent? Test at the 5% level. Table #11.1.12: Personal Goal and Importance of Money Goal Money Importance Rating 1 2 3 4 Row Total Grades 14 34 71 128 247 Popular 14 29 35 63 141 Sports 6 12 26 46 90 Column Total 34 75 132 237 478

solve the problem in detail with: 1. a chart with the columns labelled O, E, O- E, and (O-E)2/E

2. the calculation of chi square value

3. the calculation of the p-value using Xcdf.

4. you may (and should) verify your result using the Chi square test on the calculator

5. please also show claims, check of assumptions, conclusion and interpretation.