Homework Help is Here – Start Your Trial Now!
Math
Statistics
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 (it 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. 90% confidence interval estimate of the population proportion of schools that require high school grade

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 (it 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. 90% confidence interval estimate of the population proportion of schools that require high school grade

MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
See similar textbooks
icon
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
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. 90% confidence interval estimate of the population proportion of schools that require high school grade
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. 90% confidence interval estimate of the population proportion of schools that require high school grade
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
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 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…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
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
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman
SEE MORE TEXTBOOKS