Wk 8

profileM48s
ConfindenceIntervals.xlsx
Home>Mathematics homework help>Statistics homework help>Wk 8

90% Confidence interal

Age Monthly Income Formula for 90% confidence Interval for the monthly income Formula for 90% confidence Interval for the Age is as below:
18 1000
18 1008
18 1018
18 1026 where µ is the population mean where µ is the population mean
18 1029 σ is the population standard deviation σ is the population standard deviation
18 1054 n population size n population size
19 1057
19 1068 µ =Average(B2:B105)
19 1089 µ =Average(B2:B105) 25.3203883495
19 1097 2599.3653846154 σ =STDEV(B2:B105)
19 1099 σ =STDEV(B2:B105) 4.6887717197
19 1100 1681.0917918932
19 1156 n =150
19 1165 n= 104
19 1177 CI=
19 1184 CI=
20 1186 =
20 1190 = (24.69 , 25.95)
20 1222
20 1224 = (2599.365+270.345, 2599.365+270.345) Interetation
21 1225 (2529.02 , 2869.71) We are 90% confident that the population mean for ages lies between 24.69 and 25.95
21 1230
21 1234 Interpretation
22 1244 We are 90% confident that the population mean lies between 2529.02 and 2869.71
22 1250
22 1259 I also used megestat in excel and the result is as below
22 1272 Confidence interval - mean
22 1293
22 1296 90% confidence level
22 1296 2599.365 mean
23 1297 1681.092 std. dev.
23 1324 104 n
23 1359 1.645 z
23 1385 271.145 margin of error
23 1412 2328.220 lower confidence limit
23 1451 2870.510 upper confidence limit
23 1453
23 1458
23 1460
23 1460
24 1474
24 1490
24 1495
24 1515
25 1526
25 1529
25 1587
25 1611
25 1712
25 1729
25 1761
25 1766
25 1890
25 1939
25 1972
25 2186
25 2219
26 2269
26 2355
26 2391
26 2412
26 2527
26 2574
26 2585
26 2614
26 2656
27 2723
27 2851
27 2863
27 2922
27 2924
28 3076
28 3173
28 3177
28 3208
28 3221
28 3241
29 3420
29 3481
29 3492
29 3615
30 3646
30 3780
30 3836
30 3983
31 4391
31 4410
31 4599
31 4682
32 4737
32 4804
32 5179
33 5250
33 5363
33 5865
33 6060
33 6218
34 6284
34 6329
34 6409
34 6420
34 6525
34 6592
34 6994
34
35
35
35
35
35
36
36
36
37
37
37
37
37
37
37
38
39
39
39
40
40
42
42
42
43
43
43
43
43
44
44
45
45
47
47
47
48
52
61
69
70
70
72
72
75

95% Confidence interal

