Please answer question 2 which is related to question 1 using excel formula input only. Please show steps to solve using EXCEL only.Thank you very much!! 7.9PRACTICE PROBLEMS1. Data are collected in a clinical trial evaluating a newcompound designed to improve wound healing intrauma patients. The new compound is comparedagainst a placebo. After treatment for 5 days with thenew compound or placebo, the extent of wound heal-ing is measured and the data are shown in Table 7-6.Is there a difference in the extent of wound healing byTABLE 7-6 Data for Practice Problems 1 and 2Percent Wound HealingTreatment0-25% 26-50%51-75%76-100%New compound(n =125)15373241Placebo(n = 125)36453410 treatment? (Hint: Are treatment and the percentwound healing independent?) Run the appropriatetest at a 5% level of significance.2. Use the data in Problem 1 and pool the data across thetreatménts into one sample of size n = 250. Use thepooled data to test whether the distribution of thepercent wound healing is approximately normal.Specifically, use the following distribution: 30%, 40%,20%, and 10%. Run the appropriate test at a = 0.05.3. The data in Table 7–7 are collected in an experimentdesigned to investigate the impact of different posi-tions of the mother during ultrasound on fetal heart%3D

Name: Please answer question 2 which is related to question 1 using excel fo
Uploaded: 2024-03-20T07:07:26.000Z
Channel: Bartleby
Description: Please answer question 2 which is related to question 1 using excel formula input only. Please show steps to solve using EXCEL only.Thank you very much!! 7.9PRACTICE PROBLEMS1. Data are collected in a clinical trial evaluating a newcompound designed

Answered: Use the data in Problem 1 and pool the…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Topic Video

Question

Please answer question 2 which is related to question 1 using excel formula input only. Please show steps to solve using EXCEL only. Thank you very much!!

7.9
PRACTICE PROBLEMS
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 heal-
ing is measured and the data are shown in Table 7-6.
Is there a difference in the extent of wound healing by
TABLE 7-6 Data for Practice Problems 1 and 2
Percent Wound Healing
Treatment
0-25% 26-50%
51-75%
76-100%
New compound
(n =
125)
15
37
32
41
Placebo
(n = 125)
36
45
34
10

treatment? (Hint: Are treatment and the percent
wound healing independent?) Run the appropriate
test at a 5% level of significance.
2. Use the data in Problem 1 and pool the data across the
treatménts 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 a = 0.05.
3. The data in Table 7–7 are collected in an experiment
designed to investigate the impact of different posi-
tions of the mother during ultrasound on fetal heart
%3D

Expert Solution

Step 1

Null Hypothesis:

H0: The distribution of the percent wound healing is not approximately normal.

Alternative Hypothesis:

H1: The distribution of the percent wound healing is approximately normal.

Given information, pool the data across the treatments into one sample.

Treatments

15+36=51

37+45=82

32+34=66

41+10=51

Given proportions are 30%, 40%, 20% and 10%.

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Optimization$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.

Similar questions