This needs to be completed in Excel, please. I also ask that you provide step-by-step instructions on how to compute in Excel. I am not sure where to find the formulas needed or how to place them in the proper place to get the correct answer.

1.Data are collected in a clinical trial evaluating a new compound designed to improve wound healing in trauma patients. The new compound is compared against a placebo. After treatment for 5 days with the new compound or placebo, the extent of wound healing is measured and the data are shown in the table below. Is there a difference in the extent of wound healing by treatment? Run the appropriate test at a 5% level of significance.

Treatment Percent Wound Healing

0-25% 26-50% 51-75% 76-100%

New compound (n=125) 15 37 32 41

Placebo (n=125) 36 45 34 10

2.Use the data is problem 1 and pool the data across the treatments into one sample of size n=250. Use the pooled data to test whether the distribution of the percent wound healing is approximately normal. Specifically, use the following distribution: 30%, 40%, 20%, and 10%. Run the appropriate test at =0.05.

3.The data shown below was collected in an experiment designed to investigate the impact of different positions of the mother during ultrasound on fetal heart rate. Fetal heart rate is measured by ultrasound in beats per minute. The study includes 20 women who are each assigned to one position and have the fetal heart rate measured in that position. Each woman is between 28 and 32 weeks gestation. Is there a significant difference in mean fetal heart rate by position? Run the test at a 5% level of significance.

Back Side SittingStanding 140 141 144 147 144 143 145 145 146 145 147 146 141 144 148 149 139 136 144 145

4.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

5.A clinical trial is planned to compare an experimental medication designed to lower blood pressure to a placebo. Before starting the trial, a pilot study is conducted involving seven participants. The objective of the study is to assess how systolic blood pressure changes over time untreated. Systolic blood pressures are measured at baseline and again 4 weeks later. Is there a statistically significant difference in blood pressures over time? Run the test at a 5% level of significance.

Baseline 120 145 130 160 152

143 126

4 Weeks 122 142 135 158 155

140 130

6.A hypertension trial is mounted, and 12 participants are randomly assigned to receive either a new medication or a placebo. Each participant takes the assigned medication and their systolic blood pressure (SBP) is recorded after 6 months on the assigned medication. The data is shown below. Is there a difference in mean SBP between treatments? Run the appropriate test at =0.05.

Placebo New Medication

134 114

143 117

148 121

142 124

150 122

160 128