# Z test for two population proportions

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. Is there a significant difference in the proportions of patients reporting pain relief? Run the test at a 5% level of significance.

The data is shown below (Attention I need this done on excel and I also need the formula calculated on excel (simple understandable calculations step by step please).

Pain Relief No Pain Relief

new medication 44 76

Placebo 21 99

© BrainMass Inc. brainmass.com June 3, 2020, 11:57 pm ad1c9bdddfhttps://brainmass.com/statistics/z-test/z-test-two-population-proportions-310024

#### Solution Preview

Performing Hypothesis Tests Two Samples (biostatistics)

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. Is there a significant difference in the proportions of patients reporting pain relief? Run the test at a 5% level of significance.

The data is shown below (Attention I need this done on excel and I also need the formula ...

#### Solution Summary

Step by step method for computing Z test statistic for comparing two population proportion.