[go: up one dir, main page]
Scribd
Upload
64 views15 pages

Data Prob 3 Comp Final

The document appears to summarize data from a study that tested 6 different treatments for reducing redness (D of R) and healing (D of H). Each treatment used a different dose and part of a plant (leaves, bark, or seeds). The data includes the average scores for redness and healing for each treatment group at various time points, as well as statistical analysis comparing the treatment groups, which found some groups had significantly different results while others did not.

Uploaded by

Eduardo Ramos
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
64 views15 pages

Data Prob 3 Comp Final

The document appears to summarize data from a study that tested 6 different treatments for reducing redness (D of R) and healing (D of H). Each treatment used a different dose and part of a plant (leaves, bark, or seeds). The data includes the average scores for redness and healing for each treatment group at various time points, as well as statistical analysis comparing the treatment groups, which found some groups had significantly different results while others did not.

Uploaded by

Eduardo Ramos
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
You are on page 1/ 15

Treatment # 1(150mg leaves)

D of Redness

9 10

11 12 13 14
5

3.71

SF
4

D of Healing
3 T1

3.50

3.71

3.64

3.33

3
3.00 T2

Treatment # 2 (150 mg bark)


1

3.57

3.64

3 T3

3.57

3.60

3.33

3.00

Treatment # 3 (150 mg seeds)

T4

3.71

3.50

3.71

3.64

3.00

3 T5
2.67

Treatment # 4 (300 mg leaves)


1

4.00

3 T6

4.00

4.00

4.00

4.00

3.00

Treatment # 5 ( 300 mg bark)


1

3.64

3.57

3.57

3.60

3.00

2.67

Treatment # 6 ( 300 mg seeds)


1

3.57

3.57

3.64

3.60

3.33

3.00

D of R

SF

D of H

T1

T2

T3

T4

T5

3.71

3.57

3.71

3.64

3.50

3.64

3.50

3.57

3.71

3.57

3.71

3.57

Sum
10.92857
10.78571
10.92857
12
10.78571
10.78571

Average
3.642857
3.595238
3.642857
4
3.595238
3.595238

Variance
0.015306122
0.00170068
0.015306122
0
0.00170068
0.00170068

MS
5 0.07602
12 0.005952

F
12.77142857

Anova: Single Factor


SUMMARY
Groups
T1
T2
T3
T4
T5
T6

Count
3
3
3
3
3
3

ANOVA
Source of Variation
SS
Between Groups
0.380102
Within Groups
0.071429
Total

0.451531

df

17

T1-T2 (Not Significant)


t-Test: Two-Sample Assuming Equal Variances

T1-T3 (Not Significant)


t-Test: Two-Sample Assuming Equal Va

Variable 1 Variable 2
Mean
3.642857 3.595238
Variance
0.015306 0.001701
Observations
3
3
Pooled Variance
0.008503
Hypothesized Mean Difference
0
df
4
t Stat
0.632456
P(T<=t) one-tail
0.280719
t Critical one-tail
2.131847
P(T<=t) two-tail
0.561438
t Critical two-tail
2.776445

Mean
Variance
Observations
Pooled Variance
Hypothesized Mean Difference
df
t Stat
P(T<=t) one-tail
t Critical one-tail
P(T<=t) two-tail
t Critical two-tail

T2-T3 (Not Significant)

T2-T4 ( Significant)

t-Test: Two-Sample Assuming Equal Variances

t-Test: Two-Sample Assuming Equal Va

Variable 1 Variable 2
Mean
3.595238 3.642857
Variance
0.001701 0.015306
Observations
3
3
Pooled Variance
0.008503
Hypothesized Mean Difference
0
df
4

Mean
Variance
Observations
Pooled Variance
Hypothesized Mean Difference
df

t Stat
P(T<=t) one-tail
t Critical one-tail
P(T<=t) two-tail
t Critical two-tail

-0.63246
0.280719
2.131847
0.561438
2.776445

t Stat
P(T<=t) one-tail
t Critical one-tail
P(T<=t) two-tail
t Critical two-tail

T3-T4 (Significant)

t-Test: Two-Sample Assuming Equal Variances

T3-T5 (Not Significant)

Variable 1 Variable 2
Mean
3.642857
4
Variance
0.015306
0
Observations
3
3
Pooled Variance
0.007653
Hypothesized Mean Difference
0
df
4
t Stat
-5
P(T<=t) one-tail
0.003745
t Critical one-tail
2.131847
P(T<=t) two-tail
0.00749
t Critical two-tail
2.776445

t-Test: Two-Sample Assuming Equal Va

T4-T5 (Significant)

T4-T6 (Significant)

t-Test: Two-Sample Assuming Equal Variances

t-Test: Two-Sample Assuming Equal Va

Variable 1 Variable 2
Mean
4 3.595238
Variance
0 0.001701
Observations
3
3
Pooled Variance
0.00085
Hypothesized Mean Difference
0
df
4
t Stat
17
P(T<=t) one-tail
3.51E-05
t Critical one-tail
2.131847
P(T<=t) two-tail
7.02E-05
t Critical two-tail
2.776445

Mean
Variance
Observations
Pooled Variance
Hypothesized Mean Difference
df
t Stat
P(T<=t) one-tail
t Critical one-tail
P(T<=t) two-tail
t Critical two-tail

T5-T6 (Not Significant)