Age Monthly Income Formula for 95% confidence Interval for the monthly income Formula for 95% confidence Interval for the Age is as below:
18 1000
18 1008
18 1018
18 1026 where µ is the population mean where µ is the population mean
18 1029 σ is the population standard deviation σ is the population standard deviation
18 1054 n population size n population size
19 1057
19 1068 µ =Average(B2:B105)
19 1089 µ =Average(B2:B105) 25.3203883495
19 1097 2599.3653846154 σ =STDEV(B2:B105)
19 1099 σ =STDEV(B2:B105) 4.6887717197
19 1100 1681.0917918932
19 1156 n= 150
19 1165 n= 104
19 1177 CI=
19 1184 CI=
20 1186 =
20 1190 = (24.57 , 26.07)
20 1222
20 1224 = (2599.365+323.095, 2599.365+323.095) Interetation
21 1225 (2276.27 , 2922.46) We are 95% confident that the population mean for ages lies between 24.57 and 26.07
21 1230
21 1234 Interpretation
22 1244 We are 95% confident that the population mean lies between 2276.27 and 2922.46 By MegaStat in Excel:
22 1250
22 1259 Using Megastat, this is the calculation of confidence interval Confidence interval - mean
22 1272 Confidence interval - mean 95% confidence level
22 1293 confidence level 25.32 mean
22 1296 95% mean 4.6888 std. dev.
22 1296 2599.3653846154 std. dev. 150 n
23 1297 1681.0917918932 n 1.960 z
23 1324 104 z 0.750 margin of error
23 1359 1.960 margin of error 24.570 lower confidence limit
23 1385 323.0895 lower confidence limit 26.070 upper confidence limit
23 1412 2,276.2759 upper confidence limit
23 1451 2,922.4549
23 1453
23 1458
23 1460
23 1460
24 1474
24 1490
24 1495
24 1515
25 1526
25 1529
25 1587
25 1611
25 1712
25 1729
25 1761
25 1766
25 1890
25 1939
25 1972
25 2186
25 2219
26 2269
26 2355
26 2391
26 2412
26 2527
26 2574
26 2585
26 2614
26 2656
27 2723
27 2851
27 2863
27 2922
27 2924
28 3076
28 3173
28 3177
28 3208
28 3221
28 3241
29 3420
29 3481
29 3492
29 3615
30 3646
30 3780
30 3836
30 3983
31 4391
31 4410
31 4599
31 4682
32 4737
32 4804
32 5179
33 5250
33 5363
33 5865
33 6060
33 6218
34 6284
34 6329
34 6409
34 6420
34 6525
34 6592
34 6994
34
35
35
35
35
35
36
36
36
37
37
37
37
37
37
37
38
39
39
39
40
40
42
42
42
43
43
43
43
43
44
44
45
45
47
47
47
48
52
61
69
70
70
72
72
75

98% Confidence interal

Age Monthly Income Formula for 98% confidence Interval for the monthly income Formula for 98% confidence Interval for the Ages
18 1000
18 1008
18 1018
18 1026 where µ is the population mean where µ is the population mean
18 1029 σ is the population standard deviation σ is the population standard deviation
18 1054 n population size n population size
19 1057
19 1068 µ =Average(B2:B105) µ =Average(B2:B105)
19 1089 2599.3653846154 25.3203883495
19 1097 σ =STDEV(B2:B105) σ =STDEV(B2:B105)
19 1099 1681.0917918932 4.6887717197
19 1100
19 1156 n= 104 n =150
19 1165
19 1177 CI=
19 1184 CI=
20 1186 =
20 1190 =
20 1222 = (2599.365+384.088, 2599.365+384.088) (24.43 , 26.21)
20 1224 ( 2215.28 , 2983.45)
21 1225 Interetation
21 1230 Interpretation We are 98% confident that the population mean for ages lies between 24.43 and 26.21
21 1234 We are 98% confident that the population mean lies between 2215.28 and 2983.45
22 1244
22 1250
22 1259 By use of MegaStat the following result was obtained for the CI
22 1272
22 1293 Confidence interval - mean
22 1296 98% confidence level
22 1296 2599.365 mean
23 1297 1681.092 std. dev.
23 1324 104 n
23 1359 2.326 z
23 1385 383.486 margin of error
23 1412 2215.879 lower confidence limit
23 1451 2982.851 upper confidence limit
23 1453
23 1458
23 1460
23 1460
24 1474
24 1490
24 1495
24 1515
25 1526
25 1529
25 1587
25 1611
25 1712
25 1729
25 1761
25 1766
25 1890
25 1939
25 1972
25 2186
25 2219
26 2269
26 2355
26 2391
26 2412
26 2527
26 2574
26 2585
26 2614
26 2656
27 2723
27 2851
27 2863
27 2922
27 2924
28 3076
28 3173
28 3177
28 3208
28 3221
28 3241
29 3420
29 3481
29 3492
29 3615
30 3646
30 3780
30 3836
30 3983
31 4391
31 4410
31 4599
31 4682
32 4737
32 4804
32 5179
33 5250
33 5363
33 5865
33 6060
33 6218
34 6284
34 6329
34 6409
34 6420
34 6525
34 6592
34 6994
34
35
35
35
35
35
36
36
36
37
37
37
37
37
37
37
38
39
39
39
40
40
42
42
42
43
43
43
43
43
44
44
45
45
47
47
47
48
52
61
69
70
70
72
72
75

Sheet1