Use the data in Table 7.6 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 percentage of wound healing is approximately normal. Specifically, use the following distribution as the comparator: 30%, 40%, 20%, and 10%. Run the appropriate test at α = 0.05. PLEASE SHOW THE ANSWER IN EXCEL FORMAT WITH FORMULAS.

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.1: Measures Of Center
Problem 9PPS
icon
Related questions
Question

Use the data in Table 7.6 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 percentage of wound healing is approximately normal. Specifically, use the following distribution as the comparator: 30%, 40%, 20%, and 10%. Run the appropriate test at α = 0.05.

PLEASE SHOW THE ANSWER IN EXCEL FORMAT WITH FORMULAS.

TABLE 7.6 Data for Practice Problems 1 and 2
Treatment
New compound (n = 125)
Placebo (n = 125)
0-25%
15
36
Percentage of Wound Healing
26-50%
51-75%
37
32
45
34
76-100%
41
10
Transcribed Image Text:TABLE 7.6 Data for Practice Problems 1 and 2 Treatment New compound (n = 125) Placebo (n = 125) 0-25% 15 36 Percentage of Wound Healing 26-50% 51-75% 37 32 45 34 76-100% 41 10
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Calculus For The Life Sciences
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning