Urgent 1

profilestudystudent
ConfidenceIntervals.xlsx
Home>Mathematics homework help>Urgent 1

Confidence Interval for High Sc

ID GENDER HIGH SCHOOL (X) COLLEGE (Y)
1 FEMALE 78 65
2 FEMALE 82 88
3 FEMALE 58 38
4 FEMALE 77 77
5 MALE 73 86
6 MALE 73 64
7 MALE 75 78 95% confidence 90% confidence 98% confidence
8 FEMALE 60 69 (1-0.95)/2=0.025 (1-0.90)/2=0.05 (1-0.90)/2=0.01
9 MALE 88 84 1-0.025=0.975 1-0.05=0.95 1-0.01=0.99
10 MALE 89 68 z score = 1.96 z score = 1.64 z score = 2.33
11 FEMALE 57 38
12 FEMALE 65 70 1.96*10.64/sqr30=3.80 1.64*10.64/sqr30=3.19 2.33*10.64/sqr30=4.53
13 FEMALE 73 89
14 MALE 81 75 lower range = 73.1-3.8=69.3 lower range = 73.1-3.19=69.91 lower range = 73.1-4.53=68.57
15 MALE 65 60 upper range = 73.1+3.8 = 76.9 upper range = 73.1+3.19= 76.21 upper range = 73.1+4.53= 77.63
16 MALE 70 77
17 FEMALE 77 70 The CI is (69.3,76.9) The CI is (69.91,76.21) The CI is (68.57,77.63)
18 MALE 77 70
19 MALE 91 88
20 FEMALE 80 72
21 MALE 82 80
22 MALE 60 62
23 MALE 54 68
24 MALE 70 53
25 MALE 65 45
26 FEMALE 90 96
27 FEMALE 74 67
28 FEMALE 64 72
29 FEMALE 59 65
30 FEMALE 86 89
Mean 73.1 70.7666666667

Confidence Interval for College

ID GENDER HIGH SCHOOL (X) COLLEGE (Y)
1 FEMALE 78 65
2 FEMALE 82 88
3 FEMALE 58 38
4 FEMALE 77 77
5 MALE 73 86
6 MALE 73 64
7 MALE 75 78 95% confidence 90% confidence 98% confidence
8 FEMALE 60 69 (1-0.95)/2=0.025 (1-0.90)/2=0.05 (1-0.90)/2=0.01
9 MALE 88 84 1-0.025=0.975 1-0.05=0.95 1-0.01=0.99
10 MALE 89 68 z score = 1.96 z score = 1.64 z score = 2.33
11 FEMALE 57 38
12 FEMALE 65 70 1.96*14.39/sqr30=5.14 1.64*14.39/sqr30=4.31 2.33*14.39/sqr30=6.12
13 FEMALE 73 89
14 MALE 81 75 lower range = 70.77-5.14=65.63 lower range = 70.77-4.31=66.46 lower range = 70.77-6.12=64.65
15 MALE 65 60 upper range = 70.77+5.14 = 75.91 upper range = 70.77+4.31 = 75.08 upper range = 70.77+6.12=76.89
16 MALE 70 77
17 FEMALE 77 70 The CI is (65.63,75.91) The CI is (66.46,75.03) The CI is (64.65,76.89)
18 MALE 77 70
19 MALE 91 88
20 FEMALE 80 72
21 MALE 82 80 The confidence intervals shows that the 98% has a larger difference. The differnce between the lowest and the upper value.
22 MALE 60 62 The confidence intervals just shows the value of the lowest and the upper values of the interval of the true population mean.
23 MALE 54 68
24 MALE 70 53
25 MALE 65 45
26 FEMALE 90 96
27 FEMALE 74 67
28 FEMALE 64 72
29 FEMALE 59 65
30 FEMALE 86 89
Mean 73.1 70.7666666667