In: Statistics and Probability
Once you have the dataset, please use knowledge gained in other business and/or economics classes to realize what topic and theory the data could relate and a research question that it could allow you to answer. More specifically, please put together an analysis by making sure your project report includes the following:
7.1. Specify the level of significance (Type I error associated with the null hypothesis),
7.2. Determine the test statistic (the appropriate statistical test as mentioned under point 5 above),
7.3. Determine the critical values (and region(s) if applicable),
Severity of company's finacial problems | Type of intervention | Financial Stress Score |
1 | Intervention #1 | 6 |
1 | Intervention #1 | 6 |
1 | Intervention #1 | 7 |
1 | Intervention #1 | 7 |
1 | Intervention #1 | 7 |
1 | Intervention #1 | 6 |
1 | Intervention #1 | 5 |
1 | Intervention #1 | 6 |
1 | Intervention #1 | 7 |
1 | Intervention #1 | 8 |
1 | Intervention #1 | 7 |
1 | Intervention #1 | 6 |
1 | Intervention #1 | 5 |
1 | Intervention #1 | 6 |
1 | Intervention #1 | 7 |
1 | Intervention #1 | 8 |
1 | Intervention #1 | 9 |
1 | Intervention #1 | 8 |
1 | Intervention #1 | 7 |
1 | Intervention #1 | 7 |
2 | Intervention #1 | 7 |
2 | Intervention #1 | 8 |
2 | Intervention #1 | 8 |
2 | Intervention #1 | 9 |
2 | Intervention #1 | 8 |
2 | Intervention #1 | 7 |
2 | Intervention #1 | 6 |
2 | Intervention #1 | 6 |
2 | Intervention #1 | 6 |
2 | Intervention #1 | 7 |
2 | Intervention #1 | 7 |
2 | Intervention #1 | 6 |
2 | Intervention #1 | 7 |
2 | Intervention #1 | 8 |
2 | Intervention #1 | 8 |
2 | Intervention #1 | 8 |
2 | Intervention #1 | 9 |
2 | Intervention #1 | 0 |
2 | Intervention #1 | 9 |
2 | Intervention #1 | 8 |
1 | Intervention #2 | 6 |
1 | Intervention #2 | 5 |
1 | Intervention #2 | 4 |
1 | Intervention #2 | 5 |
1 | Intervention #2 | 4 |
1 | Intervention #2 | 3 |
1 | Intervention #2 | 3 |
1 | Intervention #2 | 3 |
1 | Intervention #2 | 4 |
1 | Intervention #2 | 5 |
1 | Intervention #2 | 5 |
1 | Intervention #2 | 5 |
1 | Intervention #2 | 6 |
1 | Intervention #2 | 6 |
1 | Intervention #2 | 7 |
1 | Intervention #2 | 6 |
1 | Intervention #2 | 5 |
1 | Intervention #2 | 7 |
1 | Intervention #2 | 6 |
1 | Intervention #2 | 8 |
2 | Intervention #2 | 7 |
2 | Intervention #2 | 5 |
2 | Intervention #2 | 4 |
2 | Intervention #2 | 3 |
2 | Intervention #2 | 4 |
2 | Intervention #2 | 5 |
2 | Intervention #2 | 4 |
2 | Intervention #2 | 4 |
2 | Intervention #2 | 3 |
2 | Intervention #2 | 3 |
2 | Intervention #2 | 4 |
2 | Intervention #2 | 5 |
2 | Intervention #2 | 6 |
2 | Intervention #2 | 7 |
2 | Intervention #2 | 7 |
2 | Intervention #2 | 6 |
2 | Intervention #2 | 5 |
2 | Intervention #2 | 4 |
2 | Intervention #2 | 4 |
2 | Intervention #2 | 5 |
1 | Placebo | 2 |
1 | Placebo | 1 |
1 | Placebo | 3 |
1 | Placebo | 4 |
1 | Placebo | 5 |
1 | Placebo | 4 |
1 | Placebo | 3 |
1 | Placebo | 3 |
1 | Placebo | 3 |
1 | Placebo | 4 |
1 | Placebo | 5 |
1 | Placebo | 3 |
1 | Placebo | 1 |
1 | Placebo | 2 |
1 | Placebo | 4 |
1 | Placebo | 3 |
1 | Placebo | 5 |
1 | Placebo | 4 |
1 | Placebo | 2 |
1 | Placebo | 3 |
2 | Placebo | 4 |
2 | Placebo | 5 |
2 | Placebo | 6 |
2 | Placebo | 5 |
2 | Placebo | 4 |
2 | Placebo | 4 |
2 | Placebo | 6 |
2 | Placebo | 5 |
2 | Placebo | 4 |
2 | Placebo | 2 |
2 | Placebo | 1 |
2 | Placebo | 3 |
2 | Placebo | 2 |
2 | Placebo | 2 |
2 | Placebo | 3 |
2 | Placebo | 4 |
2 | Placebo | 3 |
2 | Placebo | 2 |
2 | Placebo | 2 |
2 | Placebo | 1 |
data
Intervention 1 | Intervention 2 | Placebo |
6 | 6 | 2 |
6 | 5 | 1 |
7 | 4 | 3 |
7 | 5 | 4 |
7 | 4 | 5 |
6 | 3 | 4 |
5 | 3 | 3 |
6 | 3 | 3 |
7 | 4 | 3 |
8 | 5 | 4 |
7 | 5 | 5 |
6 | 5 | 3 |
5 | 6 | 1 |
6 | 6 | 2 |
7 | 7 | 4 |
8 | 6 | 3 |
9 | 5 | 5 |
8 | 7 | 4 |
7 | 6 | 2 |
7 | 8 | 3 |
7 | 7 | 4 |
8 | 5 | 5 |
8 | 4 | 6 |
9 | 3 | 5 |
8 | 4 | 4 |
7 | 5 | 4 |
6 | 4 | 6 |
6 | 4 | 5 |
6 | 3 | 4 |
7 | 3 | 2 |
7 | 4 | 1 |
6 | 5 | 3 |
7 | 6 | 2 |
8 | 7 | 2 |
8 | 7 | 3 |
8 | 6 | 4 |
9 | 5 | 3 |
0 | 4 | 2 |
9 | 4 | 2 |
8 | 5 | 1 |
let µ be financial stress score for
1- Intervention 1
2- Intervention 2
3- Placebo
one of hypothesis could be
ANOVA
Ho: µ1 = µ2= µ3
Ha: at least one mean is different
Using Excel
data -> data analysis -> Anova: Single Factor
Anova: Single Factor | ||||||
SUMMARY | ||||||
Groups | Count | Sum | Average | Variance | ||
Intervention 1 | 40 | 277 | 6.925 | 2.378846 | ||
Intervention 2 | 40 | 198 | 4.95 | 1.792308 | ||
Placebo | 40 | 132 | 3.3 | 1.85641 | ||
ANOVA | ||||||
Source of Variation | SS | df | MS | F | P-value | F crit |
Between Groups | 263.5167 | 2 | 131.7583 | 65.5779 | 7.9E-20 | 3.073763 |
Within Groups | 235.075 | 117 | 2.009188 | |||
Total | 498.5917 | 119 |
TS = 65.5779
critical value at 0.05 level = 3.0738
since F = 65.5779 > critical value
we reject the null hypothesis
we conclude that there is significant difference in the mean
p-value = 7.9E-20 = 7.9*10^(-20) = 0.000
since p-value < alpha , we reject the null hypothesis
we get the same result
Please rate if helpful