Please see the attached tiny sample of a large data set on the passing rate of the Licensing Examination passing rate. Every row in the subset represents a school that was randomly sampled. You may accomplish it either using MS Excel or by hand (if using an MS excel, kindly show the steps or inputed codes. If computing manually shows the solution also). Given this info, kindly compute and interpret. 1. 95% confidence interval estimate of the population average number class size among schools where high school grade is required
Please see the attached tiny sample of a large data set on the passing rate of the Licensing Examination passing rate. Every row in the subset represents a school that was randomly sampled. You may accomplish it either using MS Excel or by hand (if using an MS excel, kindly show the steps or inputed codes. If computing manually shows the solution also). Given this info, kindly compute and interpret. 1. 95% confidence interval estimate of the population average number class size among schools where high school grade is required
Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.5: Comparing Sets Of Data
Problem 13PPS
Related questions
Question
Dataset Google sheet link for better view: http://shorturl.at/awzFP
![DATASET
High
Studentpo
Average class
Numaccbs
Leadmea
Ассept
Admi
College
Quali
Number of Percentfa Percentfa
Passrate
Numacc
Facimean
Actexpgrads
school
Numcerts
size
a
Rate
Quota
Grade
Exams
Students
cfull
cmast
Grade
3500
2
4.333333333 4.307692
4.222222222 4.846154
4 3.923077
3.777777778 3.923077
4.444444444 4.307692
3.444444444 4.384615
199
476 0.647059 0.705882
15.71%
40
45
35
50
0.8
0.7
1
1
2
0.5
0.3
0.969230769 0.944444
0.88 0.666667
50.21%
3700
1
1
1
1
2
1
36.00%
1690
1
1
2
177
0.625
0.125
0.142857 0.142857
284 0.153846 0.846154
119 0.666667 0.555556
25.95%
6283
4
1
0.8
141
34.71%
3000
2500
0.766666667
1.2
45
1
0.48
1
1
3
1
37.42%
45
1
0.75
1
1
1500
3200
37.58%
40
1
1
3.666666667
5
0.9
0.6
1
1
1
2
238
0.6
0.4
1
35
253
196
132 0.333333
443 0.363636 0.636364
795 0.215686 0.764706
333 0.833333 0.666667
4.666666667
3.888888889 2.923077
3.777777778 3.538462
4 3.461538
4.888888889 4.076923
2.666666667 3.615385
4 3.692308
4.888888889 4.846154
4.222222222 4.846154
3.777777778 3.692308
4.111111111 4.230769
3.444444444 3.923077
0.666667
1.5
1.32
20.65%
2
1
1
1
0.75
0.6875
14
14.77%
2000
20
1
0.5
0.125
1232
6623
17000
5.56%
30
40
40
40
1
1
1
0.5
62.71%
1
1
1
0.5
1
1
1
96.02%
1
2
0.754285714
0.06 0
0.
1
2
12
52.34%
10000
1
1
0.96
0.3
1
14.55%
4064
10
1
1
0.75
1
1
60
0.6
0.6
2262 0.603448
1204 0.333333 0.030303
126 0.533333
57.93%
25000
40
1
0.9
0.5
1
2
1
27
45
56.98%
36.61%
49.00%
0.785
0.933333333 0.714286
0.92
699
1
1
0.875
1
3
0.2
0.125
3000
1822
2739
2500
1568
4500
6700
1100
6000
3755
20
1
1
45
40
45
40
35
1
0.65
1
2
175
0.375
33.61%
1
0.85
1
5
357
0.3125
0.5625
4
0.92
1.142857143
0.75
38.07%
1
1
4.444444444
1
1
1
211
0.7
1
42
301 0.533333 0.466667
203
4 4.384615
2.444444444 2.615385
4.777777778 4.692308
4 4.076923
4.111111111 3.692308
3.666666667 2.923077
3 3.538462
3.777777778 3.384615
3.888888889 4.769231
4.666666667 4.769231
3.222222222 3.692308
2.777777778 3.615385
4.444444444 4.538462
3.111111111 4.307692
4
4 3.769231
4.444444444 3.615385
2.888888889 3.692308
4.538462
21.95%
1
0.6
1
1
0.4
0.8
19.02%
0.4
1
1
1
1
0.75
0.25
41.83%
40
1
1
0.457142857
0.5
1
6.
0.5
4
35
45
50
30
1.2
2.2
31.18%
0.85
1
1
201
0.75
47.27%
44.73%
25.31%
54.46%
46.22%
117 0.333333
183 0.235294 0.176471
184 0.857143 0.142857
693
172
200
517 0.277778 0.333333
286
128 0.166667 0.833333
43 0.285714 0.428571
1
1
1
1
1
2.7
1
1
1
1.111111111 0.266667
0.9
5711
2
1
2
7500
50
2
1
1
0.625
0.125
1
45
30
40
40
2500
1
0.833333333
0.275
1
1
1
5
0.5
10
0.466666667 0.666667
1.32
45.05%
1900
1
1
1
1
1
0.6
1
1
29.85%
3266
0.93
1
1
3
23.89%
3000
0.8
0.4
1
1
0.45
0.25
1 0.833333
0.96
0.5
1.057142857 0.909091
0.84 0.882353
0.95
3000
791
36.94%
40
1
1
0.6
1
1
25
25
20
35
30
45
35
50
35
45
43
10.48%
1
1
1
1
1
325
2312
37.84%
1
55
0.666667
3
30.96%
26.80%
74 0.777778 0.222222
84
193 0.428571 0.285714
276 0.777778 0.888889
166 0.214286 0.857143
742
324 0.428571 0.857143
320 0.461538 0.615385
161 0.428571
0.8
1
1
2
1230
1
1
0.4
1
1
4
0.2
1
38.89%
1800
1
1
1
1
3
7
38.24%
12000
1
1
4.222222222
1
1
3
3.444444444
4.222222222 3.923077
3.888888889 4.076923
3.888888889 4.153846
3.333333333 3.923077
41.67%
3995
1
4
0.6
1
1
24.49%
0.555556
3100
3277
1
0.4
1
1
31.35%
1
1.022222222 0.782609
1
1
63.55%
8000
1
1
0.833333333
3
44.55%
7000
2
1
0.933333333 0.857143
1
1
1](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F098d742f-a34b-4bfc-b39d-4ca2091a267c%2F04618e56-1b07-438a-be58-2d8a74aca640%2Ftq2loem_processed.jpeg&w=3840&q=75)
Transcribed Image Text:DATASET
High
Studentpo
Average class
Numaccbs
Leadmea
Ассept
Admi
College
Quali
Number of Percentfa Percentfa
Passrate
Numacc
Facimean
Actexpgrads
school
Numcerts
size
a
Rate
Quota
Grade
Exams
Students
cfull
cmast
Grade
3500
2
4.333333333 4.307692
4.222222222 4.846154
4 3.923077
3.777777778 3.923077
4.444444444 4.307692
3.444444444 4.384615
199
476 0.647059 0.705882
15.71%
40
45
35
50
0.8
0.7
1
1
2
0.5
0.3
0.969230769 0.944444
0.88 0.666667
50.21%
3700
1
1
1
1
2
1
36.00%
1690
1
1
2
177
0.625
0.125
0.142857 0.142857
284 0.153846 0.846154
119 0.666667 0.555556
25.95%
6283
4
1
0.8
141
34.71%
3000
2500
0.766666667
1.2
45
1
0.48
1
1
3
1
37.42%
45
1
0.75
1
1
1500
3200
37.58%
40
1
1
3.666666667
5
0.9
0.6
1
1
1
2
238
0.6
0.4
1
35
253
196
132 0.333333
443 0.363636 0.636364
795 0.215686 0.764706
333 0.833333 0.666667
4.666666667
3.888888889 2.923077
3.777777778 3.538462
4 3.461538
4.888888889 4.076923
2.666666667 3.615385
4 3.692308
4.888888889 4.846154
4.222222222 4.846154
3.777777778 3.692308
4.111111111 4.230769
3.444444444 3.923077
0.666667
1.5
1.32
20.65%
2
1
1
1
0.75
0.6875
14
14.77%
2000
20
1
0.5
0.125
1232
6623
17000
5.56%
30
40
40
40
1
1
1
0.5
62.71%
1
1
1
0.5
1
1
1
96.02%
1
2
0.754285714
0.06 0
0.
1
2
12
52.34%
10000
1
1
0.96
0.3
1
14.55%
4064
10
1
1
0.75
1
1
60
0.6
0.6
2262 0.603448
1204 0.333333 0.030303
126 0.533333
57.93%
25000
40
1
0.9
0.5
1
2
1
27
45
56.98%
36.61%
49.00%
0.785
0.933333333 0.714286
0.92
699
1
1
0.875
1
3
0.2
0.125
3000
1822
2739
2500
1568
4500
6700
1100
6000
3755
20
1
1
45
40
45
40
35
1
0.65
1
2
175
0.375
33.61%
1
0.85
1
5
357
0.3125
0.5625
4
0.92
1.142857143
0.75
38.07%
1
1
4.444444444
1
1
1
211
0.7
1
42
301 0.533333 0.466667
203
4 4.384615
2.444444444 2.615385
4.777777778 4.692308
4 4.076923
4.111111111 3.692308
3.666666667 2.923077
3 3.538462
3.777777778 3.384615
3.888888889 4.769231
4.666666667 4.769231
3.222222222 3.692308
2.777777778 3.615385
4.444444444 4.538462
3.111111111 4.307692
4
4 3.769231
4.444444444 3.615385
2.888888889 3.692308
4.538462
21.95%
1
0.6
1
1
0.4
0.8
19.02%
0.4
1
1
1
1
0.75
0.25
41.83%
40
1
1
0.457142857
0.5
1
6.
0.5
4
35
45
50
30
1.2
2.2
31.18%
0.85
1
1
201
0.75
47.27%
44.73%
25.31%
54.46%
46.22%
117 0.333333
183 0.235294 0.176471
184 0.857143 0.142857
693
172
200
517 0.277778 0.333333
286
128 0.166667 0.833333
43 0.285714 0.428571
1
1
1
1
1
2.7
1
1
1
1.111111111 0.266667
0.9
5711
2
1
2
7500
50
2
1
1
0.625
0.125
1
45
30
40
40
2500
1
0.833333333
0.275
1
1
1
5
0.5
10
0.466666667 0.666667
1.32
45.05%
1900
1
1
1
1
1
0.6
1
1
29.85%
3266
0.93
1
1
3
23.89%
3000
0.8
0.4
1
1
0.45
0.25
1 0.833333
0.96
0.5
1.057142857 0.909091
0.84 0.882353
0.95
3000
791
36.94%
40
1
1
0.6
1
1
25
25
20
35
30
45
35
50
35
45
43
10.48%
1
1
1
1
1
325
2312
37.84%
1
55
0.666667
3
30.96%
26.80%
74 0.777778 0.222222
84
193 0.428571 0.285714
276 0.777778 0.888889
166 0.214286 0.857143
742
324 0.428571 0.857143
320 0.461538 0.615385
161 0.428571
0.8
1
1
2
1230
1
1
0.4
1
1
4
0.2
1
38.89%
1800
1
1
1
1
3
7
38.24%
12000
1
1
4.222222222
1
1
3
3.444444444
4.222222222 3.923077
3.888888889 4.076923
3.888888889 4.153846
3.333333333 3.923077
41.67%
3995
1
4
0.6
1
1
24.49%
0.555556
3100
3277
1
0.4
1
1
31.35%
1
1.022222222 0.782609
1
1
63.55%
8000
1
1
0.833333333
3
44.55%
7000
2
1
0.933333333 0.857143
1
1
1
![Please see the attached tiny sample of a large data set on the passing rate of the
Licensing Examination passing rate. Every row in the subset represents a school that
was randomly sampled. You may accomplish it either using MS Excel or by hand (if
using an MS excel, kindly show the steps or inputed codes. If computing manually
shows the solution also). Given this info, kindly compute and interpret.
1. 95% confidence interval estimate of the population average number class size among
schools where high school grade is required](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F098d742f-a34b-4bfc-b39d-4ca2091a267c%2F04618e56-1b07-438a-be58-2d8a74aca640%2Fjdsh0s_processed.png&w=3840&q=75)
Transcribed Image Text:Please see the attached tiny sample of a large data set on the passing rate of the
Licensing Examination passing rate. Every row in the subset represents a school that
was randomly sampled. You may accomplish it either using MS Excel or by hand (if
using an MS excel, kindly show the steps or inputed codes. If computing manually
shows the solution also). Given this info, kindly compute and interpret.
1. 95% confidence interval estimate of the population average number class size among
schools where high school grade is required
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Glencoe Algebra 1, Student Edition, 9780079039897…](https://www.bartleby.com/isbn_cover_images/9780079039897/9780079039897_smallCoverImage.jpg)
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
![Holt Mcdougal Larson Pre-algebra: Student Edition…](https://www.bartleby.com/isbn_cover_images/9780547587776/9780547587776_smallCoverImage.jpg)
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
![College Algebra (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781305652231/9781305652231_smallCoverImage.gif)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
![Glencoe Algebra 1, Student Edition, 9780079039897…](https://www.bartleby.com/isbn_cover_images/9780079039897/9780079039897_smallCoverImage.jpg)
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
![Holt Mcdougal Larson Pre-algebra: Student Edition…](https://www.bartleby.com/isbn_cover_images/9780547587776/9780547587776_smallCoverImage.jpg)
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
![College Algebra (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781305652231/9781305652231_smallCoverImage.gif)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning