2. Complete "Time to Practice" problems in Chapter 17 (pg. 362-363)

UseCHISQ.TESTfunction (and provide and interpretthe p-values)for problems #1, #2, & #4. (Include the Excel output in your submission.)

For #3, explain your answer for EACH scenario/item --- four altogether (e.g., a clear rationale for whychi-square test is or is not appropriate for each research question.)

Please note the use of scientific notation in some of the p-values.Ifyour p-value looks something like this:3.01305E-23 (with an "E" and a number at the end), it means: .0000000000000000000030105. (i.e., much less than .05). As such expression is difficult to include in a limited space, it is usually written as "p < .001."

Questions

1.Using the following data, test the question of the whether an equal number of democrats, republicans, and independents voted during the most recent election. Test the hypothesis at the .05 level of significance.

Political Affiliation

Republican 800Democrat 700Independent 900

2.Using the following data, test the question of whether an equal number of boys and girls participate in soccer at the elementary level at the .01 level of significance. What's your conclusion?

Gender

Boys 45Girls 55

3.Of the following four research questions, which ones are appropriate for the chi-square test?

What is the difference between the average scores of two math classes?

What is the difference between the number of children who passed the math test in Class 1 and the number of children who passed the math test in Class 2?

How many cars passed the CRASH test this year versus last year?

How fast can a soccer player run 100 yards compared with a football player?

4.At the Diabetes Institute, patients are classified as compliant (they take their medication as they should) or not (they don't). A new program manager has a new idea: Have some patients continuously monitor their blood sugar while telling others that they do not need to and see whether they fall into one of the two categories in controlling their diet, successful or not successful. Here are the data: Successful 60Unsuccessful 38So, does the program manager stay on the job or start looking?

data is in the comments.