Please answer all parts using Excel or Minitab, if possible.

FULL DATA SET:

Y Flu Shot X1 Age X2 HA X3 Gender

0 53 65 0

0 52 57 1

0 67 60 1

1 76 22 1

0 56 83 0

0 55 58 1

1 51 42 0

0 56 67 1

0 75 55 1

0 64 53 1

0 59 56 1

0 71 65 1

0 62 44 0

0 72 65 0

1 68 57 1

0 68 55 0

0 64 51 0

1 65 63 0

0 53 75 1

0 70 56 1

0 67 66 0

0 49 58 0

0 55 58 0

0 63 58 0

0 64 65 1

0 64 67 0

0 61 78 0

0 57 64 1

0 66 51 0

0 56 66 0

0 68 66 1

0 58 63 0

0 68 49 0

0 66 60 1

0 61 55 1

0 55 73 1

0 72 37 0

1 68 57 1

0 50 71 0

0 54 68 0

0 84 52 1

1 56 50 1

0 48 74 0

0 68 62 0

0 56 69 1

0 67 69 0

0 51 72 0

0 63 61 1

0 66 64 1

0 65 54 1

0 59 52 0

0 71 60 0

0 66 56 0

0 53 58 0

0 54 61 1

0 78 49 1

0 52 67 0

1 68 32 0

0 57 60 0

0 49 70 0

0 52 67 0

0 62 61 1

0 51 59 1

0 53 70 0

0 50 76 1

0 49 74 0

1 71 45 1

0 51 60 1

0 70 54 1

0 56 55 1

0 56 64 1

0 57 51 1

0 67 57 1

0 70 51 0

0 51 68 0

0 73 64 1

0 61 65 1

0 62 69 0

0 65 59 1

0 50 79 1

0 64 50 0

0 59 49 0

0 49 61 0

0 50 71 0

0 60 59 1

0 61 48 0

1 62 48 0

0 51 81 0

0 51 69 1

0 68 50 1

0 50 83 1

0 69 38 1

0 51 58 1

0 62 48 0

0 60 65 1

0 62 49 1

0 59 56 1

0 54 59 0

1 76 45 1

0 51 45 0

0 54 62 1

0 67 59 0

0 65 59 0

1 59 61 1

1 82 46 1

1 80 38 0

0 56 47 0

0 53 57 0

0 77 49 1

0 66 51 1

0 67 53 1

0 81 55 1

1 59 49 1

0 67 56 1

0 58 57 0

1 75 51 0

0 53 58 1

0 81 68 0

a. Obtain joint confidence intervals for the age odds ratio exp(30B) for male clients whose ages differ by 30 years and for the health awareness index odds ratio exp(25p2) for male clients whose health awareness index differs by 25, with family confidence coefficient of approximately .90. Interpret your intervals. b. Use the Wald test to determine whether X3, client gender, can be dropped from the regres- sion model; use = .05. State the alternatives, decision rule, and conclusion. What is the approximate P-value of the test? c. Use the likelihood ratio test to determine whether X3, client gender, can be dropped from the regression model; use -.05. State the full and reduced models, decision rule, and conclusion. What is the approximate P-value of the test? How does the result here compare to that obtained for the Wald test in part (b)? d. Use the likelihood ratio test to determine whether the following three second-order terms, the square of age, the square of health awareness index, and the two-factor interaction effect between age and health awareness index, should be added simultaneously to the regres- sion model containing age and health awareness index as first-order terms; use .05. State the alternatives, full and reduced models, decision rule, and conclusion. What is the approximate P-value of the test? a. Obtain joint confidence intervals for the age odds ratio exp(30B) for male clients whose ages differ by 30 years and for the health awareness index odds ratio exp(25p2) for male clients whose health awareness index differs by 25, with family confidence coefficient of approximately .90. Interpret your intervals. b. Use the Wald test to determine whether X3, client gender, can be dropped from the regres- sion model; use = .05. State the alternatives, decision rule, and conclusion. What is the approximate P-value of the test? c. Use the likelihood ratio test to determine whether X3, client gender, can be dropped from the regression model; use -.05. State the full and reduced models, decision rule, and conclusion. What is the approximate P-value of the test? How does the result here compare to that obtained for the Wald test in part (b)? d. Use the likelihood ratio test to determine whether the following three second-order terms, the square of age, the square of health awareness index, and the two-factor interaction effect between age and health awareness index, should be added simultaneously to the regres- sion model containing age and health awareness index as first-order terms; use .05. State the alternatives, full and reduced models, decision rule, and conclusion. What is the approximate P-value of the test