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 table 7-6. Is there a difference in the extent of wound healing by treatment? (hint: are treatment and the percent wound healing independent?) Run the appropriate test at a 5% level of significance. Percent Wound Healing Treatment                0-25%           26-50%             31-75%               76-100% New Compound (N=125) 15          37                     32                        41 Placebo(N=125)                  36          45                     34                         10

Linear Algebra: A Modern Introduction
4th Edition
ISBN:9781285463247
Author:David Poole
Publisher:David Poole
Chapter7: Distance And Approximation
Section7.3: Least Squares Approximation
Problem 31EQ
icon
Related questions
icon
Concept explainers
Topic Video
Question

Excel Exercise Week 5 Chapter 7 workbook.

Please upload your answers as an excel file with properly labeled answers. Please answer in excel only.

  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 table 7-6. Is there a difference in the extent of wound healing by treatment? (hint: are treatment and the percent wound healing independent?) Run the appropriate test at a 5% level of significance.

Percent Wound Healing

Treatment                0-25%           26-50%             31-75%               76-100%

New Compound (N=125) 15          37                     32                        41

Placebo(N=125)                  36          45                     34                         10

Table 7-6

 

Expert Solution
Step 1: Given information

Given the data as 

(O)0-25%26-50%51-75%76-100%Total
NC15373241125
Placebo36453410125
Total51826651250





trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 20 images

Blurred answer
Knowledge Booster
Sample space, Events, and Basic Rules of Probability
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.
Recommended textbooks for you
Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax
Trigonometry (MindTap Course List)
Trigonometry (MindTap Course List)
Trigonometry
ISBN:
9781305652224
Author:
Charles P. McKeague, Mark D. Turner
Publisher:
Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL