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. 99% confidence interval estimate of the population mean number of students in the schools (number of students are involved)
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. 99% confidence interval estimate of the population mean number of students in the schools (number of students are involved)
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
Dataset Google sheet link for better view: http://shorturl.at/awzFP
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. 99% confidence interval estimate of the population mean number of students in the
schools (number of students are involved)
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
Expert Solution
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
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman