Please explain how to solve the below question using excel. 1. The data in Table 7–6 were collected in a clinical trial to evaluate a new compound designed to improve wound healing in trauma patients. The new compound was compared against a placebo. After treatment for 5 days with the new compound or placebo, the extent of wound healing was measured. Is there a difference in the extent of wound healing between the treatments? (Hint: Are treatment and the percent wound healing independent?) Run the appropriate test at a 5% level of significance. Use the data in Problem 1. 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% and a = 0.05 to run the appropriate test. 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
Inverse Normal Distribution
The method used for finding the corresponding z-critical value in a normal distribution using the known probability is said to be an inverse normal distribution. The inverse normal distribution is a continuous probability distribution with a family of two parameters.
Mean, Median, Mode
It is a descriptive summary of a data set. It can be defined by using some of the measures. The central tendencies do not provide information regarding individual data from the dataset. However, they give a summary of the data set. The central tendency or measure of central tendency is a central or typical value for a probability distribution.
Z-Scores
A z-score is a unit of measurement used in statistics to describe the position of a raw score in terms of its distance from the mean, measured with reference to standard deviation from the mean. Z-scores are useful in statistics because they allow comparison between two scores that belong to different normal distributions.
Please explain how to solve the below question using excel.
1. The data in Table 7–6 were collected in a clinical trial to evaluate a new compound designed to improve wound healing in trauma patients. The new compound was compared against a placebo. After treatment for 5 days with the new compound or placebo, the extent of wound healing was measured. Is there a difference in the extent of wound healing between the treatments? (Hint: Are treatment and the percent wound healing independent?) Run the appropriate test at a 5% level of significance.
Use the data in Problem 1. 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% and a = 0.05 to run the appropriate test.
| 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 |
Chi-Square test for independence:
Under the hypothesis:
Null Hypotheses: Treatment and percent wound healing are independent.
Alternative Hypotheses: Treatment and percent wound healing are not independent.
The test has to be performed using Excel.
Firstly, calculate the Expected frequencies by using the formula:
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