t-Test: Two-Sample Assuming Equal Variances

Mean
Variance
Observations

Variable 1 Variable 2
3.595238 3.595238
0.001701 0.001701
3
3

Mean
Variance
Observations
Pooled Variance
Hypothesized Mean Difference
df
t Stat
P(T<=t) one-tail
t Critical one-tail
P(T<=t) two-tail
t Critical two-tail

Pooled Variance
0.001701
Hypothesized Mean Difference
0
df
4
t Stat
0
P(T<=t) one-tail
0.5
t Critical one-tail
2.131847
P(T<=t) two-tail
1
t Critical two-tail
2.776445

T6
3.57
3.57
3.64

P-value
F crit
0.000185 3.105875

ot Significant)
wo-Sample Assuming Equal Variances
Variable 1 Variable 2
3.642857 3.642857
0.015306 0.015306
3
3
0.015306
0
4
0
0.5
2.131847
1
2.776445

T1-T4 (Significant)

t-Test: Two-Sample Assuming Equal Variances


Variable 1 Variable 2
Mean
3.642857
4
Variance
0.015306
0
Observations
3
3
Pooled Variance
0.007653
Hypothesized Mean Difference
0
df
4
t Stat
-5
P(T<=t) one-tail
0.003745
t Critical one-tail
2.131847
P(T<=t) two-tail
0.00749
t Critical two-tail
2.776445
T2-T5 (Not Sgnificant)

wo-Sample Assuming Equal Variances


Variable 1 Variable 2
3.595238
4
0.001701
0
3
3
0.00085
0
4

t-Test: Two-Sample Assuming Equal Variances


Variable 1 Variable 2
Mean
3.595238 3.595238
Variance
0.001701 0.001701
Observations
3
3
Pooled Variance
0.001701
Hypothesized Mean Difference
0
df
4

-17
3.51E-05
2.131847
7.02E-05
2.776445

t Stat
P(T<=t) one-tail
t Critical one-tail
P(T<=t) two-tail
t Critical two-tail

0
0.5
2.131847
1
2.776445

T3-T6 (Not Significant)

wo-Sample Assuming Equal Variances


Variable 1 Variable 2
3.642857 3.595238
0.015306 0.001701
3
3
0.008503
0
4
0.632456
0.280719
2.131847
0.561438
2.776445

wo-Sample Assuming Equal Variances


Variable 1 Variable 2
4 3.595238
0 0.001701
3
3
0.00085
0
4
17
3.51E-05
2.131847
7.02E-05
2.776445

t-Test: Two-Sample Assuming Equal Variances


Variable 1 Variable 2
Mean
3.642857 3.595238
Variance
0.015306 0.001701
Observations
3
3
Pooled Variance
0.008503
Hypothesized Mean Difference
0
df
4
t Stat
0.632456
P(T<=t) one-tail
0.280719
t Critical one-tail
2.131847
P(T<=t) two-tail
0.561438
t Critical two-tail
2.776445

T1-T5

T1-T6

t-Test: Two-Sample Assuming Equal Variances

t-Test: Two-Sample Assuming Equal Variances

Variable 1 Variable 2
Mean
3.642857 3.595238
Variance
0.015306 0.001701
Observations
3
3
Pooled Variance
0.008503
Hypothesized Mean Difference
0
df
4
t Stat
0.632456
P(T<=t) one-tail
0.280719
t Critical one-tail
2.131847
P(T<=t) two-tail
0.561438
t Critical two-tail
2.776445

Variable 1 Variable 2
Mean
3.642857 3.595238
Variance
0.015306 0.001701
Observations
3
3
Pooled Variance
0.008503
Hypothesized Mean Difference
0
df
4
t Stat
0.632456
P(T<=t) one-tail
0.280719
t Critical one-tail
2.131847
P(T<=t) two-tail
0.561438
t Critical two-tail
2.776445

T2-T6

t-Test: Two-Sample Assuming Equal Variances


Variable 1 Variable 2
Mean
3.595238 3.595238
Variance
0.001701 0.001701
Observations
3
3
Pooled Variance
0.001701
Hypothesized Mean Difference
0
df
4

t Stat
0
P(T<=t) one-tail 0.5
t Critical one-tail
2.131847
P(T<=t) two-tail
1
t Critical two-tail
2.776445

Assuming Equal Variances

sf
4

Anova: Single Factor


SUMMARY
Groups
Count
Column 1
3
Column 2
3
Column 3
3
Column 4
3
Column 5
3
Column 6
3

ANOVA
Source of Variation SS
Between Groups
Within Groups
Total

Sum

df

Average Variance
10 3.333333 0.333333
10 3.333333 0.333333
9
3
0
12
4
0
9
3
0
10 3.333333 0.333333

2
2

MS
5
0.4
12 0.166667

17

P-value
F crit
2.4 0.099393 3.105875

dur
3

Anova: Single Factor


SUMMARY
Groups
Count
Column 1
3
Column 2
3
Column 3
3
Column 4
3
Column 5
3
Column 6
3

ANOVA
Source of Variation SS
Between Groups
0.444444
Within Groups
1.333333
Total

1.777778

Sum

df

Average Variance
9
3
0
9
3
0
8 2.666667 0.333333
9
3
0
8 2.666667 0.333333
9
3
0

MS
5 0.088889
12 0.111111
17

P-value
F crit
0.8 0.570523 3.105875

You might also like