Statistics Assignment 3

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 24

75.

3
76.4
83.2
91
80.1
77.5
84.8
81

Sample Mean 81.1625


Sample Standard Deviation (Population Estimate) 5.151681418
3) Standard Error of the Mean (SEM) 1.821394432
4) Critical Value (98% Confidence Level) 2.33
5) Margin of Error (ME) 4.243849028
6) Lower Bound of Confidence Interval 0.90783239
7) Upper Bound of Confidence Interval 9.395530445

Sample Proportion (p^​)


Standard Error (SE)
Critical Value
Margin of Error (ME)
Lower Bound of Confidence Interval
Upper Bound of Confidence Interval

Description Drug 1
Sample Size (n) 90
Sample Mean (xˉ) 8.5
Sample Standard Deviation (s) 1.8
Degrees of Freedom (df) 8
Difference in Sample Means (xˉ1​−xˉ2​) 0.6
Pooled Standard Deviation (sp​) 2.08131569
Standard Error (SE) 0.339442263
t-statistic 1.7691759
Critical Value (t-critical) 1.6602314
p-value 0.0418188

Since the absolute value of the t-statistic (1.769) is greater than the t-critical value (1.660), and the p-v

Description Original Training Method


Sample Size (n) 16
Sample Mean (xˉ) 688
Sample Standard Deviation (s) 32.63
Degrees of Freedom (df) 15
Difference in Sample Means (xˉ1​−xˉ2​) -12.6
Pooled Standard Deviation (sp​) 28.38454513
Standard Error (SE) 10.98912407
t-statistic 1.147266924
Critical Value (t-critical) 2.228138852
p-value 0.144994124

Since the absolute value of the t-statistic (1.147) is less than the t-critical value (2.228), and the p-value (0.145) is greater than the signi

1 Sample mean 39.2


2 Std Deviation 3.2
3 Critical Value 1.959963986
4 Margin of Error 0.6271884756
5 Confidence Interval
lower bound 38.57281152
upper bound 39.82718848

We are 95% sure it falls between lower bound and upper bound.
1 Industry Average (μ)
2 Population Standard Deviation (σ)
3 Sample Mean (xˉ)
4 Sample Size (n)
5 Significance Level (α)
6 Test Statistic (z-score)
7 Critical Value
8 Conclusion

Since the calculated test statistic is less than the critical value, we fail to reject the null hypothesis. Th

1 Confidence Level (%)


2 Margin of Error
3 Z-Score
4 Estimated Proportion (p)
5 Sample Size Needed
6 Sample Size Needed (p = 0.05)
7 Sample Size Needed (p = 0.25)

1 Supplier
2 1
3 2
4 3
5 4
6 5
7 6
8 7
9 8
10 Mean Difference
11 Std Dev of Diff
12 t-statistic
13 Degrees of Freedom
14 p-value

Based on the calculated p-value of approximately 0.06


30 to 39 Age Group
Sample Size (n) 175
Number Rating as Excellent (x) 87
Proportion (p) 0.497142857142857

Standard Error 0.041063717


Z-score 1.699422121
p-value 0.089207919
For the proportion of people rating the program as excellent:
The p-value is approximately 0.089, which is greater than the significance level (α=0.05). Therefore,
30 to 39 Age Group
Sample Size (n) 175
Number Planning to Upgrade (x) 52
Proportion (p) 0.297142857142857

Standard Error 0.031448812


Z-score 3.42681017
p-value 0.000610327

For the proportion of people planning to purchase and upgrade:


The p-value is approximately 0.0006, which is less than the significance level (α=0.05). Therefore, we
0.6
0.01224744871
2.05
0.02507326889
0.5749267311
0.6250732689

Drug 2
80
7.9
2.1
value (1.660), and the p-value (0.042) is less than the significance level of 0.05, we reject the null hypothesis.

New Training Method


11
700.6
24.84
10

ue (0.145) is greater than the significance level of 0.05, we fail to reject the null hypothesis.
144
52
100.51
121
0.1
-9.199807692
1.281551564

