Please refer to table to answer question and please answer in excel format. Please show how to put it in excel. Thank you.

4) A clinical trial is conducted to compare a new pain re- liever for arthritis to a placebo. Participants are randomly assigned to receive the new medication or a placebo, and the outcome is pain relief within 30 minutes. The dataare shown in Table 7-8. Is there a significant difference in the proportions of patients reporting pain relief? Run the test at a 5% level of significance.

TABLE 7-8 Data for Practice Problem 4 Pain Relief No Pain Relief New medication 44 76 Placebo 21 99