Excel Work 1) Calculate a Chi-Square Goodness of Fit using the data below, assuming that your expected frequencies are the same for each group (you should have the same number of people for both Observed and Expected frequencies if you add them up across your three groups). (1 ) points) 2) What are your hypotheses? (1 point) a. Null b. Alternative 3) What is your critical value and are your results significant? (1 point) Group Observed Expected 1 17 ? 2 54 ? 3 79 4) Calculate your expected frequencies for each of the four cells below based on the observed frequencies provided? (1 point) 5) Calculate a Chi-Square test for Independence using this information. (1 12 points) 6) What are your hypotheses? (1 point) a. Null b. Alternatie 7) What is your critical value and are your results significant? (1 point) No Improvement Improvement No Therapy 16 24 Behavioral Therapy 21 59