ect the null hypothesis. Therefore, at the 0.10 significance level, Joel cannot conclude that his clients' commission is higher tha

95
0.5
1.96
0.5
588
1715
6769

Before After Difference


16 14 -2
12 13 1
18 12 -6
7 6 -1
14 9 -5
19 15 -4
6 8 2
17 15 -2
-2.125
2.799872446
-2.146671949
7
0.0689516412

lue of approximately 0.069 at a significance level of 0.05, we fail to reject the null hypothesis.
40 to 49 Age Group
220
94
0.427272727272727

evel (α=0.05). Therefore, we fail to reject the null hypothesis.


40 to 49 Age Group
220
37
0.168181818181818

el (α=0.05). Therefore, we reject the null hypothesis.


null hypothesis.
s clients' commission is higher than the industry average.
City
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100

Sameer is interested in knowing the average profit for products that advertise through newspaper, but he does not have
(a) Find the estimated standard error of the mean
(b) Construct a 90 percent confidence interval for the mean =Answer
In an effort to estimate the proportion of respondents that prefer purchasing products online, the analyst takes a rando
Based on a random sample of 100, test the hypothesis that half of the cities use newspapers for advertisement at a 2% s
Based on a random sample of 100, test the hypothesis that less than 62% of the cities use 'Offline' as a sales channel at a
Based on a random sample of 100, test the hypothesis that the average profit is 750000 at a 5% significance level.
Based on a random sample of 100, test the hypothesis that the average sales is more than 2000 at a 1% significance leve
Consider a first sample of 40 cities starting from city 1 to city 40 and a second sample of 60 cities starting from city 41 t
Consider a first sample of 40 cities starting from city 1 to city 40 and a second sample of 60 cities starting from city 41 t
Consider a first sample of 12 cities starting from City 1 to City 12 and a second sample of 15 cities starting from City 40
Consider a first sample of 35 cities starting from City 1 to City 35 and a second sample of 50 cities starting from City 51
Item Type
Baby Food
Snacks
Beverages
Cereal
Snacks
Personal Care
Clothes
Clothes
Clothes
Baby Food
Office Supplies
Cosmetics
Cereal
Cosmetics
Baby Food
Meat
Cereal
Office Supplies
Beverages
Baby Food
Beverages
Baby Food
Fruits
Beverages
Snacks
Cereal
Cosmetics
Baby Food
Meat
Cereal
Office Supplies
Beverages
Baby Food
Snacks
Beverages
Cereal
Snacks
Personal Care
Clothes
Clothes
Clothes
Baby Food
Office Supplies
Cosmetics
Cereal
Cosmetics
Baby Food
Snacks
Personal Care
Clothes
Clothes
Clothes
Baby Food
Office Supplies
Cosmetics
Cereal
Cosmetics
Baby Food
Baby Food
Office Supplies
Cosmetics
Cereal
Cosmetics
Baby Food
Snacks
Beverages
Cereal
Snacks
Personal Care
Clothes
Clothes
Clothes
Baby Food
Office Supplies
Cosmetics
Cereal
Cosmetics
Baby Food
Meat
Cereal
Office Supplies
Beverages
Baby Food
Beverages
Baby Food
Fruits
Beverages
Snacks
Cereal
Cosmetics
Baby Food
Meat
Cereal
Office Supplies
Beverages
Baby Food
Snacks
Beverages
Cereal
Snacks

meer is interested in knowing the average profit for products that advertise through newspaper, but he does not have enough time t
Find the estimated standard error of the mean
Construct a 90 percent confidence interval for the mean =Answer
an effort to estimate the proportion of respondents that prefer purchasing products online, the analyst takes a random sample of 10
sed on a random sample of 100, test the hypothesis that half of the cities use newspapers for advertisement at a 2% significance leve
sed on a random sample of 100, test the hypothesis that less than 62% of the cities use 'Offline' as a sales channel at a 10% significa
sed on a random sample of 100, test the hypothesis that the average profit is 750000 at a 5% significance level.
sed on a random sample of 100, test the hypothesis that the average sales is more than 2000 at a 1% significance level.
nsider a first sample of 40 cities starting from city 1 to city 40 and a second sample of 60 cities starting from city 41 to city 100 for th
nsider a first sample of 40 cities starting from city 1 to city 40 and a second sample of 60 cities starting from city 41 to city 100 for th
nsider a first sample of 12 cities starting from City 1 to City 12 and a second sample of 15 cities starting from City 40 to City 55 for
nsider a first sample of 35 cities starting from City 1 to City 35 and a second sample of 50 cities starting from City 51 to City 100 fo

