PLEASE USE EXCEL TO ANSWER THE QUESTION

A clinical trial is conducted comparing a new pain reliever for arthritis to a placebo. Participants are randomly assigned to receive the new treatment or a placebo and the outcome is pain relief within 30 minutes. The data are shown below. Is there a significant difference in the proportions of patients reporting pain relief? Run the test at a 5% level of significance.

.	Pain Relief	No Pain Relief
New medication	44	76
Placebo	21	99