Question
(a) Estimated standard error of the mean
(b) 90% confidence interval for the mean profit
Estimate and construct a 91% confidence interval for the proportion of the population who purchase online
Hypothesis test: Half of the cities use newspapers for advertisement at a 2% significance level
Hypothesis test: Less than 62% of the cities use 'Offline' as a sales channel at a 10% significance level
Hypothesis test: The average profit is 750000 at a 5% significance level
Hypothesis test: The average sales is more than 2000 at a 1% significance level
Is the average Radio Ad Budget of sample 1 Rs. 1500 more than the average Radio Ad Budget of sample 2?
Is the proportion of Offline Channel higher in the first sample than in the second one at a 10% significance level
Is the average TV Ad Budget of sample 1 more than that of sample 2 at a 5% significance level?
Is the average profit of sample 1 more than that of sample 2 at a 2% significance level?
Profit Sales Administration cost
TV Ad Budget
Advertisement Sales Channel Order Priority (in '0000 Rs) (in '00 units) (in '000 Rs) (in '00 Rs)
News Paper Offline M 95 23 167 243
Social Media Online C 56 12 45 49
News Paper Offline C 122 30 229 44
News Paper Offline L 27 6 65 125
News Paper Offline C 52 11 253 171
Social Media Online L 78 18 79 277
News Paper Offline H 81 18 249 205
Social Media Online M 59 14 92 65
Social Media Online M 82 19 94 154
Social Media Online M 77 18 212 239
News Paper Offline C 24 6 230 262
Social Media Online M 105 26 150 87
News Paper Offline L 67 15 239 292
News Paper Offline H 99 24 37 202
Social Media Online L 71 16 203 156
News Paper Offline H 70 16 147 180
Social Media Online C 40 8 157 193
Social Media Online L 81 18 47 90
Social Media Online C 117 30 223 126
News Paper Offline C 67 15 220 16
News Paper Offline L 89 20 117 235
News Paper Offline M 103 25 131 191
Social Media Online L 62 14 245 216
News Paper Offline L 110 27 47 241
News Paper Offline L 30 6 179 128
News Paper Offline C 58 13 28 116
Social Media Online L 96 23 139 205
News Paper Offline C 125 30 26 138
News Paper Offline C 96 24 172 7
News Paper Offline L 43 9 154 203
Social Media Online M 85 20 24 287
News Paper Offline L 102 25 16 165
Social Media Online L 41 9 250 230
Social Media Online L 57 12 74 66
Social Media Online C 117 30 214 77
News Paper Offline L 70 16 17 169
Social Media Online M 42 9 202 210
News Paper Offline L 101 24 163 272
News Paper Offline L 93 21 165 122
Social Media Online L 53 12 51 74
News Paper Offline C 125 30 173 114
Social Media Online L 92 21 116 256
Social Media Online M 96 24 242 17
Social Media Online L 82 20 60 185
News Paper Offline L 58 13 251 166
News Paper Offline L 37 7 181 117
News Paper Offline C 118 30 200 262
Social Media Online L 84 20 123 226
News Paper Offline M 36 7 215 136
News Paper Offline L 54 12 68 292
Social Media Online L 70 16 159 238
News Paper Offline L 52 11 170 96
News Paper Offline M 71 17 123 269
News Paper Offline C 27 6 160 239
Social Media Online C 40 8 213 51
News Paper Offline L 94 22 203 60
News Paper Offline C 27 6 207 26
Social Media Online L 78 18 78 74
News Paper Offline H 114 28 234 140
Social Media Online M 100 24 152 242
Social Media Online M 40 9 138 207
Social Media Online M 66 14 27 259
News Paper Offline C 119 30 39 165
News Paper Offline M 73 17 236 105
Social Media Online C 106 26 259 147
News Paper Offline C 114 29 143 56
News Paper Offline L 82 20 108 18
News Paper Offline C 107 27 77 19
Social Media Online L 33 7 18 220
News Paper Offline H 70 16 77 19
Social Media Online M 83 20 113 167
Social Media Online M 111 28 161 59
Social Media Online M 64 14 232 39
News Paper Offline C 105 26 122 240
Social Media Online M 79 18 88 140
News Paper Offline L 72 17 66 162
News Paper Offline H 24 6 59 11
Social Media Online L 37 8 148 22
News Paper Offline H 60 14 13 64
Social Media Online C 51 11 244 137
Social Media Online L 66 14 233 72
Social Media Online C 99 24 238 83
News Paper Offline C 113 28 113 148
News Paper Offline L 41 9 30 148
News Paper Offline M 101 25 219 266
Social Media Online L 110 28 93 215
News Paper Offline L 45 10 46 239
News Paper Offline L 44 10 199 161
News Paper Offline C 33 7 116 263
Social Media Online L 72 17 189 90
News Paper Offline C 81 18 22 21
News Paper Offline C 103 26 175 109
News Paper Offline L 106 27 206 22
Social Media Online M 92 21 244 28
News Paper Offline L 73 17 61 123
Social Media Online L 120 30 28 7
Social Media Online L 82 20 248 293
Social Media Online C 44 10 253 189
News Paper Offline L 54 12 205 231
Social Media Online M 49 11 50 46

mine all the records so he randomly selects a sample of 100. For the sample he finds that the mean is 68 and standard deviation is 2

pondents. 45 of the sales were made online. Construct a 91% confidence interval to estimate the proportion of the population who p

adio Ad Budget. At a 7% significance level, is the average Radio Ad Budget of sample 1 Rs. 1500 more than the average Radio Ad B
ewspaper Ad Budget. At a 10% level of significance, Is the proportion of Offline Channel higher in the first sample than in the secon
TV Ad Budget. At a 5% significance level, Is the average TV Ad Budget of sample 1 more than that of sample 2?
Profit. At a 2% significance level, Is the average profit of sample 1 more than that of sample 2?

Answer
2.5
(63.8875, 72.1125)
(0.36574, 0.53426)
Fail to reject null hypothesis
Fail to reject null hypothesis
Fail to reject null hypothesis
Reject null hypothesis
Fail to reject null hypothesis
Reject null hypothesis
Fail to reject null hypothesis
Reject null hypothesis
Radio Ad Budget
Newspaper Ad Budget
(in '00 Rs) (in '00 Rs)
35 37
16 82
48 74
2 103
13 74
29 23
29 21
18 100
32 100
27 34
2 25
42 35
22 31
38 75
26 74
23 51
5 107
29 98
47 114
22 5
34 24
39 59
18 64
43 10
4 75
17 59
36 44
49 70
37 68
8 25
34 54
39 62
7 67
16 9
47 10
23 86
8 19
39 113
35 85
14 26
49 79
34 112
37 80
32 82
18 46
5 62
47 76
33 59
5 36
14 93
24 32
14 44
27 104
3 37
5 17
35 34
3 54
29 66
46 98
38 54
7 29
19 39
48 72
27 7
42 99
46 106
32 47
43 15
4 34
25 96
33 59
45 66
19 20
42 66
29 67
27 33
2 40
5 40
18 33
13 9
21 103
38 110
45 79
7 107
39 82
44 93
11 72
9 21
4 36
27 57
30 34
40 88
43 2
35 103
27 43
48 30
33 45
10 38
15 113
13 60

and standard deviation is 25 .

ion of the population who purchase online.

an the average Radio Ad Budget of sample 2?


rst sample than in the second one?

You might also like